SQL Magento Get the list of SKUs that are in a catalog_price_rule

👴 Careful You’re reading an old article ! Some links might be broken and content may be outdated

The parameter « rule_id » can be viewed in the URL when you are editing the catalog price rule.

select sku
from catalog_product_entity
where entity_id in (
SELECT DISTINCT product_id 
FROM catalogrule_product 
WHERE rule_id=<rule_id>
);