[Skip to main content](#vessel-content) # Mass Action Products Access Level ## - **[Pgva](/forum/user/34261-pgva "View Pgva's Profile")** - [![Pgva's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34261.jpg)](/forum/user/34261-pgva "View Pgva's Profile") Topic Author - [ Offline](/forum/user/34261-pgva) Less More - Posts: 56 - Thank you received: 0 - - 7 months 1 week ago [\#370927](#370927) by [Pgva](/forum/user/34261-pgva "View Pgva's Profile") *[Mass Action Products Access Level](/forum/44-mass-actions/910203-mass-action-products-access-level#370927 "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.14 -- PHP version -- : 8.2.30 Hi, i need to remove the access level "Public" privilege on all products while keeping privilege to all other profiles. I'm turning around for quite a while now but can't find the way how so far. Thanks in advance for your help")* was created by *[Pgva](/forum/user/34261-pgva "View Pgva's Profile")* -- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.14 -- PHP version -- : 8.2.30 Hi, i need to remove the access level "Public" privilege on all products while keeping privilege to all other profiles. I'm turning around for quite a while now but can't find the way how so far. Thanks in advance for your help Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MTAyMDMtbWFzcy1hY3Rpb24tcHJvZHVjdHMtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86324 - Thank you received: 14286 - - 7 months 1 week ago [\#370935](#370935) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass Action Products Access Level](/forum/44-mass-actions/910203-mass-action-products-access-level#370935 "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.14 -- PHP version -- : 8.2.30 Hi, i need to remove the access level "Public" privilege on all products while keeping privilege to all other profiles. I'm turning around for quite a while now but can't find the way how so far. Thanks in advance for your help")* Hi, The `product_access` column stores access levels as a comma-separated list of Joomla user group IDs with commas on both sides, for example `,1,2,3,`. The special value `all` means accessible to everyone. To remove the "Public" access level (group ID 1) from all your products while keeping the other access levels, you can create a mass action with: - Filter: Table `product`, Column `product_access`, Operator `contain`, Value `,1,` - Action: "Update values", Column `product_access`, Type `operation`, Value `REPLACE(product.product_access, ',1,', ',')` This will turn for example `,1,2,3,` into `,2,3,` on each matching product, removing only the Public group while preserving the rest. If some of your products have `product_access` set to `all` (which includes Public by definition), you will need a second mass action to handle those separately. In that case, set the filter to match products where `product_access` equals `all`, and the action to set `product_access` to a string value containing the specific groups you want to keep (e.g. `,2,3,`). After running the mass action, you can verify the results by checking a few products in the backend. The Access Level field on the product edit form should no longer show "Public" in the list. Note also that you have a "limitations" area in mass actions which limits the amount of elements processed at once. If you have more than 500 products / variants you can increase it a bit or run the mass action several times, changing the limitations each time to process the different batches of products one after the other. I would recommend you make a backup of your database before you do this. Mass actions are powerful but a small mistake with mass actions can erase hours of work. You can read more about mass actions here: [ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html) I would recommend you do before using them. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MTAyMDMtbWFzcy1hY3Rpb24tcHJvZHVjdHMtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Pgva](/forum/user/34261-pgva "View Pgva's Profile")** - [![Pgva's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34261.jpg)](/forum/user/34261-pgva "View Pgva's Profile") Topic Author - [ Offline](/forum/user/34261-pgva) Less More - Posts: 56 - Thank you received: 0 - - 6 months 3 weeks ago [\#371472](#371472) by [Pgva](/forum/user/34261-pgva "View Pgva's Profile") Replied by *[Pgva](/forum/user/34261-pgva "View Pgva's Profile")* on topic *[Mass Action Products Access Level](/forum/44-mass-actions/910203-mass-action-products-access-level#371472 "-- HikaShop version -- : 6.4.0 -- Joomla version -- : 4.4.14 -- PHP version -- : 8.2.30 Hi, i need to remove the access level "Public" privilege on all products while keeping privilege to all other profiles. I'm turning around for quite a while now but can't find the way how so far. Thanks in advance for your help")* Works perfectly for me. Thanks for your support and sorry for late feedback, i was away from the office for couple of weeks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MTAyMDMtbWFzcy1hY3Rpb24tcHJvZHVjdHMtYWNjZXNzLWxldmVsP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)