Specify hard to reach shipping locations

  • Posts: 1133
  • Thank you received: 12
  • Hikashop Business
5 days 15 hours ago #370083

-- HikaShop version -- : 6.2.0
-- Joomla version -- : 3.10.12

Hi!

There are about 9.000 locations in my country that are hard to reach for the courier company and they have specific prices.
I need to add all these locations in my shipping methods but there are too many to do it manually, is there a faster easier way?

So my checkout page would have to be like this:

1. Select Country: Greece's hard to reach locations (from dropdown field)
2. (when selecting Greece's hard to reach locations) Select location: blabla

Thank you

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84999
  • Thank you received: 13854
  • MODERATOR
5 days 10 hours ago #370084

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.

Please Log in or Create an account to join the conversation.

  • Posts: 1133
  • Thank you received: 12
  • Hikashop Business
4 days 12 hours ago #370101

Hi!

I think it would be much easier for users to put their Post Code number in a field and by filtering that they would get the correct shipping location and cost.

Like in IKEA's website for example: www.ikea.gr/kalathi-agoron/

Can the checkout be like that?

Thank you!

Please Log in or Create an account to join the conversation.

  • Posts: 84999
  • Thank you received: 13854
  • MODERATOR
4 days 8 hours ago #370102

Hi,

Something like this is already possible with HikaShop with the Shipping estimation plugin:
www.hikashop.com/marketplace/product/244...tion-by-obsidev.html

The following user(s) said Thank You: verzevoul

Please Log in or Create an account to join the conversation.

  • Posts: 1133
  • Thank you received: 12
  • Hikashop Business
3 days 16 hours ago #370117

Okay thank you for that!

And it's for the checkout page right?

Please Log in or Create an account to join the conversation.

  • Posts: 84999
  • Thank you received: 13854
  • MODERATOR
3 days 13 hours ago #370119

No, it's on the product page. However, the information you enter for it will carry to other products and to the cart / checkout. This means that :
- once you enter the information on one product page, you'll directly see the shipping estimation on other product pages
- on the registration form, the address information already provided will be prefilled
- the shipping methods selection on the checkout will be based on the information already provided
- the first shipping method being preselected automatically, the cart module will display the shipping fee automatically for it, if the shipping fee display setting is activated in the cart module settings page
So, I think it is even better that what is proposed on the Greek Ikea website.

Note that we've moved forward quite well with the sub zones import, and the shipping methods creation. We'll be able to provide a nice solution to people with the same need to enter a lot of zones / shipping methods with the next version of HikaShop. We're planning the next release for February.

The following user(s) said Thank You: verzevoul

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum