OpenCart Community

Is there a way to get product reviews by brand in opencart 2.3. 0.2? I want to know if it is possible to do so to create a mod or look for a mod that does it or comes close to doing it. I'm interested because I developed a marketplace of stores based on opencart and it is organized in such a way that each store is actually a manufacturer, and its products are associated with said manufacturer, from which i need to see how to extract product ratings from each manufacturer to get the statistics of store ratings and rates them with stars as is done with products.

Hi!

Yes, this can be done with just one SQL query. The query will need to use the oc_review (avg), oc_product, and oc_manufacturer_description tables.

halfhope wrote: ↑

Sun Sep 15, 2024 11:25 am

Hi!

Yes, this can be done with just one SQL query. The query will need to use the oc_review (avg), oc_product, and oc_manufacturer_description tables.

Thank you very much, I made an ocmod that achieves this and shows the brand rating on the product sheet, below the brand, a brand must be assigned to the product and have comments.



here link : https://www.opencart.com/index.php?rout ... n_id=46485

This ocmod for oc2.3.0.2 shows the average product ratings assigned to the manufacturer brand, scoring with native opencart stars the brand rating based on product reviews.

for default theme

PLEASE BUY IT IF ANYONE NEEDS IT, I need resources to buy other mods for my projects. Thanks