[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 5 months ago [\#241312](#241312) 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?start=20#241312 "-- 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")* Unfortunately I am no php code writer I'm not sure I understand why such a simple thing has not been integrated into Hikashop? Surely if I create a product with 178 flavours in Hikashop, then exported it to CSV, and then imported it into another Hikashop website, then all the flavours would be there? If this is the case then why can I not just export my product, edit the CSV and import it again? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#241316](#241316) 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?start=20#241316 "-- 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, > this is my exact question, is there a simple way or have I no option but to manually type in 178 values for this? As I told you before, you can use the CSV import from PHPMyAdmin to import that data in the hikashop_characteristic table. You have three things: - characteristics - products - variants of products generated out of the values of characteristics. When you export a CSV of products, you'll get the products and the variants data in your CSV. You won't have the characteristics data. So you would first have to add the characteristic and its values before importing the CSV of the products and variants in your new website in your example. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#241359](#241359) 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?start=20#241359 "-- 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")* > ncoates wrote: Unfortunately I am no php code writer > > I'm not sure I understand why such a simple thing has not been integrated into Hikashop? > > Surely if I create a product with 178 flavours in Hikashop, then exported it to CSV, and then imported it into another Hikashop website, then all the flavours would be there? > > If this is the case then why can I not just export my product, edit the CSV and import it again? So this wouldn't work?? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#241379](#241379) 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?start=20#241379 "-- 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")* It depends what you mean by "this". > Surely if I create a product with 178 flavours in Hikashop, then exported it to CSV, and then imported it into another Hikashop website, then all the flavours would be there? You would first have to add the characteristic and all its values in the new website. Then, you could import a CSV of 3000 products with all their variants of the different flavours for each one automatically to the new website. You can export your product, edit the CSV and import it again. The modifications will be done to the product. But if you want to add a new bunch of variants to a product, you first need to add the corresponding values in the characteristic used in the product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#242568](#242568) 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?start=20#242568 "-- 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 basically I still have to type in 178 flavours (values) and if those flavours (values) are different for 50 products, thats a lot of typing.... To have the ability to copy and paste these flavours would be so much easier, as I have these available to copy.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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 [\#242571](#242571) 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?start=20#242571 "-- 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 just have to type all the different flavours possible as values of the characteristic. You need to do that only once. Once done, you can use the values for each product without having to type anything. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODQ0NjUtbWFzcy11cGxvYWQtdmFyaWFudHM/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)