I have been stuck with this problem since my upgrade to 220.127.116.11 and it seems that the problem is still not resolved with 18.104.22.168.
If I were to set up a catalog price rule while Flat Category/Product is enabled, the following catalog price rule will cause the promotion to be applied to the wrong combination of products:
The price rule will still apply to Category ID: 10, 138, and so on.
I see in Magento 22.214.171.124 release notes:
However, the problem with the use of "is one of / is not one of" in Catalog Price Rules doesn't seem to be resolved yet, even in 126.96.36.199.
Every time I launch a promotion I have to do the following in order to get the rules to apply to the correct products:
Before upgrading there will only be 3 steps involved:
Or alternatively you can just script the process through a cron job.
Hopefully these issues can be addressed.
Thanks for your reply. I will be posting the bug report soon.
Anyway, a word of caution for everyone reading this that plans to launch a Catalog Price Rule promotion that will apply to products using the "is one of / is not one of" options, you need to make sure that if you plan to run your promotion overnight, or even for a few days, you have to make sure you disable the "catalog_product_index_price_reindex_all" and "catalogrule_apply_all" cron jobs.
These cron jobs are configured by default to run at 1AM and 2AM respectively to re-index your product prices. If you re-enabled the Flat Product/Category indexes after applying your catalog price rule, having these cron jobs enabled will screw up your promotion while you're sleeping in bed. (Learned this the hard way) The price rule will be applied to the wrong set of products again even if you have made sure the price rules are applied correctly before the cron job ran.
Use the excellent Aoe_Scheduler extension by Fabrinzio Branca from AOE to manage or disable your Magento cron jobs:
Hi @jasperthedummy, did you manage to fix this, or got any replies on your ticket ?