Hope this is helpful to anyone who needs to use Pakistani addresses for their Dolibarr.
Home ► Dictionary ► Regions
| Code | Label | Country |
|---|---|---|
| 800 | Punjab Province | Pakistan |
| 801 | Balochistan Province | Pakistan |
| 802 | Khyber-Pakhtunkhwa Province | Pakistan |
| 803 | Sindh Province | Pakistan |
| 804 | Azad Kashmir | Pakistan |
| 805 | Gilgit-Baltistan | Pakistan |
| 806 | Islamabad Capital Territory | Pakistan |
Home ► Dictionary ► States
SQL:
-- PUNJAB
INSERT INTO `llx_c_departements` (`code_departement`, `fk_region`, `cheflieu`, `tncc`, `ncc`, `nom`, `active`)
VALUES
("801", "800", "54000", "0", "", "Lahore", 1),
("802", "800", "63100", "0", "", "Bahawalpur", 1),
("803", "800", "32200", "0", "", "Dera Ghazi Khan", 1),
("804", "800", "38000", "0", "", "Faisalabad", 1),
("805", "800", "52250", "0", "", "Gujranwala", 1),
("806", "800", "60000", "0", "", "Multan", 1),
("807", "800", "46000", "0", "", "Rawalpindi", 1),
("808", "800", "57000", "0", "", "Sahiwal", 1),
("809", "800", "40100", "0", "", "Sargodha", 1),
--BALOCHISTAN
("810", "801", "89100", "0", "", "Kalat", 1),
("811", "801", "92600", "0", "", "Makran", 1),
("812", "801", "15550", "0", "", "Naseerabad", 1),
("813", "801", "87300", "0", "", "Quetta", 1),
("814", "801", "82000", "0", "", "Sibi", 1),
("815", "801", "85200", "0", "", "Zhob", 1),
("816", "801", "84800", "0", "", "Loralai", 1),
("817", "801", "94100", "0", "", "Rakhshan", 1),
--KHYBER-PAKHTUNKHWA
("818", "802", "28100", "0", "", "Bannu", 1),
("819", "802", "29050", "0", "", "Dera Ismail Khan", 1),
("820", "802", "22010", "0", "", "Hazara", 1),
("821", "802", "26000", "0", "", "Kohat", 1),
("822", "802", "19200", "0", "", "Malakand", 1),
("823", "802", "23200", "0", "", "Mardan", 1),
("824", "802", "25000", "0", "", "Peshawar", 1),
--SINDH PROVINCE
("825", "803", "43130", "0", "", "Banbhore", 1),
("826", "803", "71000", "0", "", "Hyderabad", 1),
("827", "803", "74200", "0", "", "Karachi", 1),
("828", "803", "65200", "0", "", "Sukkur", 1),
("829", "803", "77150", "0", "", "Larkana", 1),
("830", "803", "69000", "0", "", "Mirpur Khas", 1),
("831", "803", "67450", "0", "", "Shaheed Benazirabad", 1),
--AZAD KASHMIR
("832", "804", "10250", "0", "", "Mirpur", 1),
("833", "804", "13100", "0", "", "Muzaffarabad", 1),
("834", "804", "12350", "0", "", "Poonch", 1),
--GILGIT-BALTISTAN
("835", "805", "15100", "0", "", "Gilgit", 1),
("836", "805", "16100", "0", "", "Baltistan", 1),
("837", "805", "14100", "0", "", "Diamer", 1),
--ISLAMABAD CAPITAL TERRITORY
("838", "806", "44000", "0", "", "Islamabad", 1);
The names are collated from Wikipedia and the postal codes were through web searches
