- Posts: 1184
- Thank you received: 13
Specify hard to reach shipping locations
8 months 4 days ago #370083
by verzevoul
Specify hard to reach shipping locations was created by verzevoul
-- 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
-- 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
Please Log in or Create an account to join the conversation.
8 months 4 days ago #370084
by nicolas
Replied by nicolas on topic Specify hard to reach shipping locations
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:
Then, import into the #__hikashop_zone table:
docs.phpmyadmin.net/en/latest/import_export.html
Example for a few locations:
You also need to prepare another CSV to link them to the greece zone to #__hikashop_zone_link:
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.
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:
Code:
zone_namekey, zone_name, zone_name_english, zone_code_2, zone_code_3, zone_type, zone_published
docs.phpmyadmin.net/en/latest/import_export.html
Example for a few locations:
Code:
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);
Code:
INSERT INTO `#__hikashop_zone_link` (zone_parent_namekey, zone_child_namekey) VALUES
('GREECE_HTR', 'GREECE_HTR_AEGINA'),
('GREECE_HTR', 'GREECE_HTR_SPETSES');
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.
8 months 3 days ago #370101
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
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!
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.
8 months 2 days ago #370102
by nicolas
Replied by nicolas on topic Specify hard to reach shipping locations
Hi,
Something like this is already possible with HikaShop with the Shipping estimation plugin:
www.hikashop.com/marketplace/product/244...tion-by-obsidev.html
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.
8 months 2 days ago #370117
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
Okay thank you for that!
And it's for the checkout page right?
And it's for the checkout page right?
Please Log in or Create an account to join the conversation.
8 months 2 days ago #370119
by nicolas
Replied by nicolas on topic Specify hard to reach shipping locations
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.
- 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.
7 months 2 weeks ago #370319
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
Hi,
I updated to the latest version okay.
So with the Shipping Estimation plugin, can the Post Code be used to filter the shipping locations?
For example, in the product the customer enters their Post Code number and the plugin would give them as options the only locations with that Post Code? Instead if showing 9000 location that we have total?
Thank you
I updated to the latest version okay.
So with the Shipping Estimation plugin, can the Post Code be used to filter the shipping locations?
For example, in the product the customer enters their Post Code number and the plugin would give them as options the only locations with that Post Code? Instead if showing 9000 location that we have total?
Thank you
Please Log in or Create an account to join the conversation.
7 months 2 weeks ago #370320
by nicolas
Replied by nicolas on topic Specify hard to reach shipping locations
Hi,
Yes. Exactly.
Yes. Exactly.
Please Log in or Create an account to join the conversation.
7 months 2 weeks ago #370327
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
Yes but without this plugin , hikashop engine can do the same in the checkout?
I mean if the address has the correct postcode can hikashop work ? Whithout the plugin
I mean if the address has the correct postcode can hikashop work ? Whithout the plugin
Please Log in or Create an account to join the conversation.
7 months 2 weeks ago #370328
by nicolas
Replied by nicolas on topic Specify hard to reach shipping locations
Hi,
Yes, HikaShop will only display to the customer the shipping methods which restrictions match with the address he entered.
This plugin only allows the user to enter his post code beforehand to directly get the shipping cost displayed on the product page, without having to go to the checkout. But the filtering is done by HikaShop, not the plugin.
Yes, HikaShop will only display to the customer the shipping methods which restrictions match with the address he entered.
This plugin only allows the user to enter his post code beforehand to directly get the shipping cost displayed on the product page, without having to go to the checkout. But the filtering is done by HikaShop, not the plugin.
Please Log in or Create an account to join the conversation.
7 months 2 weeks ago #370333
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
Hello Nicolas!
What about if we set the the "Minimum and Maximum Post code"
Does hikashop trigger that case?
I tried with no success
Thank you
What about if we set the the "Minimum and Maximum Post code"
Does hikashop trigger that case?
I tried with no success
Thank you
Please Log in or Create an account to join the conversation.
7 months 2 weeks ago #370335
by verzevoul
Replied by verzevoul on topic Specify hard to reach shipping locations
No I was wrong Nikolas . It works.
The following user(s) said Thank You: nicolas
Please Log in or Create an account to join the conversation.
Time to create page: 0.247 seconds