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

#   Import multiple characteristics

##

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

Less More

- Posts: 2
- Thank you received: 0
-
-

13 years 2 months ago [\#119936](#119936) by [boony21030](/forum/user/26878-boony21030 "View boony21030's Profile")  *[Import multiple characteristics](/forum/25-install-update/861321-import-multiple-characteristics#119936 "I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:  For example, suppose that you have a product with 1 characteristic being the size and two variants: 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  Can anyone explain it? Has anyone done this successfully?")* was created by *[boony21030](/forum/user/26878-boony21030 "View boony21030's Profile")*

I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:

*For example, suppose that you have a product with 1 characteristic being the size and two variants:
product\_code,product\_parent\_id,size
main\_product,,big
first\_variant,main\_product,big
second\_variant,main\_product,small*

Can anyone explain it? Has anyone done this successfully?

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

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

Less More

- Posts: 2
- Thank you received: 0
-
-

13 years 2 months ago [\#119952](#119952) by [boony21030](/forum/user/26878-boony21030 "View boony21030's Profile")  Replied by *[boony21030](/forum/user/26878-boony21030 "View boony21030's Profile")* on topic *[Import multiple characteristics](/forum/25-install-update/861321-import-multiple-characteristics#119952 "I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:  For example, suppose that you have a product with 1 characteristic being the size and two variants: 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  Can anyone explain it? Has anyone done this successfully?")*

I finally figured it out.. used this import
product_code,product_parent_id,reel-color,rod size
100,0,black,3x
12,100,amber,4x
13,100,clear,4x
336,100,green,5x

But it only updates 1 characteristics... any idea why?

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

13 years 2 months ago [\#119982](#119982) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import multiple characteristics](/forum/25-install-update/861321-import-multiple-characteristics#119982 "I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:  For example, suppose that you have a product with 1 characteristic being the size and two variants: 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  Can anyone explain it? Has anyone done this successfully?")*

The main product is not a variant. You just need to have the default characteristic selected there. So you're missing a line in your CSV. It should actually be:
product_code,product_parent_id,reel-color,rod size
100,0,black,3x
11,100,black,3x
12,100,amber,4x
13,100,clear,4x
336,100,green,5x

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

- **[jeaki](/forum/user/32878-jeaki "View jeaki's Profile")**
- [![jeaki's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32878-jeaki "View jeaki's Profile")
- [ Offline](/forum/user/32878-jeaki)

Less More

- Posts: 2
- Thank you received: 0
-
-

11 years 8 months ago [\#190383](#190383) by [jeaki](/forum/user/32878-jeaki "View jeaki's Profile")  Replied by *[jeaki](/forum/user/32878-jeaki "View jeaki's Profile")* on topic *[Import multiple characteristics](/forum/25-install-update/861321-import-multiple-characteristics#190383 "I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:  For example, suppose that you have a product with 1 characteristic being the size and two variants: 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  Can anyone explain it? Has anyone done this successfully?")*

I have a problem importing products that have variants. All together, with variants, I have more than 4k products. Whe I import the attached file, the results say i imported the products, but only one displays. any help would be appreciated, as this is getting to be very frustrating

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

11 years 8 months ago [\#190392](#190392) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Import multiple characteristics](/forum/25-install-update/861321-import-multiple-characteristics#190392 "I am trying to import for products with 3 variants (characteristics). I looked up the import documentations and cannot understand the explanation:  For example, suppose that you have a product with 1 characteristic being the size and two variants: 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  Can anyone explain it? Has anyone done this successfully?")*

Hi,

I invite you to read our documentation regarding the import of CSVs. There is section explaining the import of products with variants:
[ www.hikashop.com/support/support/documen...hikashop-import.html](https://www.hikashop.com/support/support/documentation/73-hikashop-import.html)
As explained there, you should have 1 line for the main product and 1 line for each variant (which is not the case in your CSV).
Here is how it should look like for the first product of your CSV:
[ take.ms/vqoYU](http://take.ms/vqoYU)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2MTMyMS1pbXBvcnQtbXVsdGlwbGUtY2hhcmFjdGVyaXN0aWNzP3RtcGw9bWFya2Rvd24=) 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.161 seconds

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

[](#top)
