Skip to main content

Same product names get put together in result

12 years 4 months ago - 12 years 4 months ago #160069 by Fontijn
-- url of the page with the problem -- : localhost
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 2.5.19
-- PHP version -- : 5.3.18
-- Browser(s) name and version -- : Firefox

Hi,

Facing an problem when visiting my report page. (See attachment for the options i selected)
The report i made shows how many times an product has been sold.

It seems that the system isnt checking the id's of the products and makes an result for every id. Instead i think the systems makes an result for every product name.
Cause i have 2 products with the same name, in the report page they get put together and show as one result.

You can test it yourself by making 2 products and give them the exact same name the only difference is to change the alias so you dont get an error. Then make an order and see what happens ;)

Is there any solution to this problem?

Dear regards,

Fontijn
Last edit: 12 years 4 months ago by Fontijn.

Please Log in or Create an account to join the conversation.

12 years 4 months ago - 12 years 4 months ago #160405 by Fontijn
Solved!

Administrator\components\com_hikashop\classes\widget.php Line 1634 :
Code:
.$leftjoin.' '.$filters.' GROUP BY prod.order_product_name ORDER BY Total '.$order.' '.$limit;

Change to :
Code:
.$leftjoin.' '.$filters.' GROUP BY prod.product_id ORDER BY Total '.$order.' '.$limit;
Last edit: 12 years 4 months ago by Fontijn.

Please Log in or Create an account to join the conversation.

12 years 4 months ago #160426 by Jerome
Hi,

Thanks, we will add your fix in HikaShop.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Please Log in or Create an account to join the conversation.

Time to create page: 0.077 seconds
Powered by Kunena Forum