VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: andrewm57 on March 26, 2019, 18:07:47 PM

Title: Base price & Final Price rules
Post by: andrewm57 on March 26, 2019, 18:07:47 PM
I had a company import J 2.5.28 + VM 2.6.18 data into my new J 3.9.4 & VM 3.4.2 build.

However, they did not import tax/calculations, which I've manually fixed. They also did not import the Base Price & Final Price rules on products.

Right now Base Price and Final Price are set to "Apply No Rule". They need to be "Apply Default Rules" & "Apply Generic Rules" respectively throughout.

I'm moderately comfortable with a phpMyAdmin/SQL solution, but I can't find where to make the change. Can somebody point me at the table/column(s) for making those changes?

TIA,
Andrew.

Title: Re: Base price & Final Price rules
Post by: andrewm57 on March 27, 2019, 03:20:37 AM
Nebermind. Finally traced thru the code to find that they are `product_tax_id` and `product_discount_id` in the ``xxxxx_virtuemart_product_prices` table.