Wrong Price listing in product_show

  • Posts: 73
  • Thank you received: 0
14 years 10 months ago #5609

Hello,

and again I have a problem I can not solve. For a product I have some more prices in matter of the quantity. So in the backend I set there some prices like for the quantitys:

0
10
25
50
100
250
500
1000

After saving they are showing like this, in the front- and backend:

1000
500
250
100
50
25
0
10

...or this....

1000
500
250
100
50
0
25
10

But why? How can I solve this? I want to have the highest price with the lowest quantity in the first line and the other under it.

Regards, Benny.

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

  • Posts: 84734
  • Thank you received: 13805
  • MODERATOR
14 years 10 months ago #5614

Could you edit the file administrator/com_hikashop/classes/currency.php and replace the code

$query = 'SELECT * FROM '.hikashop::table('price').' WHERE '.implode(' AND ',$filters);
by the code
$query = 'SELECT * FROM '.hikashop::table('price').' WHERE '.implode(' AND ',$filters). ' ORDER BY price_value ASC';
and the code
$query = 'SELECT a.* FROM '.hikashop::table('price').' AS a WHERE '.implode(' AND ',$filters);
by the code
$query = 'SELECT a.* FROM '.hikashop::table('price').' AS a WHERE '.implode(' AND ',$filters). ' ORDER BY a.price_value ASC';
and try again ?

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

  • Posts: 73
  • Thank you received: 0
14 years 10 months ago #5631

Hello,

thanks! ASC was the wrong direction but DESC did it. Now it updated and.....I had to hack it ones more. But now its working. But there is still a lot to do.

Regards, Benny.

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

  • Posts: 84734
  • Thank you received: 13805
  • MODERATOR
14 years 10 months ago #5681

Yes. We'll add that modification to next release. Thanks for the feedback.

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

Time to create page: 0.057 seconds
Powered by Kunena Forum