[SOLVED]How to calculate shipping rates?

[nuclearholocausto]

Hello all! I need to set up properly the following. Here's the scenario:

All items @ $15 ea and weighs 1 lb each.
Shipping starts @ $5 for the first item.
Each additional item, add $3.
Orders more than $100, gets Free Shipping.

Any help would be greatly appreciated!

[web.geek]

Not sure what version of PS you are using, but I believe both 1.3x and 1.4x have shipping rates by price and weight ranges.

If everything in the shop costs $15 each and always weighs 1 lb. each, you could set up a shipper by weight range or by price range. For instance the setup by price would be something like $0-16 = $5, $16-31 = $8, $31-46 = $11, $46-61 = $14, $61-76 = $17, $76-100 = $20 (the last range would be 76-90, but since you are using $15 increments, anything after $90 is going to be over $100 and get free shipping).

Make sense? For weight you would do something similar: 0-2 lb = $5, 2-3 = $8, 3-4 = $11, 4-5 = $14, 5-6 = $17, 6-7 = $20.

[nuclearholocausto]

That's basically the same logic i have in my BO. With the exception of the weight ranges since it may not pick it up if you had it setup like yours. I have it as 0.01-2lbs = 5, 2.01-3lbs = 8, 3.01-4lbs = 11, 4.01-5lbs = 14, 5.01-6lbs = 17, 6.01-7lbs = 20. Anything more than 7lbs should be free shipping since the price would be at 105. After setting it up like this the first item added to the cart seems to work just fine but after adding another item for some reason it gives a $20 shipping. Meaning it's not picking up the condition correctly. Any other suggestions?

[web.geek]

It sounds like a couple of possibilities. It could be calculating that the weight is greater than 7 lbs already and using the highest shipping fee by default. That would also mean that your free shipping after X lbs logic probably isn't working. Or it could be that the weight of the second item is somehow set to 5 lbs. Outside of that, I'm not sure. Are you using any shipping modules? The UPS module has some well known issues in bug tracker, although this doesn't sound like any of those.

I've been using 1.4x weight ranges for a couple of months now, and I haven't run into this problem before.

[nuclearholocausto]

Thank you for the replies web.geek! After changing the weight ranges from decimal to whole numbers it finally worked. BTW, I've tried this with 1.3.x and 1.4.x both seems to work. My next stop is getting the USPS module to work.

[GoldenMoney]

My shipping rate based on price and formula and it is very simple x 0.127

Is there formula "window" in Prestashop where I can simply place the above formula or I have to manually configure increase of each $50 in ranges from 0 to 100,000?