Recently on one of our client’s stores (this one in particular running Magento 1.4.1.1) we ran into an issue with creating a Shopping Cart Price Rule promo. The goal was to create a rule where if there were 3 or more products with a certain SKU in the cart then apply a discount. However, when we went to create the rule – based on SKU – we realized that the conditions dropdown was no longer displaying the attributes as it had in the past. The dropdown looked something like this:
Please choose a condition to add…
Conditions Combination
Cart Item Attribute
– Price In cart
– Quantity in cart
– Row total in cart
Product Attribute
– Attribute Set
– Category
The fix that worked for us:
In the Magento Admin Panel go to Catalog > Attributes > Manage Attributes
Select any attribute that you’d like to be able to sort by in the conditions list. On the edit-a-attribute page, under “Frontend Properties” set “Use for Promo Rule Conditions” to “Yes”. Save the attribute.
Then go to System > Index Management and re-index.
Now – when you go back to creating your Shopping Cart Price Rule, you will see your attribute in the conditions list.
Simple fix for an annoying issue.
Win
Thanks mate! You’re my hero!
February 23, 2011 at 9:20 am
Sean
I second that, Win.
The Magento Knowledge Base needs to be updated, or the default configuration should include SKU to match the Knowledge Base examples.
March 26, 2011 at 12:48 pm
Jason
You just saved me another 2+ hours of going around in circles. THANKS!!!!
April 12, 2011 at 5:32 pm
Nick
They should include some basic attributes for promo condition.Thanks!!
June 9, 2011 at 4:31 am
Steve Crooks
Thank you.
Just spent an afternoon reading manuals and getting no where until I found this.
The fix works form although I have to add my SKUs as ‘Actions’ and not ‘Conditions’. Not a problem, just thought it might help someone else
June 10, 2011 at 12:56 pm
gopal
nice….its a small thing…but very needy…
June 11, 2011 at 3:27 am
Dave
Thanks for this! I agree this needs to be a point in the Knowledge Base
June 27, 2011 at 3:34 pm
Clive
Thanks for your post – I have spent over an hour trying to figure out where I was going wrong – or blind…I can’t imagine why this would not be a default setting.
July 15, 2011 at 10:53 am
Terence Lim
You are my hero! The official tutorial didn’t mention about this and I couldn’t where gone wrong until I found this. I can see my product attribute now.
August 22, 2011 at 11:03 am
Jacqueline DeVito
Why thank you; you’re making us blush. Glad we could help!
August 23, 2011 at 9:43 am
hannah
PHEW!!!!!!!!!!!! A HUUUUUGE thanks to whoever figured this out! Magento tutorials was NO help, you saved me another 4 hours of pulling my hair out!
January 21, 2012 at 9:47 am
Jacqueline DeVito
You’re quite welcome!
January 26, 2012 at 11:37 am
Francisco
After this issue i have another problem. When i apply the discount to the sku 1,2 e see that all the other products also get the discount. Any idea?
February 5, 2012 at 5:54 pm
Peter
Thanks! How easy, if only it was documented…
February 20, 2012 at 10:35 am
Derek
Thanks for the help. I have had this happen multiple times and couldn’t figure out why. All is good now.
Thank you!
February 21, 2012 at 4:39 pm
Magento Manchester
ABSOLUTE LEGEND!!! Here’s me forking out for expensive plugins when the magento core can do what I’m after anyway!
April 16, 2012 at 8:29 am
Salim
Thanks. That’s not so difficult as I think.
July 1, 2012 at 12:59 pm
cheayden
Hello , I am a new magento and my question is that How to show all value of new attribute in dropdown box in shopping cart
November 16, 2012 at 5:18 am
Steve
Thank you! It would have taken me hours to find that solution.
May 15, 2013 at 10:07 pm