[Skip to main content](#vessel-content) # How could I remove price for products? ## - **[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")** - [![progreccor's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4816.jpg)](/forum/user/4816-progreccor "View progreccor's Profile") Topic Author - [ Offline](/forum/user/4816-progreccor "Москва") - SEO, webdesign Less More - Posts: 2293 - Thank you received: 315 - - - - [](http://www.d-dd.ru) - 10 years 2 weeks ago [\#252131](#252131) by [progreccor](/forum/user/4816-progreccor "View progreccor's Profile") *[How could I remove price for products?](/forum/44-mass-actions/886857-how-could-i-remove-price-for-products#252131 "-- HikaShop version -- : 2.6.4 I need to set prices for variants. At this time I have prices for products but thats wrong. Could I remove prices for products and keep prices for variants?")* was created by *[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")* -- HikaShop version -- : 2.6.4 I need to set prices for variants. At this time I have prices for products but thats wrong. Could I remove prices for products and keep prices for variants? --- Я не явлюсь официальной службой поддержки! Я здесь добровольно! Хочешь получить купон на скидку Hikashop? Спроси меня как! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy84ODY4NTctaG93LWNvdWxkLWktcmVtb3ZlLXByaWNlLWZvci1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 10 years 2 weeks ago [\#252141](#252141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How could I remove price for products?](/forum/44-mass-actions/886857-how-could-i-remove-price-for-products#252141 "-- HikaShop version -- : 2.6.4 I need to set prices for variants. At this time I have prices for products but thats wrong. Could I remove prices for products and keep prices for variants?")* Hi, There is no mass action to remove prices. So you would either have to do it one by one through the interface, or with a MySQL query in your PHPMyAdmin. Something like that: DELETE * FROM #__hikashop_price WHERE price_product_id IN (SELECT product_id FROM #__hikashop_product WHERE product_parent_id = 0); That will remove all the prices of the main products on your website whether they have variants or not but won't change the prices of the variants. The following user(s) said Thank You: [progreccor](/forum/user/4816-progreccor "View progreccor's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy84ODY4NTctaG93LWNvdWxkLWktcmVtb3ZlLXByaWNlLWZvci1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")** - [![progreccor's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4816.jpg)](/forum/user/4816-progreccor "View progreccor's Profile") Topic Author - [ Offline](/forum/user/4816-progreccor "Москва") - SEO, webdesign Less More - Posts: 2293 - Thank you received: 315 - - - - [](http://www.d-dd.ru) - 10 years 2 weeks ago [\#252325](#252325) by [progreccor](/forum/user/4816-progreccor "View progreccor's Profile") Replied by *[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")* on topic *[How could I remove price for products?](/forum/44-mass-actions/886857-how-could-i-remove-price-for-products#252325 "-- HikaShop version -- : 2.6.4 I need to set prices for variants. At this time I have prices for products but thats wrong. Could I remove prices for products and keep prices for variants?")* there is small mistake in your query: Code: DELETE FROM #__hikashop_price WHERE price_product_id IN (SELECT product_id FROM #__hikashop_product WHERE product_parent_id = 0); there is not need for the * in this query ![;-)](/media/kunena/emoticons/14.png ";-)") but thank you for your support. This is why I love hika! --- Я не явлюсь официальной службой поддержки! Я здесь добровольно! Хочешь получить купон на скидку Hikashop? Спроси меня как! The following user(s) said Thank You: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy84ODY4NTctaG93LWNvdWxkLWktcmVtb3ZlLXByaWNlLWZvci1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[oxido](/forum/user/29793-oxido "View oxido's Profile")** - [![oxido's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29793-oxido "View oxido's Profile") - [ Offline](/forum/user/29793-oxido) Less More - Posts: 282 - Thank you received: 42 - - 2 years 1 month ago [\#363294](#363294) by [oxido](/forum/user/29793-oxido "View oxido's Profile") Replied by *[oxido](/forum/user/29793-oxido "View oxido's Profile")* on topic *[How could I remove price for products?](/forum/44-mass-actions/886857-how-could-i-remove-price-for-products#363294 "-- HikaShop version -- : 2.6.4 I need to set prices for variants. At this time I have prices for products but thats wrong. Could I remove prices for products and keep prices for variants?")* How to delete multiple prices for multiple products of the same category by specifying the category ID, but keeping the main price Code: DELETE p FROM #__hikashop_price p JOIN #__hikashop_product_category pc ON p.price_product_id = pc.product_id WHERE pc.category_id = 39 AND p.price_min_quantity > 0; The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy84ODY4NTctaG93LWNvdWxkLWktcmVtb3ZlLXByaWNlLWZvci1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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.089 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)