Posted 02 August 2012 - 05:33 PM
I am trying to install the MultiGeoZone MultiTable shipping module.
I have to set up 4 shipping tables for four different geographic zones.
I was directed to try the MultiGeoZone MultiTable module.
I have the module, but I am having an issue installing the module.
The steps are a follows:
1. Copy files from `catalog` to your osCommerce installation.
2. Import SQL file `_install_sql/INSTALL_v1.000.sql` to your DB.
3. Setup Pre-configuration from Admin -> Configuration -> MultiGeoZone MultiTable Shipping
4. Setup shipping Geo Zones (see "SETTING UP GEOZONES" section of the README file)
5. Install & setup module from Admin -> Modules -> Shipping -> MultiGeoZone MultiTable
I have done step one and I think I understand (in theory at least) steps 3, 4 and 5.
When it comes to step 2 - I believe I understand the theory (that it will give the Admin -> Configuration the ability to handle geozones).
But I don't know how to DO step 2.
I don't know what DB they are talking about.
I don't know where this DB is.
Finally, I don't know how to import the SQL file "INSTALL_v1.000.sql" to the DB.
Any and all help would be most welcome.
Posted 02 August 2012 - 05:38 PM
Banners Box 2.3.x Support
Categories Accordion Box 2.3.x Support
Categories Images Box 2.2x 2.3.x Support
Closest Shipper 2.2x Support
Document Manager 2.2x Support
Generic Box 2.3.x Support
Get 1 Free 2.2x Support
jQuery Banner Rotator 2.2x 2.3.x Support
Modular Front Page 2.3.x Support
Modular SEO Header Tags 2.3.x Support
MVS 2.2x Support
PDF Datasheet 2.3.x Support
Price Updater 2.2x
Products Specifications 2.2x 2.3.x Development Version Support Bugs/Suggestions
Request a Review 2.2x - 2.3.x Support
Similar Products Box 2.2x
Specials Image Overlay 2.3x Support
Theme Switcher 2.3.x Support
Posted 02 August 2012 - 09:14 PM
I did step 3 - Admin -> Configuration -> MultiGeoZone MultiTable Shipping
(the fact that there was a MultiGeoZone MultiTable Shipping option in the Configuration menu means I did step 2 right)
I did step 4 and 5 - and whene I tested I got nothing...... (sigh)
I think I went wrong with the setting up of the geozones (I have attached a screen capture of me setting up the geozones)
Any help is most welcome - thanks
Posted 03 August 2012 - 01:50 PM
When I launch "Tax Zones" menu I get the option to "Insert" a new tax zone.
I then get the options "Zone Name" and "Description".
For Zone Name I have entered in ones like "shp:EastCanada" I have added the "shp:" part so the shipping module (in step 5) will see the new zones.
For Description I have entered in the province codes. So for the "shp:EastCanada" I entered in "QC,NS,NB,NF,PE,NT" which are the provincial codes for these provinces. I then "Saved" the new zone.
There is something I am missing in this step.
Posted 03 August 2012 - 07:43 PM
Now I have to get the rest to work.....
I decided to use the Continental US and Eurozone SQL scripts as a guide.
for example in the US script:
INSERT INTO `geo_zones` VALUES ('', 'Shp: United States: 48', 'United States: Continental 48 states', NULL, now());
INSERT INTO `zones_to_geo_zones` VALUES ('', 223, 1, last_insert_id(), NULL, now()),
('', 223, 4, last_insert_id(), NULL, now()),
('', 223, 5, last_insert_id(), NULL, now()),
('', 223, 12, last_insert_id(), NULL, now()),
---- etc -------
('', 223, 65, last_insert_id(), NULL, now());
I assume that
'Shp: United States: 48' - will make shipping zone name.
'United States: Continental 48 states' - will make the zone's description
('', 223, 1, last_insert_id(), NULL, now()), - 223 = Country code for the United States and the 1 is the state code (in this case Alabama (AL).
With these assumptions I made a script for Western Canada (AB, SK, MB, ON and YT)
Here is the script:
INSERT INTO `geo_zones` VALUES ('', 'Shp: Canada West : 5 ', 'Western Canada: AB SK MB ON YK', NULL, now());
INSERT INTO `zones_to_geo_zones` VALUES ('', 38, 1, last_insert_id(), NULL, now()),
('', 38, 3, last_insert_id(), NULL, now()),
('', 38, 9, last_insert_id(), NULL, now()),
('', 38, 12, last_insert_id(), NULL, now()),
('', 38, 13, last_insert_id(), NULL, now());
38 = Canada
1 = AB, 3 = MB, 9 = ON, 12 = SK, 13 = YK
I run this script and it did show in the "Tax Zones" menu.
And it appeared in the MultiGeoZone MultiTable shipping module.
But when testing the module - when the test address was a US one it worked perfectly.
When the test address was an Ontario (ON) one or Alberta (AB) nothing in the shipping module appears.
Posted 07 August 2012 - 08:46 PM
I was thinking that since I defined the country as Canada, then the zone setting of 1 would be AB (Alberta - alphabetically the first province), well it don't work that way....
but I did figure it out.