[SOLVED] Adding sold items counter on product details page PS1.6

[azizimranz]

Hi All,

 

Can anyone tell me the detailed answer how can I implement the number of sold items in product details page in PrestaShop 1.6?

 

 

Thanks in advance.

[vekia]

in product.php class add this code

    public static function getNbOfSales($id_product){
        $res = Db::getInstance()->getRow('
			SELECT quantity FROM `'._DB_PREFIX_.'product_sale`
			WHERE `id_product` = '.(int)$id_product);
            return $res['quantity'];
    }

then in product.tpl template file you can use:

{Product::getNbOfSales($product->id)}

to display product sales nb

[azizimranz]

Hi Vekia,

 

Thanks a lot.

 

Its solved.

[vekia]

you're welcome :-)

glad to hear that i could help a little with this little piece of code

topic title marked as solved.

with regards,

Milos

[pixelhk]

where should i place this statement?

 

{Product::getNbOfSales($product->id)}

[1Luciano]

Guess the guy who posted it doesn't seem to have an answer to it.