[Skip to main content](#vessel-content)
# Profile for eurovideo
##
[](/forum/user/32709-eurovideo "View eurovideo's Profile")
**[ Offline](/forum/user/32709-eurovideo)**
- **User Type:** User
- **Register Date:** 21 May 2014
- **Last login:** 12 years 5 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 08:43
- **Posts:** 2
- **Profile views:** 36
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# eurovideo's recent posts (2 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920) | [CSV Import of variants not as expected](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920 "Hello there, I'm trying to upload my shop inventory from CSV files. I would like to have a number of products, describing their specifications, and then add packaging variants with price information. E.g. as a product I may have chocolate, and as variant I may sell chocolate bars and chocolote boxes. I've run several trials to get this working, but only with a D-tour it leads to success. In order to understand what's going on, I created some test cases to show things. Test case 1: The products to import And this is what happens: ACTION: Import OK -> INSPECT: phpMyAdmin shows four products in the table #__hikashop_product INSPECT: Variants recognized in the back-end, with correct pricing INSPECT: All variants appear, prices are not updated when selecting a variant, no suffix is displayed for the variant in the product name. ACTION: Product -> Manage variants -> INSPECT: Variants are removed from the front-end; product is free INSPECT: phpMyAdmin shows only one product in the table #__hikashop_product; all variants are gone INSPECT: in the back-end, all variants are gone as well. Test case 2: The file to import the main product: And the file to import all variants somewhat later: And this is what happens: ACTION: Import main product, ACTION: Product -> Add characteristics INSPECT: Three additional products without name are found in phpMyAdmin, all child of the just imported product INSPECT: Three variants are shown in the back-end INSPECT: Three variants are shown in the front-end, suffixes are displayed for the variant in the product name. No variant has a price, which is in-line with expectations. ACTION 2: Import variants, OK -> INSPECT: Three additional variants with name are now found in phpMyAdmin, making in total 6 variants INSPECT: The newly imported variants are orphans INSPECT: The newly imported variants don show in the back-end INSPECT: No price information is available in the front-end Test case 3 The file to import the main product The file to import the variants later: Note that the variant file this time also contains the main product Then this is what happens: ACTION: Import main product, OK -> ACTION: Product -> Add characteristics ACTION: Product -> Manage variants -> delete all INSPECT: Three additional products without name are found in phpMyAdmin, all child of the just imported product INSPECT: Three variants are shown in the back-end, having no names INSPECT: Three variants are shown in the front-end, suffixes are displayed for the variant in the product name. No variant has a price, which is in-line with expectations. ACTION 2: Import variants, OK -> INSPECT: The variants are updated with the newly read information, as shown in phpMyAdmin INSPECT: The back-end shows the correct structure INSPECT: The front-end displays the variants with variant price and package suffix in the title --> SUCCESS Test case 4 The file for the product and variants, actually the same as test case 1: And here are the test results: ACTION: Import OK -> ACTION: Product -> Manage variants -> ACTION: Product -> add characteristics ACTION: Product -> Manage variants -> select and delete all INSPECT: Unnamed variants still exists in the back-end ACTION 2:Import again, same file, OK -> INSPECT: Everything is fine --> SUCCESS Conclusions * To import variants, the file must also name the main product. Having the main product already loaded is not sufficient * The way to load variants is to first create these using "add characteristics", then delete all created variants, then load the variants. Can someone help here? Thanks and regards, Paul -- HikaShop version -- : 2.3.0 Business edition -- Joomla version -- : 3.2.3 -- PHP version -- : 5.5.9-1 Ubuntu -- Browser(s) name and version -- : Chrome") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 7 months ago, by [paulvanharen](/forum/user/20480-paulvanharen "View paulvanharen's Profile") [Last Post](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920 "Now I created another characteriscic called "singolo", with a variant called "scheda" and now everithing is working. Maybe calling the characteristic and the variant with te same name such...") 12 years 5 months ago by [eurovideo](/forum/user/32709-eurovideo "View eurovideo's Profile") | Replies:6 Views:1123 | [Last Post](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920 "Now I created another characteriscic called "singolo", with a variant called "scheda" and now everithing is working. Maybe calling the characteristic and the variant with te same name such...") by [eurovideo](/forum/user/32709-eurovideo "View eurovideo's Profile") 12 years 5 months ago |
| [](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156812) | [CSV Import of variants not as expected](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156812 "Hello there, I'm trying to upload my shop inventory from CSV files. I would like to have a number of products, describing their specifications, and then add packaging variants with price information. E.g. as a product I may have chocolate, and as variant I may sell chocolate bars and chocolote boxes. I've run several trials to get this working, but only with a D-tour it leads to success. In order to understand what's going on, I created some test cases to show things. Test case 1: The products to import And this is what happens: ACTION: Import OK -> INSPECT: phpMyAdmin shows four products in the table #__hikashop_product INSPECT: Variants recognized in the back-end, with correct pricing INSPECT: All variants appear, prices are not updated when selecting a variant, no suffix is displayed for the variant in the product name. ACTION: Product -> Manage variants -> INSPECT: Variants are removed from the front-end; product is free INSPECT: phpMyAdmin shows only one product in the table #__hikashop_product; all variants are gone INSPECT: in the back-end, all variants are gone as well. Test case 2: The file to import the main product: And the file to import all variants somewhat later: And this is what happens: ACTION: Import main product, ACTION: Product -> Add characteristics INSPECT: Three additional products without name are found in phpMyAdmin, all child of the just imported product INSPECT: Three variants are shown in the back-end INSPECT: Three variants are shown in the front-end, suffixes are displayed for the variant in the product name. No variant has a price, which is in-line with expectations. ACTION 2: Import variants, OK -> INSPECT: Three additional variants with name are now found in phpMyAdmin, making in total 6 variants INSPECT: The newly imported variants are orphans INSPECT: The newly imported variants don show in the back-end INSPECT: No price information is available in the front-end Test case 3 The file to import the main product The file to import the variants later: Note that the variant file this time also contains the main product Then this is what happens: ACTION: Import main product, OK -> ACTION: Product -> Add characteristics ACTION: Product -> Manage variants -> delete all INSPECT: Three additional products without name are found in phpMyAdmin, all child of the just imported product INSPECT: Three variants are shown in the back-end, having no names INSPECT: Three variants are shown in the front-end, suffixes are displayed for the variant in the product name. No variant has a price, which is in-line with expectations. ACTION 2: Import variants, OK -> INSPECT: The variants are updated with the newly read information, as shown in phpMyAdmin INSPECT: The back-end shows the correct structure INSPECT: The front-end displays the variants with variant price and package suffix in the title --> SUCCESS Test case 4 The file for the product and variants, actually the same as test case 1: And here are the test results: ACTION: Import OK -> ACTION: Product -> Manage variants -> ACTION: Product -> add characteristics ACTION: Product -> Manage variants -> select and delete all INSPECT: Unnamed variants still exists in the back-end ACTION 2:Import again, same file, OK -> INSPECT: Everything is fine --> SUCCESS Conclusions * To import variants, the file must also name the main product. Having the main product already loaded is not sufficient * The way to load variants is to first create these using "add characteristics", then delete all created variants, then load the variants. Can someone help here? Thanks and regards, Paul -- HikaShop version -- : 2.3.0 Business edition -- Joomla version -- : 3.2.3 -- PHP version -- : 5.5.9-1 Ubuntu -- Browser(s) name and version -- : Chrome") Category: [Import & Export (CSV, XLS…)](/forum/37-import-export-csv-xls "Questions about import and export will find an answer here") Topic started 12 years 7 months ago, by [paulvanharen](/forum/user/20480-paulvanharen "View paulvanharen's Profile") [Last Post](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920 "Now I created another characteriscic called "singolo", with a variant called "scheda" and now everithing is working. Maybe calling the characteristic and the variant with te same name such...") 12 years 5 months ago by [eurovideo](/forum/user/32709-eurovideo "View eurovideo's Profile") | Replies:6 Views:1123 | [Last Post](/forum/37-import-export-csv-xls/866916-csv-import-of-variants-not-as-expected#156920 "Now I created another characteriscic called "singolo", with a variant called "scheda" and now everithing is working. Maybe calling the characteristic and the variant with te same name such...") by [eurovideo](/forum/user/32709-eurovideo "View eurovideo's Profile") 12 years 5 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.119 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)