Hi,
That's quite a challenge with 9,000 locations! Here's the current situation and a potential workaround:
1. Create a Custom Country Zone :
Go to System > Zones and create a new zone:
Name: "Greece - Hard to Reach Locations" (or similar)
Type: Country
Then add sub-zones (states) under this country zone for each hard-to-reach location. The challenge, as you noted, is that HikaShop doesn't currently have a bulk import feature for zones.
Workaround: Direct Database Import
If you're comfortable with PHPMyAdmin, you can prepare a CSV with columns:
zone_namekey, zone_name, zone_name_english, zone_code_2, zone_code_3, zone_type, zone_published
Then, import into the #__hikashop_zone table:
docs.phpmyadmin.net/en/latest/import_export.html
Example for a few locations:
INSERT INTO `#__hikashop_zone`
(zone_namekey, zone_name, zone_name_english, zone_code_2, zone_code_3, zone_type, zone_published)
VALUES
('GREECE_HTR_AEGINA', 'Αίγινα', 'Aegina', 'AI', 'AIG', 'state', 1),
('GREECE_HTR_SPETSES', 'Σπέτσες', 'Spetses', 'SP', 'SPE', 'state', 1);You also need to prepare another CSV to link them to the greece zone to #__hikashop_zone_link:
INSERT INTO `#__hikashop_zone_link` (zone_parent_namekey, zone_child_namekey) VALUES
('GREECE_HTR', 'GREECE_HTR_AEGINA'),
('GREECE_HTR', 'GREECE_HTR_SPETSES');Where GREECE_HTR is the zone_namekey of your parent "Greece Hard to Reach" zone.
Tip: Export the existing Greece states first to see the exact format HikaShop uses, then model your imports on that structure.
And the situation is similar with shipping methods. You would have to create one shipping method per state, which is impractical via the interface. So, the workaround is also to export/import the #__hikashop_shipping table via your PHPMyAdmin.
We're going to look at what we can do in order to improve this process for the next version of HikaShop.