[Skip to main content](#vessel-content) # Import - variants missing ## - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 4 days ago [\#252997](#252997) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#252997 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* was created by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* -- url of the page with the problem -- : [ www.insignia16.co.uk](http://www.insignia16.co.uk) -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 4 days ago [\#253024](#253024) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253024 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi, Before you import products with variants, you must make sure that all the values that you want to use are already listed in the characteristics that you can edit via the menu Products>Characteristics. So please check on that. The CSV itself looks fine. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 4 days ago [\#253079](#253079) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253079 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi, those characteristics are already there Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 3 days ago [\#253083](#253083) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253083 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi, Can you provide screenshots of the settings of these characteristics please ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 3 days ago [\#253130](#253130) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253130 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi See attached - [ ![Chara5.jpg](/forum/attachment/34146) ](/forum/attachment/34146 "Chara5.jpg") [ ](/forum/attachment/34146?download=1 "Chara5.jpg") - [ ![Chara3.jpg](/forum/attachment/34147) ](/forum/attachment/34147 "Chara3.jpg") [ ](/forum/attachment/34147?download=1 "Chara3.jpg") - [ ![Chara2.jpg](/forum/attachment/34148) ](/forum/attachment/34148 "Chara2.jpg") [ ](/forum/attachment/34148?download=1 "Chara2.jpg") - [ ![Chara4.jpg](/forum/attachment/34149) ](/forum/attachment/34149 "Chara4.jpg") [ ](/forum/attachment/34149?download=1 "Chara4.jpg") - [ ![Chara1.jpg](/forum/attachment/34150) ](/forum/attachment/34150 "Chara1.jpg") [ ](/forum/attachment/34150?download=1 "Chara1.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 3 days ago [\#253149](#253149) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253149 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* I have just imported the original export I made, it shows the dropdown options, but if I add any new products to the spreadsheet it seems to then disable the dropdowns for the quantity & size, but not the white options. It must be something I am doing wrong when adding a product to the spreadsheet, only thing I can think of? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 2 days ago [\#253141](#253141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253141 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi, It looks like you don't have the values of the "Select Quantity" that you're trying to import. Here is what you have in your CSV: [ take.ms/w05QW](http://take.ms/w05QW) and among them only the "500" value is present in your characteristic values screenshot. So either correct the CSV to have the exact values that you have on your website, or add the missing values in the characteristic on the website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 2 days ago [\#253224](#253224) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253224 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Ok, on the quantities that did not appear on my spreadsheet, strange. I took all the commas out of the quantities as the csv would not allow commas, the quantities are now appearing, but the sizes are not appearing apart from the 2 different ones I entered onto the site when building the product, all the sizes I've added to the spreadsheet are not showing, could it be it would not import anything with a " in? eg, my sizes show as 1.5" x 1.5", maybe I should try this as showing as 1.5in x 1.5in ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 2 days ago [\#253225](#253225) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253225 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* I tried using 1.5in x 1.5in as opposed to 1.5" x 1.5" and that didn't change things, but now the prices on the larger quantities are not importing, very confusing as to why this is happening, any help would be appreciated Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")** - [![NuttyKevin's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Topic Author - [ Offline](/forum/user/45596-nuttykevin) Less More - Posts: 21 - Thank you received: 0 - - 10 years 2 days ago [\#253226](#253226) by [NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile") Replied by *[NuttyKevin](/forum/user/45596-nuttykevin "View NuttyKevin's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253226 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Update I have found a slightly long way round, if I enter the variants into the product in Hikashop and export, I can then add the prices and weight into the spreadsheet and import, this seems to get round the issue of having the variants appear on the site, had hoped I could do everything in the spreadsheet, but at least this is a slightly quicker option. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 10 years 1 day ago [\#253253](#253253) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import - variants missing](/forum/37-import-export-csv-xls/887036-import-variants-missing#253253 "-- url of the page with the problem -- : www.insignia16.co.uk -- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 When I import products back into store, the variants are missing. I have 3 variants, White Option, size and quantity, the white option shows fine, but it does not import the size and quantity variants for some reason. I have only added more products to the csv and have not adjusted any of the headers, so not sure why this is happening. I am using LibreOffice as the csv editing program")* Hi, It should be possible to do everything with the CSV. So you must still have had some difference between the CSV values and what you had in the website. The export/import solved that yes. I guess that if you base yourself on that CSV to duplicate it for another product, it should be able to create all the variants during the import. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODcwMzYtaW1wb3J0LXZhcmlhbnRzLW1pc3Npbmc/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.386 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)