Prestashop中的产品信息

Does anyone know how to get the product information by product ID and show the correct price in prestashop? I have tried a custom SQL query and I can get the product information, however I can't seem to show the correct price since Prestashop stores different price scenarios in separate tables. ex. ps_product, ps_specific_price, ps_attribute_impact

you can use the prestashop class.

$product = new Product($id_product,false,$lang_id);

now you will have all details in $product variable. if you want to take any variable you take like this.

$name = $product->name;

it is for prestashop 1.5x

I figured out the looping problem. I had to create an array to store all the information in. It ended up working like this

$products = array();
foreach($productIDs as $productID) {
$products[$productID['id_product']] = new Product($productID['id_product'], false, '1');
}