[Skip to main content](#vessel-content) # Change the price of all products ## - **[melisari](/forum/user/9503-melisari "View melisari's Profile")** - [![melisari's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/origami.png)](/forum/user/9503-melisari "View melisari's Profile") Topic Author - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 11 months ago [\#135521](#135521) by [melisari](/forum/user/9503-melisari "View melisari's Profile") *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135521 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* was created by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance! - [ ![h7ae59de.jpg](/forum/attachment/14142) ](/forum/attachment/14142 "h7ae59de.jpg") [ ](/forum/attachment/14142?download=1 "h7ae59de.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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: 86360 - Thank you received: 14296 - - 12 years 11 months ago [\#135542](#135542) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135542 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* You set a filter so that the mass action only affect the products with a price of 50. So you probably don't want any filter and only an action with a price of 50 set so that it updates the value of all the products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[melisari](/forum/user/9503-melisari "View melisari's Profile")** - [![melisari's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/origami.png)](/forum/user/9503-melisari "View melisari's Profile") Topic Author - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 11 months ago [\#135550](#135550) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135550 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* Yes of course, i want to change only de products that cost 50, but then... i dont understand the options (INT, FLOAT, STRING, OPERATION) i even tried with each one, but nothing happened. What i want to do, is simple change 50 to 114 Thank you so much in advance and for your patient! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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: 86360 - Thank you received: 14296 - - 12 years 11 months ago [\#135586](#135586) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135586 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* Then you need to keep the filter on 50 and in your action select INT and enter 114. Also, add a second filter on "limit" and make sure that you increase the limit as otherwise, it will only apply to the first 500 products costing 50. Once you're set, you can click on "process" in order to run the mass action and change the price. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[melisari](/forum/user/9503-melisari "View melisari's Profile")** - [![melisari's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/origami.png)](/forum/user/9503-melisari "View melisari's Profile") Topic Author - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 11 months ago [\#135619](#135619) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135619 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* Nothing happened... im sure im missing something... - [ ![h07f0481.jpg](/forum/attachment/14155) ](/forum/attachment/14155 "h07f0481.jpg") [ ](/forum/attachment/14155?download=1 "h07f0481.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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: 86360 - Thank you received: 14296 - - 12 years 11 months ago [\#135685](#135685) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135685 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* This will only do it for 500 products. Do you have more products with that 50 price ? In that case, you should either rerun it several times or increase the limit. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[melisari](/forum/user/9503-melisari "View melisari's Profile")** - [![melisari's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/origami.png)](/forum/user/9503-melisari "View melisari's Profile") Topic Author - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 11 months ago [\#135686](#135686) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135686 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* I only have 100 products, and those i need to change are just 71 If i cant do it with mass actions, could you please help me do it in php myadmin? Once i did it that way, i remember I increased the price by 15%, but i dont know how to do it if i only need to change the price... maybe with a sum? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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: 86360 - Thank you received: 14296 - - 12 years 11 months ago [\#135784](#135784) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135784 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* I'm not just why it wouldn't work with the mass action, but it's indeed quite easy to do with a mysql query. Simply use such query: UPDATE jos_hikashop_price SET price_value=114 WHERE price_value=50; The following user(s) said Thank You: [melisari](/forum/user/9503-melisari "View melisari's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[melisari](/forum/user/9503-melisari "View melisari's Profile")** - [![melisari's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/origami.png)](/forum/user/9503-melisari "View melisari's Profile") Topic Author - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 11 months ago [\#135801](#135801) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Change the price of all products](/forum/44-mass-actions/864152-change-the-price-of-all-products#135801 "Hi! Im trying to simple change the price of all products for another one. But i cant make it work, i dont know if im doing something wrong, just need a little step by step, thank you so much in advance!")* Thank you so much! You are my hero! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NjQxNTItY2hhbmdlLXRoZS1wcmljZS1vZi1hbGwtcHJvZHVjdHM/dG1wbD1tYXJrZG93bg==) 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.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)