"What People are Buying right now?" Opencart Module for free

Another free Opencart module for my visitors and subscribers, this extension will show “What People are buying right now?”. It lists out the recently ordered products.

To download the module click below:

Download What People are Buying module for free

Installation

Upload the folders ‘admin’ and ‘catalog’ and their files from the extracted directory to your server OpenCart main directory. Check this installation video if have any issues

OpenCart core files are not changed.

After installation:

You can edit the module and setup following:

Then setup in your preferred layout and you will see like below:

Query implemented is below:

public function getLatestOrderedProducts($limit)
{
	$product_data = "";
	$product_data = $this->cache->get('product.latestordered.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . $this->config->get('config_customer_group_id') . '.' . (int)$limit);

	if (!$product_data) {
		$product_data = array();

		$query = $this->db->query("SELECT op.product_id FROM " . DB_PREFIX . "order_product op LEFT JOIN `" . DB_PREFIX . "order` o ON (op.order_id = o.order_id) LEFT JOIN `" . DB_PREFIX . "product` p ON (op.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY o.order_id DESC LIMIT " . (int)$limit);
		foreach ($query->rows as $result) {
			$product_data[$result['product_id']] = $this->getProduct($result['product_id']);
		}
		$this->cache->set('product.latestordered.' . (int)$this->config->get('config_language_id') . '.' . (int)$this->config->get('config_store_id') . '.' . $this->config->get('config_customer_group_id') . '.' . (int)$limit, $product_data);
	}

	return $product_data;
}