Same product names get put together in result

  • Posts: 16
  • Thank you received: 0
10 years 4 months ago #160069

-- 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

Attachments:
Last edit: 10 years 4 months ago by Fontijn.

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

  • Posts: 16
  • Thank you received: 0
10 years 4 months ago #160405

Solved!

Administrator\components\com_hikashop\classes\widget.php Line 1634 :

.$leftjoin.' '.$filters.' GROUP BY prod.order_product_name ORDER BY Total '.$order.' '.$limit;

Change to :
.$leftjoin.' '.$filters.' GROUP BY prod.product_id ORDER BY Total '.$order.' '.$limit;

Last edit: 10 years 4 months ago by Fontijn.

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

  • Posts: 26146
  • Thank you received: 4026
  • MODERATOR
10 years 4 months ago #160426

Hi,

Thanks, we will add your fix in HikaShop.

Regards,


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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum