- Posts: 16
- Thank you received: 0
Same product names get put together in result
12 years 3 months ago - 12 years 3 months ago #160069
by Fontijn
Same product names get put together in result was created 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
-- 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 3 months ago by Fontijn.
Please Log in or Create an account to join the conversation.
12 years 3 months ago - 12 years 3 months ago #160405
by Fontijn
Replied by Fontijn on topic Same product names get put together in result
Solved!
Administrator\components\com_hikashop\classes\widget.php Line 1634 :
Change to :
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 3 months ago by Fontijn.
Please Log in or Create an account to join the conversation.
12 years 3 months ago #160426
by Jerome
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.
Replied by Jerome on topic Same product names get put together in result
Hi,
Thanks, we will add your fix in HikaShop.
Regards,
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.157 seconds