Can't get price groups to stack a certain way to offer specific deals.

[mamorde]

What we are trying to do is offer a specific product at 20% off with one price group and then have a second deal where if they buy 2 or more of the same products (in pairs of 2) they get one at full price and one 50% off. What we can't seem to get to work is having these price groups work in tandem while not adding together. If a customer has 1 of this item in their basket, I want them to get it for 20% off and if they add a second one, I want one of them to be full price and the second one to be 50% off. I have tried all kinds of combinations of price group permissions and priorities, but nothing seems to work. Is there a way for this to happen?

[Nick]

mamorde Could something like this work:

Create two price groups:

1. Price Group Type of Product discount.
   1. Discount of 20%
   2. Add the product to the discounted products
2. Price Group Type of Product discount
   1. Discount of 50%
   2. Maximum Item Discount Quantity value of 1
   3. Restrict Qualifying Quantity minimum value of 2
   4. Give the Price group a higher priority of the 20% off price group
   5. Set the 20% off price group as Excluded for Same Basket
   6. Add the product to the discounted products
   7. Add the product to the qualifying products

This should give the product a 20% off discount if one is added to the basket. Then if two are added to the basket the second price group will overwrite the 20% off giving one product a 50% discount and the second product full price.

I was able to set this up in my development store if you want to test (I can't promise the price groups will be there forever): https://mivalearn.mivamerchantdev.co...ilet-bowl.html

[mamorde]

Hey Nick this works for a single order of 1 or 2 of the same product. It doesn't seem to apply right once you add more than 2 items into your cart.

Ideally I would like to have it work to where if a customer purchased 1, it would be 20% off. If they purchase 2, the first one would go back to full price and the second would be 50% off. If they purchase 3, the first one would be full price, the second would be 50% off, and the third would be 20% off. If they purchase 4, then 2 would be full price and 2 would be 50% off. Then continue to have it continue that cycle as more of the same product are purchased.

I know that seems convoluted, but it's a very effective sales tactic for our customer base.

Thank you so much for the response!

[Nick]

Ideally I would like to have it work to where if a customer purchased 1, it would be 20% off. If they purchase 2, the first one would go back to full price and the second would be 50% off. If they purchase 3, the first one would be full price, the second would be 50% off, and the third would be 20% off. If they purchase 4, then 2 would be full price and 2 would be 50% off. Then continue to have it continue that cycle as more of the same product are purchased.

That is a very complicated discount, let me bring this to our team and see if it is possible.

[Nick]

mamorde I figured out a way to accomplish this but it would not be dynamic, meaning you would need to create price groups for every quantity level (ie if you think that they will add a quantity of 100 you will need price groups to account for the different discounts).

Going back to the example I posted above you will see that product works up to a quantity of 5. Here are the price groups I needed to create for it to work:
price_group.JPG

[mamorde]

Thank you so much for this Nick. This is definitely more work than it's worth but I am happy to know that there wasn't a simple solution that I wasn't aware of. We will keep this info in our back pocket for when we want to try this though!