[Skip to main content](#vessel-content) # Mass upload variants ## - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 6 months ago [\#239911](#239911) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#239911 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* was created by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* -- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 6 months ago [\#239955](#239955) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#239955 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hello? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 6 months ago [\#239968](#239968) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#239968 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, Export/import of a CSV is the way to go yes. If it didn't add the variants, it means that you're missing something in your CSV. Could you provide a copy of the CSV you're trying to import ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 6 months ago [\#240141](#240141) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240141 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Tried a few different ways - heres the last one i tried. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240151](#240151) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240151 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, Your CSV is no good at all. There are no columns. Everything is in one column: [ take.ms/KkbO1](http://take.ms/KkbO1) There should be many columns: for the product_code, for the characteristic name, for the product_parent_id, etc. If you do an export of a CSV from HikaShop you should see the many columns available, and our export documentation has information on the main columns you can use and how to use them: [ www.hikashop.com/support/documentation/73-hikashop-import.html](https://www.hikashop.com/support/documentation/73-hikashop-import.html) Based on what I can see in your csv, you would need to first create two characteristics, one for the flavour, one for the weight, with all the possible values in each one. And then, you would have at least these columns in your CSV: product_code : the code of the product or the variant product_parent_id: nothing for main products and the product_code of the main product for variants flavour: the default flavour for the main product and the flavour value for the variant weight: the default weight for the main product and the weight value for the variant Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240192](#240192) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240192 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Sure I guessed this, I tried this option because when I export the full csv I cannot see a column to add the variants, I tried entering in one column but it did not work... I have created the Characteristic and variants already, also I do not need a product weight...I have attached a full export, perhaps you can show where to add my flavour please? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240197](#240197) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240197 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, There you have the columns you need: product_code, product_parent_id, OMG Flavour Then, you can add extra columns as you need them (price_value, categories, product_quantity, etc). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240254](#240254) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240254 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* What is the minimum columns I can use in the CSV export to be able to just paste all the flavours into the CSV? because I cannot seem to upload an XLS file and pasting into the CSV is not easy when I need to add all the other info before the flavour I.E. all;"";0;"";"10ml_Oh_My_God_UK_Made_E_liquid_1";0;"2016-05-10";0;"";"m";0;"";"0.000 m";0;2;"";"";"";"0.000 m";0;0;"";0;"2016-05-10";0;"";"";"10ml_Oh_My_God_UK_Made_E_liquid";0;1;-1;"";"";"";0;0;0;"variant";"";0;0;0;0;"kg";"0.000 m";"";"";"";"";"";"";"";"";"Apple & Raspberry 6MG";"" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 10 years 5 months ago [\#240260](#240260) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240260 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, The minimum columns number in your case is 3 columns, one for the product code, another for the product_parent_id to link the product to the parent and the last one the column to set the desired value. The ones given by Nicolas, then you can add extra columns based on the needed data. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240331](#240331) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240331 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Ok so I uploaded this csv but it did not work as expected, it added blank variants...any idea why? Regards Neil Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240363](#240363) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240363 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, The product_id column should be removed. As for the blank variants, this means that the value doesn't exist in the characteristic. Before using a value of a characteristic for the import of products, that value must be added in the characteristic. You can then use it for all products imports you want. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago - 10 years 5 months ago [\#240447](#240447) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240447 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* I'm totally lost here - I have added the product characteristic (OMG Flavour) I added 3 Values which are, Apple & Raspberry 6MG, Apple & Raspberry 12MG, Apple & Raspberry 24MG in the back end.... now I wanted to do a mass upload of values, which are the rest of the flavours....should I pm you log in details? UPDATE - PM sent Last edit: 10 years 5 months ago by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240502](#240502) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240502 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, Well what you want to do and what you said you wanted to do are differents. You seem to be mistaking variants and values for the same thing. Supposing you're selling 1000 products. Suppose that each product has a characteristic "flavour". That characteristic has 100 values. So each product can have up to 100 variants. For example, in one product, you'll aattach only 10 values of that characteristic so that product will have 10 variants. The import system allows you to import products and variants of products. But it doesn't allow you to import characteristics or values. So as I said in my previous email, before import products and variants using the values of a characteristic, you first need to add all the values of the characteristic in the interface. There is no import system for the characteristics. You can export/import a CSV of the hikashop_characteristic table in your phpmyadmin if you want to do a mass upload of the values of a characteristic, but you can use the HikaShop products import for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240869](#240869) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240869 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* So I can not do a mass upload of values? That means I have to manually type in 178 flavours for each product? Or use myphpadmin? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240872](#240872) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240872 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Also I have tried uploading in myphpadmin but it doesnt work - could you explain how please? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240890](#240890) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240890 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, > So I can not do a mass upload of values? Not in HikaShop, only through PHPMyAdmin. > That means I have to manually type in 178 flavours for each product? No. You need to type in the 178 flavours values once in the values listing of the flavour characteristic. Once that's done, you can use the CSV that you were using to generate the variants of all the products based on the values of that characteristic. You don't need PHPMyAdmin for that. And for 178 values, you can add them through the characteristic edition interface of your backend. It should only take a few minutes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#240975](#240975) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240975 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* I guess that is only if the flavours are the same for each product? Here I am assuming that : value = flavour type i.e. apple, banana characteristic = flavour ? Thanks for all your help so far, but I think I am still struggling to understand how I can simplify this for myself to add 178 flavours to a product without typing each one manually Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 5 months ago [\#240977](#240977) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#240977 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, No. You need to enter all the possible flavours as values of your flavour characteristic. Once that's done, you can import your products with the variants you want for each product. Each product doesn't have to have a variant for each value of the characteristic. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")** - [![ncoates's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6378-ncoates "View ncoates's Profile") Topic Author - [ Offline](/forum/user/6378-ncoates) Less More - Posts: 56 - Thank you received: 0 - - 10 years 5 months ago [\#241074](#241074) by [ncoates](/forum/user/6378-ncoates "View ncoates's Profile") Replied by *[ncoates](/forum/user/6378-ncoates "View ncoates's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#241074 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* I need to enter all the possible flavours as values of my characteristic, yes, I know, but there are so many flavours that to type them all would take so long, I wanted to be able to copy them from the CSV I have and paste them somewhere or do a mass upload - this is my exact question, is there a simple way or have I no option but to manually type in 178 values for this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 10 years 5 months ago [\#241079](#241079) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass upload variants](/forum/44-mass-actions/884465-mass-upload-variants#241079 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.5.1 -- PHP version -- : 5.4.40 Hi Please can you tell me the best way to mass upload variants? I have tried exporting various different selections of CSV and XLS and editing that file and then uploading but this does not add any variants, am I doing something wrong? I have 1 product that has 1 Characteristic (Flavour) but there are around 50 flavours, this is my goal, to upload mass flavours to 1 product.... Thank you Neil")* Hi, You can potentially create a MySQL request from that csv file with some PHP code. This MySQL will have to insert values in the table "#__hikashop_characteristic", the only columns to fill are "characteristic_value" which is the name of the variant and "characteristic_parent_id" must be the id of the characteristic. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.104 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)