Discounted Prices Database Location

[Waggers]

I'm just about to reduce our VAT inclusive prices to reflect the VAT reduction. I'm planning to copy the 'Prices' column in the 'Product' table to Excel, modify the prices an copy them back into the database.

However, we have many products with multiple prices (i.e. 1+ £10, 25+ £7, 100+ £5) which are set up in 'prices' section of the product details.

Can anyone tell be where, in the database, these multiple prices are stored? I can't see them in the 'Product' table?

Hope all this makes sense!

[Krithika]

Hello Richard

This can be found in the ProductProperties table. In the nType column, if you scroll down, you will find the discount entries against nType value of 4. Hope this helps.

Cheers

[Waggers]

Thank you Krithika,