Required fields for new product and variants impor

  • Posts: 25
  • Thank you received: 0
8 years 9 months ago #230536

-- HikaShop version -- : essential v2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6.8

Hello

I need to use .csv to create new products and import them. I have existing characteristics and
values that will be common to all products, however, each product and it's variants of those characteristics and values will have unique pricing.

How am I to build a new product in a .csv spread sheet to import it if I need to have “product_parent_id” “product_id” “product_code” in advance before I can import successfully?

I really don't want to copy a product and then export it to modify it and then re import it. If I had to do that I may as well create the products in Hikashop which is not optional because I have to many very complex products.

Thanks,

Mike

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 9 months ago #230540

Hi,

The product_code is the SKU of your products/variants so you must have it already somewhere. The product_id column is not necessary and should be removed from the CSV. The product_parent_id can contain either the product_id of the main product or its product_code (SKU), so you have that information as well.
That way, you don't need to first export the products and reimport. You can directly import a CSV with the correct data.

The following user(s) said Thank You: MichaelGary

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

  • Posts: 25
  • Thank you received: 0
8 years 8 months ago #232056

Hello,

I have another .csv question. So as you can see on the attached screen shot of a .csv export that I have three products. My products all have a 3 digit ID number that is used for the SKU.

You can see that one product "478" on row 20 has several variants and also one option that has 4 variants also.

All of the related variant information for that product appears is on rows 23 through 36 and is bellow the products, however, there is
also other variant information for the same variants/product that appear above the products in rows 4 through 19. Why is this and what
is this?

Apparently, if I want to use those same variants on another product created from scratch in the .csv, I would have to use all variants in rows 4-19 and 23-36? how would I name them?

I don't understand how to name those same variants for other new products?

Thank you,.

Attachments:

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

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

Hi,

The rows from 4 to 19 are variants without link to a main product. They are invalid I think in your database so they appear wrong in the export.
As you say, the variants have to be after the main product row, and the product_parent_id column of the variant has to contain the product_code of the main product.

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

Time to create page: 0.059 seconds
Powered by Kunena Forum