Magento1.8 – Catalog Price Rules Not Working

catalog-price-rulesmagento-1.8

I'm on Mage 1.8 with custom data.

I have created a catalog rule that give 10% discount when sku = 'n2610' ( relative product id is 16 )
saved the rule
apply all the rule

Now I m testing the rule with the following code:

<?php
require_once './app/Mage.php';
umask(0);
Mage::app();
//Mage::setIsDeveloperMode(true);

$rule = Mage::getModel('catalogRule/rule')->load(5);

var_dump($rule->getData());
var_dump($rule->getMatchingProductIds());

getMatchingProductIds() gives me back an array() with all prod. here the part for the interested product.

RESULT:

16 => 
array (size=3)
  0 => int 0
  1 => int 0
  2 => int 0

I expect that the array contains some 1.

If I debug the following method, I can see that the $validatedValue is always empty so the rule never match.

Mage_Rule_Model_Condition_Abstract::validateAttribute($validatedValue)

Anyone can point me to the error ? is it a bug on 1.8 ( I'm quite sure I haven't touched any core file.)

Best Answer

According to this answer: https://stackoverflow.com/questions/19857309/magento-1-8-0-0-promotion-catalog-price-rules-does-not-work-when-condition-i

It's a bug/feature in 1.8, Catalog Rules work with conditions for attributes with scope other than Global.

Related Solutions

Magento – Catalog Rules Don’t Get Applied on Product Save

Magento support confirmed it's a core bug. In Mage_CatalogRule_Model_Resource_rule::insertRuleData at about line 247 the code:

if (count($productIds) > 0) {
   $selectByStore->where('p.entity_id IN (?)', $productIds);
}

Should be replaced by

if (count($productIds) > 0) {
   $selectByStore->where('p.entity_id IN (?)', array_keys($productIds));
}

I would guess this will be fixed in the next minor point release due out late November 2013 (1.8.1 and 1.13.1).

Edit:

This was indeed patched in versions 1.8.1 and 1.13.1

Check If Product Has Catalog Price Rule in Magento

If you don't have many rules or many products you can try this:

$website = Mage::app()->getWebsite();
$product = $this->getProduct();
$rules = Mage::getModel('catalogrule/rule')->getCollection()
    ->addWebsiteFilter($website) //filter rules for current site
    ->addIsActiveFilter(1); //filter active rules

foreach ($rules as $rule) {
    $affectedProductIds = $rule->getMatchingProductIds();
    if (in_array($product->getId(), $affectedProductIds)) {
        //product has a price rule set for it
    }
}

The quick and dirty idea would be to search for a record in the table catalogrule_product.
All products that are affected by catalog rules are referenced in that table.

$resource = Mage::getSingleton('core/resource');
$connection = $resource->getConnection('core_read');
$tableName = $resource->getTableName('catalogrule_product');
$count = $connection->fetchOne('SELECT COUNT(1) as c FROM '.$tableName.' WHERE product_id = '. $product->getId());

if ($count == 1) { 
    //you have a rule for the product
}

But this is not the best practice.

Best Answer

Related Solutions

Magento – Catalog Rules Don’t Get Applied on Product Save

Check If Product Has Catalog Price Rule in Magento

Related Topic