International Shipping

Ajeh,

You were so right! I tried very hard not to make any typos and even though you explicitly mention it in your post I still missed the following and made the typo!

$itemintlsmall_total_count = $total_count - $_SESSION['cart']->free_shipping_items();

I of course had free_shipping_itemintlsmalls() in each of the non working modules...

Thank you so much again... But now I am back to my original problem... I don't think this will work for me, I need shipping based on the size of the product, there are only two sizes, and the shipping has 2 zones, USA and INTL:

1. USA Small item $7.00 (per item)
2. USA Large item $10.00 (per item)
3. Not USA Small item: $20.00 (per item)
4. Not USA Large Item $35.00 (per item)

And I don't want the customer to have a choice (they would always choose small which is cheaper of course) but need to apply the shipping automatically to the order based on some product metric, maybe weight?

Any ideas?

Thanks again!

Gary777

IF your prices were proportional, you could use the Per Unit perweightunit shipping module where the products_weight is used to determine the shipping price ...

Example:
Small Products set weight to 7
Large Products set weight to 10

Then in the Per Unit perweightunit you would set the charge to 1.00 which would give:
$1.00 x 7 x qty = $7.00 x qty
$1.00 x 10 x qty = $10.00 x qty

Then clone that to perweightunitint and set the charge to 2.75 which would give:
$2.75 x 7 x qty = $19.25 x qty
$2.75 x 10 x qty = $27.50 x qty

But that would make your rates $19.25 and $27.50 but you could adjust the rate of 2.75 to something else to get closer to the mark ...

Then configure the shipping module to work with your zones ...

Thanks Linda,

Thanks what I figured, I was hoping there was another way...

Have a great evening!

Gary777

Well, I hope everyone can play this game. :smile:

So, here's my contribution - two lists, one for European Union and the rest of the World, enter your own lines for creating the zone Definition with your own numeric codes. Good for local European Traders.

When creating the EU list, if you want a more local definition for your own country, just remove your country from the EU zone and give it a separate shipping and tax code.

If there are any errors here let me know and I'll edit. But it looks okay from here.

------------------------------
EU List
------------------------------
INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (14, 0, 31),
(21, 0, 31),
(33, 0, 31),
(55, 0, 31),
(56, 0, 31),
(57, 0, 31),
(67, 0, 31),
(72, 0, 31),
(73, 0, 31),
(81, 0, 31),
(84, 0, 31),
(97, 0, 31),
(103, 0, 31),
(105, 0, 31),
(117, 0, 31),
(123, 0, 31),
(124, 0, 31),
(132, 0, 31),
(150, 0, 31),
(170, 0, 31),
(171, 0, 31),
(175, 0, 31),
(189, 0, 31),
(190, 0, 31),
(195, 0, 31),
(203, 0, 31),
(222, 0, 31);

