[Solved] How to show product discounts for bulk orders in product grid?

patrickbozic wrote: ↑

Fri Oct 05, 2018 8:06 pm

Working with OpenCart 2.0.1.1. and the Journal 2 template, I have several products with bulk-order discounts. When displaying them in the product grid (category.tpl) I would like to display the lowest discount price instead of the regular price (if a product has a discount). I've understood the basics of OpenCart's MVC system, but I don't know the best way to access the discount data in the category.tpl file.

I've tried to access discounts data in category.php via:

Code: Select all

$discounts_data = $this->model_catalog_product->getProductDiscounts($result['product_id']);

$discounts = array();

foreach ($discounts_data as $discount) {
	$discounts[] = array(
		'quantity' => $discount['quantity'],
		'price'    => $this->currency->format($this->tax->calculate($discount['price'], $result['tax_class_id'], $this->config->get('config_tax')))
	);
}

and then passing $discounts into $data['products'] by adding 'discount' => $discounts

Then in category.tpl I've tried to access that data via $product['discount'], but it seems that no values get passed over from category.php. Does anyone have an idea how to do this?

Thanks a lot

$discounts[]

$discounts[$discount['product_id']]

'discount'    => $discounts

'discount' => (!empty($discounts[$result['product_id']]) ? $discounts[$result['product_id']] : array())

straightlight wrote: ↑

Sat Oct 06, 2018 8:17 pm

The issue is once you created the array from the controller, you then need to extract the created $product['discount'] array in your TPL file. As an alternate solution, you can modify your $discounts array from the controller from:

Code: Select all

$discounts[]

to read:

Code: Select all

$discounts[$discount['product_id']]

Then, replace:

Code: Select all

'discount'    => $discounts

with:

Code: Select all

'discount' => (!empty($discounts[$result['product_id']]) ? $discounts[$result['product_id']] : array())

Then, you can use the: $product['discount']['quantity'] and $product['discount']['price'] from your TPL file with an IF statement.