fields(array( 'country_id' => 404, 'country_name' => 'Kenya', 'country_iso_code_2' => 'KE', 'country_iso_code_3' => 'KEN', 'version' => 1, )) ->execute(); // Make the entries in the zones table. $zones = array( array(404, '700', 'Bonde la Ufa'), array(404, '200', 'Central'), array(404, '300', 'Coast'), array(404, '400', 'Eastern'), array(404, '500', 'Kaskazini Masariki'), array(404, '200', 'Kati'), array(404, '800', 'Maqharibi'), array(404, '400', 'Mashariki'), array(404, '110', 'Nairobi'), array(404, '500', 'North-Eastern'), array(404, '600', 'Nyanza'), array(404, '300', 'Pwani'), array(404, '700', 'Rift Valley'), array(404, '800', 'Western'), ); $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name')); foreach ($zones as $zone) { $query->values($zone); } $query->execute(); // Set address format uc_set_address_format( 404, "!company\r\n". "!first_name !last_name\r\n". "!street1\r\n". "!street2\r\n". "!city !zone_code !postal_code\r\n". "!country_name_if" ); }