Hi there,
I have to write a sql query to retrieve some data form virtuemart tables and I need to extract the final price (salesprice) but I still do not understand where (and if it is) this price is stored into db;
for example, in this record I do not see any discount but in the frontend of the website yes... could you help me?
(http://www.mountainworldaq.it/shared/virtuemart_product_prices.gif)
(http://www.mountainworldaq.it/shared/price_into_site.gif)
Hi,
the prices are not stored into db. The salesprice is calculated by core function.
Regards,
Maik
ok thanks, but do you know how the function apply (calculate) discount and taxes if product_discount_id and product_tax_id in the db are 0?