[Skip to main content](#vessel-content) # SOLVED - Bulk change for price access level ## - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago - 14 years 2 months ago [\#59125](#59125) by [donig](/forum/user/7760-donig "View donig's Profile") *[SOLVED - Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59125 "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?")* was created by *[donig](/forum/user/7760-donig "View donig's Profile")* 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? --- Joomla! 2.5.6 Hikashop Business 1.6.0 Last edit: 14 years 2 months ago by [donig](/forum/user/7760-donig "View donig's Profile"). Reason: SOLVED Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 3 months ago [\#59127](#59127) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59127 "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 ![:-)](/media/kunena/emoticons/9.png ":-)"). Tony Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago [\#59132](#59132) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59132 "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?")* 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... --- Joomla! 2.5.6 Hikashop Business 1.6.0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 14 years 3 months ago [\#59134](#59134) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59134 "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?")* The access levels for prices are stored in the price_access column of the hikashop_price table. That's the one you should update. Also, the value should be the id of the user group with a comma before and after. So it should be something like that: update xxxx_hikashop_price set price_access = ",18,"; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago [\#59140](#59140) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59140 "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?")* Still, it has no effect ![:(](/media/kunena/emoticons/5.png ":(") 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 14 years 3 months ago [\#59141](#59141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59141 "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?")* What is the query you're using ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago - 14 years 3 months ago [\#59143](#59143) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59143 "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?")* 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... ![:P](/media/kunena/emoticons/15.png ":P") 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 3 months ago by [donig](/forum/user/7760-donig "View donig's Profile"). Reason: hide shown real prefix tables Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 14 years 3 months ago [\#59145](#59145) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59145 "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're changing the default value of the column. That's not what you should do. Click on "SQL", paste the query I gave you, change the prefix of the table and the id of the user group in the query and run the query. Here is a tutorial: [ community.mybb.com/thread-4720.html](http://community.mybb.com/thread-4720.html) The following user(s) said Thank You: [donig](/forum/user/7760-donig "View donig's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago [\#59147](#59147) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59147 "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?")* It worked like a charm. --- Joomla! 2.5.6 Hikashop Business 1.6.0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago [\#59192](#59192) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59192 "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?")* OK, it worked like a charm, indeed ![:)](/media/kunena/emoticons/8.png ":)") 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 14 years 3 months ago [\#59237](#59237) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59237 "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?")* That means that you set the id of a user group which doesn't exist in the query you run in phpmyadmin. Please replace 18 in the query by the id of the user group you want. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago - 14 years 3 months ago [\#59266](#59266) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59266 "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?")* 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... --- Joomla! 2.5.6 Hikashop Business 1.6.0 - [ ![screenshot.1.png](/forum/attachment/5001) ](/forum/attachment/5001 "screenshot.1.png") [ ](/forum/attachment/5001?download=1 "screenshot.1.png") Last edit: 14 years 3 months ago by [donig](/forum/user/7760-donig "View donig's Profile"). Reason: wrong attached file Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 14 years 3 months ago [\#59293](#59293) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59293 "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?")* I only see that you have the default user groups of Joomla 1.5. So 18 should be the Registered user group. So that one should be checked in the price ACL popup when using that query. I don't know why it wouldn't work for you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[donig](/forum/user/7760-donig "View donig's Profile")** - [![donig's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7760.png)](/forum/user/7760-donig "View donig's Profile") Topic Author - [ Offline](/forum/user/7760-donig) Less More - Posts: 25 - Thank you received: 2 - - - - 14 years 3 months ago [\#59299](#59299) by [donig](/forum/user/7760-donig "View donig's Profile") Replied by *[donig](/forum/user/7760-donig "View donig's Profile")* on topic *[Re: Bulk change for price access level](/forum/2-general-talk-about-hikashop/59125-solved-bulk-change-for-price-access-level#59299 "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?")* 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! --- Joomla! 2.5.6 Hikashop Business 1.6.0 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzU5MTI1LXNvbHZlZC1idWxrLWNoYW5nZS1mb3ItcHJpY2UtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.138 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)