MZMT MultiGeoZone MultiTable Shipping [Support Thread]

[dreamscape]

Wow, so if I'm understanding things right, you could have

Yes that is exactly correct (and one of the most requested reasons for having upper limits).

[DogTags]

Yes that is exactly correct (and one of the most requested reasons for having upper limits).

Yeehah!

The beauty of this is that you don't have to have all shipping methods for each weight group. Meaning, all heavy orders go by UPS. This makes labelling and time management much more efficient.

Great!

Thanks, dreamscape. MZMT is one of the most useful mods :)

[DogTags]

Oh, forgot to ask...

Will the new version be compatible with zc 1.2.7d ?

Many thanks :-)

[bmurry]

I’ve set up MultiGeoZone in zencart v 1.3 and it works but I would like to add more tables to my zones. The documentation says that tables can be added in Admin -> Configuration -> MultiGeoZone MultiTable Shipping but this only lets me change the number of zones. How do I change the number of tables?


Thank you,


Dave Murry

[clydejones]

You should have 2 options here:

Admin -> Configuration -> MultiGeoZone MultiTable Shipping

Number of Geo Zones
Number of Tables per Geo Zone

[bmurry]

I only have one option for the number of zones. I'll try to re-install.

[dreamscape]

Run this if you have problems with the included install SQL file.

--
-- Set the number of geo zones and tables per geo zone that you want in the initial install
-- (these can also be changed later on from the Zen Cart admin Configuration section)
--
SET @num_geozones = '3';
SET @num_tables = '3';


--
-- There shouldn't be a need to edit below this line
--
SELECT (@group_id := configuration_group_id) FROM configuration_group WHERE configuration_group_title = 'MultiGeoZone MultiTable Shipping';
DELETE FROM configuration WHERE configuration_group_id = @group_id;
DELETE FROM configuration WHERE configuration_key = 'MODULE_SHIPPING_MZMT_NUMBER_GEOZONES';
DELETE FROM configuration WHERE configuration_key = 'MODULE_SHIPPING_MZMT_NUMBER_TABLES';
DELETE FROM configuration_group WHERE configuration_group_id = @group_id;

INSERT INTO configuration_group VALUES ('', 'MultiGeoZone MultiTable Shipping', 'The options which configure the MultiGeoZone MultiTable Shipping Module', '1', '1');
SELECT @group_id := LAST_INSERT_ID();
UPDATE configuration_group SET sort_order = @group_id WHERE configuration_group_id = @group_id;
INSERT INTO configuration 
VALUES 
	('', 'Number of Geo Zones', 'MODULE_SHIPPING_MZMT_NUMBER_GEOZONES', @num_geozones, 'The number of shipping geo zones.', @group_id, '0', NULL, now(), NULL, NULL),
	('', 'Number of Tables per Geo Zone', 'MODULE_SHIPPING_MZMT_NUMBER_TABLES', @num_tables, 'The number of shipping tables per geo zone.', @group_id, '1', NULL, now(), NULL, NULL);

[Shelia]

I get the error below when I run the sql file. My configuration_group table is named zen_configuration_group. I don't know enough about sql to make the change needed to run the file correctly. Can you help?

--
-- There shouldn't be a need to edit below this line
--
SELECT (

@group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'MultiGeoZone MultiTable Shipping';



MySQL said:  

#1146 - Table 'bbhccom_zencart1.configuration_group' doesn't exist

[TheOracle]

#1146 - Table 'bbhccom_zencart1.configuration_group' doesn't exist

Ok, so - since your configuration_group doesn't exist, simply go to your admin section - > tools - > SQL Patches.

Then, execute the following SQL Statement:

DROP TABLE IF EXISTS configuration_group;
CREATE TABLE configuration_group (
configuration_group_id int(11) NOT NULL auto_increment,
configuration_group_title varchar(64) NOT NULL default '',
configuration_group_description varchar(255) NOT NULL default '',
sort_order int(5) default NULL,
visible int(1) default '1',
PRIMARY KEY (configuration_group_id),
KEY idx_visible_zen (visible)
) TYPE=MyISAM;

If it is not possible to access this page, due to excessive missing infos, simply go to your phpmyadmin and execute this one instead:

DROP TABLE IF EXISTS bbhccom_zencart1.configuration_group;
CREATE TABLE bbhccom_zencart1.configuration_group (
configuration_group_id int(11) NOT NULL auto_increment,
configuration_group_title varchar(64) NOT NULL default '',
configuration_group_description varchar(255) NOT NULL default '',
sort_order int(5) default NULL,
visible int(1) default '1',
PRIMARY KEY (configuration_group_id),
KEY idx_visible_zen (visible)
) TYPE=MyISAM;

However, the first solution would still be advisable to use if it is possible to access.

From there, retry the multigeozone configuration page to see if this error occurs again. If it does, then I would suggest to back up this table, (once you have properly set up all your configurations from that MOD), in order to avoid this problem in the future.

[dreamscape]

I get the error below when I run the sql file. My configuration_group table is named zen_configuration_group. I don't know enough about sql to make the change needed to run the file correctly. Can you help?

The file is designed so it can run from the Zen Cart SQL Patch tool in the Zen Cart admin. It will automatically add the db prefix if needed.