SOLVED! How to remove (unpublish) currently used price quantity levels?

  • Posts: 38
  • Thank you received: 5
  • Hikashop Business
4 years 7 months ago #309532

-- url of the page with the problem -- : outsidefabric.com
-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.10
-- PHP version -- : 5.7
-- Browser(s) name and version -- : chrome

Out site has 3 public price quantity levels (0-9, 10-59, 60+) and another 3 only for Wholesale customers (0-9, 10-59, 60+)... We would like to hide from the public all 3 of quantity levels and have any non-wholesale users only see "Retail Price."

How can we do this on all products with the public pricing levels without having to go in to each one and deleting each level?

Thanks in advance for the help!

Last edit: 4 years 5 months ago by shockoe.

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
4 years 7 months ago #309556

Hi,

Normally, if you configure the 3 public prices for the guest / registered user groups, and the 3 wholesale prices for the wholsale customers user group, each user will only see his 3 prices.
So I'm not sure what you want to delete / change ?

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

  • Posts: 38
  • Thank you received: 5
  • Hikashop Business
4 years 7 months ago #309563

We NOW want to hide (delete if we have to) the 3 public quantity price levels... WITHOUT having to go into each product separately to delete/hide the level. We only want the public to see the "Retail Price". We still want the "Wholesale" users to see the quantity discounts.

Please help...

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
4 years 7 months ago #309571

Hi,

Just hiding the prices for the public on the product page is easy with a small view override of product / listing.php via Display>Views.
With a bit of PHP, you would load the user groups of the current user and based on the user groups, you would skip the foreach which displays the prices or not.
joomla.stackexchange.com/questions/18357...evel-user-belongs-to
www.hikashop.com/support/documentation/1...ize-the-display.html
If you know PHP and with what is in these two links, you should be able to achieve it.
However, the devil is in the details... This won't mean that it will change anything for the price of the product in the cart, checkout, order for these users. But you're not talking about that in your messages. But maybe you don't want to sell to these users either, only to wholesale users ? In that case, this change could be fine on its own.
Otherwise, I'm afraid that the prices will have to be changed in the products. And in that case, the fastest could be to do MySQL query in your database via phpmyadmin.
For example:

DELETE FROM #__hikashop_price where price_access LIKE '%,XX,%'
where #__ is the prefix of your tables and XX the id of a user group. This query will delete all the prices assigned to that user group (even if they are assigned to other user groups).

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

Time to create page: 0.069 seconds
Powered by Kunena Forum