Magento Exclude Products from Shopping Cart Price Rule

Magento Exclude Products from Shopping Cart Price Rule

October 15, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Exclude Products from Shopping Cart Price Rule

Excluding Products from Magento Shopping Cart Price Rules

Hello Michael,

I understand your concern about managing over a thousand shopping cart price rules in Magento. Let’s walk through the best approach to exclude a new product from all existing rules without having to update each one individually.

Understanding Magento Rule Conditions

Magento stores rule conditions as serialized arrays, which can make them difficult to work with directly. Each condition is stored as an associative array with keys like attribute, operator, and value. For example:

array(
    'attribute' => 'sku',
    'operator'   => '==',
    'value'      => 'ABCD1234'
)

Excluding a Product Programmatically

To exclude the new product from all shopping cart price rules, we’ll follow these steps:

1. Find the Rule IDs

First, you need to fetch all the rule IDs using Magento’s core API or a direct database query.

$rules = Mage::getModel('salesrule/rule')->getCollection();
foreach ($rules as $rule) {
    $ruleIds[] = $rule->getId();
}

2. Get the Serialized Conditions

For each rule, retrieve the serialized conditions array:

$conditions = unserialize($rule->getConditionsSerialized());

3. Exclude the New Product

Identify the new product’s SKU or ID and remove it from the conditions array.

$newProductSku = 'NEW_PRODUCT_SKU';
foreach ($conditions as $key => $condition) {
    if (isset($condition['attribute']) && $condition['attribute'] == 'sku'
        && isset($condition['value']) && $condition['value'] == $newProductSku
    ) {
        unset($conditions[$key]);
    }
}

4. Save the Updated Conditions

Re-serialize the updated conditions array and save it back to the rule:

$rule->setConditionsSerialized(serialize($conditions));
$rule->save();

Efficiency and Best Practices

To optimize this process for a large number of rules:

  • Consider limiting the results per page when fetching rules.
  • Use Magento’s resource model or indexers to ensure data consistency (if applicable).
  • Avoid direct database queries and use Magento’s built-in models and collections where possible.

Conclusion

Excluding a product from all shopping cart price rules in Magento can be achieved programmatically by manipulating the serialized conditions. By following this approach, you avoid having to manually update each rule individually—a significant time saver when dealing with hundreds of existing rules.

Remember to test your changes thoroughly before deploying them to your production environment to ensure no unintended side effects occur.

If you need further assistance or want to discuss Magento development best practices in more detail, feel free to reach out at https://laravelcompany.com/contact/. We’d be happy to help!

Checkout Catalog Database API

Our network