Cart Price Rule If ALL of these conditions are TRUE Logic Bug

[webkeonsanjeev]

Hi Dear,

I have setup cart price rule in magento 2.2 community version If ALL of these conditions are TRUE should work as AND condition not OR.

Below is my condition:

If ALL of these conditions are TRUE :

If an item is FOUND in the cart with ALL of these conditions true:
SKU contains ASRP-ET
Total Items Quantity equals or greater than 8
Total Items Quantity equals or less than 11
-----------------------------
Apply: Fixed amount discount for whole cart
Discount Amount: 4
I have added 7 products that contains SKU ASRP-ET & one product that SKU not contain ASRP-ET

Discount should not apply but discount is applying means only one condition is true total item qty 8 or greater. SKU contains condition is not checking.

Thanks

Sanjeev

[Sunil Patel]

---

@webkeonsanjeevwrote:

Hi Dear,

I have setup cart price rule in magento 2.2 community version If ALL of these conditions are TRUE should work as AND condition not OR.

Below is my condition:

If ALL of these conditions are TRUE :

If an item is FOUND in the cart with ALL of these conditions true:
SKU contains ASRP-ET
Total Items Quantity equals or greater than 8
Total Items Quantity equals or less than 11
-----------------------------
Apply: Fixed amount discount for whole cart
Discount Amount: 4
I have added 7 products that contains SKU ASRP-ET & one product that SKU not contain ASRP-ET

Discount should not apply but discount is applying means only one condition is true total item qty 8 or greater. SKU contains condition is not checking.

Thanks

Sanjeev

---

---

@webkeonsanjeevwrote:

Hi Dear,

I have setup cart price rule in magento 2.2 community version If ALL of these conditions are TRUE should work as AND condition not OR.

Below is my condition:

If ALL of these conditions are TRUE :

If an item is FOUND in the cart with ALL of these conditions true:
SKU contains ASRP-ET
Total Items Quantity equals or greater than 8
Total Items Quantity equals or less than 11
-----------------------------
Apply: Fixed amount discount for whole cart
Discount Amount: 4
I have added 7 products that contains SKU ASRP-ET & one product that SKU not contain ASRP-ET

Discount should not apply but discount is applying means only one condition is true total item qty 8 or greater. SKU contains condition is not checking.

Thanks

Sanjeev

---

Hello,

please do with Action condition not using Conditions tab.

[Manthan Dave]

Hi @webkeonsanjeev

As you are applying fixed amount discount for whole cart.

So you need to use Conditions from ACTION tab instead of Conditions tab.

You have already selected fixed amount discount from ACTION tab - below in it there is condition section where you can add condition : if all of these conditions are true

then add the conditions you want.

It will works !

[webkeonsanjeev]

Hi 

I have removed condition from conditions tab and add below condition in action tab but now discount is not applying I think qty in cart means simple product row qty but i want to give discount as per configure product qty.

If ALL of these conditions are TRUE :
SKU contains ASRP-ET
Quantity in cart equals or greater than 8 
Quantity in cart equals or less than 11

[Manthan Dave]

@webkeonsanjeev - Okay i understand !!!

in that case you are adding in condition tab that is correct !!

But in magento 2  native condition is available like - IS and CONTAINS

So even though when you are adding 8 quantities in cart , but among them 1 product have SKU Contains ASRP-ET , then it will apply discount. 

Because both the condition is match over here - SKU contains ASRP-ET and Quantity contains 8.

So in your case , you need to customize  it for the same.

[webkeonsanjeev]

I have solved my above requirement by using below conditions:

Cart price rule 1

If ALL of these conditions are TRUE :
If total quantity equals or greater than 4 for a subselection of items in cart matching ALL of these conditions:
SKU contains FBMS
If total quantity equals or less than 7 for a subselection of items in cart matching ALL of these conditions:
SKU contains FBMS
Apply: Fixed amount discount for whole cart

Discount Amount: 45

--------------------------------------

Cart price rule 2

If ALL of these conditions are TRUE :
If total quantity equals or greater than 8 for a subselection of items in cart matching ALL of these conditions:
SKU contains FBMS
If total quantity equals or less than 11 for a subselection of items in cart matching ALL of these conditions:
SKU contains FBMS
Apply: Fixed amount discount for whole cart

Discount Amount: 90

----------------------------------------------------------------------

At the time of adding product from product detail page above condition give $90 discount of qty 7 but it should give discount 45 not 90 but same if we update qty from cart page it work perfect as above condition.

Why cart price rule does not work before update qty from cart page. 

Any suggestion?

Thanks

Sanjeev