Need a complex shipping module.

[ebolt007]

So, I have a client, with a store and he needs a complex shipping module, basically he needs the following criteria for shipping and this is on a per product basis.
if a product is more than $199 but less than 70lbs it's free, and if a product is over $1200 and more than 70lbs it's free, all other products have UPS rate shipping applied. And if it's going to Alaska or Hawaii then there is no free shipping.

So if someone adds 2 products to their cart, and
Product A = $250 and 50lbs (FREE)
Product B = $100 and 50LBS (Shipping)

You would only have shipping costs assigned to the 2nd (Product B) when they check out.

Can anyone please help me? I can't find a module that's similar to this anywhere.

[CobraPlant]

Use CEON Advanced Shipper module. It has the level of flexibility that you need. It's a paid module, but well worth it if you have various shipping calculations. You can set your shipping rates by regions, product, categories, weight, price, and number of items in any of these combinations.
http://dev.ceon.net/web/zen-cart/advanced-shipper

[picandnix]

I second that Cobraplant, I use that mod too, it's well worth the small price for such flexibility.

[ebolt007]

Here's my problem tho, all of the product is pulled in dynamically through an ftp and he has a ton of product, can you settup group type things with the CEON module so it knows to calculate certain weight and amount of products? I can't find anything like this, it seems like you have to select each product one at a time.

[CobraPlant]

Yes, you can set up your shipping calculations (weight, number of items, total sale price) by categories, subcategories and specific products. I have several shipping calculations. I sell DVDs which I ship via First Class Mail. If someone purchases just DVDs, the shipping module calculates a flat rate shipping for First Class Mail. If they order something else along with DVDs, the shipping is based on weight and sent Priority Mail. I also have a specific product that is sent only by Parcel Post. You can always visit the CEON website and ask Conor if his module will fit your needs. If anything, he may even assist you in modifying it to make it fit your needs Frankly, this module is the closest to doing what you want done.

[ebolt007]

Cool thanks, yeah I'll check with him and read a lot more documentation and I think I'm close, so I added a method for it doing the below, which does this in all regions except Alaska and Hawaii, and checks that the price is over $199 and the weight is under 70lbs, which works and gives free shipping, but does this for the overall order, I need it on a per product basis, anyone know how to do this? I've tried putting this whole thing inside <numitems>*:</numitems> as well, but doesn't work. Ideas?

Countries/Postcodes: 	

US:!AKHI, US
Table of Rates: 	

<price>199-*: <weight>0-70: 0.00</weight></price>