MZMT MultiGeoZone MultiTable Shipping [Support Thread]

[Parafanaylya]

yes, it works with 1.3 - download here

[maxus]

thank you
sorry all for cross post
post can be deleted 8)

[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

[cpk]

My client has two types of products, small and large. All products are shipped at a flat rate per product. Small items (videos) are shipped via US Postal Service and larger items are shipped via UPS. Customers do not get to choose since the drop shipper only offers these choices. This currently works just fine for the continental U.S. with the per unit module set up to use the product shipping weight as the actual shipping amount in $. This is not ideal but it works. Unfortunately, I don't think this method will work for multiple geo zones (Alaska, Hawaii, and Puerto Rico).

My client now wants to offer shipping rates for Alaska, Hawaii and Puerto Rico but those are also set at a different flat rate amounts per product as determined by the drop shipper.

To complicate things further, it needs to be set up so that when you purchase one video, the shipping is $4.00. If you buy two videos, the first is $4.00 shipping and quantities greater than one are shipped at $2.00 for each after the first, e.g. 1st video = $4 shipping, 2nd video = $2.00 shipping, total shipping for two videos = $6.00, 3 videos = $4+$2+$2=$8. ( I currently have something working that accomplishes this using a combination of per unit/per weight unit as the shipping amount and the handling fee thanks to Ajeh's help)

I have seen many recommendations for the MZMT contribution since it is so flexible but feel a bit stupid since I can't seem to figure out how to make it work or configure it properly on my test server. I am not sure if this is what I need or if I need to seek a different solution.

Would MZMT allow me to do these kinds of shipping configurations? If not, any suggestions on how I might accomplish the above configuration for different geo zones?

Thanks,

cpk

[Ajeh]

You can custmize your Shipping Modules ...

Take item.php ... 2 files to customize:

/includes/modules/shipping/item.php
/includes/languages/english/modules/shipping/item.php

Copy to the files:

/includes/modules/shipping/usperitems.php
/includes/languages/english/modules/shipping/usperitems.php

Global replace item with usperitems ...

Global replace ITEM with USPERITEMS ...

WARNING: be aware free_shipping_items does not get touched ...

Next make one for Alaska, Hawaii, etc.
Copy to the files:

/includes/modules/shipping/usperitemsislands.php
/includes/languages/english/modules/shipping/usperitemsislands.php

Do basically the same on global replace but with usperitemsislands case sensative

On usperitems set Handling to 2.00 and Per Item charge to 2.00

This makes 1st product $4.00 and additional +$2.00

Make your Zones for these Shipping Modules ...

Once all done, you have your separate shipping modules for each area ...

NOTE: check MZMT and see if that doesn't have built in a per item charge like this as it would be easier and more flexible to use that if it does ...

[cpk]

I considered cloning the shipping module as I have seen you recommend it to others before but since I am using the product shipping weight as the actual shipping dollar amount, I didn't think that cloning the shipping module would work. I thought MZMT might offer me more control over different products and regions.

What I need is the ability to have a specific shipping price for each individual product for shipment to continental U.S. and different price for each product for Alaska, Hawaii, and Puerto Rico (which would be considered the same region since individual product pricing is the same for AK,HI, PR).

What complicates this further is that I also have to have the ability to offer reduced shipping pricing for customers who purchase more than one video and have that discount apply only to shipping on videos. That is why I provided the example in my first post.

The solution you recommended in the other post works fine for one region but I am at a loss as to how to provide different shipping amounts for different geo zones since I have used the individual products shipping weight field for each product for the continental U.S. region already.

Maybe I am mistaken but I thought I might have to switch to another shipping mod entirely to accomplish this and MZMT looked like it might be the solution but I am unsure if I can set a table rate for every product in each geo zone.

Thanks,

cpk