Automatically add product if total is over X amount?

Is it possible to add a free item to the cart if the total reaches a certain dollar amount? I give a free squeegee away to large orders and it would be nice if this item could automatically be added to the order after a certain dollar amount. Right now, I just note the dollar amount when processing and hope I remember to throw it in the package. Wasn’t sure if there was an easy way to do this or a workaround of some sort.

You can create a promotion with the “Order total” condition and a “Free products” bonus.



Bob

Thanks Bob…I was pretty sure this could be done somehow but wasn’t sure where to start.



Jacy

Hmmm…I am having problems getting this to work completely properly. It may not be possible.



I have it set up as a Cart promotion. If Order Total is above $99.99 then it adds the item to the cart. The problem is that I offer quantity discounts too. So the actual total may be $70 but it still adds the free product to the cart. I have played around the Priority setting but that doesn’t seem to affect it.



Is there a way for it to look for the price AFTER the quantity discounts are applied?

It seems to be working for me. Are you saying that you want the bonus given based on the non-discounted price?



Bob

[quote name=‘jobosales’]Are you saying that you want the bonus given based on the non-discounted price?



Bob[/quote]



Yes, I am looking for the item to be added to the cart only if the total after discounts is still $100.

[quote name=‘IsItFast’]Yes, I am looking for the item to be added to the cart only if the total after discounts is still $100.[/QUOTE]

I am on 2.0.12 and it works that way for me.



For example, product with a price of $69 ($45 for quantity 2 or more for registered user):



Unregistered user:

Buys 1@$69 - No bonus

Buys 2@$69 - Bonus given



Registered user:

Buys 1@$69 - No bonus

Buys 2@$45 - No bonus



Bob

Well that’s odd. I wonder if it has something to do with 2.0.12 or the registered user part. My discounts work at 2-4, 5-9, 10-40, and so on no matter if the customer is registered or not. I don’t think there is a way I could have set it up “wrong” but I’ll double check.

[quote name=‘IsItFast’]Well that’s odd. I wonder if it has something to do with 2.0.12 or the registered user part. My discounts work at 2-4, 5-9, 10-40, and so on no matter if the customer is registered or not. I don’t think there is a way I could have set it up “wrong” but I’ll double check.[/QUOTE]

I just tried again with the quantity discount not tied to being registered and got the following results:

1@$69 - No bonus

2@$45 - No bonus

3@$45 - Bonus given



One possibility I think I remember was that the order total condition was including the tax and shipping. Is that a possibility?



The most likely explanation is a change from 2.0.11 to 2.0.12.



Bob

Bob, I sure appreciate all the help.



I’m not sure the tax/shipping suggestion is relevant since the discount is shown before I get to that point. I looked through the 2.0.12 change log and couldn’t see any promotion fixes that would have fixed anything so I am at a loss here.



If anyone can confirm that this only works in 2.0.12 OR if someone can confirm it works as I need it in previous versions it would be much appreciated.



To see this (not) in action on my cart you can go to [url]url] and add 15 of those to the cart. You will notice the subtotal is $119.85 but after discount the total is $83.89 so the customer should not be getting the free squeegee.

The bonus seems to be getting triggered based on the number of items in the cart (10 to 49 Products Quantity Discount). Do you have a promotion set up with a condition of “Total products in the cart”?



Bob

I think I see what is happening.



You are using a promotion to do your quantity discounts - I should have picked up on that when you said that you played around with the priorities. I was using the quantity discount on the products (which works). Is there any way you can just use the quantity discounts rather than a promotion?



To be honest though, your scenario should still work as long as the “Free squegee” promotion has a higher priority and you do not have “Stop other rules” checked on the discount promotion.



Bob

You are correct Bob. I am using promotions for my quantity discounts. I (think) I have to do it this way for my set up. My quantity discount applies no matter what the product is…it is based off the number of products in the cart (not the number of the identical items) so I can’t really change that.



But I too thought that changing the priorities around should fix things but they seem to have no effect on how the discount works. I tried the upper and lower end of the scale just to be safe that it didn’t work “backwards”. And I did try “stop other rules” just to rule it out. No luck with anything.



This is odd.



Jacy

I realized why you are using a discount promotion right after I posted and using a promotion is the only way to accomplish this.



I would report this as a bug. As long as the discount promotion does not have “Stop other rules” checked and has a lower priority number, it should work - at least, that is my take on it.



Bob

It appears that it is a bug BUT I need to pay to fix it. They had me change the schema file within the cart to fix it but it didn’t work. Here is their response:


[QUOTE]Sorry for possible inconvenience. Please change back the code. Unfortunately the functionality of the promotions was changed in new versions. My solution does not suit in this case. Some additional PHP code modifications are required to do it. It is not covered by our technical support service. We can offer you our Custom Development service. Please let me know if you want our engineers to make these modifications for you on a paid basis and I will forward your request to our custom development specialist for an estimate.[/QUOTE]



It really sucks paying for support just to be told to “give us more money” and we will fix it. I don’t mind paying to get something the way I want it to but this is just something that should work from the beginning. Isn’t that what the “priority” settings are for?

The promotions are slowly improving but they still need quite a bit of work - both bugfixes and improvements. A quick review on the Bug Tarcker for “promotions” is pretty telling.



Bob