I tried to add a CATALOG price rule, not a cart price rule, using multiple sku's. I'm on Magento 2.1.2. In the past I have been able to create price rules (i.e. 30% off) and added products using SKU's. The products then show up on the front end with the discounted price.

I recently just tried this and found that only 2 of the many sku's I have added are being affected. I tried several times to add the sku's and no matter what, only 2 of the sku's work.

I then checked the database table and the RULES are there all written to the DB correctly, but under the rules, it seems that the SKU's I add in the admin will not be written to the DB table that lists the item #'s under each rule?

Does anyone have any issues with this? There are a number of the posts about this, but nothing with a definite answer. I have even found a bug report, but that was for CE 1.8. and 1.9 HERE. I also found an issue on Github where a contributor states that "in magento you have no ability to create Catalog rule based on list of SKU. You can create rule only based Attribute Set or Category." which doesn't seem to be correct.

Does anyone out here have any concrete solution or idea about this?

1 Answer 1


I found that I needed to edit the SKU attribute to make it selectable for Promo Rule Conditions in Magento 2.1.4.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.