Adding Common Shipping to Every Country

If you want to create a standard shipping method for every country listed in Cartweaver, find the shipping method id that you want to use (from tbl_shipmethod) and hard-code it into the following query. Run it from your database admin tool. The following example assumes an id of "12":

INSERT INTO tbl_shipmethcntry_rel
(shpmet_cntry_Meth_ID,shpmet_cntry_Country_ID)
SELECT 12 as shpmet_cntry_Meth_ID, country_ID as shpmet_cntry_Country_ID
FROM `tbl_list_countries`

Back to Cartweaver PHP FAQ, code changes, and samples