Import multiple characteristics

  • Posts: 2
  • Thank you received: 0
12 years 7 months ago #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_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 or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
12 years 7 months ago #119952

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 or Create an account to join the conversation.

  • Posts: 85393
  • Thank you received: 13959
  • MODERATOR
12 years 7 months ago #119982

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 or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
11 years 1 month ago #190383

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

This message has an attachment file.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

  • Posts: 85393
  • Thank you received: 13959
  • MODERATOR
11 years 1 month ago #190392

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
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

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Powered by Kunena Forum