0

I have seen a few other posting on a similar topic but none solve my particular problem.

I am using Table Rates for Shipping and adding a different Shipping rate for certain regions of the UK using postcode wildcards:

Country,Region/State,Zip/Postal Code,Order Subtotal (and above),Shipping Price
GB,,,0,4.99
GB,,,40,0
GB,,BT%,0,12.99
GB,,BT%,40,7.99
GB,,IM%,0,10.99
GB,,IM%,40,15.99
GB,,GY%,0,10.99
GB,,GY%,40,15.99
GB,,JE%,0,10.99
GB,,JE%,40,15.99

I have also used this format:

Country,Region/State,Zip/Postal Code,Order Subtotal (and above),Shipping Price
GB,*,*,0,4.99
GB,*,*,40,0
GB,*,BT%,0,12.99
GB,*,BT%,40,7.99
GB,*,IM%,0,10.99
GB,*,IM%,40,15.99
GB,*,GY%,0,10.99
GB,*,GY%,40,15.99
GB,*,JE%,0,10.99
GB,*,JE%,40,15.99

...but only the first two rows are ever used - theBT, IM, BY and JE postcodes are ignored.

I have create a Table using only IM% to check whether the first two lines overwrite the rest but I get a message "no shipping rates available".

Am I using the correct format to isolate the postcodes?

Update: I've tried a couple of other suggestions without luck - adding the wildcard at the end and removing the wildcard character from the partial postcode.

Country,Region/State,Zip/Postal Code,Order Subtotal (and above),Shipping Price
GB,,BT,0,12.99
GB,,BT,40,7.99
GB,,IM,0,10.99
GB,,IM,40,15.99
GB,,GY,0,10.99
GB,,GY,40,15.99
GB,,JE,0,10.99
GB,,JE,40,15.99
GB,,,0,4.99
GB,,,40,0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.