Import CSV and ITEM with VARIANT

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

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.

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

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.

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"

Hi,

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