Author Topic: Shipping zones  (Read 2136 times)

0 Members and 1 Guest are viewing this topic.

David M. Graham

  • Administrator
  • Sr. Member
  • *****
  • Offline Offline
  • Posts: 380
  • Karma: 12
    • View Profile
    • osCommerce University
Re: Shipping zones
« Reply #7 on: September 11, 2008, 04:24:03 PM »
I would expect that once you added the new zones and built the new geo_zones,  you would end up with entries in your zones_to_geo_zones table that are pretty standard.  So, from there, you would need to use code similar to the country / state drop down to get the cities "zone_id", then use that value to retrieve the "Geo Zone" using the zone_to_geo_zone table.

(This should be very similar to determining a zone from a US state ...)

David


David M. Graham

  • Administrator
  • Sr. Member
  • *****
  • Offline Offline
  • Posts: 380
  • Karma: 12
    • View Profile
    • osCommerce University
Re: Shipping zones
« Reply #6 on: September 11, 2008, 04:06:08 PM »
Timoz,

The "zones" shipping module operates by building "Geo Zones".    I expect (just from memory, which is not too good this afteroon), that the shipping module is matching countries to its zone definitions (remember, they are really entries in the geo_zones database table) using the ISO code to do lookups.  -- ie, find the country, then find a geo zone which holds it using the zone_country_id field in the zones_to_geo_zones table.

No real provision is made for geo zones smaller than a state. 

I suspect what would have to be done (as a custom hack) is add additional entries to the zones table (per city, town, village, etc), use the "Tax Zone" tool to cluster them together, and write a module which could then use some identifier to do the lookup based on the zone id's. 

David

timoz

  • Newbie
  • *
  • Offline Offline
  • Posts: 12
  • Karma: 0
  • TiMoz on a hot day
    • View Profile
    • SabayaStyle.com e-shop
Re: Shipping zones
« Reply #5 on: September 08, 2008, 08:01:50 PM »
in countries table Egypt is a zone, and it is divided to cities each group of cities form an inner zones.
and all the world to me is another zone

I noticed that shipping module zones.php is looking for the country counties ISO Codes as a Zone.
So how to make it refer to the code in the Zone table, and not the counties ISO Codes.

 ???
Tamer Ragheb
TiMoz............................
Consider the environment. Please don't print unless you really need to.

David M. Graham

  • Administrator
  • Sr. Member
  • *****
  • Offline Offline
  • Posts: 380
  • Karma: 12
    • View Profile
    • osCommerce University
Re: Shipping zones
« Reply #4 on: August 14, 2008, 08:34:27 AM »
I don't see any reason that it could not be done, though this is likely more a case of building a custom zone file set rather than PHP coding per se.

It would put the burden for managing any  OTHER addresses on you, but this may be acceptable within the context of domestic shipping within Egypt.

I'd like to learn a bit more about the issues there, but it does seem an interesting problem.. ;)

David

timoz

  • Newbie
  • *
  • Offline Offline
  • Posts: 12
  • Karma: 0
  • TiMoz on a hot day
    • View Profile
    • SabayaStyle.com e-shop
Re: Shipping zones
« Reply #3 on: August 12, 2008, 02:51:23 PM »
and how can this be done? is there someone who can offer his services?
Tamer Ragheb
TiMoz............................
Consider the environment. Please don't print unless you really need to.

David M. Graham

  • Administrator
  • Sr. Member
  • *****
  • Offline Offline
  • Posts: 380
  • Karma: 12
    • View Profile
    • osCommerce University
Re: Shipping zones
« Reply #2 on: August 10, 2008, 02:55:28 PM »
I believe this would require a new shipping module entirely, and possibly some extensions to or "misuse" of the current zone system.

David

timoz

  • Newbie
  • *
  • Offline Offline
  • Posts: 12
  • Karma: 0
  • TiMoz on a hot day
    • View Profile
    • SabayaStyle.com e-shop
Shipping zones
« Reply #1 on: August 02, 2008, 10:49:14 AM »
Is this possible to add these data to any shipping module available in my e-shop?

Shipping cost inside my country EGYPT:
          Up to 1Kg           every extra Kg
zone 1  10.00                      4.00
zone 2  15.00                      4.00
zone 3  23.00                      6.00
zone 4  19.00                      5.00
and so one....

every zone covers some locations:
zone 1  covers: Cairo, Giza, Helwan..etc
zone 2  covers: Alex, Behira, Ismaeilia..etc
zone 3  ... etc..
and so on...

my target is to make the shopping cart calculate the shipping cost automatically for every order upon checkout, however I want to give a free shipping on orders over specified amount for each zone of the above mentioned zones.

thank you  :)
www.sabayastyle.com
Tamer Ragheb
TiMoz............................
Consider the environment. Please don't print unless you really need to.