Access level mass action

  • Posts: 46
  • Thank you received: 2
8 years 8 months ago #251486

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2

Hi,

I would like to change the products access level (ACL) for all products of my shop. Now they all are defined to display a price for one group only, and there is only one price per product. i would like to keep the same price, but display it for everyone !

Its a bit exhausting to check all products manually, so i wonder if it is possible to use the mass action algorythm.. As i dont know how it is represented in the tables, i dont whant to do some mistake.

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

  • Posts: 46
  • Thank you received: 2
8 years 8 months ago #251487

Sorry to ask questions when i just have to observe the database, i'm too lazy sometimes :

UPDATE hikashop_price
SET price_access = ',1,'
WHERE 1

The following user(s) said Thank You: Jerome

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

  • Posts: 26251
  • Thank you received: 4040
  • MODERATOR
8 years 8 months ago #251495

Hi,

You are right, an SQL query would be appropriate in your situation.
You can also use a mass-action on the "product" table and perform the action "modify price access level".

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.057 seconds
Powered by Kunena Forum