How can we upload a product with variants?

  • Posts: 386
  • Thank you received: 7
  • Hikashop Business
3 years 3 months ago #328578

-- HikaShop version -- : 4.4.0
-- Joomla version -- : ‎3.9.23
-- PHP version -- : 7.3.25

How can we upload a product with variants? We do the upload with the text area.

We have created the characteristic "Sauces" with different values.

Now we want to upload a product called "Sauces" with different variants (from the characteristic).

What we need in fields:
product_code, product_parent_id, product_name, product_alias, options, price_value, categories, product_vendor_id

We now have this:
product_code,product_type,product_parent_id,product_name,product_alias,options,price_value,categories,product_vendor_id
Sausjes 222,main,,Sausjes,Sausjes 222,,2.60,81,4
Harissa,variant,Sausjes 222,Harissa,,,,,4
Knoflooksaus,variant,Sausjes 222,Knoflooksaus,,,,,4

But we don't get the characteristic in the product. See attachment



Regards,
Michiel

Attachments:

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

  • Posts: 4519
  • Thank you received: 611
  • MODERATOR
3 years 3 months ago #328594

Hello,

Don't forget that you can process some search in this forum to have some answer or the most common questions, here "import products variants".

You can have a look on this topic in order to learn more details, and even see an CSV example.

And don't forget to use the "Help" button to have more details about how to use HikaShop Configuration in general.

Hope this will help you to progress on your subject.

Regards

Last edit: 3 years 3 months ago by Philip.

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

  • Posts: 386
  • Thank you received: 7
  • Hikashop Business
3 years 3 months ago #328634

Thank you for your response ... I know you can search, but I can't figure it out yet.
I have tried everything again and have "Harissa" as standard with the main product.

product_code,product_type,product_parent_id,product_name,product_alias,Sausjes,options,price_value,categories,product_vendor_id
Sausjes 222,main,,Sausjes,Sausjes 222,Harissa,,2.60,81,4
Harissa,variant,Sausjes 222,Harissa,,,,,,4
Knoflooksaus,variant,Sausjes 222,Knoflooksaus,,,,,,4

The variants have been uploaded correctly, but no default has been selected yet ??
The main product is "Sauces" and the characteristic is also called "Sauces" ... and with the main product I tell the system that "Harissa" is the default for Sauces. What am I missing here?

Attachments:
Last edit: 3 years 3 months ago by BluepointWebdesign.

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
3 years 2 months ago #328678

Hi,

This would indicate that the value you entered in the cell of the main product for the column of the characteristic isn't in the list of available values in the characteristic.
Now, I don't know how you configured your characteristic so I can't say for sure.
However, a good way to go about it is to do it the other way around:
- you first create a product with the variants like you want via the interface.
- you check the checkbox of that product on the products listing and click on the "export" button
- that will give you a CSV file of the data of the product that you can open with excel
- you delete all the unecessary columns and keep only the ones you want
- you delete the empty lines
You'll get the CSV file you can use for an import of that product including the variants.

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

Time to create page: 0.077 seconds
Powered by Kunena Forum