Problems with flat rate shipping

[DryDiapersPlus]

Hi -

Ok to give a bit of background on what I'm trying to do. On my previous shopping cart with a template site, I wanted to give free shipping on 1 product only - so on the product page, I would check off the box that said "free shipping".

Then, I created a rule that said anything under $175 was $12.99 shipping - anything over $175 was free shipping.

It worked a treat.

However, with Squirrellcart - I'm not that fortunate...so myself and my website developer are having some issues trying to get my shipping to work.

I want it to happen that if my customer orders 1 case of a specific brand of briefs, they get free shipping ON THE BRIEFS ONLY.

So - if they put other items in their shopping cart, if they total less than $175 - they get charged a flat rate of $12.99. If they have more than $175 in products (NOT including the cost of the case of briefs - but over and above that) - then they get free shipping on the entire order.

How can this be set up. We've tried many ways - and somehow either the customer gets charged shipping when they shouldn't - or they don't get charged shipping when they should :-(

Please help.

Thanks

[dave01978]

Hi -

Ok to give a bit of background on what I'm trying to do. On my previous shopping cart with a template site, I wanted to give free shipping on 1 product only - so on the product page, I would check off the box that said "free shipping".

Then, I created a rule that said anything under $175 was $12.99 shipping - anything over $175 was free shipping.

It worked a treat.

However, with Squirrellcart - I'm not that fortunate...so myself and my website developer are having some issues trying to get my shipping to work.

I want it to happen that if my customer orders 1 case of a specific brand of briefs, they get free shipping ON THE BRIEFS ONLY.

So - if they put other items in their shopping cart, if they total less than $175 - they get charged a flat rate of $12.99. If they have more than $175 in products (NOT including the cost of the case of briefs - but over and above that) - then they get free shipping on the entire order.

How can this be set up. We've tried many ways - and somehow either the customer gets charged shipping when they shouldn't - or they don't get charged shipping when they should :-(

Please help.

Thanks

