Mass action is not executed

Hi,

Well, first you need to check that your cron task is running:
www.hikashop.com/support/documentation/5...cron-task.html#check
Otherwise, the "every day" trigger won't work.
Then, you need to check that the value you have in order_product_height has the same format as what is returned by the curdate mysql function.
Also, note that the access level modification might have been done, but the user might have to logout / login to see the change as the access levels of the current user are cached in the user session data by Joomla.

Hi,

Your problem is with the order_product_height condition.
The value returned by the curdate function is with the format "YYYY-MM-DD" :
www.w3schools.com/sql/func_mysql_curdate.asp
So it's not compatible with what it stored in that custom field.
You need to use date_format in order to generate a date in the same format as stored in that column :
www.tutorialspoint.com/change-the-curdat...0use%20date_format() .
And here you'll find the possible things you can use for the format:
www.w3schools.com/sql/func_mysql_date_format.asp

Hi,

It is an "AND". However, note that the elements searched on are orders, not order products.
So as long as an order has a product with the id 73 and a product with the correct order_product_height, it will match, even if the conditions are only met for different products of the same order.

Also, if you're trying to have a subscription system, you don't need to do all that.
You can just use HikaSubscription which we made especially for that:
www.hikashop.com/component/hikashop/prod...ikasubscription.html
I would rather recommend to use this instead of trying to create mass actions. It will be easier and much more stable going forward.

Hello,

We will try to process in another way, can you provide through our Contact us form some backend access in order to process ourselves somes test on your MassActions ?
Don't forget to add an Url link to this topic in your message.

Also, what do you mean on this question, we aren't sure to understand, here :
"Is this a one-time or recurring payment?"

Awaiting your returns to progress on your subject.
Regards

Hello,

You purchase one time HikaSubscription (and enjoy one year of help and unlimited help) but you don't have to upgrade (and so purchase it each year).
Now, if some update have to be done to your website as Joomla, HikaShop or Php maybe you will have to use the last HikaSubscription versions, but we aren't be able to tell you when in the future, you will have to update.

We have find the issue in your MassAction, unfortunatelly in your Filter you have this :
order_product_height = DATE_FORMAT(CURDATE(), "%Y%m%d")

The design of a MassAction can't process an "operation" in your searching value, here, DATE_FORMAT(CURDATE(), "%Y%m%d"), this will only search and compare found value in your DataBase.

So far we didn't see how you can search a dynamic value without some development or use HikaSubscription.

regards

Hi,

HikaSerial / HikaSubscription is quite mature. Extra features are mainly about developping new plugins for it.
In fact, a big new release is currently in the works to add Joomla 4 support like we did for HikaShop with the 4.4.0 and the 4.4.1 (that was released a few days ago).

We cannot provide a coupon code for the purchase of HikaSerial / HikaSubscription.