[Skip to main content](#vessel-content) # Raise all products prices and then discount.. ## - **[viki667](/forum/user/28401-viki667 "View viki667's Profile")** - [![viki667's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28401.jpg)](/forum/user/28401-viki667 "View viki667's Profile") Topic Author - [ Offline](/forum/user/28401-viki667) Less More - Posts: 17 - Thank you received: 0 - - - [](http://www.modernikoti.fi) - 12 years 11 months ago [\#133014](#133014) by [viki667](/forum/user/28401-viki667 "View viki667's Profile") *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#133014 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* was created by *[viki667](/forum/user/28401-viki667 "View viki667's Profile")* Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx ![:)](/media/kunena/emoticons/3.png ":)") --- *Laadukas moderni kulmasohva, valkoinen kulmasohva tai iso kulmasohva: [ ModerniKoti](http://www.modernikoti.fi)* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 11 months ago [\#133057](#133057) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#133057 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Hi, 1. Sure, you'll just have to use an SQL request like : Code: UPDATE `#_hikashop_price` SET `price_value`= `price_value` + 30 WHERE 1 Where # is your database prefix. 2. To do that you'll just have to create a 30% discount through "*Hikashop->Orders->Discounts*" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 9 months ago [\#142663](#142663) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#142663 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Dear Mohamed, i need to increase the prices of all my products by a 20%... i used to know how to do it but i dont remember anymore! Please help me... ¡thank you in advance! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 9 months ago [\#142664](#142664) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#142664 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Nevermind! i found the answer in the forum! Solved! ![:D](/media/kunena/emoticons/1.png ":D") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[viki667](/forum/user/28401-viki667 "View viki667's Profile")** - [![viki667's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28401.jpg)](/forum/user/28401-viki667 "View viki667's Profile") Topic Author - [ Offline](/forum/user/28401-viki667) Less More - Posts: 17 - Thank you received: 0 - - - [](http://www.modernikoti.fi) - 12 years 9 months ago [\#142668](#142668) by [viki667](/forum/user/28401-viki667 "View viki667's Profile") Replied by *[viki667](/forum/user/28401-viki667 "View viki667's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#142668 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Would you pase here link aswell please --- *Laadukas moderni kulmasohva, valkoinen kulmasohva tai iso kulmasohva: [ ModerniKoti](http://www.modernikoti.fi)* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/9503-melisari) Less More - Posts: 103 - Thank you received: 2 - - 12 years 9 months ago [\#142669](#142669) by [melisari](/forum/user/9503-melisari "View melisari's Profile") Replied by *[melisari](/forum/user/9503-melisari "View melisari's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#142669 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Of course: [ www.hikashop.com/forum/4-how-to/72156-gl...-increase.html#72239](http://www.hikashop.com/forum/4-how-to/72156-global-price-increase.html#72239) Hugs! Sue. The following user(s) said Thank You: [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#142679](#142679) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Raise all products prices and then discount..](/forum/26-product-category-display/863721-raise-all-products-prices-and-then-discount#142679 "Is it possible to raise all product prices by lets say 30% and then make visible discount for 30% ? thanx :)")* Thanks for sharing your solution! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NjM3MjEtcmFpc2UtYWxsLXByb2R1Y3RzLXByaWNlcy1hbmQtdGhlbi1kaXNjb3VudD90bXBsPW1hcmtkb3du) 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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)