I'm am trying to figure out what you want,
they need to order a case + $175 in other merch to get the free shipping?
or free shipping on a case by itself?
For the Case + 175 is that free shipping on orders of anything over 175? or does it need to include the case as well (I kind of read that as both ways but not sure (if it needs both you need a rule with 2 conditions to be met, and use the total however you may need to add the cost of the case to the $175 for the rule)
I am thinking i am not understanding becuase of being tired.

If I can figure out exactly what you want I can probably come up with a work around
Dave

dave

[DryDiapersPlus]

No - it's not you - it's a bit confusing (not to me because I'm the one doing it LOL!)

Ok scenario 1:

Customer orders:

• 1 case of briefs = free shipping
• 1 case of liners = shipping
• 5 pairs of incontinence underwear
  total equals (for liners & underwear) more than $175 (without including the case above) = free shipping
• so entire order is free shipping

scenario 2
Customer orders

• 1 case of briefs = free shipping
• 1 case of liners = shipping
• 5 pairs of incontinence underwear
  total equals (for liners & underwear) more than $175 (without including the case above) = free shipping
• so entire order is free shipping

scenario 3
Customer orders

• 1 case of briefs = free shipping
• 1 pair of underwear = shipping
• total NOT INCLUDING case is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 4
Customer orders

• 1 case of briefs = free shipping
• 4 pair of underwear = shipping
• total NOT INCLUDING case is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 5
Customer orders

• no case of briefs
• 4 pair of underwear = shipping
• total is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 5
Customer orders

• no case of briefs
• 10 pair of underwear = shipping
• total is more than $175 so order is free shipping

I think I've thought of all the scenarios...

Thanks

Tammy

[designwerks]

I'm glad I charge shipping for everything in my store...

I've often thought about free shipping but, then the money would come out of my pocket... FedEx and Canada Post don't ship for free.

Have you ever thought of having a free shipping weekend / week for promo? (that be easy to code)...

Perhaps a coupon code (in the value of shipping ) the NEXT time they order, to keep em' coming back to your store?

I value the concept of free shipping, and the need to be competitive on the web, but dislike the fact that the shipping companies never really give anything away. We are making them much profit.

[dave01978]

OK im still confused, are you wanting all of them condtions to be met on every order?
or what? if they only order a case of briefs is it free shipping?
are you wanting free shipping on $175+ only if they have a case, or on any order over $175 (not including the case)
it might be hard to code based on the case price, but might be able to do it, just want to make sure i understand what you want

No - it's not you - it's a bit confusing (not to me because I'm the one doing it LOL!)

Ok scenario 1:

Customer orders:

• 1 case of briefs = free shipping
• 1 case of liners = shipping
• 5 pairs of incontinence underwear
  total equals (for liners & underwear) more than $175 (without including the case above) = free shipping
• so entire order is free shipping

scenario 2
Customer orders

• 1 case of briefs = free shipping
• 1 case of liners = shipping
• 5 pairs of incontinence underwear
  total equals (for liners & underwear) more than $175 (without including the case above) = free shipping
• so entire order is free shipping

scenario 3
Customer orders

• 1 case of briefs = free shipping
• 1 pair of underwear = shipping
• total NOT INCLUDING case is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 4
Customer orders

• 1 case of briefs = free shipping
• 4 pair of underwear = shipping
• total NOT INCLUDING case is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 5
Customer orders

• no case of briefs
• 4 pair of underwear = shipping
• total is less than $175 so order is charged $12.99 (flat rate) shipping

scenario 5
Customer orders

• no case of briefs
• 10 pair of underwear = shipping
• total is more than $175 so order is free shipping

I think I've thought of all the scenarios...

Thanks

Tammy

[DryDiapersPlus]

I'm glad I charge shipping for everything in my store...

I've often thought about free shipping but, then the money would come out of my pocket... FedEx and Canada Post don't ship for free.

Have you ever thought of having a free shipping weekend / week for promo? (that be easy to code)...

Perhaps a coupon code (in the value of shipping ) the NEXT time they order, to keep em' coming back to your store?

I value the concept of free shipping, and the need to be competitive on the web, but dislike the fact that the shipping companies never really give anything away. We are making them much profit.

On our .ca site - we charge shipping for everything because - as you so eloquently put it money would come out of my pocket... FedEx and Canada Post don't ship for free

However, on my .com site, the manufacturer pays for the shipping of the 1 product - and no other site charges for shipping on that product (the resellers that sell it) - so I have to pass the savings on for that product, too - or I'm not competitive :-(

[DryDiapersPlus]

OK im still confused, are you wanting all of them condtions to be met on every order?
or what? if they only order a case of briefs is it free shipping?
are you wanting free shipping on $175+ only if they have a case, or on any order over $175 (not including the case)
it might be hard to code based on the case price, but might be able to do it, just want to make sure i understand what you want

Hi, I know it's confusing I've been trying to figure it out for almost a year now - and can't seem to get anything to work.

So basically when they order this particular case of briefs - they get free shipping on that case. If they order anything else with that case - they have to pay the flat rate of $12.99 - IF the total of all other products in their basket is less than $175. If the total of all the other products in the basket (not including the case of briefs in the total amount - because they already get free shipping) - then the rest of the order is free shipping too.

If the don't order this particular brand of briefs, and order something else - if the total in the cart is less than $175 - flat rate shipping of $12.99. If their total in the cart is over $175 - it's free shipping.

Am I just making it more confusing? or helping more here???

[dave01978]

Ok I got this figured out I think

First off I assume you got the case set as ship as separate package, then have flat rate of $0.00

Now I also assume you have the flat fate for $12.99 set up for orders

Now this is where it gets tricky, what you need to do is set up a rule for your shipping for free shipping, now you will need to add several possibly to make up to however many cases you think you might sell in one order I will post screen shots of how I have it set up, and working to allow free shipping on order without a certain product.
On my rules I set up to make it easy for me to test using a rule I already had partially set up, so free shipping will be $5.00 in my example, and the order threshold is $125 without a product called test.

Rule #3 sets the states that I do not want it to apply to, if you want all then go ahead and skip that section.
Rule #2 sets total cost
Rule #4 checks on the cases of specific price.
This rule will allow all orders of $175 to ship for free as long as they do not include any cases of specified product.

Now you will need to add more rules for each case
so you want the total to =175+(cost of case)
set rule to have item = 1

do same for 2 cases
175+case+case
rule set have 2 cases
I hope this makes sence, and add as many as you feel nessicary
Daveshipping2.PNGshipping1.PNG

[DryDiapersPlus]

Thanks Dave - it's all Greek to me - but I'm going to forward on to my web developer - he's probably going to 'get it' where I don't..

Thank you so much for working so hard on this! I sure hope this works!

Tammy

[DryDiapersPlus]

Ok I got this figured out I think

Ok - I thought I got it - but I don't...

So - I need to set up a free shipping rule first. I want everything (except the case of briefs) included in the order in progress, right? So, the rule I set up is:

Details: Free shipping over $175
Rule: 1 - Order in Progress
Apply When: Grand Total is greater than or equal to $175.00

Rule 2 - Order in progress
Apply When: Product Quantity is greater than or equal to: 0
should I put 0 in there - so it never counts any of the cases of briefs?

I don't need to apply to provinces or states - so rule 3 doesn't matter to me.

I don't understand Rule #4


So then on the flip side, since I want to charge $12.99 flat shipping (the opposite above) then I would just change the rule to charge flat rate of $12.99 for all the same rules above?

Hoping you understand me

[DryDiapersPlus]

PS - these things won't let me edit I didn't see a 'rule 1' - and that really confused me... did I miss something?

[dave01978]

Ok - I thought I got it - but I don't...

So - I need to set up a free shipping rule first. I want everything (except the case of briefs) included in the order in progress, right? So, the rule I set up is:

Details: Free shipping over $175
Rule: 1 - Order in Progress
Apply When: Grand Total is greater than or equal to $175.00

Rule 2 - Order in progress
Apply When: Product Quantity is greater than or equal to: 0

You would want this to say equal to 0, so that it wont count them in, then add in a different rule with 175+case and case=1 and keep going

should I put 0 in there - so it never counts any of the cases of briefs?

I don't need to apply to provinces or states - so rule 3 doesn't matter to me.

I don't understand Rule #4

What rule #4 does is checks if there is a case, and the quantity (based on how many rules you need to set up, you need to basically mirror the 1 rule for 0 cases @175
1 case $175+$cost of case
2 cases $175 + $cost of case+ $cost of case
I hope this clears it up a bit for you

So then on the flip side, since I want to charge $12.99 flat shipping (the opposite above) then I would just change the rule to charge flat rate of $12.99 for all the same rules above?

Do you already have the $12.99 shipping rate set up? If so no need to change it.[/quote]

Hoping you understand me [/QUOTE]

[dave01978]

PS - these things won't let me edit I didn't see a 'rule 1' - and that really confused me... did I miss something?

I edit my rules depending on what i need at the time, so i used that as a base as I had a bunch of info pre loaded the rule #'s dont matter as long as you have the total for free + the check for the case.
Dave

[DryDiapersPlus]

I know you said that if I had a flat rate shipping rule already - that I didn't need to make one - for this case. However, that was the problem was that people weren't getting charged shipping when they needed to.

So - I've gone ahead and made the same rule - just sort of reversed it - so that anything under $175 gets charged $12.99 - except I put in the rule with the option of the product quantity of the case of briefs of equal to or great than 0 - so hopefully - this will work - that if someone orders a case (which is set under the product description to free shipping) - then they won't get charged shipping on the case - but anything else in the same order - will get charged the $12.99.

Does that sound right? (hopelessly confused...)

[DryDiapersPlus]

Here's a screen shot of the two rules http://i43.photobucket.com/albums/e3...ay50/rules.png