------------------------------
Worldlist - All countries Except EU
------------------------------
INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1, 0, 30),
(2, 0, 30),
(3, 0, 30),
(4, 0, 30),
(5, 0, 30),
(6, 0, 30),
(7, 0, 30),
(8, 0, 30),
(9, 0, 30),
(10, 0, 30),
(11, 0, 30),
(12, 0, 30),
(13, 0, 30),
(15, 0, 30),
(16, 0, 30),
(17, 0, 30),
(18, 0, 30),
(19, 0, 30),
(20, 0, 30),
(22, 0, 30),
(23, 0, 30),
(24, 0, 30),
(25, 0, 30),
(26, 0, 30),
(27, 0, 30),
(28, 0, 30),
(29, 0, 30),
(30, 0, 30),
(31, 0, 30),
(32, 0, 30),
(34, 0, 30),
(35, 0, 30),
(36, 0, 30),
(37, 0, 30),
(38, 0, 30),
(39, 0, 30),
(40, 0, 30),
(41, 0, 30),
(42, 0, 30),
(43, 0, 30),
(44, 0, 30),
(45, 0, 30),
(46, 0, 30),
(47, 0, 30),
(48, 0, 30),
(49, 0, 30),
(50, 0, 30),
(51, 0, 30),
(52, 0, 30),
(53, 0, 30),
(54, 0, 30),
(58, 0, 30),
(59, 0, 30),
(60, 0, 30),
(61, 0, 30),
(62, 0, 30),
(63, 0, 30),
(64, 0, 30),
(65, 0, 30),
(66, 0, 30),
(68, 0, 30),
(69, 0, 30),
(70, 0, 30),
(71, 0, 30),
(74, 0, 30),
(75, 0, 30),
(76, 0, 30),
(77, 0, 30),
(78, 0, 30),
(79, 0, 30),
(80, 0, 30),
(82, 0, 30),
(83, 0, 30),
(85, 0, 30),
(86, 0, 30),
(87, 0, 30),
(88, 0, 30),
(89, 0, 30),
(90, 0, 30),
(91, 0, 30),
(92, 0, 30),
(93, 0, 30),
(94, 0, 30),
(95, 0, 30),
(96, 0, 30),
(98, 0, 30),
(99, 0, 30),
(100, 0, 30),
(101, 0, 30),
(102, 0, 30),
(104, 0, 30),
(106, 0, 30),
(107, 0, 30),
(108, 0, 30),
(109, 0, 30),
(110, 0, 30),
(111, 0, 30),
(112, 0, 30),
(113, 0, 30),
(114, 0, 30),
(115, 0, 30),
(116, 0, 30),
(118, 0, 30),
(119, 0, 30),
(120, 0, 30),
(121, 0, 30),
(122, 0, 30),
(125, 0, 30),
(126, 0, 30),
(127, 0, 30),
(128, 0, 30),
(129, 0, 30),
(130, 0, 30),
(131, 0, 30),
(133, 0, 30),
(134, 0, 30),
(135, 0, 30),
(136, 0, 30),
(137, 0, 30),
(138, 0, 30),
(139, 0, 30),
(140, 0, 30),
(141, 0, 30),
(142, 0, 30),
(143, 0, 30),
(144, 0, 30),
(145, 0, 30),
(146, 0, 30),
(147, 0, 30),
(148, 0, 30),
(149, 0, 30),
(151, 0, 30),
(152, 0, 30),
(153, 0, 30),
(154, 0, 30),
(155, 0, 30),
(156, 0, 30),
(157, 0, 30),
(158, 0, 30),
(159, 0, 30),
(160, 0, 30),
(161, 0, 30),
(162, 0, 30),
(163, 0, 30),
(164, 0, 30),
(165, 0, 30),
(166, 0, 30),
(167, 0, 30),
(168, 0, 30),
(169, 0, 30),
(172, 0, 30),
(173, 0, 30),
(174, 0, 30),
(176, 0, 30),
(177, 0, 30),
(178, 0, 30),
(179, 0, 30),
(180, 0, 30),
(181, 0, 30),
(182, 0, 30),
(183, 0, 30),
(184, 0, 30),
(185, 0, 30),
(186, 0, 30),
(187, 0, 30),
(188, 0, 30),
(191, 0, 30),
(192, 0, 30),
(193, 0, 30),
(194, 0, 30),
(196, 0, 30),
(197, 0, 30),
(198, 0, 30),
(199, 0, 30),
(200, 0, 30),
(201, 0, 30),
(202, 0, 30),
(204, 0, 30),
(205, 0, 30),
(206, 0, 30),
(207, 0, 30),
(208, 0, 30),
(209, 0, 30),
(210, 0, 30),
(211, 0, 30),
(212, 0, 30),
(213, 0, 30),
(214, 0, 30),
(215, 0, 30),
(216, 0, 30),
(217, 0, 30),
(218, 0, 30),
(219, 0, 30),
(220, 0, 30),
(221, 0, 30),
(223, 0, 30),
(224, 0, 30),
(225, 0, 30),
(226, 0, 30),
(227, 0, 30),
(228, 0, 30),
(229, 0, 30),
(230, 0, 30),
(231, 0, 30),
(232, 0, 30),
(233, 0, 30),
(234, 0, 30),
(235, 0, 30),
(236, 0, 30),
(237, 0, 30),
(238, 0, 30),
(239, 0, 30),
(240, 0, 30);

:smartalec:

Thanks for the update ... these lists are very handy to have ... :smile:

Should you get the time, building them into a contribution makes it easier for people to find them ... now wouldn't that be fun to make ... :cool:

Does anyone have an SQL for creating a 48-state US zone (no armed forces, puerto rico , hawaii, or alaska )?
If nobody has it, i guess i'll have to make one :)

Ok. Here's my contribution.

Continuous 48 states:

