Import multiple characteristics

  • Posts: 2
  • Thank you received: 0
11 years 9 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
11 years 9 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: 83893
  • Thank you received: 13580
  • MODERATOR
11 years 9 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
10 years 3 months 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

Attachments:

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

  • Posts: 83893
  • Thank you received: 13580
  • MODERATOR
10 years 3 months 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.070 seconds
Powered by Kunena Forum