[Skip to main content](#vessel-content)

#   Importing Variants

##

- **[HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")**
- [![HH-Frisco's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1537-hh-frisco "View HH-Frisco's Profile") Topic Author
- [ Offline](/forum/user/1537-hh-frisco)

Less More

- Posts: 11
- Thank you received: 0
-
-

15 years 5 months ago [\#17245](#17245) by [HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")  *[Importing Variants](/forum/4-how-to/17245-importing-variants#17245 "The documentation for the importing of variants shows product&#95;code,product&#95;parent&#95;id,size main&#95;product,,big first&#95;variant,main&#95;product,big second&#95;variant,main&#95;product,small  I have the following questions: 1-the characteristic &quot;size&quot; has to be all ready defined. Do the variants associated with &quot;size&quot; have to all ready be defined? 2-Why is &quot;big&quot; utilized on the second line where the product is defined? Could &quot;small&quot; have been used? 3-What do the third and fourth line do? Do they define new variants for the characteristic &quot;size&quot;? Do they define what variants should be shown for &quot;main&#95;product&quot;? 4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big &amp; small. 5-when do you use the variant&#95;id in an import?")* was created by *[HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")*

The documentation for the importing of variants shows
product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small

I have the following questions:
1-the characteristic "size" has to be all ready defined. Do the variants associated with "size" have to all ready be defined?
2-Why is "big" utilized on the second line where the product is defined? Could "small" have been used?
3-What do the third and fourth line do? Do they define new variants for the characteristic "size"? Do they define what variants should be shown for "main_product"?
4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big &amp; small.
5-when do you use the variant_id in an import?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3MjQ1LWltcG9ydGluZy12YXJpYW50cz90bXBsPW1hcmtkb3du) 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: 86316
- Thank you received: 14276
-
-

15 years 5 months ago [\#17258](#17258) 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 Variants](/forum/4-how-to/17245-importing-variants#17258 "The documentation for the importing of variants shows product&#95;code,product&#95;parent&#95;id,size main&#95;product,,big first&#95;variant,main&#95;product,big second&#95;variant,main&#95;product,small  I have the following questions: 1-the characteristic &quot;size&quot; has to be all ready defined. Do the variants associated with &quot;size&quot; have to all ready be defined? 2-Why is &quot;big&quot; utilized on the second line where the product is defined? Could &quot;small&quot; have been used? 3-What do the third and fourth line do? Do they define new variants for the characteristic &quot;size&quot;? Do they define what variants should be shown for &quot;main&#95;product&quot;? 4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big &amp; small. 5-when do you use the variant&#95;id in an import?")*

1. yes
2. it's to specify the default value. You could have put small indeed.
3. yes, they are variants. the 2nd line is the main product. The 3 and 4 are its variants. that enables you to define for example different prices for different variants
4. that's indeed the case
5. There is no variant_id. The system handles the variant table automatically based on product_parent_id which indicates which variant is for which product.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3MjQ1LWltcG9ydGluZy12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")**
- [![HH-Frisco's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1537-hh-frisco "View HH-Frisco's Profile") Topic Author
- [ Offline](/forum/user/1537-hh-frisco)

Less More

- Posts: 11
- Thank you received: 0
-
-

15 years 5 months ago [\#17267](#17267) by [HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")  Replied by *[HH-Frisco](/forum/user/1537-hh-frisco "View HH-Frisco's Profile")* on topic *[Re: Importing Variants](/forum/4-how-to/17245-importing-variants#17267 "The documentation for the importing of variants shows product&#95;code,product&#95;parent&#95;id,size main&#95;product,,big first&#95;variant,main&#95;product,big second&#95;variant,main&#95;product,small  I have the following questions: 1-the characteristic &quot;size&quot; has to be all ready defined. Do the variants associated with &quot;size&quot; have to all ready be defined? 2-Why is &quot;big&quot; utilized on the second line where the product is defined? Could &quot;small&quot; have been used? 3-What do the third and fourth line do? Do they define new variants for the characteristic &quot;size&quot;? Do they define what variants should be shown for &quot;main&#95;product&quot;? 4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big &amp; small. 5-when do you use the variant&#95;id in an import?")*

I want a characteristic called "Size". Sometimes the product would have the "Size" value of Small, Medium, Large &amp; Extra Large. For other products the "Size" might be 10,12,&amp;14. How do I load the two different products and get the right variants? Currently when even if I import the third and fourth line that tells it which variant to use the product has all "Size" values loaded as variants.

Should I create two different characteristics both called "Size". One would have Small, Medium, Large &amp; Extra Large. The second would have 10,12,&amp; 14. But then on the import how would I tell the system which "Size" characteristic to use for creating variants?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3MjQ1LWltcG9ydGluZy12YXJpYW50cz90bXBsPW1hcmtkb3du) 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: 86316
- Thank you received: 14276
-
-

15 years 5 months ago [\#17272](#17272) 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 Variants](/forum/4-how-to/17245-importing-variants#17272 "The documentation for the importing of variants shows product&#95;code,product&#95;parent&#95;id,size main&#95;product,,big first&#95;variant,main&#95;product,big second&#95;variant,main&#95;product,small  I have the following questions: 1-the characteristic &quot;size&quot; has to be all ready defined. Do the variants associated with &quot;size&quot; have to all ready be defined? 2-Why is &quot;big&quot; utilized on the second line where the product is defined? Could &quot;small&quot; have been used? 3-What do the third and fourth line do? Do they define new variants for the characteristic &quot;size&quot;? Do they define what variants should be shown for &quot;main&#95;product&quot;? 4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big &amp; small. 5-when do you use the variant&#95;id in an import?")*

it is has all the variants when you go in the manage variants area of your product is means that the system wasn't able to import correctly your variants and that you didn't had any variant for your product. Thus, the system created all the variants automatically based on the characteristics of the product when you went there and not based on your CSV when you imported it.
You are right that you should have only one characteristic.
The problem lies in your CSV which has a problem.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE3MjQ1LWltcG9ydGluZy12YXJpYW50cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; 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.122 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
