How to remove price in admin products list?

  • Posts: 129
  • Thank you received: 6
5 days 4 hours ago #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.

Please Log in or Create an account to join the conversation.

  • Posts: 83296
  • Thank you received: 13466
  • MODERATOR
4 days 2 hours ago #365710

Hi,

There is no action "delete price". What you can do is to use the action "run MySQL query" and use this MySQL query:

DELETE FROM #__hikashop_price WHERE price_product_id = {product_id};

The following user(s) said Thank You: levelup

Please Log in or Create an account to join the conversation.

  • Posts: 129
  • Thank you received: 6
4 days 2 hours ago #365712

Can I enter multiple product IDs instead of running this command multiple times with different {product_id}?

Please Log in or Create an account to join the conversation.

  • Posts: 83296
  • Thank you received: 13466
  • MODERATOR
3 days 22 hours ago #365713

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum