Access level mass action

-- 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.

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

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,