SOLVED - Bulk change for price access level

Hi,

I want to change the price access level from "all" to a custom one for all the products at the same time.
Is there a way to do that?

You could update with SQL either at the mysql command line or via phpmyadmin.

update xxxx_hikashop_product set product_access = "<something>";

That will do for every product including the variants.

It currently carries a default of 'all'.

I'd test it on your dev server first .

Tony

Thanks, but I want to restrict access only for the price for a certain user group, not to the products.
I tried to change "price_access" from "all" to "registered" but nothing happens...

Still, it has no effect
First I wrote right in this form: ,18,
Then I tried this: ",18,";
(I don't know MySQL sintax)

I manage to use phpMYAdmin for certain operations but I don't know MySQL.
So, please, be more explicit because I don't know what are you referring at...
This is what appears at the top in phpMyAdmin's windows after the change:
ALTERTABLE`xxxx_hikashop_price`CHANGE`price_access``price_access` VARCHAR( 255)CHARACTERSET utf8 COLLATE utf8_general_ci NOTNULL DEFAULT',18,'

It worked like a charm.

OK, it worked like a charm, indeed but later I noticed that I stepped into a problem.
Now, the access is restricted for both unregistered and registered users and remains the same even I change the user group ID back to 29.
I noticed that in the price access level list nothing is checked but only the "custom" radio-button (none of the user groups is selected).

I used the query that you provided to me (with the correct prefix tables):

update xxxx_hikashop_price set price_access = ",18,";

First, I used 18, after that I tried 29 and again 18.
But the selection remains like in the attached image...

Well... because it was my fault, I realized after you mentioned about Joomla 1.5.
Now I get it, I wrongly used the user group id 18 instead of 2 (because I have Joomla 2.5)

Thanks very much!