Import CSV and ITEM with VARIANT

  • Posts: 156
  • Thank you received: 0
6 years 8 months ago #289679

-- HikaShop version -- : 3.3.2
-- Joomla version -- : 3.8.6
-- PHP version -- : 5.6

In my CSV i have the following column:

Column:
RECORD_TYPE

Such column include a row PRODUCT and a row MODEL

PRODUCT means main product and MODEL as variants (colours)

How it is possibile to import the right informations using just one column, as in this case. My aim is change as little as possible a csv that has thousands of items

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
6 years 8 months ago #289716

Hi,

I don't understand your question.
What do you mean by "import using just one column" ? You already use just one column, the "RECORD_TYPE" column.
Please provide more precise information.

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

  • Posts: 156
  • Thank you received: 0
6 years 8 months ago #289739

nicolas wrote: Hi,

I don't understand your question.
What do you mean by "import using just one column" ? You already use just one column, the "RECORD_TYPE" column.
Please provide more precise information.


As you can see from the attachment, in the first colun I have PRODUCT and MODEL
PRODUCT means product and MODEL means variants.



These information are all in the first column named record_type.

How can I import MODEL and its VARIANTS

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
6 years 8 months ago #289740

Hi,

If you want to import variants in your CSV, you need to have:
- a column for each characteristic (color, size, etc)
- in the main product row, you need to have the default value for each characteristic
- in each variant row, you need to have the value for each characteristic corresponding to each variant
- a column for the product_parent_id
- in each variant row, you need to have the product_code (or product_id) of the main product in the product_parent_id column

There is no need to have a record_type type of column.

It would be quite complex to change the way the import of the variants works to be able to work differently.

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

  • Posts: 32
  • Thank you received: 2
6 years 8 months ago #289806

I got something similar, i added a column "product_type" and for each row a value of :
"main" for product and "variant" for variants

@nicolas
is it required or product_parent_id is enough ?

@SuX
So column "record_type" = "product_type" and "PRODUCT" = "main" and "MODEL" = variant"

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
6 years 8 months ago #289810

Hi,

The product_type column is not necessary if you have the product_parent_id column filled.

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

Time to create page: 0.063 seconds
Powered by Kunena Forum