How to set up geo-based shipping rules???

[Brainwrek]

I've tried just about everything I can think of, but can't get this to work..

I need 3 shipping rules:

USA - $0.00
Canada - $3.00
Int'l - $8.00


I thought that the following would work, but it doesn't:

Rule 1:
Apply when: Country is...
Operator: Equal to
Value: United States
Shipping cost: $0.00
Apply to shipping type: First Class (<--I created this)
Apply to shipping method: Mail (<--I created this)
Priority: 1

Rule 2:
Apply when: Country is...
Operator: Equal to
Value: Canada
Shipping cost: $3.00
Apply to shipping type: First Class
Apply to shipping method: Mail
Priority: 2

Rule 3:
Apply when: Country is...
Operator: Not equal to
Value: United States
Shipping cost: $8.00
Apply to shipping type: First Class
Apply to shipping method: Mail
Priority: 3

Rule 4:
Apply when: Country is...
Operator: Not equal to
Value: Canada
Shipping cost: $8.00
Apply to shipping type: First Class
Apply to shipping method: Mail
Priority: 3

[Brainwrek]

The only way I can think to make it work would be to go though every single country and set it to $8.00...which would take forever! Any shortcuts? Upload an excel file maybe?

[Brainwrek]

Nevermind... I uploaded an excel file into PhpMyAdmin and it all works just fine. Sure took a lot less time than doing it through the cart admin. :yahoo:

[Jamie]

Nice approach! Although there should be an easier way, there is not (yet!).

Thanks,
Jamie