How to empty variants price through mass action?

  • Posts: 9
  • Thank you received: 0
  • Hikashop Business
3 years 2 months ago #226483

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.8

Hi, is there any way to empty the price of my variants. Due to an import error all my products have 0 in the variants pricefield. I need it totally empty so I will see the main price of each product again.
Any suggestion how to do it? Actually I can just change the price but not empty it.
I have the Business Edition of Hikashop
Thanks & regards
Markus

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

  • Posts: 13201
  • Thank you received: 2316
  • MODERATOR
3 years 2 months ago #226512

Hi,

This is indeed a missing feature in the mass actions. We can only set a price value but not remove a price.
I add this on our todo list.

For now, you can use this MySQL request to remove the price entries of the variants:

DELETE price FROM #__hikashop_price AS price JOIN #__hikashop_product AS product ON price.price_product_id = product.product_id WHERE product.product_type = 'variant'

Please do a backup before anything :)

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

  • Posts: 9
  • Thank you received: 0
  • Hikashop Business
3 years 2 months ago #226521

Thanks for the quick solution. Would be great to see it implemented soon. :)

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

  • Posts: 344
  • Thank you received: 3
2 years 8 months ago #244317

Jooomla 3.5
Hikashop 2.6.3

After updating prices and adding tax with massaction I have som products with variants, and these variants now has the price 0

I need to remove the price 0 in these variants and make them blank.
The other products that have variants with different prices has to stay this way, and not be affected.

Is this possible with Mass action ?

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

  • Posts: 13201
  • Thank you received: 2316
  • MODERATOR
2 years 8 months ago #244320

Hi,

You can potentially set a mass action like that: take.ms/8yCDV
That way the action will be applied only on variants with a price higher than 0.

As always, before doing any action please backup your database.

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

  • Posts: 846
  • Thank you received: 92
2 years 6 months ago #250612

hi
what is the default SQL type and value of price for variant in SQL table ?
regard's

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

  • Posts: 23353
  • Thank you received: 3627
  • MODERATOR
2 years 6 months ago #250656

Hi,

We are not able to understand your question.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 846
  • Thank you received: 92
2 years 5 months ago #251980

i ll do a test myself and give feedback ! here another way to ask my question


set up


shoes product use 2 characteristics that have each 2 values
size -> small big
color -> red , blue
so i have 2*2=4 variants ( sub product ) attach to the main product


question
can we define for each variant a specific price
big red 100€
small red 50€
where this value price is store in sql database ! i want sql table name , column name and type name

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

  • Posts: 65163
  • Thank you received: 9467
  • MODERATOR
2 years 5 months ago #252002

Hi,

Yes, you can do that.
In the interface, under the "variants" tab of the product, you can edit each variant and enter a price for each.
All the products and variants prices are stored in the table hikashop_price in the column "price_value" which is a decimal.

The following user(s) said Thank You: lionel75

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

Time to create page: 0.085 seconds
Powered by Kunena Forum