Update vm prices remotely

[pm4698]

Hello there,

I have a Joomla 3.6.4 with VM 3.0.18 website and i am working with a developer who builds a bridge between eshop and an ERP.

When he updates the table __virtuemart_product_prices and places product_price and 0 as product_discount_id, in backend we get the same price at Cost price and Final price fields and the drop down besides Final price is set to Apply generic rules.


So, like this if we have some discount rules in Taxes & Calculation rules those rules are not applied at all in product. But, in backend if you just fill in Cost price and besides Final price you select apply generic rules, then Final price is autocalculated on save.

Any ideas on this?

Thank you in advance

[Milbo]

you should only update the costprice, the rest is done by the rules https://docs.virtuemart.net/manual/general-concepts/204-tax-and-calculation-rules-overview.html