Free shipping for orders over X$ in the lower 48 only?

[maxilious]

How do I set Free shipping for orders over X$ in the lower 48 only?

[Ajeh]

Do you want the other shipping module(s) to still show when you have the Free Shipping showing?

If so, you can make a Zone for the lower 48 states and use it with Free Shipping Options freeoptions and set the Total to >= XX.XX

Now you will get the Free Shipping Option for the lower 48 but they can choose to expedite the order and pick a different shipping method ...

[maxilious]

How or where do I make a zone for the lower 48?

[Ajeh]

Under the Locations/Taxes ... Zone Definitions ...

You can build one for the 48 Lower and DC ...

[JackA]

I'd like to do the same as maxilious.

I've looked at Zones and Zone Definitions. Do I setup a definition and somehow attach it to a zone or vice versa? Under Zones, the states are all listed separately.
Under Zone Definitions, it doesn't seem to offer a way to select the contiguous 48 states.

[JackA]

Well, it looks like you have to insert each state (zone) into a new zone definition. That right? No shortcuts?

[Ajeh]

Merlinpa1969 posted awhile back a nice build for the 48 states plus DC ...

Now where did that nice thread go ...

[Ajeh]

To create the Zone for the Lower 48 States plus DC you can use the following in the Tools ... Insert SQL Patches ...

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (21, '48 Lower States', '48 States + DC', NULL, '2008-02-01 12:12:12');

INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES
(223, 1, 21),
(223, 4, 21),
(223, 5, 21),
(223, 12, 21),
(223, 13, 21),
(223, 14, 21),
(223, 15, 21),
(223, 16, 21),
(223, 18, 21),
(223, 19, 21),
(223, 22, 21),
(223, 23, 21),
(223, 24, 21),
(223, 25, 21),
(223, 26, 21),
(223, 27, 21),
(223, 28, 21),
(223, 29, 21),
(223, 31, 21),
(223, 32, 21),
(223, 33, 21),
(223, 34, 21),
(223, 35, 21),
(223, 36, 21),
(223, 37, 21),
(223, 38, 21),
(223, 39, 21),
(223, 40, 21),
(223, 41, 21),
(223, 42, 21),
(223, 43, 21),
(223, 44, 21),
(223, 45, 21),
(223, 47, 21),
(223, 48, 21),
(223, 49, 21),
(223, 51, 21),
(223, 53, 21),
(223, 54, 21),
(223, 55, 21),
(223, 56, 21),
(223, 57, 21),
(223, 58, 21),
(223, 59, 21),
(223, 61, 21),
(223, 62, 21),
(223, 63, 21),
(223, 64, 21),
(223, 65, 21);

Be sure to backup your database first before running things like this ...

[JackA]

Gulp! I've never done this before. Do I just copy the code you provided and paste it into the "Insert SQL query here" area of the Admin>Tools>Insert SQL Patch?

The SQL Executor instructions seem to say that is correct.

I have backed up my db. But, I had already begun one-by-one building manually a 48-state zone definition. I have about 23 more to go. Will your script overwrite/replace what's there already or do I need to do something else first?

[maxilious]

Thank you Ajeh.

To create the Zone for the Lower 48 States plus DC you can use the following in the Tools ... Insert SQL Patches ...

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (21, '48 Lower States', '48 States + DC', NULL, '2008-02-01 12:12:12');

INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES
(223, 1, 21),
(223, 4, 21),
(223, 5, 21),
(223, 12, 21),
(223, 13, 21),
(223, 14, 21),
(223, 15, 21),
(223, 16, 21),
(223, 18, 21),
(223, 19, 21),
(223, 22, 21),
(223, 23, 21),
(223, 24, 21),
(223, 25, 21),
(223, 26, 21),
(223, 27, 21),
(223, 28, 21),
(223, 29, 21),
(223, 31, 21),
(223, 32, 21),
(223, 33, 21),
(223, 34, 21),
(223, 35, 21),
(223, 36, 21),
(223, 37, 21),
(223, 38, 21),
(223, 39, 21),
(223, 40, 21),
(223, 41, 21),
(223, 42, 21),
(223, 43, 21),
(223, 44, 21),
(223, 45, 21),
(223, 47, 21),
(223, 48, 21),
(223, 49, 21),
(223, 51, 21),
(223, 53, 21),
(223, 54, 21),
(223, 55, 21),
(223, 56, 21),
(223, 57, 21),
(223, 58, 21),
(223, 59, 21),
(223, 61, 21),
(223, 62, 21),
(223, 63, 21),
(223, 64, 21),
(223, 65, 21);

Be sure to backup your database first before running things like this ...