MZMT MultiGeoZone MultiTable Shipping [Support Thread]

[Website Rob]

includes/modules/shipping/zones.php

That is the file I suggest you start with. Good info is provided on how to at least, get a handle on what you want to do. And yes, for any new/customized; Country, City, Village, that you want entered, they must be manually added. Good news is that you only have to enter them once -- and backup that file.

[Kruna]

Thanks a lot for your answer...getting closer, but still some things are not clear. I changed the number of zones to 5, but in Zencart admin there are added six rows, that's ok, every Zone needs three rows (ZoneCountry, ZoneShippingTable and ZoneHandlingFee), but without any text, they are just blank...which row stands for what? SAme order?
Still when I enter the Zones (location-taxes/zones) I can only put the country, zone and code, no city, no village...by the way, assuming I insert all the villages and then go to modules/shipping/zones...do I have to enter all the let's say 200 codes for one zone I have???

Maybe I have found already a solution...I found a thread where it says how to enter the states/provinces by dropdown

http://www.zen-cart.com/forum/showth...ht=cities+drop

so the client has to chose between the ones I inserted...and may not put a wrong one. I am going to try this out and see how far I get.

Thanks a lot for any help.

Kruna

[peanut77]

Hello

I have just installed this on 1.35 (alls good as per normal) however none of my ez pages are now showing my ez page side box is on - and pages are all visable with sort orders but they are just not displaying on screen. totally stuck

I do have a back up so I can put back to before I installed - but I need this module - any ideas? help needed

[meadwench]

::bump:: Anyone? I'd really like to figure out why my MZMT won't show up in the checkout process. I'm doing a test order from NC, which should be part of the lower 48....

[meadwench]

OK, it is showing, but only the 'rest of the world' flat rate of $45. I've got rates for the US lower 48, and AK/HI/outlying, and when I change my address in the system, the rates still show $45 for 'rest of the world'.

I've got the store location set in admin......what am I missing here?

[meadwench]

I'm having the same issue. On a hunch, I checked the details for one of my zones, Shp: United States: 48, which came with MZMT. I ran the SQL, and it affected 49 rows, but only one state, Alabama, shows when I look at the details of the zone in admin. I suspect that you might have the same problem. Check the details on your 'Rest of the World' doesn't include Peru, as I suspect it will be why you're getting the higher rate.

I'm going to look at the SQL code for my area, and see if I can fix it, as adding each state by hand is a bit laborious.

[meadwench]

Sure enough, the SQL code wasn't correctly adding the states. I went into my PHPMyAdmin, and fixed it. Turns out that the geo_zone id was going in as '0', when it should have been '23' (in my db, yours will vary). I fixed that, and *voila*, states were in my list, and all is good!

[branholm]

Sure enough, the SQL code wasn't correctly adding the states. I went into my PHPMyAdmin, and fixed it. Turns out that the geo_zone id was going in as '0', when it should have been '23' (in my db, yours will vary). I fixed that, and *voila*, states were in my list, and all is good!

Thank you for the information, but this does not help when some people are not able to do SQL coding, like myself.

Please give a detailed accounting of how you fixed it.

[recordshow]

TAKEN FROM INSTRUCTIONS:

Located in the `_geo_zones_sql` folder are some SQL files to import into your database for pre-built shipping zones. The following are the Geo Zones and their SQL file in this folder that you can just import into your Zen Cart database (setting them up by hand can be painstaking if they have a lot of zones/countries):

* United States (continental 48 + DC) - `US_48.sql`
* United States (Alaska & Hawaii) - `US_AKHI.sql`
* United States (APO/FPO) - `US_APOFPO.sql`
* European Union (entire European Union) - `EU_ALL.sql`


MY QUESTION IS WHERE EXACTLY DO I COPY THESE FILES IN MY ZENCART DATABASE? I CAN"T GET IT TO SHOW UP IN THE PULLDOWN MENU.

Thanks!

[recordshow]

TAKEN FROM INSTRUCTIONS:

1. Copy files from `_zen_cart_folder` to your Zen Cart install.
2. Import SQL file `_install_sql/INSTALL_v1.100.sql` to your DB.
3. Setup Pre-configuration from Admin -> Configuration -> MultiGeoZone MultiTable Shipping
4. Setup shipping Geo Zones (see Setting Up Geo Zones section of the Read Me document)
5. Install & setup module from Admin -> Modules -> Shipping -> MultiGeoZone MultiTable

RE: STEP 3. I DO NOT SEE "MultiGeoZone MultiTable Shipping" WHEN I GO TO ADMIN/CONFIGURATION. YET IT IS THERE IN STEP 5 DID I MISS SOMETHING?

Help is appreciated.
Thanks in advance.