exclude non continental united states zones from free shipping.

[gloerick]

[FONT=Verdana]Hello all,[/FONT]

[FONT=Verdana]Please anyone, I need to exclude some USA zones from the free shipping such as Hawaii, Alaska, Puerto rico, virgin islands and such, need to have the free shipping to continental usa only.[/FONT]

[FONT=Verdana]please, I just lost shipping to Puerto rico this morning :-( as it gave free shipping..[/FONT]

[FONT=Verdana][FONT=Verdana]also anyone have a list of ALL the United States Zones ?[/FONT]
[FONT=Verdana]as I deleted all none continental usa thinking it would solve the issue, now you just cannot select the location on the sign up form, so I messed that up also.[/FONT][/FONT]

[FONT=Verdana]Thx,[/FONT]
[FONT=Verdana]Erick[/FONT]

[gloerick]

[FONT=Verdana]I tried creating a zone called free shipping then added a single state to it, then told the free shipping mod to use that zone for free shipping.[/FONT]

[FONT=Verdana]but now all products with free shipping, if the state is NOT in the free shipping zone then NO RATES show for shipping, just empty, but if I use a state IN the free shipping zone it at least shows and shows free as expected.[/FONT]
[FONT=Verdana][/FONT][FONT=Verdana][/FONT]
[FONT=Verdana]but no rates "just empty" to a state NOT in the free shipping zone ? [/FONT][FONT=Verdana]it should show rates ? and the product does have a weight assigned to it.[/FONT]
[FONT=Verdana][/FONT]
[FONT=Verdana][/FONT]
[FONT=Verdana]Thx,[/FONT]

[gloerick]

I also just tried the info from https://www.zen-cart.com/tutorials/i...hp?article=409

but it errored

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);

[gloerick]

ok, I did each of the two INSERT INTO seperatly and it added
so I set the free shipping mod to the lower 48 zone,

now NO shipping rates are shown for items with free shipping to NON 48 states, ie alaska, hawaii and such

seems the free shipping is OFF for the free shipping items ? outside the 48.

[gloerick]

free shipping is yellow ? what is that ?

[Ajeh]

What shipping modules do you have installed?

What are you using for Free Shipping?

Modules ... Shipping ...
Free Shipping Options freeoptions
-- OR --
FREE SHIPPING! freeshipper

Modules ... Order Totals ...
Shipping ot_shipping

where Free Shipping is enabled for over an amount?

How is Free Shipping indicated?

0 Weight?

Always Free Shipping?

Have you ever touched or customized the:
/includes/classes/shipping.php

We need more details than what you are providing ...

[gloerick]

Hi,

I have fedex express and ground, UPS, USPS both for the 1.5v and the FREE SHIPPING! freeshipper. all green but for the free shipping.

no amount for free shipping, just checked the free shipping in the items setup properties.

all items have weight.

indicated ? Yes, Always Free Shipping in the properties.

not that I know of for editing the shipping.php

ot_shipping = 200 and had 50 for the total, set to 0 and no change.
this did not work, was giving everything free shipping

thx for the help :-)

[Ajeh]

Is there perhaps a link to your site that we could peek at?

[gloerick]

Sure, I am @ http://www.efpsupply.com
I can allow in a remote connection with teamviewer or let you in as admin ?

but I have been searching for days now, and it bit me today when Puerto rico ordered.

or I can give you the test login I use that has the different addresses.

[Ajeh]

When you have the Product marked as Always Free Shipping is that for *everyone* or just some people?