Find Shopping Cart Rule Match by Product Programmatically in Magento

magento-1.7magento-1.8moduleMySQL

Question Updated

I am being try to find the discount amount which match the shopping cart rule based on product. I replicate the module 'Shopping Cart Price Rule' to another module which i want to create my discount rule under condition tab.My new module does not have coupon code.It has rule information and condition only.

So Here i want to get discount amount that matches my new module rule based on product details(product id, sku) with out coupon code.

/**
 * Get rules collection for current object state
 *
 * @return Mage_SalesRule_Model_Mysql4_Rule_Collection
 */
protected function _getRules()
{
    $key = $this->getWebsiteId() . '_' . $this->getCustomerGroupId() . '_' . $this->getCouponCode();
    return $this->_rules[$key];
}

Here we dont use $this->getCouponCode() to find the rule match.

Before going to replicated module, i just want to know is it possible in shopping cart price rule module.

My question is , How do i find the discount amount based on product that matches shopping cart price rule with out giving coupon code ?

Best Answer

I tried with external file,Given product id to find the matched sales rule conditions.

require_once("app/Mage.php");

Mage::app('default'); 

$pid = 53;
$_product= Mage::getModel('catalog/product')->load($pid);

$coll = Mage::getResourceModel('salesrule/rule_collection')->load();
foreach($coll as $rule){
  $rule->afterLoad(); 
}  

 $quoteId = Mage::getSingleton('checkout/session')->getQuoteId(); 
 $real_quote = Mage::getSingleton('sales/quote')->load($quoteId);                
 $product = Mage::getModel('sales/quote_item')->setQuote($real_quote)->setProduct($_product);  
 $product->setAllItems(array($_product));                 
 $product->getProduct()->setProductId($_product->getEntityId());    
foreach($coll as $rule) 
{  
    if ($rule->getConditions()->validate($product))  
    {            
       echo ':)';
       echo $rule->getData('discount_amount');
  }        
}   
exit;

Related Solutions

Magento – Mark Products Matching Shopping Cart Price Rules

I solved it like that

Just change process function in Validator.php to

public function process($_quote) {
    $i               = 0;
    $quote           = $_quote;
    $customerSession = Mage::getSingleton('customer/session');
    foreach ($this->_rules as $rule) {
        // @var $rule FME_Affiliates_Model_Program
        // already tried to validate and failed
        if ($rule->getIsValid() === false) {
            continue;
        }
        if ($rule->getIsValid() !== true) { 
            $rule->afterLoad();
            if (!$rule->validate($quote)) { // quote does not meet rule's conditions , //Call Found.php
                $rule->setIsValid(false);
                continue;
            }
            $rule->setIsValid(true); // passed all validations, remember to be valid
        }

        $this->_appliedProductsIds[]                 =  Mage::getSingleton('checkout/session')->getReturnProductRuleValues();
        $this->_appliedProductsIds[$i]['program_id'] =  $rule->getProgramId();
        Mage::getSingleton('checkout/session')->unsReturnProductRuleValues($this->_ReturnValues);
        $i = $i + 1;
    }
    return $this;
}

And validate function in Found.php to

public function validate(Varien_Object $object) { 
//Called form Validator.php
    $all       = $this->getAggregator() === 'all';
    $true      = (bool)$this->getValue();
    $found     = false;

$Count =  count($object->getAllItems()); 
$i = 0;
    foreach ($object->getAllItems() as $item) {
        $found = $all ? true : false;
        foreach ($this->getConditions() as $cond) {

            $validated = $cond->validate($item); // Call to Product.php's function 'validate'

    if($validated) {
        $this->_ProductId[] = $item->getProductId();
    }

    if($i == $Count) {
        if ($all && !$validated) {
        $found = false;
        break;
        } elseif (!$all && $validated) {
        $found = true;
        break 2;
        }
    }

        }
    if($i == $Count) {
    if ($found && $true) {
        break;
    }
    }
    $i = $i + 1;
    }

$this->_ReturnValues['Product_Id'] = $this->_ProductId;
if(!empty($this->_ProductId)) {
    $this->_ReturnValues['Bool'] = true;
} else {
    $this->_ReturnValues['Bool'] = false;
}

    if ($found && $true) {
        // found an item and we're looking for existing one
    Mage::getSingleton('checkout/session')->setReturnProductRuleValues($this->_ReturnValues);
        return true;
    } elseif (!$found && !$true) {
        // not found and we're making sure it doesn't exist
    Mage::getSingleton('checkout/session')->setReturnProductRuleValues($this->_ReturnValues);
        return true;
    }
Mage::getSingleton('checkout/session')->setReturnProductRuleValues($this->_ReturnValues);
    return false;
}

And access the values in Observer with Vadidator class object like $appliedProductsIds = $validator->_appliedProductsIds;

Hop this will help someone..

Magento – To show coupon (shopping cart discount) amount including tax

Changing 'Apply discount on prices' to 'including tax' will ensure that discounts are displayed inclusive of tax, but in my experience this throws out the overall tax calculation. This seems to be because it will now subtract the GROSS discount (tax incl.) from the tax excl. basket total before calculating overall tax, whereas it should still subtract the NET discount (tax excl.).

Best Answer

Related Solutions

Magento – Mark Products Matching Shopping Cart Price Rules

Magento – To show coupon (shopping cart discount) amount including tax

Related Topic