Mass Action Using Date

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

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