Importsheet question

  • Posts: 45
  • Thank you received: 1
9 years 11 months ago #184344

-- HikaShop version -- : 2.3.4 Business
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : Chrome 39.0.2171.95 m

Maybe simple solution, but it seems that i can't find the answer:
Were do I find information of the importsheet, what colom does what.
I need to create several different product groups, (Wines) and the next level is white wines and the final level is the product it self. help? :dry:

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

  • Posts: 12953
  • Thank you received: 1778
9 years 11 months ago #184352

Hello,
If you want more information about the import/export option, a solution can maybe be to create a test product, export it through a CSV file and check that CSV file.

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

  • Posts: 45
  • Thank you received: 1
9 years 10 months ago #184395

I created a csv file and tested the import. Creating main categories worked just fine. Only the products and prices are not imported, so somewere there someting is wrong. I attached the testfile. Can you have a look wat's wrong?

Thankx.

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 10 months ago #184398

Delete the product_id column as these products do not exist yet.
Also, for the product_code of the variants, you should put a product code, not the description of the product. The description should actually go in the product_description column.
Finally, you're import two products with three variants each. In such case, you should have a characteristic with three values and link the products/variants to the corresponding value in the CSV.
If you create a product with variants in the backend and that you export it, you'll see that you get an extra column for the characteristic of the product and the values for each row link the variant/product to the values of the characteristic.
Also note that the characteristic and the values should already exist in your backend before importing a CSV referencing the characteristic/values.

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

Time to create page: 0.087 seconds
Powered by Kunena Forum