Multiple Shipping > two with special options

Permalink Browser Info Environment
Hey people!

I'm trying to do two things here and I'm just not getting the settings right and I'm banging my head against a wall.

I want to define 3 zones really
- Spokane, WA area
- Coeur d'Alene Area
- Everywhere else in the US.

The Spokane and Coeur d'Alene have two options:
- Hand Delivery
- Ship in the mail

The rest of the US gets only one option:
-Ship in the mail.

The attached settings work...but only for the Spokane area. Bah! Why can't I get it to see Coeur d'Alene or the default?

Thanks!
Amanda

2 Attachments

Type: Discussion
Status: Archived
rainmaker
View Replies: View Best Answer
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
Your cost rules table looks OK.

The issue stems from some confusion in the Zones, Address to Zone and Delivery Options tabs. Also, bear in mind that the match for zones will always keep the first country matched, then immediately beneath that the last state/province, zip etc (there are only 2 levels of match). So your existing rules will always match the first USA and will never get as far as the second USA.

Zones:
Other USA
Spokane
CDA
Rest of World

Delivery Options:
Delivery
Direct Ship

Address to Zone Map:
Country contains United States => Other USA
Town/City equals Spokane => Spokane
Town/City contains Coeur d'Alene|Coeur dAlene|cda|Hayden => CDA
Country default Default => Rest of World

You may also want to list Spokane zip codes and Coeur d'Alene zip codes as lines beneath each town/city, as a backup to catch those who mis-spell their town/city.

Address to Zone Map:
Country contains United States => Other USA
Town/City equals Spokane => Spokane
Zip Code in range XXXXX-YYYYY|XXXXX-YYYYY => Spokane
Town/City contains Coeur d'Alene|Coeur dAlene|cda|Hayden => CDA
ZipCode in range NNNNN-MMMMM|NNNNN-MMMMM => CDA
Country default Default => Rest of World

If there is another Spokane, Coeur d'Alene, Hayden etch in other states, then you could map them back again:

Address to Zone Map:
Country contains United States => Other USA
Town/City equals Spokane => Spokane
Zip Code in range XXXXX-YYYYY|XXXXX-YYYYY => spokane
Town/City contains Coeur d'Alene|Coeur dAlene|cda|Hayden => CDA
ZipCode in range NNNNN-MMMMM|NNNNN-MMMMM => CDA
State/Province not contain Washington|Idaho => Other USA
Country default Default => Rest of World

Finally, because Coeur d'Alene looks like it is a prime candidate for mis-spelling, you may want to add a regular expression match to generalise it a bit further. However, bear in mind that a loose regular expression could create false matches.

Address to Zone Map:
Country contains United States => Other USA
Town/City equals Spokane => Spokane
Zip Code in range XXXXX-YYYYY|XXXXX-YYYYY => spokane
Town/City contains Coeur d'Alene|Coeur dAlene|cda|Hayden => CDA
Town/City regex ^Coeur.*Alene$ => CDA
ZipCode in range NNNNN-MMMMM|NNNNN-MMMMM => CDA
State/Province not contain Washington|Idaho => Other USA
Country default Default => Rest of World

The regex means anything that starts 'Coeur' and ends 'Alene' with anything else in the middle.

Or even:
Address to Zone Map:
Country contains United States => Other USA
Town/City equals Spokane => Spokane
Zip Code in range XXXXX-YYYYY|XXXXX-YYYYY => spokane
Town/City contains Coeur d'Alene|Coeur dAlene|cda|Hayden => CDA
Town/City regex ^C.*Alene$ => CDA
ZipCode in range NNNNN-MMMMM|NNNNN-MMMMM => CDA
State/Province not contain Washington|Idaho => Other USA
Country default Default => Rest of World

Which of the above you use depends on where the emphasis of your requirements is and you will probably need to play with these to match the requirement details (because I don't know the details or your geography).
rainmaker replied on at Permalink Reply 1 Attachment
rainmaker
Hey Johnthefish!

Dang! That was some explanation! Thanks so much for helping out with that. I think I really over thought my zones. @_@

The final was the one I wrapped up with. I didn't do one of the lines you asked for that had the state not equal to Idaho and WA because of Seattle and other cities. :) And this isn't for the international orders. She wants them to call for that.

You have saved me yet again! Hope you had a great holiday weekend (if you celebrate it)!
Thanks!

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.