fields(array( 'country_id' => 332, 'country_name' => 'Haiti', 'country_iso_code_2' => 'HT', 'country_iso_code_3' => 'HTI', 'version' => 1, )) ->execute(); // Make the entries in the zones table. $zones = array( array(332, 'HT-AR', 'Artibonite'), array(332, 'HT-CE', 'Centre'), array(332, 'HT-GA', 'Grande-Anse'), array(332, 'HT-NI', 'Nippes'), array(332, 'HT-ND', 'Nord'), array(332, 'HT-NE', 'Nord-Est'), array(332, 'HT-NO', 'Nord-Ouest'), array(332, 'HT-OU', 'Ouest'), array(332, 'HT-SD', 'Sud'), array(332, 'HT-SE', 'Sud-Est'), ); $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( 332, "!company\r\n" . "!first_name !last_name\r\n" . "!street1\r\n" . "!street2\r\n" . "!city, !zone_name !postal_code\r\n" . "!country_name_if" ); }