Different shipping rates based on zone?

Excellent stuff...

Please bear in mind that when you add countries like this, and give them a "made-up" ISO code as we have done:

Country Name: Channel Islands
ISO 2-Digit: CS
ISO 3-Digit: CSL

This is NOT an official ISO country code.

Right now, the ISO has not assigned Country Codes to "Channel Islands".

(However, there are reserved codes for the individual islands.)

Why is this important?

If you plan to use zc-linked shipping services (by uploading dedicated modules) for services like USPS or FedEx, then these services are likely to use ISO codes to identify destination addresses. As there is no official ISO zone called CS or CSL, these third-party systems may not recognise the delivery address.

Go HERE for more info.

I know I am joining this post rather belatedly but I love this mod and am busy integrating it in my UK only website. I would like to take things a little further:

For UK Mainland 'regions' I charge £A

For Offshore UK 'regions' I charge £B

Ok so far so good with this mod. However I need to be able to ship free over £40 for UK Mainland (easy enough) BUT not offer free shipping to Offshore UK. Am I missing something simple here or does any clever person know how I do this. Is this another 'cloning' excercise or is it something much more difficult?

Any assistance would be very welcome.

Many thanks

Rob

I'm wanting to do a simular thing to my site, but I don't want to have to add all the zones for all international shipping - I wouldn't even know every country to add - I'm pretty much willing to ship to all countries that allow me to ship my products to.

I'm using a table rate for US shipping right now, but want to also use a table rate for international shipping too. I don't want to use weight for either. Is there a simpler way to do this?

Can't there be some kind of check box at checkout for them to either choose US or International shipping and which ever they choose that is the table rate that checkout calculates? I also am wondering if the USPS module lets you do something like that or do they only go by weight and zone set ups too?

I am really interested in fairestcape's original post. I have installed the new zones and got the shipping to work based on the zones also. My only issue is with paypal now, because of is doesn't recognise the new countries. I get an error before actually being transferred to paypal (not express checkout, this is for a test user that already exists in my test store and I do not use website payments pro):

"10725 Shipping Address Country Error - There was an error in the Shipping Address Country field"

I wonder if anybody else has encountered these issues and what action could be taken to have these shipping zones but still have the ability to checkout with paypal?

not sure if people are still reading this, i hope they are

im currently trying to install this setup on a test system to see how its working etc...

