[Skip to main content](#vessel-content) # Importing Product Variables Using CSV/excel ## - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13697](#13697) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") *[Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13697 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* was created by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file. I dont really want to have to add it through the shop one at a time. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13698](#13698) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13698 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* When you say variable, you mean a characteristic ? If your characteristic is called color and that you have the values blue and red, you can do like this: product_name,product_parent_id,color main product,,blue variant 1,main_product,blue variant 2,main product,red Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13793](#13793) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13793 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Sorry. Yes its is characteristic. Can these be added to the excel doc or can it only be done once it is converted to csv? Thanks. This is a great product by the way.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago - 15 years 6 months ago [\#13794](#13794) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13794 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* You can of course do the same in excel. a CSV is only a tabular data set : each comma separates the data into columns and each return carriage separates the data into rows. so in excel it will be like this: Code: product_name product_parent_id color main product blue variant 1 main product blue variant 2 main product red Last edit: 15 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13798](#13798) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13798 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Thanks again for amazing support. I take it then each product has to be listed with each of its colur variants. so i need to creat an entry for each color variant. There are 20 different colours so I need 20 different varriaions of that product listed in the excel sheet. The product id is it ceated automatically or do I need to creat it first before the import? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13799](#13799) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13799 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13800](#13800) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13800 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Am I on right track with attached.. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13802](#13802) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13802 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* The product id is indeed created automatically Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13803](#13803) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13803 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* xml attached #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13805](#13805) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13805 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* HikaShop does not handle xml for import, only CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13806](#13806) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13806 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Sorry saved in wrong format. #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13807](#13807) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13807 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Sorry saved in wrong format. #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13809](#13809) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13809 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* You don't need to precise all the information in the variants. Only the information which is different from the main product. It's faster and simpler. And when you need to change something in the future, it will be easier as you will only have to change the main product information. #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13858](#13858) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13858 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Thanks again for the corrected csv. When I import my products using this format into the shop I get the following error and the characteristics are not displayed. "6090 products found : 0 new products imported, 5800 invalid product code, 290 already existing products Have I got the product_parent_id wrong Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13861](#13861) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13861 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Ah, you should specify a product_code in your variants. But please note that each product_code should be unique. So, if your main product's code is "my_prod", you could have your variants code being "my_prod_blue", "my_prod_red", etc for example. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13863](#13863) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13863 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* great will try that. Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13864](#13864) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13864 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Hi Changed the code in product parent_id but still get invalid product code error. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13865](#13865) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13865 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* File attached #### *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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 - - 15 years 6 months ago [\#13868](#13868) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13868 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* The product_parent_id column should contain the code of the main product while the product_code column should contain the code of the variant. It should be like this: Parent_Category,categories,product_name,product_parent_id,Confirm Colour,product_code,price_value,images Base Units,Hi Line Base White,High Line Base 150mm x 720mm,,White,150B,21.71,hlbase.jpg ,,,150B,White,150B_w,21.71, ,,,150B,Cream,150B_c,21.71, ,,,150B,Vanilla,150B_v,23.87, ,,,150B,Alabaster,150B_a,23.87, ,,,150B,Natural Aida Walnut,150B_na,23.87, ,,,150B,Tobacco Aida Walnut,150B_ta,23.87, ,,,150B,Calais Oak,150B_co,23.87, ,,,150B,Light Winchester Oak,150B_lw,23.87, ,,,150B,Lancaster Oak,150B_lo,23.87, ,,,150B,Winchester Oak,150B_wo,23.87, ,,,150B,Canadian Maple,150B_cm,23.87, ,,,150B,Ellmau Beech,150B_eb,23.87, ,,,150B,Sand beige,150B_sb,23.87, ,,,150B,Lissa Oak,150B_lo,23.87, ,,,150B,Light Tiepolo,150B_lt,23.87, ,,,150B,Dark Tiepolo,150B_dt,23.87, ,,,150B,Woodline Mocha,150B_wm,26.33, ,,,150B,Dark Cordoba Olive,150B_dco,26.33, ,,,150B,Ontario Walnut,150B_ow,26.33, ,,,150B,Romano Cherry,150B_rc,26.33, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")** - [![scsplus's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1932-scsplus "View scsplus's Profile") Topic Author - [ Offline](/forum/user/1932-scsplus) Less More - Posts: 14 - Thank you received: 0 - - 15 years 6 months ago [\#13870](#13870) by [scsplus](/forum/user/1932-scsplus "View scsplus's Profile") Replied by *[scsplus](/forum/user/1932-scsplus "View scsplus's Profile")* on topic *[Re: Importing Product Variables Using CSV/excel](/forum/4-how-to/13697-importing-product-variables-using-csv-excel#13870 "I have an excel spread sheet containing 600 plus products the I can import into the shop no problem. Each product has the same variable ie colour. Is there away to add the variable to the excel file....")* Thanks. First class support.... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNjk3LWltcG9ydGluZy1wcm9kdWN0LXZhcmlhYmxlcy11c2luZy1jc3YtZXhjZWw/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.547 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)