Show Total Vendor Products Beside Vendor Name

General General Questions
1

Hi,

may i know how to show total vendor product in the product page block and vendor page?

https://snag.gy/SWpg1j.jpg

Thank You

2

For example, you can create HTML block with Smarty support and the following code

Product page:

Total products from vendor: {"SELECT COUNT(product_id) FROM ?:products WHERE company_id = ?i AND status = ?s"|db_get_field:$product.company_id:'A'}

Vendor store page:

Total products from vendor: {"SELECT COUNT(product_id) FROM ?:products WHERE company_id = ?i AND status = ?s"|db_get_field:$company_id:'A'}
3

For example, you can create HTML block with Smarty support and the following code

Product page:

Total products from vendor: {"SELECT COUNT(product_id) FROM ?:products WHERE company_id = ?i AND status = ?s"|db_get_field:$product.company_id:'A'}

Vendor store page:

Total products from vendor: {"SELECT COUNT(product_id) FROM ?:products WHERE company_id = ?i AND status = ?s"|db_get_field:$company_id:'A'}

Hi,

can i put this in product page default_template.tpl?

4

Thank ecomlab, you save my day.

5

Thank ecomlab, you save my day.

You are welcome! This way of realization is not good from my point of view, but it works and it can be easily integrated