Make product sale end empty

-- HikaShop version -- : 3.2.1
-- Joomla version -- : 3.8.2
-- PHP version -- : 7.1

Hi i would like to make the product sale end date empty



This mass change does work, how can i make this work?

Regards René

Hi,

Three things:
1. You don't need a filter since the field cannot be negative. And if the date is not zero then it will be set to 0 and if it's already 0 then that won't change anything.
So I would recommend removing that filter.
2. The limitations area will only process the first 500 elements. If your products have variants they will be taken into account in the limitations system. So try setting a limit of 5000 instead of 500.
3. The column in the database is an integeter not a varchar or a text, so you should select 'int' instead of "string" and enter the numeric value 0 in the value field.

Hi Nicolas,

Thanks for your replying, i think i got the wrong db field.



I need to empty the Available to field, witch db field do i need to empty? And is this an integer too?


Regards René

Hi,

It is the product_sale_end field. So what I said before applies.
Did it not help ?

Hi Nicolas, the limitation did the trick.

Thanks in advance, regards René

Hi,

So it's all ok now ?

Yes Nicolas thanks!

Regards René