Make product sale end empty

  • Posts: 184
  • Thank you received: 5
  • Hikashop Business
1 year 3 weeks ago #282939

-- 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é

Attachments:
Last Edit: 1 year 3 weeks ago by renem.

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

  • Posts: 64169
  • Thank you received: 9262
  • MODERATOR
1 year 3 weeks ago #282946

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.

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

  • Posts: 184
  • Thank you received: 5
  • Hikashop Business
1 year 3 weeks ago #282981

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é

Attachments:

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

  • Posts: 64169
  • Thank you received: 9262
  • MODERATOR
1 year 3 weeks ago #282985

Hi,

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

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

  • Posts: 184
  • Thank you received: 5
  • Hikashop Business
1 year 2 weeks ago #283196

Hi Nicolas, the limitation did the trick.

Thanks in advance, regards René

Attachments:
Last Edit: 1 year 2 weeks ago by renem.

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

  • Posts: 64169
  • Thank you received: 9262
  • MODERATOR
1 year 2 weeks ago #283201

Hi,

So it's all ok now ?

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

  • Posts: 184
  • Thank you received: 5
  • Hikashop Business
1 year 2 weeks ago #283258

Yes Nicolas thanks!

Regards René

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

Time to create page: 0.091 seconds
Powered by Kunena Forum