[Skip to main content](#vessel-content) # Mass action update specific prices ## - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1189 - Thank you received: 13 - - 5 years 4 months ago [\#333248](#333248) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") *[Mass action update specific prices](/forum/44-mass-actions/902731-mass-action-update-specific-prices#333248 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 Hi, I would like to update the prices of some products and i need some help! The products are from one specific category and their price is 16.06 € including tax, what i need to do is decrease their price to 12,95 € including tax. Could you please help me do that? Thank you")* was created by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 Hi, I would like to update the prices of some products and i need some help! The products are from one specific category and their price is 16.06 € including tax, what i need to do is decrease their price to 12,95 € including tax. Could you please help me do that? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDI3MzEtbWFzcy1hY3Rpb24tdXBkYXRlLXNwZWNpZmljLXByaWNlcz90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14266 - - 5 years 4 months ago [\#333250](#333250) 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 update specific prices](/forum/44-mass-actions/902731-mass-action-update-specific-prices#333250 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 Hi, I would like to update the prices of some products and i need some help! The products are from one specific category and their price is 16.06 € including tax, what i need to do is decrease their price to 12,95 € including tax. Could you please help me do that? Thank you")* Hi, You don't need a mass action anymore to do that. A simpler solution is to go in your products listing in the backend and click on the category in the left explorer. Make sure you have all the products on the page and click on the main checkbox at the top left corner of the listing to select all the products of that category. Once done, click on the "actions" button at the top. That will open a popup. There, select the action "update the values" and select the price_value column. Select the type "float" and enter in the input field the value 12.95 Then, validate and that's it. Please note that this supposes that the products already have their price with taxes in the database. If that's not the case, then you need to first calculate the price without taxes that you want to user instead of 12.95 in the input field of the popup. The following user(s) said Thank You: [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDI3MzEtbWFzcy1hY3Rpb24tdXBkYXRlLXNwZWNpZmljLXByaWNlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[alevogel](/forum/user/40766-alevogel "View alevogel's Profile")** - [![alevogel's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40766-alevogel "View alevogel's Profile") - [ Offline](/forum/user/40766-alevogel) Less More - Posts: 28 - Thank you received: 3 - - 4 years 7 months ago [\#340075](#340075) by [alevogel](/forum/user/40766-alevogel "View alevogel's Profile") Replied by *[alevogel](/forum/user/40766-alevogel "View alevogel's Profile")* on topic *[Mass action update specific prices](/forum/44-mass-actions/902731-mass-action-update-specific-prices#340075 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 Hi, I would like to update the prices of some products and i need some help! The products are from one specific category and their price is 16.06 € including tax, what i need to do is decrease their price to 12,95 € including tax. Could you please help me do that? Thank you")* Hi there I have a similar question - BUT: I have to chnge prices of variants, in two currencies: I have 10 products in a specific category, each with 20 variants with different prices, depending on a characteristic. I want to set new prices for all variants with the same characteristic (the size in this case) for all products in the category - that means: a new price in CHF and a new price in EUR. How can I do that? Thanks, Alexandra Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDI3MzEtbWFzcy1hY3Rpb24tdXBkYXRlLXNwZWNpZmljLXByaWNlcz90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14266 - - 4 years 7 months ago - 4 years 7 months ago [\#340088](#340088) 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 update specific prices](/forum/44-mass-actions/902731-mass-action-update-specific-prices#340088 "-- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.9.27 Hi, I would like to update the prices of some products and i need some help! The products are from one specific category and their price is 16.06 € including tax, what i need to do is decrease their price to 12,95 € including tax. Could you please help me do that? Thank you")* Hi, You can't do it with an "update the values" action, as it will set the same price for both currencies. And you can't also select some variants of a product based on a characteristic value with the mass actions system. So you would have to directly run a complex MySql query in your PHPMyAdmin. Something like that : Code: UPDATE #__hikashop_product as p LEFT JOIN #__hikashop_product as pp ON pp.product_id = p.product_id LEFT JOIN #__hikashop_product_category as pc ON pp.product_id = pc.product_id LEFT JOIN #__hikashop_category as cat ON pc.category_id = cat.category_id LEFT JOIN #__hikashop_price as price ON p.product_id = price.price_product_id LEFT JOIN #__hikashop_currency as currency ON price.price_currency_id = currency.currency_id LEFT JOIN #__hikashop_variant AS v ON p.product_id = v.variant_product_id LEFT JOIN #__hikashop_characteristic AS c ON c.characteristic_id = v.variant_characteristic_id SET price_value = XXX WHERE cat.category_name = 'YYY' AND c.characteristic_value = 'ZZZ' AND currency.currency_code = 'AAA' where XXX is the new price, YYY the name of the category, ZZZ the value of the characteristic, AAA the currency code AND #__ the table prefix of your website. Note that I didn't test it... If it's a one time thing and you only have a few products with a few variants to modify, I would recommend to simply modify them via the interface provided in the backend of HikaShop. Last edit: 4 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MDI3MzEtbWFzcy1hY3Rpb24tdXBkYXRlLXNwZWNpZmljLXByaWNlcz90bXBsPW1hcmtkb3du) 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.235 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)