[Skip to main content](#vessel-content) # Mass action on specific user group ## - **[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")** - [![nicobraam's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50754-nicobraam "View nicobraam's Profile") Topic Author - [ Offline](/forum/user/50754-nicobraam) Less More - Posts: 49 - Thank you received: 3 - - 3 years 2 months ago [\#354676](#354676) by [nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile") *[Mass action on specific user group](/forum/44-mass-actions/906931-mass-action-on-specific-user-group#354676 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend")* was created by *[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")* -- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend - [ ![foto1.jpg](/forum/attachment/57691) ](/forum/attachment/57691 "foto1.jpg") [ ](/forum/attachment/57691?download=1 "foto1.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDY5MzEtbWFzcy1hY3Rpb24tb24tc3BlY2lmaWMtdXNlci1ncm91cD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14293 - - 3 years 2 months ago [\#354684](#354684) 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 on specific user group](/forum/44-mass-actions/906931-mass-action-on-specific-user-group#354684 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend")* Hi, The "access level" filter of the "product" data is related to the "access level" of your products, not to the "access level" of the prices of the products. So with the filter you selected you will target "all the products where the user group "super admin" is selected in the "access level" setting of the product". These are the products that the users from this user group can access on the frontend. It has nothing to do with prices. Then, there are two cases: 1. You only have one price configured in your products, without "all" selected in the "access level" setting of the price. In that case, being able to split the price into two, one for the users of your specific user group, and another one for everyone else will be difficult. You would need to run several complex queries through your database. 2. Or you already have one price specifically configured for the user group you want to target. In that case, you can run a MySQL query like this: Code: UPDATE #__hikashop_price set price_value = price_value*1.06 WHERE price_access LIKE '%,xx,%' where #__ needs to be replaced by the table prefix of the tables, and xx by the id of the user group you want to target. This will update the price already available for the users of your specific user group. Finally, if you already have prices in your products, but that the prices are for all the users. Instead of creating different prices, which will be rather difficult ( as I was saying above ), a simpler solution would be to create a discount for that user group via the menu Orders>Discounts. That way, the discount will apply on the fly on the frontend for the users of the user group. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDY5MzEtbWFzcy1hY3Rpb24tb24tc3BlY2lmaWMtdXNlci1ncm91cD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")** - [![nicobraam's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50754-nicobraam "View nicobraam's Profile") Topic Author - [ Offline](/forum/user/50754-nicobraam) Less More - Posts: 49 - Thank you received: 3 - - 3 years 2 months ago [\#354694](#354694) by [nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile") Replied by *[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")* on topic *[Mass action on specific user group](/forum/44-mass-actions/906931-mass-action-on-specific-user-group#354694 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend")* Hello, I tried to execute in PHP myAdmin the next line of code : UPDATE `x1qp6_hikashop_price` SET `price_value`='price_value*1,06' WHERE `price_access` LIKE '%,8,%'; and got this error message: MySQL ha dicho: Documentación \#1366 - Incorrect decimal value: 'price_value*1,06' for column `superstar_colores`.`x1qp6_hikashop_price`.`price_value` at row 2 I changed the comma of 1,06 for a point 1.06 but got the sam error message. Best regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDY5MzEtbWFzcy1hY3Rpb24tb24tc3BlY2lmaWMtdXNlci1ncm91cD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14293 - - 3 years 2 months ago [\#354698](#354698) 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 on specific user group](/forum/44-mass-actions/906931-mass-action-on-specific-user-group#354698 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend")* Hi, The problem is not the comma or point there, but the quote you added around price_value*1,06 This is not valid. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDY5MzEtbWFzcy1hY3Rpb24tb24tc3BlY2lmaWMtdXNlci1ncm91cD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")** - [![nicobraam's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50754-nicobraam "View nicobraam's Profile") Topic Author - [ Offline](/forum/user/50754-nicobraam) Less More - Posts: 49 - Thank you received: 3 - - 3 years 2 months ago [\#354717](#354717) by [nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile") Replied by *[nicobraam](/forum/user/50754-nicobraam "View nicobraam's Profile")* on topic *[Mass action on specific user group](/forum/44-mass-actions/906931-mass-action-on-specific-user-group#354717 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.11 Hello, I am trying to increase the price of all products for a specific user group (Super Users) with 6% but it increases the prices for all usergroups. At the photo you can see the settings of the "Mass Action" i run. Am i missing something? Best regards and happy weekend")* Thanks that resolved the problem... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDY5MzEtbWFzcy1hY3Rpb24tb24tc3BlY2lmaWMtdXNlci1ncm91cD90bXBsPW1hcmtkb3du) 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.064 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)