Compare actual product price against db tables

[NemoPS]

Hi there everyone,

I'm working on a layered navigation module, and currently having a REALLY bad time getting the right price out of products. Prestashop pricing system is pretty complicated, since is based on multiple factors placed in multiple tables. So a product can cost 32€ to me and 48€ to somebody else. I managed to get the right price using Product::getPriceStatic, even if it causes a bad table streass if the products are like 1200, the real problem is: ho can i check that value, the actual price, in database, since it's spreaded into multiple columns, present for some products, not present for others?

 

I hope somebody can help me

 

regards