CSV import a custom field auto add to price

  • Posts: 81
  • Thank you received: 6
12 years 7 months ago #75604

how would you import a custom field via CSV which would add to the overall value of the price of a product?
i have the price column (price_value)already but need to add an additional cost which is set in csv file as deliver

NEED DESPERATE HELP!

And i have Express Delivery Column but for the life of me have no clue how to import it directly into the express delivery shipping so it shows on checkout!!!!!

Last edit: 12 years 7 months ago by foxy3433. Reason: additional help needed

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

  • Posts: 2334
  • Thank you received: 403
12 years 7 months ago #75837

Hi there,

Like it's said in the import documentation :

...you can also insert variants of products. You will have to specify in the product_parent_id column the product_code of the main product which must be inserted before the variants in the file. You will also have to have column names matching the characteristics in the store.

For example, suppose that you have a product with 1 characteristic being the size and two variants:

product_code,product_parent_id,size

main_product,,big

first_variant,main_product,big

second_variant,main_product,small

Actually you just have to set a "product_type" column with the "variant" type for your variants :). You'll thus be able to change your variants price.

And about the shipping method you should check the FAQ as well ;)

Last edit: 12 years 7 months ago by Eliot.

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

  • Posts: 81
  • Thank you received: 6
12 years 7 months ago #75900

Thanks for that but i'm still lost no where can i find what the Columns actually relate to. i.e

product_parent_id what is that? where can i find it

i also found on the forum a few bits about shipping importing via mysql which i can successfully import but nothing happens when i try to purchase the product i think this column tables needs relations in means of what they relate to even though a few are self explanatory i'm hitting brick walls without knowing how to get around them!!!!

And where would you enter the variant price i only have 1 and want it to auto add to the price of the product without having to be selected

Last edit: 12 years 7 months ago by foxy3433.

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

  • Posts: 83995
  • Thank you received: 13605
  • MODERATOR
12 years 7 months ago #75941

We already told you several times what the product_parent_id is ! It's even written in Eliot's post above:

You will have to specify in the product_parent_id column the product_code of the main product


And the example CSV:
product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small

So if you have a main product with the code "main_product", its variants must have the value "main_product" in the product_parent_id.


If "nothing happens" it means that you didn't import the shipping prices properly. Please check that you can see them in the product edition page, in the shipping prices area and that all their data is correct.

Variant prices do NOT auto add to product prices. Variant prices replace the main product price. If you have a "price_value" column in your CSV, you can specify the price of each variant of the price, so you could simply enter there the price of your main product+the variant price.

PS: please stop posting the same questions everywhere or we'll have to delete doublons.

The following user(s) said Thank You: foxy3433

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

Time to create page: 0.069 seconds
Powered by Kunena Forum