[Skip to main content](#vessel-content)

#   Wrong Price listing in product\_show

##

- **[benkly](/forum/user/547-benkly "View benkly's Profile")**
- [![benkly's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/547-benkly "View benkly's Profile") Topic Author
- [ Offline](/forum/user/547-benkly)

Less More

- Posts: 73
- Thank you received: 0
-
-

15 years 9 months ago [\#5609](#5609) by [benkly](/forum/user/547-benkly "View benkly's Profile")  *[Wrong Price listing in product\_show](/forum/4-how-to/5609-wrong-price-listing-in-product-show#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.")* was created by *[benkly](/forum/user/547-benkly "View benkly's Profile")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MDktd3JvbmctcHJpY2UtbGlzdGluZy1pbi1wcm9kdWN0LXNob3c/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 9 months ago [\#5614](#5614) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Wrong Price listing in product\_show](/forum/4-how-to/5609-wrong-price-listing-in-product-show#5614 "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.")*

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

$query = 'SELECT * FROM '.hikashop::table('price').' WHERE '.implode(' AND ',$filters);

by the code Code:

$query = 'SELECT * FROM '.hikashop::table('price').' WHERE '.implode(' AND ',$filters). ' ORDER BY price_value ASC';

and the code Code:

$query = 'SELECT a.* FROM '.hikashop::table('price').' AS a WHERE '.implode(' AND ',$filters);

by the code 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MDktd3JvbmctcHJpY2UtbGlzdGluZy1pbi1wcm9kdWN0LXNob3c/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[benkly](/forum/user/547-benkly "View benkly's Profile")**
- [![benkly's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/547-benkly "View benkly's Profile") Topic Author
- [ Offline](/forum/user/547-benkly)

Less More

- Posts: 73
- Thank you received: 0
-
-

15 years 9 months ago [\#5631](#5631) by [benkly](/forum/user/547-benkly "View benkly's Profile")  Replied by *[benkly](/forum/user/547-benkly "View benkly's Profile")* on topic *[Re: Wrong Price listing in product\_show](/forum/4-how-to/5609-wrong-price-listing-in-product-show#5631 "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.")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MDktd3JvbmctcHJpY2UtbGlzdGluZy1pbi1wcm9kdWN0LXNob3c/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

15 years 9 months ago [\#5681](#5681) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Wrong Price listing in product\_show](/forum/4-how-to/5609-wrong-price-listing-in-product-show#5681 "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.")*

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzU2MDktd3JvbmctcHJpY2UtbGlzdGluZy1pbi1wcm9kdWN0LXNob3c/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.064 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
