Mass Action Using Date

  • Posts: 2
  • Thank you received: 0
  • Hikashop Business
2 years 6 months ago #255930

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.4

What is the best way to create a mass action using the current date. I have a custom field that has an expiration date and I would like to purge products that are after the expiration date using the current date such as:

purge products with custom field date < current date

Thanks!

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

  • Posts: 65706
  • Thank you received: 9590
  • MODERATOR
2 years 6 months ago #255932

Hi,

I'm afraid I don't know a good solution for that with a mass action.
The {time} tag which can be used to do such checks for order_created/order_modified, product_created/product_modified fields only works with unix timestamp fields and the custom fields don't use that type but a custom text format.

So in that case, it's better to run a MySQL query with your own cron task on your server.
stackoverflow.com/questions/21196613/run...-query-as-a-cron-job

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

Time to create page: 0.056 seconds
Powered by Kunena Forum