Catalog Price Rules disappear the next day, cron doesn't help

[ludwig-gramberg]

When using Catalog Price Rules (without a start- and end-date) the cron does not write values into catalogrule_product_price only reindexing triggers that. Without a value for each day the rules stop to work the next day.

Preconditions

1. Magento 2.4-develop
2. cron is enabled and running

Steps to reproduce

1. Create a Customer Group
2. Create an active Catalog Price Rule:
   1. Assign the Rule to your new Customer Group
   2. Condition is "Attribute Set is Default" or some other condition which is always true
   3. Action is: "Apply as Percentage of original"
   4. Discount Amount: "20"
   5. Other Action Options set to "No"
3. run indexer
4. confirm reduced prices
5. wait 1 day (or set forward clock)

Expected result

1. catalog price rule still applies

Actual result

1. catalog price rule no longer applies
2. running reindex fixes the problem

[ludwig-gramberg]

i'm not sure wether or not this is caused by not defining a start-and enddate but either way it should work or the admin-interface should not allow to chose parameters which make this not functioning.

[miakusha]

Hi @ludwig-gramberg , thank for report
I've linked this GitHub issue to internal ticket MAGETWO-59126

[Thanh1010]

100000000 limit price as inappropriate.
My countries Vietnam 1 us, the product is up to hundreds of millions is normal (greater inflation ). We desire no limit on the price to be listed them for more than 100 million. Current price is limited to only 100 million is inappropriate and cart are also limited. thank you !

[korostii]

This particular bug has been reported on Magento 1.9 as well.

[Chuvisco88]

In Magento 1.X this bug occurs if you are living in a timezone which is more than +01:00 from GMT. The default cronjob is running at 01:00 and is using GMT time to set the rule_date.
In said case the date will be "yesterday" so there would be no price rule for the current day.

Example:

Current Datetime: 2017-07-19 01:00:00 (at current timezone)
Current Datetime at GMT: 2017-07-18 23:00:00
At 01:00 cronjob runs to write price rules with "$coreDate->gmtTimestamp('Today');"
Function will return "2017-07-18" which in this example is "yesterday"

But as far as I can see https://github.com/magento/magento2/blob/develop/app/code/Magento/CatalogRule/Model/Indexer/ReindexRuleProductPrice.php does solve that issue by setting the toDate with the current date + 1.
So does this still not work in Magento 2?