News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Base price & Final Price rules

Started by andrewm57, March 26, 2019, 18:07:47 PM

Previous topic - Next topic

andrewm57

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.


andrewm57

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.