MySQL

,

Directly run a mySql query on magento for the best seller+

I have prefixed the tables “mag_”, please change to suit. SELECT product_id, sum( total_qty_ordered ) AS ‘total’, `value` AS product_nameFROM...

Read More+ 4 years ago
, ,

OpenCart efficiency – logging viewed products+

OpenCart, straight out of the box, helpfully records products viewed. /catalog/model/catalog/product.php called from catalog/controller/product/product.php public function updateViewed($product_id) { $this->db->query(“UPDATE ”...

Read More+ 5 years ago