INSERT INTO `zen_geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (30, 'US - 48 states', 'Continuous 48 states', NULL, '2008-11-25');

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

If you'd like to add some , but not the rest of the US Zones, you'll need to add the following lines to the above insert statement (just what's in the parenthesis):

(223,6, 30), AF Armed Forces Africa
(223,7, 30), AA Armed Forces Americas
(223,8, 30), AC Armed Forces Canada
(223,9, 30), AE Armed Forces Europe
(223,10, 30), AM Armed Forces Middle East
(223,11, 30), AP Armed Forces Pacific
(223,2, 30), AK Alaska
(223,17, 30), FM Federated States Of Micronesia
(223,20, 30), GU Guam
(223,21, 30), HI Hawaii
(223,30, 30), MH Marshall Islands
(223,46, 30), MP Northern Mariana Islands
(223,52, 30), PR Puerto Rico
(223,3, 30), AS American Samoa
(223,60, 30), VI Virgin Islands

In another thread I asked this question about shipping to the contiguous 48 by UPS yet onlyoffering all others US Postal.

The answer I received was to create a zone for each.

My question to you great folks who know all of this stuff is this:

Of the lists posted, if I were to use the one of the 48 contiguous states for UPS only, would I somehow insert that into the UPS shipping module? If so, how would I do that?

Then do I find a list of non 48 such as international and US territories into the US Postal module? Again, how would I do that?

However, if I do this, will it discontnue to offer my international customers the use of UPS Expedited and such?

Maybe what I'm wanting to do is a little too ambitious. I want to offer everyone outside of the contiguous 48 both USPS and UPS but not offer the contiguous 48 USPS rather just UPS.

Or maybe I should get used to going to the post office.

Thanks,

Whips

Interesting question.

Certainly you can set up separate definition zones for the different lists you want to ship to, but the issue arises when you have a zone in two lists. I can't remember from my recent experience (been a very busy time) whether your customer will then have two shipping choices on an order, or it creates a conflict.

I suggest try it out with just a couple of zones and a few test orders to see what happens. Then, if it works they way you wish you can take the lists on this thread or create your own.

:lookaroun

Hopefully I am in the right place, and asking the right question.

I need two table rates, one for Australia, and one for the rest of the world. Basically any order up to x$ is charged at a flat rate which will depend on whether it is being shipped Australia wide, or internationally.

The x$ figure will be different for Australia and international, but after that order amount is reached the shipping would be free.

Example Australian order up to $750 is $20 shipping flat rate, $751+ and shipping is free. International order up to $1000 is $40 after $1001 order value international shipping is free.

I note the sql inserts for other places earlier in this thread and hoping someone has done the same thing for Australia vs the rest of the world.

Cheers

Anna718:

Hopefully I am in the right place, and asking the right question.

I need two table rates, one for Australia, and one for the rest of the world...

I note the sql inserts for other places earlier in this thread and hoping someone has done the same thing for Australia vs the rest of the world.

Cheers

Try modifying this element (it's on page three of this thread) All Except UK.

You will need to insert the UK code and remove the Australian code(s). Then just create a separate Definition Zone for the Australian States.

Have fun.

:smartalec:

You could use Zone Rates and set them up so that AU gets one rate and 00, for anything not defined, gets another rate ...

Thanks for the suggestions. Will give those a try.

kburner:

I installed the SQL patch from Ajeh (Thank you!:clap:)

I took your advice from another post....thanks again. Kim:clap:

I loaded the sql patch some time ago. It went great. I have domestic and international setup with the shipping. Domestic is in the table rate base and international set with weight with Zone Rate mod I loaded.

My site just went live and I am finding that the international shipping is on every order and the customer has to click on best rate to get their domestic table rate. I thought shipping checked for domestic or interna'l in address. Is there some kind of default because every domestic (US) order I try and get feedback from customers hit the (International) zone rate with weight.

Any help would be greatly appreciated.
Thanks, Kim

Ajeh:

You could use Zone Rates and set them up so that AU gets one rate and 00, for anything not defined, gets another rate ...

Oops! I forgot about that one - much simpler!

:blush:

Kinda liked it when I added it a version or so ago ... I so hated building a Zone for everything under the sun ... :cool:

Hope this works happily for you ...

kburner:

I loaded the sql patch some time ago. It went great. I have domestic and international setup with the shipping. Domestic is in the table rate base and international set with weight with Zone Rate mod I loaded.

My site just went live and I am finding that the international shipping is on every order and the customer has to click on best rate to get their domestic table rate. I thought shipping checked for domestic or interna'l in address. Is there some kind of default because every domestic (US) order I try and get feedback from customers hit the (International) zone rate with weight.

Any help would be greatly appreciated.
Thanks, Kim

Does anyone know how to fix this? It is charging International fees to customers that are login with US address. Customer has to go further down page to click best way. I have lost several customers due to thinking they are getting more expensive charge.
:frusty:

How do you have the Zone Rate zones configured that your International Shipping is showing for the US?

Did you define your Zones for the rest of the world, excluding the US?

NOTE: the simple way to do this on Zone Rate zones ...

Set the SKIP to US ..

Set the Zone 1 to 00 for Everyone else ...

All done ... :smile:

Ajeh:

How do you have the Zone Rate zones configured that your International Shipping is showing for the US?

Did you define your Zones for the rest of the world, excluding the US?

I set zone definitions with MI (for tax), Not US (all countries except US) and US (all US).

Kim