Resolved Update price using "virtuemart_product_id" rather than "product_sku"

Hello,

You can use the virtuemart_product_id instead of the SKU to update products, just can't use it to create new products. To use it, simply replace product_sku with virtuemart_product_id in your import file. In your template set the Update based on field to virtuemart_product_id as well.

Thank you for your reply,

I've just tried to do it and didn't work, maybe I've missed something. I tried to put only :

"virtuemart_product_id";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" all the lines get skipped.

Also tried :

"virtuemart_product_id";"product_sku";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_override" while I gave only one sku code for the product in the first line, this one doesn't get skipped while all the other lines without sku code do get skipped.

Here is the debug file for the last case: com_csvi.log.33.zip

Thank you for your help.

Hello,
In VirtueMart price import product_sku is one of the needed field and since it is not there, the rows are getting skipped. To solve this add product_sku field to your import with a fake value say 1. This way we are passing on with the needed field check and the price is updated with virtuemart_product_id. Let me know if this helps.

Hi again,

I've just figured out that I was doing a "price" operation which seemed more appropriate for a price update but when I used the "product" operation the price got updated as expected with only "virtuemart_product_id".

I'm still wondering why it doesn't work with the "price" operation ?

Thanks again and sorry for the inconvenience !

Hello,
In VirtueMart price import product_sku is one of the needed field

Ah ok now I get it! It would be nice to also include the virtuemart_product_id as an option of a required field since it's an unique ID for the product !

Also thank you for the fast reply.

Hello,

I'm still wondering why it doesn't work with the "price" operation ?

As i said earlier, product_sku is one of the required field in price import and since that was missing in your import file the record has been skipped. Did you see message that "Missing required fields" when the import is done?