Need help with somewhat complicated shipping setup

Okay, here's the deal. I currently carry three brands, all of which drop-ship for me.

http://www.phoenixtuning.com/zenstore/

Digital Dash, Gauges, Converters, are drop-shipped using UPS for national orders only, international orders are sent to me and then I have to reship them using USPS. I offer free shipping over $200 in the US. So:

If the order is under $200 and it's national, then I need to use a UPS calculator.
If the order is over $200 and it's national, it will be free shipping
If the order is international, I need to use the USPS calculator (regardless of the order total)

Is there a way to do this?

Then, for ECU Jumper Patch Harnesses, these are drop-shipped using Fedex, and again orders over $200 are free shipping. So:

If the order is under $200 and it's national, then I need to use a Fedex calculator
If the order is over $200 and it's national, it will be free shipping
If the order is international, then I need to use a Fedex calculator regardless of the order total

Again, is there a way to set this category up this way?

Any help would be very much appreciated!

-Doc

Anyone have any ideas? I really need help with this, especially this one:

Digital Dash, Gauges, Converters, are drop-shipped using UPS for national orders only, international orders are sent to me and then I have to reship them using USPS. I offer free shipping over $200 in the US. So:

If the order is under $200 and it's national, then I need to use a UPS calculator.
If the order is over $200 and it's national, it will be free shipping
If the order is international, I need to use the USPS calculator (regardless of the order total)

Any help would be great, I'm like :frusty: trying to figure this out :cool:

... and what happens if I order 1 thing from group A and 1 from group B?

Let me see...

If you order something from more than one group AND it's a national order AND it's under $200, OR it's an international order, then shipping will need to be calculated SEPARATELY for each group.

Example 1: (international order)

One clutch kit for $279

Shipping: x amount

One PDR-1 trunk actuator $35

Shipping: x amount

One Celica ECU patch harness $135

Shipping: x amount

Example 2: (domestic order over $200)

One clutch kit for $279

One PDR-1 trunk actuator $35

One Celica ECU patch harness $135

Shipping: Free

Example 3: (domestic order under $200)

One PDR-1 trunk actuator $35

Shipping: x amount

One Celica ECU patch harness $135

Shipping: x amount

The good thing is that with all three groups, international shipping is done with USPS. But, each group is coming from a different place so each one would have to be calculated separately. I'm open to different ideas on how to approach the whole problem, this is the simplest thing I've come up with so far but if someone has a suggestion on a different way to go about it, I'm all ears.

-Doc

Is there a way to do this or is it just impossible? Do I need to figure out a different way to go about it?

I'm willing to pay for assistance if someone knows how to get this set up.

-Doc

URL edited
Suggest contacting author of advanced shipping mod,
url above, to see if his creation produces your requirements.

Thanks for the link, I've emailed him but no response yet.

Again, I'm willing to pay for this if there's a programmer out there who can do it.

:lamo:

-Doc

This is the last piece of the puzzle, once I get this taken care of I can launch my store! :cry:

PM sent
:smile:

Hi Doc,

How are you?

Dr Tweak:

I've emailed him but no response yet.

My apologies, I was away on holiday. Nice to come back to some sunny weather I have to say, although it's much harder to be in front of the screen when it's so sunny outside!

Anyway... :)

Just thought I'd say hello, now that I'm back. :)

All the best...

Conor

I was away on holiday
Guessed you were conor, hence my pm to Dr Tweak.
Hope you had great time.
:smile:

I sent this message to Conor by email but I'm going to post it up here as well in case someone out there has a suggestion for what to do here.

Okay, let me start from the top because I'm afraid that I have overcomplicated things. I'll explain my needs as simply as possible and then if anyone can just look at that and give me some suggestions that would be great.

My store (not currently linked-to) is located at http://www.phoenixtuning.com/zenstore/ (go ahead and take a look)

I have three primary products that I sell. The first is clutches and flywheels. These items are drop-shipped by the manufacturer. If the
customer is in the US, they ship by UPS and charge about $12. If the customer is international, they ship by USPS and charge anywhere from
$35 to $75 depending on how fast and where it's going. I may or may not offer my customers free shipping the US only on these products.

The second is Digital Dash, Gauges, Converters. This manufacturer drop-ships domestic orders ONLY by UPS. They charge me $9 to $20. They
will not ship international for me so what happens when an international customer makes an order is, the manufacturer ships the
items to me by UPS, then I re-ship them using USPS, which costs anywhere from $30 to $80 depending on how fast and where it's going. I
may or may not offer free shipping to my customers in the US only on orders over $200 of Dakota Digital items.

The third is ECU Jumper Patch harnesses. This manufacturer drop-ships in the US using Fedex, and they charge me $9. They also drop-ship
internationally using USPS, which again the costs vary. I would prefer not to offer free shipping on these products since the profit margin
is very small.

Besides the obvious complications already presented, the problem is further compounded if a customer buys items from different categories.
For example, if they bought a digital gauge that is $89 and also bought a jumper harness that is $135, I will be charged twice (from
two different manufacturers) for shipping, so I also would need to charge the customer shipping for each item, whereas the standard
shipping module seems to automatically combine shipping.

I'm trying to figure out a method of charging shipping that is fair, doesn't cause me to lose money, and is simple. Help! :)