I have a product that has some unique shipping requirements that requires different rates to different locations.
Product A can be shipped anywhere to the state of MA. However, if it is being delivered to a certain set of zip codes (the city of Boston) it must be charged a different rate. Several other states have similar situations.
I have a shipping zone setup called "Contiguous US" that contains simply all 48 continental US states and no zip codes specified. I created another Zone called "Boston Surcharge" and added the specific zip codes to it. I then created 2 separate shipping options "delivery" and "delivery with boston surcharge". If I use one of the zip codes contained in the Boston Zone, I am not getting the correct delivery option, it looks as if it is being overridden by the "Contiguous US" zone.
Ideas?
Shipping Zones/Zip Code Exclusion
Re: Shipping Zones/Zip Code Exclusion
Looking at the database itself in the table dbo.ac_ShipZones, there looks to be a field limit of 255. I'm going to have much more than 255 characters to enter because it isn't going to be nice and neat to allow the use of wildcards with this particular set of zipcodes.
Am I just going to have to create a bunch of different zones like Boston1 and Boston2 until I hit the 255 limit on each one?
Am I just going to have to create a bunch of different zones like Boston1 and Boston2 until I hit the 255 limit on each one?