[Skip to main content](#vessel-content) # Import of Variants ## - **[mair](/forum/user/9742-mair "View mair's Profile")** - [![mair's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17.png)](/forum/user/9742-mair "View mair's Profile") Topic Author - [ Offline](/forum/user/9742-mair) Less More - Posts: 46 - Thank you received: 2 - - [](http://www.workwearandsports.co.uk/) - 14 years 2 weeks ago - 14 years 2 weeks ago [\#69318](#69318) by [mair](/forum/user/9742-mair "View mair's Profile") *[Import of Variants](/forum/4-how-to/69318-import-of-variants#69318 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* was created by *[mair](/forum/user/9742-mair "View mair's Profile")* Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. *This attachment is hidden for guests. Please log in or register to see it.* [ ![screendump.png](/forum/attachment/6192) ](/forum/attachment/6192 "screendump.png") [ ![screendump2.png](/forum/attachment/6193) ](/forum/attachment/6193 "screendump2.png") Nav --- [ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk) - [ ![screendump.png](/forum/attachment/6192) ](/forum/attachment/6192 "screendump.png") [ ](/forum/attachment/6192?download=1 "screendump.png") - [ ![screendump2.png](/forum/attachment/6193) ](/forum/attachment/6193 "screendump2.png") [ ](/forum/attachment/6193?download=1 "screendump2.png") Last edit: 14 years 2 weeks ago by [mair](/forum/user/9742-mair "View mair's Profile"). Reason: Added further information Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mair](/forum/user/9742-mair "View mair's Profile")** - [![mair's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17.png)](/forum/user/9742-mair "View mair's Profile") Topic Author - [ Offline](/forum/user/9742-mair) Less More - Posts: 46 - Thank you received: 2 - - [](http://www.workwearandsports.co.uk/) - 14 years 2 weeks ago [\#69328](#69328) by [mair](/forum/user/9742-mair "View mair's Profile") Replied by *[mair](/forum/user/9742-mair "View mair's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#69328 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* I am figuring this out, but it does seem to that I then have to go to every single products add the characteristics and then import each product at a time? I also have to manually add the characteristics to each product, before importing each product. For example throughout the whole product range their are 628 unique colours and combinations and 150 sizes. With 1012 unique products without variants being the parent products. Surely there must be a way to automate this process? Help would help so much ![:)](/media/kunena/emoticons/8.png ":)") --- [ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 14 years 2 weeks ago [\#69535](#69535) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#69535 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* Hi, The problem is that in your CSV you're missing the size and colour values. There, you should enter the size/colour which will be displayed on the product page by default. Since you don't have any, the variants cannot be generated properly for the product which is why you have to add your characteristics manually after importing the CSV. If the CSV would be correct, you wouldn't have to do that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mair](/forum/user/9742-mair "View mair's Profile")** - [![mair's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17.png)](/forum/user/9742-mair "View mair's Profile") Topic Author - [ Offline](/forum/user/9742-mair) Less More - Posts: 46 - Thank you received: 2 - - [](http://www.workwearandsports.co.uk/) - 14 years 2 weeks ago [\#69646](#69646) by [mair](/forum/user/9742-mair "View mair's Profile") Replied by *[mair](/forum/user/9742-mair "View mair's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#69646 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* Thanks so much for you help Nicolas, I put in one sample product and with the characteristics manually. The after exporting the csv I opened it up in Excel and simply changed the data. It seems I have to click manage variants to save each product with the variants? The Categories have been imported successfully. I have included the exported CSV, does anything seem odd in this to you? *This attachment is hidden for guests. Please log in or register to see it.* --- [ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 14 years 1 week ago [\#69882](#69882) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#69882 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* Hi, You should not have to click on the "manage variants" button of each product. If you have to do it after the import, it means that there is a problem with the CSV. I can see that you have some empty values in the colour column for some variants. That could be a problem. The column product_id should also be removed. Also make sure that all the values that you have for the characteristics in the CSV exists already in HikaShop. The following user(s) said Thank You: [mair](/forum/user/9742-mair "View mair's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mair](/forum/user/9742-mair "View mair's Profile")** - [![mair's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-17.png)](/forum/user/9742-mair "View mair's Profile") Topic Author - [ Offline](/forum/user/9742-mair) Less More - Posts: 46 - Thank you received: 2 - - [](http://www.workwearandsports.co.uk/) - 14 years 1 week ago [\#69927](#69927) by [mair](/forum/user/9742-mair "View mair's Profile") Replied by *[mair](/forum/user/9742-mair "View mair's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#69927 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* Thanks nicolas, Can I remove columns that I simply don't need ? --- [ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 14 years 1 week ago [\#70042](#70042) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Import of Variants](/forum/4-how-to/69318-import-of-variants#70042 "Hi, If I wish to import variants, I believe the characteristics need to be created first, Is this correct? The problem that I am having is if for example I have two products: Product1: sweatshirt Large, Medium, Small and then the colours Red Blue Green Product2: Tshirt 5-6, 7-8, 9-11 and the colours Yellow, Pink, White Do I need to create separate characteristics for these before I import? Any help would be greatly appreciated as always. I have added the screen dumps, the products initially appear in the front end, but without the correct quantities, but then when I go into manage variants, I get the saved message and they then disappear. Nav")* Yes. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY5MzE4LWltcG9ydC1vZi12YXJpYW50cz90bXBsPW1hcmtkb3du) 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.234 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)