but when i goto run the SQL script in php or zencart, i just get errors
in zencart sql

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS zones_to_geo_zones' at line 1
in:
[INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (495, 252, 'Isles of Scilly', 'Isles of Scilly'), (494, 253, 'Isle of Wight', 'Isle of Wight'), (327, 241, 'Antrim', 'Antrim'), (328, 241, 'Armagh', 'Armagh'), (329, 241, 'Derry', 'Derry'), (330, 241, 'Down', 'Down'), (331, 241, 'Fermanagh', 'Fermanagh'), (332, 241, 'Londonderry', 'Londonderry'), (333, 241, 'Tyrone', 'Tyrone'), (334, 242, 'Aberdeenshire', 'Aberdeenshire'), (335, 242, 'Angus', 'Angus'), (336, 242, 'Argyll', 'Argyll'), (337, 242, 'Ayrshire', 'Ayrshire'), (338, 242, 'Banffshire', 'Banffshire'), (339, 242, 'Berwickshire', 'Berwickshire'), (340, 242, 'Borders', 'Borders'), (341, 251, 'Bute (islands of Arran and Bute)', 'Bute (islands of Arran and Bute)'), (342, 242, 'Caithness', 'Caithness'), (343, 242, 'Central', 'Central'), (344, 242, 'Clackmannanshire', 'Clackmannanshire'), (345, 242, 'Dumfriesshire', 'Dumfriesshire'), (346, 242, 'Dumfries and Galloway', 'Dumfries and Galloway'), (347, 242, 'Dunbartonshire', 'Dunbartonshire'), (348, 242, 'East Lothian', 'East Lothian'), (349, 242, 'Edinburgh', 'Edinburgh'), (350, 242, 'Elgin', 'Elgin'), (351, 242, 'Fife', 'Fife'), (352, 242, 'Forfarshire (see Angus)', 'Forfarshire (see Angus)'), (353, 242, 'Grampian', 'Grampian'), (354, 242, 'Haddington', 'Haddington'), (355, 250, 'Highland', 'Highland'), (356, 250, 'Inverness-shire', 'Inverness-shire'), (357, 242, 'Kincardineshire', 'Kincardineshire'), (358, 242, 'Kinross-shire', 'Kinross-shire'), (359, 242, 'Kirkcudbrightshire', 'Kirkcudbrightshire'), (360, 242, 'Lanarkshire', 'Lanarkshire'), (361, 242, 'Linlithgow', 'Linlithgow'), (362, 242, 'Lotian', 'Lotian'), (363, 242, 'Midlothian', 'Midlothian'), (364, 242, 'Moray', 'Moray'), (365, 242, 'Nairnshire', 'Nairnshire'), (366, 251, 'Orkney', 'Orkney'), (367, 242, 'Peeblesshire', 'Peeblesshire'), (368, 242, 'Pembrokeshire', 'Pembrokeshire'), (369, 242, 'Perth', 'Perth'), (370, 242, 'Perthshire', 'Perthshire'), (371, 242, 'Renfrewshire', 'Renfrewshire'), (372, 242, 'Ross & Cromarty (inc part of Lew', 'Ross & Cromarty (inc part of Lew'), (373, 242, 'Roxburghshire', 'Roxburghshire'), (374, 242, 'Selkirkshire', 'Selkirkshire'), (375, 251, 'Shetland', 'Shetland'), (376, 242, 'Stirlingshire', 'Stirlingshire'), (377, 242, 'Sutherland', 'Sutherland'), (378, 242, 'Tayside', 'Tayside'), (379, 242, 'West Lothian', 'West Lothian'), (496, 251, 'Hebrides', 'Hebrides'), (381, 242, 'Wigtownshire', 'Wigtownshire'), (382, 242, 'Zetland', 'Zetland'), (383, 243, 'Merthyr Tydfil ', 'Merthyr Tydfil '), (384, 243, 'Caerphilly ', 'Caerphilly '), (385, 243, 'Blaenau Gwent', 'Blaenau Gwent'), (386, 243, 'Torfaen', 'Torfaen'), (387, 243, 'Monmouthshire', 'Monmouthshire'), (388, 243, 'Newport', 'Newport'), (389, 243, 'Cardiff', 'Cardiff'), (390, 243, 'Vale of Glamorgan', 'Vale of Glamorgan'), (391, 243, 'Bridgend', 'Bridgend'), (392, 243, 'Rhondda Cynon Taf', 'Rhondda Cynon Taf'), (393, 243, 'Neath Port Talbot', 'Neath Port Talbot'), (394, 243, 'Swansea', 'Swansea'), (395, 243, 'Carmarthenshire', 'Carmarthenshire'), (396, 243, 'Ceredigion', 'Ceredigion'), (397, 243, 'Powys', 'Powys'), (398, 243, 'Wrexham', 'Wrexham'), (399, 243, 'Flintshire', 'Flintshire'), (400, 243, 'Denbighshire', 'Denbighshire'), (401, 243, 'Conwy', 'Conwy'), (402, 243, 'Gwynedd', 'Gwynedd'), (403, 243, 'Anglesey (Ynys Môn)', 'Anglesey (Ynys Môn)'), (404, 243, 'Pembrokeshire', 'Pembrokeshire'), (405, 243, 'Clwyd', 'Clwyd'), (406, 244, 'Avon', 'Avon'), (407, 244, 'Bedfordshire', 'Bedfordshire'), (408, 244, 'Berkshire', 'Berkshire'), (409, 244, 'Bristol', 'Bristol'), (410, 244, 'Buckinghamshire', 'Buckinghamshire'), (411, 244, 'Cambridgeshire', 'Cambridgeshire'), (412, 244, 'Cheshire', 'Cheshire'), (413, 244, 'Cleveland', 'Cleveland'), (414, 244, 'Cornwall', 'Cornwall'), (415, 244, 'Cumberland', 'Cumberland'), (416, 244, 'Cumbria', 'Cumbria'), (417, 244, 'Derbyshire', 'Derbyshire'), (418, 244, 'Devon', 'Devon'), (419, 244, 'Dorset', 'Dorset'), (420, 244, 'Durham', 'Durham'), (421, 244, 'Essex', 'Essex'), (422, 244, 'East Sussex', 'East Sussex'), (423, 244, 'East Yorkshire', 'East Yorkshire'), (424, 244, 'Gloucestershire', 'Gloucestershire'), (425, 244, 'Greater Manchester', 'Greater Manchester'), (426, 244, 'Hampshire', 'Hampshire'), (427, 244, 'Herefordshire', 'Herefordshire'), (428, 244, 'Hertfordshire', 'Hertfordshire'), (429, 244, 'Humberside', 'Humberside'), (430, 244, 'Huntingdonshire', 'Huntingdonshire'), (432, 244, 'Kent', 'Kent'), (433, 244, 'Lancashire', 'Lancashire'), (434, 244, 'Leicestershire', 'Leicestershire'), (435, 244, 'Lincolnshire', 'Lincolnshire'), (436, 244, 'London', 'London'), (437, 244, 'Middlesex', 'Middlesex'), (438, 244, 'Merseyside', 'Merseyside'), (439, 244, 'Norfolk', 'Norfolk'), (440, 244, 'Northamptonshire', 'Northamptonshire'), (441, 244, 'Northumberland', 'Northumberland'), (442, 244, 'North Yorkshire', 'North Yorkshire'), (443, 244, 'Nottinghamshire', 'Nottinghamshire'), (444, 244, 'Oxfordshire', 'Oxfordshire'), (445, 244, 'Rutland', 'Rutland'), (446, 244, 'Shropshire', 'Shropshire'), (447, 244, 'Somerset', 'Somerset'), (448, 244, 'South Yorkshire', 'South Yorkshire'), (449, 244, 'Staffordshire', 'Staffordshire'), (450, 244, 'Suffolk', 'Suffolk'), (451, 244, 'Surrey', 'Surrey'), (452, 244, 'Sussex', 'Sussex'), (453, 244, 'Tyne and Wear', 'Tyne and Wear'), (454, 244, 'Warwickshire', 'Warwickshire'), (455, 244, 'Westmorland', 'Westmorland'), (456, 244, 'West Midlands', 'West Midlands'), (457, 244, 'West Sussex', 'West Sussex'), (458, 244, 'West Yorkshire', 'West Yorkshire'), (459, 244, 'Wiltshire', 'Wiltshire'), (460, 244, 'Worcestershire', 'Worcestershire'), (461, 244, 'Yorkshire', 'Yorkshire'), (462, 246, 'Jersey', 'Jersey'), (463, 246, 'Guernsey', 'Guernsey'), (464, 246, 'Alderney', 'Alderney'), (465, 246, 'Sark', 'Sark'), (466, 246, 'Herm', 'Herm'), (467, 245, 'Isle of Man', 'Isle of Man'), DROP TABLE IF EXISTS zones_to_geo_zones;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

and in PHPMYADMIN

SQL query:

-- -- Dumping data for table `zones` -- INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (495, 252, 'Isles of Scilly', 'Isles of Scilly'), (494, 253, 'Isle of Wight', 'Isle of Wight'), (327, 241, 'Antrim', 'Antrim'), (328, 241, 'Armagh', 'Armagh'), (329, 241, 'Derry', 'Derry'), (330, 241, 'Down', 'Down'), (331, 241, 'Fermanagh', 'Fermanagh'), (332, 241, 'Londonderry', 'Londonderry'), (333, 241, 'Tyrone', 'Tyrone'), (334, 242, 'Aberdeenshire', 'Aberdeenshire'), (335, 242, 'Angus', 'Angus'), (336, 242, 'Argyll', 'Argyll'), (337, 242, 'Ayrshire', 'Ayrshire'), (338, 242, 'Banffshire', 'Banffshire'), (339, 242, 'Berwickshire', 'Berwickshire'), (340, 242, 'Borders', 'Borders'), (341, 251, 'Bute (islands of Arran and Bute)', 'Bute (islands of Arran and Bute)'), (342, 242, 'Caithness', 'Caithness'), (343, 242, 'Central', 'Central'), (344, 242, 'Clackmannanshire', 'Clackmannanshire'), (345, 242, 'Dumfriesshire', 'Dumfriesshire'), [...]

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `zones_to_geo_zones`' at line 153 

hopefully somebody can shed some light on this as iv looked at line 153 and it seems fine :S....

line153 dont even link to "zones_to_geo_zones"...

help??

spid3r1987:

not sure if people are still reading this, i hope they are

im currently trying to install this setup on a test system to see how its working etc...

but when i goto run the SQL script in php or zencart, i just get errors
in zencart sql

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS zones_to_geo_zones' at line 1
in:
[INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (495, 252, 'Isles of Scilly', 'Isles of Scilly'), (494, 253, 'Isle of Wight', 'Isle of Wight'), (327, 241, 'Antrim', 'Antrim'), (328, 241, 'Armagh', 'Armagh'), (329, 241, 'Derry', 'Derry'), (330, 241, 'Down', 'Down'), (331, 241, 'Fermanagh', 'Fermanagh'), (332, 241, 'Londonderry', 'Londonderry'), (333, 241, 'Tyrone', 'Tyrone'), (334, 242, 'Aberdeenshire', 'Aberdeenshire'), (335, 242, 'Angus', 'Angus'), (336, 242, 'Argyll', 'Argyll'), (337, 242, 'Ayrshire', 'Ayrshire'), (338, 242, 'Banffshire', 'Banffshire'), (339, 242, 'Berwickshire', 'Berwickshire'), (340, 242, 'Borders', 'Borders'), (341, 251, 'Bute (islands of Arran and Bute)', 'Bute (islands of Arran and Bute)'), (342, 242, 'Caithness', 'Caithness'), (343, 242, 'Central', 'Central'), (344, 242, 'Clackmannanshire', 'Clackmannanshire'), (345, 242, 'Dumfriesshire', 'Dumfriesshire'), (346, 242, 'Dumfries and Galloway', 'Dumfries and Galloway'), (347, 242, 'Dunbartonshire', 'Dunbartonshire'), (348, 242, 'East Lothian', 'East Lothian'), (349, 242, 'Edinburgh', 'Edinburgh'), (350, 242, 'Elgin', 'Elgin'), (351, 242, 'Fife', 'Fife'), (352, 242, 'Forfarshire (see Angus)', 'Forfarshire (see Angus)'), (353, 242, 'Grampian', 'Grampian'), (354, 242, 'Haddington', 'Haddington'), (355, 250, 'Highland', 'Highland'), (356, 250, 'Inverness-shire', 'Inverness-shire'), (357, 242, 'Kincardineshire', 'Kincardineshire'), (358, 242, 'Kinross-shire', 'Kinross-shire'), (359, 242, 'Kirkcudbrightshire', 'Kirkcudbrightshire'), (360, 242, 'Lanarkshire', 'Lanarkshire'), (361, 242, 'Linlithgow', 'Linlithgow'), (362, 242, 'Lotian', 'Lotian'), (363, 242, 'Midlothian', 'Midlothian'), (364, 242, 'Moray', 'Moray'), (365, 242, 'Nairnshire', 'Nairnshire'), (366, 251, 'Orkney', 'Orkney'), (367, 242, 'Peeblesshire', 'Peeblesshire'), (368, 242, 'Pembrokeshire', 'Pembrokeshire'), (369, 242, 'Perth', 'Perth'), (370, 242, 'Perthshire', 'Perthshire'), (371, 242, 'Renfrewshire', 'Renfrewshire'), (372, 242, 'Ross & Cromarty (inc part of Lew', 'Ross & Cromarty (inc part of Lew'), (373, 242, 'Roxburghshire', 'Roxburghshire'), (374, 242, 'Selkirkshire', 'Selkirkshire'), (375, 251, 'Shetland', 'Shetland'), (376, 242, 'Stirlingshire', 'Stirlingshire'), (377, 242, 'Sutherland', 'Sutherland'), (378, 242, 'Tayside', 'Tayside'), (379, 242, 'West Lothian', 'West Lothian'), (496, 251, 'Hebrides', 'Hebrides'), (381, 242, 'Wigtownshire', 'Wigtownshire'), (382, 242, 'Zetland', 'Zetland'), (383, 243, 'Merthyr Tydfil ', 'Merthyr Tydfil '), (384, 243, 'Caerphilly ', 'Caerphilly '), (385, 243, 'Blaenau Gwent', 'Blaenau Gwent'), (386, 243, 'Torfaen', 'Torfaen'), (387, 243, 'Monmouthshire', 'Monmouthshire'), (388, 243, 'Newport', 'Newport'), (389, 243, 'Cardiff', 'Cardiff'), (390, 243, 'Vale of Glamorgan', 'Vale of Glamorgan'), (391, 243, 'Bridgend', 'Bridgend'), (392, 243, 'Rhondda Cynon Taf', 'Rhondda Cynon Taf'), (393, 243, 'Neath Port Talbot', 'Neath Port Talbot'), (394, 243, 'Swansea', 'Swansea'), (395, 243, 'Carmarthenshire', 'Carmarthenshire'), (396, 243, 'Ceredigion', 'Ceredigion'), (397, 243, 'Powys', 'Powys'), (398, 243, 'Wrexham', 'Wrexham'), (399, 243, 'Flintshire', 'Flintshire'), (400, 243, 'Denbighshire', 'Denbighshire'), (401, 243, 'Conwy', 'Conwy'), (402, 243, 'Gwynedd', 'Gwynedd'), (403, 243, 'Anglesey (Ynys Môn)', 'Anglesey (Ynys Môn)'), (404, 243, 'Pembrokeshire', 'Pembrokeshire'), (405, 243, 'Clwyd', 'Clwyd'), (406, 244, 'Avon', 'Avon'), (407, 244, 'Bedfordshire', 'Bedfordshire'), (408, 244, 'Berkshire', 'Berkshire'), (409, 244, 'Bristol', 'Bristol'), (410, 244, 'Buckinghamshire', 'Buckinghamshire'), (411, 244, 'Cambridgeshire', 'Cambridgeshire'), (412, 244, 'Cheshire', 'Cheshire'), (413, 244, 'Cleveland', 'Cleveland'), (414, 244, 'Cornwall', 'Cornwall'), (415, 244, 'Cumberland', 'Cumberland'), (416, 244, 'Cumbria', 'Cumbria'), (417, 244, 'Derbyshire', 'Derbyshire'), (418, 244, 'Devon', 'Devon'), (419, 244, 'Dorset', 'Dorset'), (420, 244, 'Durham', 'Durham'), (421, 244, 'Essex', 'Essex'), (422, 244, 'East Sussex', 'East Sussex'), (423, 244, 'East Yorkshire', 'East Yorkshire'), (424, 244, 'Gloucestershire', 'Gloucestershire'), (425, 244, 'Greater Manchester', 'Greater Manchester'), (426, 244, 'Hampshire', 'Hampshire'), (427, 244, 'Herefordshire', 'Herefordshire'), (428, 244, 'Hertfordshire', 'Hertfordshire'), (429, 244, 'Humberside', 'Humberside'), (430, 244, 'Huntingdonshire', 'Huntingdonshire'), (432, 244, 'Kent', 'Kent'), (433, 244, 'Lancashire', 'Lancashire'), (434, 244, 'Leicestershire', 'Leicestershire'), (435, 244, 'Lincolnshire', 'Lincolnshire'), (436, 244, 'London', 'London'), (437, 244, 'Middlesex', 'Middlesex'), (438, 244, 'Merseyside', 'Merseyside'), (439, 244, 'Norfolk', 'Norfolk'), (440, 244, 'Northamptonshire', 'Northamptonshire'), (441, 244, 'Northumberland', 'Northumberland'), (442, 244, 'North Yorkshire', 'North Yorkshire'), (443, 244, 'Nottinghamshire', 'Nottinghamshire'), (444, 244, 'Oxfordshire', 'Oxfordshire'), (445, 244, 'Rutland', 'Rutland'), (446, 244, 'Shropshire', 'Shropshire'), (447, 244, 'Somerset', 'Somerset'), (448, 244, 'South Yorkshire', 'South Yorkshire'), (449, 244, 'Staffordshire', 'Staffordshire'), (450, 244, 'Suffolk', 'Suffolk'), (451, 244, 'Surrey', 'Surrey'), (452, 244, 'Sussex', 'Sussex'), (453, 244, 'Tyne and Wear', 'Tyne and Wear'), (454, 244, 'Warwickshire', 'Warwickshire'), (455, 244, 'Westmorland', 'Westmorland'), (456, 244, 'West Midlands', 'West Midlands'), (457, 244, 'West Sussex', 'West Sussex'), (458, 244, 'West Yorkshire', 'West Yorkshire'), (459, 244, 'Wiltshire', 'Wiltshire'), (460, 244, 'Worcestershire', 'Worcestershire'), (461, 244, 'Yorkshire', 'Yorkshire'), (462, 246, 'Jersey', 'Jersey'), (463, 246, 'Guernsey', 'Guernsey'), (464, 246, 'Alderney', 'Alderney'), (465, 246, 'Sark', 'Sark'), (466, 246, 'Herm', 'Herm'), (467, 245, 'Isle of Man', 'Isle of Man'), DROP TABLE IF EXISTS zones_to_geo_zones;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

> and in PHPMYADMIN
> ```
SQL query:

-- -- Dumping data for table `zones` -- INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (495, 252, 'Isles of Scilly', 'Isles of Scilly'), (494, 253, 'Isle of Wight', 'Isle of Wight'), (327, 241, 'Antrim', 'Antrim'), (328, 241, 'Armagh', 'Armagh'), (329, 241, 'Derry', 'Derry'), (330, 241, 'Down', 'Down'), (331, 241, 'Fermanagh', 'Fermanagh'), (332, 241, 'Londonderry', 'Londonderry'), (333, 241, 'Tyrone', 'Tyrone'), (334, 242, 'Aberdeenshire', 'Aberdeenshire'), (335, 242, 'Angus', 'Angus'), (336, 242, 'Argyll', 'Argyll'), (337, 242, 'Ayrshire', 'Ayrshire'), (338, 242, 'Banffshire', 'Banffshire'), (339, 242, 'Berwickshire', 'Berwickshire'), (340, 242, 'Borders', 'Borders'), (341, 251, 'Bute (islands of Arran and Bute)', 'Bute (islands of Arran and Bute)'), (342, 242, 'Caithness', 'Caithness'), (343, 242, 'Central', 'Central'), (344, 242, 'Clackmannanshire', 'Clackmannanshire'), (345, 242, 'Dumfriesshire', 'Dumfriesshire'), [...]

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `zones_to_geo_zones`' at line 153 

hopefully somebody can shed some light on this as iv looked at line 153 and it seems fine :S....

line153 dont even link to "zones_to_geo_zones"...

help??

think i found the problem :D

(466, 246, 'Herm', 'Herm'),
(467, 245, 'Isle of Man', 'Isle of Man')[B],[/B]

changed this to ;
and seemed to work :D

Hi

I thought this was a great idea and added all the extra countries only to find that it made a mess of my Paypal Express as it only accepts official ISO codes.

Just a warning for anyone else thinking of adding this, unless someone has a way of getting round this?

Thanks
Ralph