Setting values for import

  • Posts: 12
  • Thank you received: 0
13 years 3 months ago #5768

I am really struggling to set up my CSV file for import with Business Edition and would appreciate help.

I have many products. Each product has a characteristic called "Size". Each characteristic has 3 variants... small, medium and large, each with its own price. My main problem is that I am struggling to set up the prices for my products as the price table (#_hikashop_price) has only 1 column for price_value. The #_hikashop_characteristic and #_hikashop_variant tables do not have a price in them so how do I set up the price for each of my variants?

Regards
Deon

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
13 years 3 months ago #5774

You can do like this:

product_code,product_parent_id,size,price_value
main_product,,S,10
variant_1,main_product,S,10
variant_2,main_product,L,12
variant_3,main_product,XL,14
variant_4,main_product,XXL,16

Note that you need to already have the characteristic "size" defined with at least the values S, L, XL and XXL entered for it, otherwise, the system won't be able to import the product in that example.

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

Time to create page: 0.052 seconds
Powered by Kunena Forum