Jump to content
hornetnz

$0 international shipping

Recommended Posts

At the time we setup the site, the client wasn't sure how they wanted to handle non-us orders...so I deleted all countries from the db so only US people could create an account and order. I have table based rates setup for US customers. The client now wants to handle international orders by giving a $0 international shipping option with the note that shipping costs will be added once costs are determined. Whats the easiest way to set this up? Also wondering if someone can toss me the portion of db script that will reset my countries to default.

Share this post


Link to post
Share on other sites

@@hornetnz

 

Here is the countries SQL statement (minus the US because you already have that one installed:

 

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');

INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1');

INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1');

INSERT INTO countries VALUES (5,'Andorra','AD','AND','1');

INSERT INTO countries VALUES (6,'Angola','AO','AGO','1');

INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1');

INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1');

INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1');

INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1');

INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1');

INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1');

INSERT INTO countries VALUES (13,'Australia','AU','AUS','1');

INSERT INTO countries VALUES (14,'Austria','AT','AUT','5');

INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1');

INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1');

INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1');

INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1');

INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1');

INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1');

INSERT INTO countries VALUES (21,'Belgium','BE','BEL','1');

INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1');

INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1');

INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1');

INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1');

INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1');

INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');

INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1');

INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1');

INSERT INTO countries VALUES (30,'Brazil','BR','BRA','1');

INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');

INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1');

INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1');

INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1');

INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1');

INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1');

INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1');

INSERT INTO countries VALUES (38,'Canada','CA','CAN','1');

INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1');

INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1');

INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF','1');

INSERT INTO countries VALUES (42,'Chad','TD','TCD','1');

INSERT INTO countries VALUES (43,'Chile','CL','CHL','1');

INSERT INTO countries VALUES (44,'China','CN','CHN','1');

INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR','1');

INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1');

INSERT INTO countries VALUES (47,'Colombia','CO','COL','1');

INSERT INTO countries VALUES (48,'Comoros','KM','COM','1');

INSERT INTO countries VALUES (49,'Congo','CG','COG','1');

INSERT INTO countries VALUES (50,'Cook Islands','CK','COK','1');

INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI','1');

INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV','1');

INSERT INTO countries VALUES (53,'Croatia','HR','HRV','1');

INSERT INTO countries VALUES (54,'Cuba','CU','CUB','1');

INSERT INTO countries VALUES (55,'Cyprus','CY','CYP','1');

INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE','1');

INSERT INTO countries VALUES (57,'Denmark','DK','DNK','1');

INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI','1');

INSERT INTO countries VALUES (59,'Dominica','DM','DMA','1');

INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM','1');

INSERT INTO countries VALUES (61,'East Timor','TP','TMP','1');

INSERT INTO countries VALUES (62,'Ecuador','EC','ECU','1');

INSERT INTO countries VALUES (63,'Egypt','EG','EGY','1');

INSERT INTO countries VALUES (64,'El Salvador','SV','SLV','1');

INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ','1');

INSERT INTO countries VALUES (66,'Eritrea','ER','ERI','1');

INSERT INTO countries VALUES (67,'Estonia','EE','EST','1');

INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH','1');

INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1');

INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO','1');

INSERT INTO countries VALUES (71,'Fiji','FJ','FJI','1');

INSERT INTO countries VALUES (72,'Finland','FI','FIN','1');

INSERT INTO countries VALUES (73,'France','FR','FRA','1');

INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX','1');

INSERT INTO countries VALUES (75,'French Guiana','GF','GUF','1');

INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF','1');

INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF','1');

INSERT INTO countries VALUES (78,'Gabon','GA','GAB','1');

INSERT INTO countries VALUES (79,'Gambia','GM','GMB','1');

INSERT INTO countries VALUES (80,'Georgia','GE','GEO','1');

INSERT INTO countries VALUES (81,'Germany','DE','DEU','5');

INSERT INTO countries VALUES (82,'Ghana','GH','GHA','1');

INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB','1');

INSERT INTO countries VALUES (84,'Greece','GR','GRC','1');

INSERT INTO countries VALUES (85,'Greenland','GL','GRL','1');

INSERT INTO countries VALUES (86,'Grenada','GD','GRD','1');

INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP','1');

INSERT INTO countries VALUES (88,'Guam','GU','GUM','1');

INSERT INTO countries VALUES (89,'Guatemala','GT','GTM','1');

INSERT INTO countries VALUES (90,'Guinea','GN','GIN','1');

INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB','1');

INSERT INTO countries VALUES (92,'Guyana','GY','GUY','1');

INSERT INTO countries VALUES (93,'Haiti','HT','HTI','1');

INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1');

INSERT INTO countries VALUES (95,'Honduras','HN','HND','1');

INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG','1');

INSERT INTO countries VALUES (97,'Hungary','HU','HUN','1');

INSERT INTO countries VALUES (98,'Iceland','IS','ISL','1');

INSERT INTO countries VALUES (99,'India','IN','IND','1');

INSERT INTO countries VALUES (100,'Indonesia','ID','IDN','1');

INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1');

INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ','1');

INSERT INTO countries VALUES (103,'Ireland','IE','IRL','1');

INSERT INTO countries VALUES (104,'Israel','IL','ISR','1');

INSERT INTO countries VALUES (105,'Italy','IT','ITA','1');

INSERT INTO countries VALUES (106,'Jamaica','JM','JAM','1');

INSERT INTO countries VALUES (107,'Japan','JP','JPN','1');

INSERT INTO countries VALUES (108,'Jordan','JO','JOR','1');

INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ','1');

INSERT INTO countries VALUES (110,'Kenya','KE','KEN','1');

INSERT INTO countries VALUES (111,'Kiribati','KI','KIR','1');

INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1');

INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR','1');

INSERT INTO countries VALUES (114,'Kuwait','KW','KWT','1');

INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ','1');

INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1');

INSERT INTO countries VALUES (117,'Latvia','LV','LVA','1');

INSERT INTO countries VALUES (118,'Lebanon','LB','LBN','1');

INSERT INTO countries VALUES (119,'Lesotho','LS','LSO','1');

INSERT INTO countries VALUES (120,'Liberia','LR','LBR','1');

INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1');

INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE','1');

INSERT INTO countries VALUES (123,'Lithuania','LT','LTU','1');

INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX','1');

INSERT INTO countries VALUES (125,'Macau','MO','MAC','1');

INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1');

INSERT INTO countries VALUES (127,'Madagascar','MG','MDG','1');

INSERT INTO countries VALUES (128,'Malawi','MW','MWI','1');

INSERT INTO countries VALUES (129,'Malaysia','MY','MYS','1');

INSERT INTO countries VALUES (130,'Maldives','MV','MDV','1');

INSERT INTO countries VALUES (131,'Mali','ML','MLI','1');

INSERT INTO countries VALUES (132,'Malta','MT','MLT','1');

INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL','1');

INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ','1');

INSERT INTO countries VALUES (135,'Mauritania','MR','MRT','1');

INSERT INTO countries VALUES (136,'Mauritius','MU','MUS','1');

INSERT INTO countries VALUES (137,'Mayotte','YT','MYT','1');

INSERT INTO countries VALUES (138,'Mexico','MX','MEX','1');

INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1');

INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA','1');

INSERT INTO countries VALUES (141,'Monaco','MC','MCO','1');

INSERT INTO countries VALUES (142,'Mongolia','MN','MNG','1');

INSERT INTO countries VALUES (143,'Montserrat','MS','MSR','1');

INSERT INTO countries VALUES (144,'Morocco','MA','MAR','1');

INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ','1');

INSERT INTO countries VALUES (146,'Myanmar','MM','MMR','1');

INSERT INTO countries VALUES (147,'Namibia','NA','NAM','1');

INSERT INTO countries VALUES (148,'Nauru','NR','NRU','1');

INSERT INTO countries VALUES (149,'Nepal','NP','NPL','1');

INSERT INTO countries VALUES (150,'Netherlands','NL','NLD','1');

INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT','1');

INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL','1');

INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL','1');

INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC','1');

INSERT INTO countries VALUES (155,'Niger','NE','NER','1');

INSERT INTO countries VALUES (156,'Nigeria','NG','NGA','1');

INSERT INTO countries VALUES (157,'Niue','NU','NIU','1');

INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK','1');

INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP','1');

INSERT INTO countries VALUES (160,'Norway','NO','NOR','1');

INSERT INTO countries VALUES (161,'Oman','OM','OMN','1');

INSERT INTO countries VALUES (162,'Pakistan','PK','PAK','1');

INSERT INTO countries VALUES (163,'Palau','PW','PLW','1');

INSERT INTO countries VALUES (164,'Panama','PA','PAN','1');

INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG','1');

INSERT INTO countries VALUES (166,'Paraguay','PY','PRY','1');

INSERT INTO countries VALUES (167,'Peru','PE','PER','1');

INSERT INTO countries VALUES (168,'Philippines','PH','PHL','1');

INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN','1');

INSERT INTO countries VALUES (170,'Poland','PL','POL','1');

INSERT INTO countries VALUES (171,'Portugal','PT','PRT','1');

INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI','1');

INSERT INTO countries VALUES (173,'Qatar','QA','QAT','1');

INSERT INTO countries VALUES (174,'Reunion','RE','REU','1');

INSERT INTO countries VALUES (175,'Romania','RO','ROM','1');

INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS','1');

INSERT INTO countries VALUES (177,'Rwanda','RW','RWA','1');

INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1');

INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA','1');

INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT','1');

INSERT INTO countries VALUES (181,'Samoa','WS','WSM','1');

INSERT INTO countries VALUES (182,'San Marino','SM','SMR','1');

INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP','1');

INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU','1');

INSERT INTO countries VALUES (185,'Senegal','SN','SEN','1');

INSERT INTO countries VALUES (186,'Seychelles','SC','SYC','1');

INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE','1');

INSERT INTO countries VALUES (188,'Singapore','SG','SGP', '4');

INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1');

INSERT INTO countries VALUES (190,'Slovenia','SI','SVN','1');

INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB','1');

INSERT INTO countries VALUES (192,'Somalia','SO','SOM','1');

INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF','1');

INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1');

INSERT INTO countries VALUES (195,'Spain','ES','ESP','3');

INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA','1');

INSERT INTO countries VALUES (197,'St. Helena','SH','SHN','1');

INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM','1');

INSERT INTO countries VALUES (199,'Sudan','SD','SDN','1');

INSERT INTO countries VALUES (200,'Suriname','SR','SUR','1');

INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1');

INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ','1');

INSERT INTO countries VALUES (203,'Sweden','SE','SWE','1');

INSERT INTO countries VALUES (204,'Switzerland','CH','CHE','1');

INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR','1');

INSERT INTO countries VALUES (206,'Taiwan','TW','TWN','1');

INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK','1');

INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1');

INSERT INTO countries VALUES (209,'Thailand','TH','THA','1');

INSERT INTO countries VALUES (210,'Togo','TG','TGO','1');

INSERT INTO countries VALUES (211,'Tokelau','TK','TKL','1');

INSERT INTO countries VALUES (212,'Tonga','TO','TON','1');

INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO','1');

INSERT INTO countries VALUES (214,'Tunisia','TN','TUN','1');

INSERT INTO countries VALUES (215,'Turkey','TR','TUR','1');

INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM','1');

INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA','1');

INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV','1');

INSERT INTO countries VALUES (219,'Uganda','UG','UGA','1');

INSERT INTO countries VALUES (220,'Ukraine','UA','UKR','1');

INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE','1');

INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR','1');

INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1');

INSERT INTO countries VALUES (225,'Uruguay','UY','URY','1');

INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB','1');

INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT','1');

INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT','1');

INSERT INTO countries VALUES (229,'Venezuela','VE','VEN','1');

INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM','1');

INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB','1');

INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR','1');

INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF','1');

INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH','1');

INSERT INTO countries VALUES (235,'Yemen','YE','YEM','1');

INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG','1');

INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR','1');

INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB','1');

INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

 

However, I am not sure how your client plans to add the international shipping costs after the order has been placed and payment has been made, so I would suggest you set up the international shipping using a weight table or a 'real-time' shipping quote provider.

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

In the past, they've done a money request via paypal. Using a weight table for these products doesn't work since some are very light but large.

 

Thanks for the sql.

Share this post


Link to post
Share on other sites

You can also download the package for the version you are using and add the zones info.

 

Cheers

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Search for "Rest of the world" and "ROW" in the add-ons

 

Cheers

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

If your not going to calculate shipping by country I would not bother adding the countries back in. Just add a "Rest of World" "country" and use zone rate with weight to calculate 0USD for all RoW orders. ie 0USD for orders up to 1000kg for example.

 

Up to you how you tell the customer you will email them back with quote.

Share this post


Link to post
Share on other sites

Paypal is still going to try and validate their address, so I assumed adding the countries back in would be required...

Share this post


Link to post
Share on other sites

Paypal is still going to try and validate their address, so I assumed adding the countries back in would be required...

 

In my understanding PayPal verifies the address of the PayPal account and the shipping address they select in PayPal. It does not validate the address entered in OSCommerce. I talk about the most basic PayPal option, Standard.

 

I stand to be corrected though.....

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×