[Skip to main content](#vessel-content) # How to remove price in admin products list? ## - **[levelup](/forum/user/61801-levelup "View levelup's Profile")** - [![levelup's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61801-levelup "View levelup's Profile") Topic Author - [ Offline](/forum/user/61801-levelup) Less More - Posts: 145 - Thank you received: 6 - - 1 year 8 months ago [\#365693](#365693) by [levelup](/forum/user/61801-levelup "View levelup's Profile") *[How to remove price in admin products list?](/forum/4-how-to/909141-how-to-remove-price-in-admin-products-list#365693 "-- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hi How to remove the price of variant products by using the action button at the top of the back-end Product List? I usually select the "update the values" to change the price from the action field, then select price_value from the next field and enter the desired amount. But now I want to remove the cost of the variant product to get the amount from the original product. When I zero the value using the action button, the amount is 0, which means the product is free. The amount of empty does not accept.")* was created by *[levelup](/forum/user/61801-levelup "View levelup's Profile")* -- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hi How to remove the price of variant products by using the action button at the top of the back-end Product List? I usually select the "update the values" to change the price from the action field, then select price_value from the next field and enter the desired amount. But now I want to remove the cost of the variant product to get the amount from the original product. When I zero the value using the action button, the amount is 0, which means the product is free. The amount of empty does not accept. --- Life is the unique stage of our art. Everyone sings their own song and leaves the stage. The stage is always permanent. Blessed is that song that people remember. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzkwOTE0MS1ob3ctdG8tcmVtb3ZlLXByaWNlLWluLWFkbWluLXByb2R1Y3RzLWxpc3Q/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 1 year 8 months ago [\#365710](#365710) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to remove price in admin products list?](/forum/4-how-to/909141-how-to-remove-price-in-admin-products-list#365710 "-- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hi How to remove the price of variant products by using the action button at the top of the back-end Product List? I usually select the "update the values" to change the price from the action field, then select price_value from the next field and enter the desired amount. But now I want to remove the cost of the variant product to get the amount from the original product. When I zero the value using the action button, the amount is 0, which means the product is free. The amount of empty does not accept.")* Hi, There is no action "delete price". What you can do is to use the action "run MySQL query" and use this MySQL query: Code: DELETE FROM #__hikashop_price WHERE price_product_id = {product_id}; The following user(s) said Thank You: [levelup](/forum/user/61801-levelup "View levelup's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzkwOTE0MS1ob3ctdG8tcmVtb3ZlLXByaWNlLWluLWFkbWluLXByb2R1Y3RzLWxpc3Q/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[levelup](/forum/user/61801-levelup "View levelup's Profile")** - [![levelup's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/61801-levelup "View levelup's Profile") Topic Author - [ Offline](/forum/user/61801-levelup) Less More - Posts: 145 - Thank you received: 6 - - 1 year 8 months ago [\#365712](#365712) by [levelup](/forum/user/61801-levelup "View levelup's Profile") Replied by *[levelup](/forum/user/61801-levelup "View levelup's Profile")* on topic *[How to remove price in admin products list?](/forum/4-how-to/909141-how-to-remove-price-in-admin-products-list#365712 "-- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hi How to remove the price of variant products by using the action button at the top of the back-end Product List? I usually select the "update the values" to change the price from the action field, then select price_value from the next field and enter the desired amount. But now I want to remove the cost of the variant product to get the amount from the original product. When I zero the value using the action button, the amount is 0, which means the product is free. The amount of empty does not accept.")* Can I enter multiple product IDs instead of running this command multiple times with different {product_id}? --- Life is the unique stage of our art. Everyone sings their own song and leaves the stage. The stage is always permanent. Blessed is that song that people remember. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzkwOTE0MS1ob3ctdG8tcmVtb3ZlLXByaWNlLWluLWFkbWluLXByb2R1Y3RzLWxpc3Q/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86358 - Thank you received: 14293 - - 1 year 8 months ago [\#365713](#365713) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to remove price in admin products list?](/forum/4-how-to/909141-how-to-remove-price-in-admin-products-list#365713 "-- HikaShop version -- : 5.1.3 -- Joomla version -- : 5.2.3 -- PHP version -- : 8.2 Hi How to remove the price of variant products by using the action button at the top of the back-end Product List? I usually select the "update the values" to change the price from the action field, then select price_value from the next field and enter the desired amount. But now I want to remove the cost of the variant product to get the amount from the original product. When I zero the value using the action button, the amount is 0, which means the product is free. The amount of empty does not accept.")* Hi, You need to leave the {product_id} tag in the MySQL query. It will be HikaShop which will replace it with the product ids on the fly. So, you can select several products / variants run that MySQL query with the {product_id} tag, and they will all be affected. The following user(s) said Thank You: [levelup](/forum/user/61801-levelup "View levelup's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzkwOTE0MS1ob3ctdG8tcmVtb3ZlLXByaWNlLWluLWFkbWluLXByb2R1Y3RzLWxpc3Q/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.057 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)