- Posts: 25
- Thank you received: 2
SOLVED - Bulk change for price access level
14 years 2 months ago #59127
by tony@10uk.net
Replied by tony@10uk.net on topic Re: Bulk change for price access level
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
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
Please Log in or Create an account to join the conversation.
14 years 1 month ago #59140
by donig
Joomla! 2.5.6
Hikashop Business 1.6.0
Replied by donig on topic Re: Bulk change for price access level
Still, it has no effect 
First I wrote right in this form: ,18,
Then I tried this: ",18,";
(I don't know MySQL sintax)
First I wrote right in this form: ,18,
Then I tried this: ",18,";
(I don't know MySQL sintax)
Joomla! 2.5.6
Hikashop Business 1.6.0
Please Log in or Create an account to join the conversation.
14 years 1 month ago - 14 years 1 month ago #59143
by donig
Joomla! 2.5.6
Hikashop Business 1.6.0
Replied by donig on topic Re: Bulk change for price access level
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,'
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,'
Joomla! 2.5.6
Hikashop Business 1.6.0
Last edit: 14 years 1 month ago by donig. Reason: hide shown real prefix tables
Please Log in or Create an account to join the conversation.
14 years 1 month ago #59192
by donig
Joomla! 2.5.6
Hikashop Business 1.6.0
Replied by donig on topic Re: Bulk change for price access level
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).
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).
Joomla! 2.5.6
Hikashop Business 1.6.0
Please Log in or Create an account to join the conversation.
14 years 1 month ago - 14 years 1 month ago #59266
by donig
Joomla! 2.5.6
Hikashop Business 1.6.0
Replied by donig on topic Re: Bulk change for price access level
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...
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...
Joomla! 2.5.6
Hikashop Business 1.6.0
Last edit: 14 years 1 month ago by donig. Reason: wrong attached file
Please Log in or Create an account to join the conversation.
Time to create page: 0.303 seconds