International Shipping

[Gary777]

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

[Ajeh]

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 ...

[Gary777]

Thanks Linda,

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

Have a great evening!

Gary777

[worldmaker]

Well, I hope everyone can play this game.

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

[Ajeh]

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

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 ...

[greenhat]

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

[greenhat]

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

[whippy]

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

[worldmaker]

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.

[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. 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