International Shipping

[spleen]

Hi Linda,
I figured out the country code for Canada (38) and slightly modified your script for international shipping using the zonetable rate. Following your instructions I installed the sql patch but get an error message:

1062 Duplicate entry '20' for key 1 in:
[INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (20, 'Not CA', 'All Countries Except CA', NULL, '2008-01-01 12:32:13');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas of where I went wrong?

Here is the code I was using:
INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20, 'Not CA', 'All Countries Except CA', NULL, '2008-01-01 12:32:13');

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

[Ajeh]

The value of 20 is probably being used for another zone ...

You would want to change them to 21 or whatever value is free ...

[spleen]

Thanks a lot!
The patch installed correctly, I have a "Not CA" option.
I must have some other problems since the US and International shipping prices are still not showing up. :-(

www.revglacier.com/online-store

[spleen]

Ooops, my url is www.friendsrevglacier.com/online-store

[kburner]

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

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

[Ajeh]

Thanks for the update and glad that this was able to help you ...

[Gary777]

Hi All,

I have created 4 Cloned Per Item shipping modules and have added Linda's zones via the 2 SQL INSERT statements and everything shows up and appears to be working until I try to checkout.

When I login as a customer, add an item to my cart and try to checkout I get a blank page.

Checkout works fine if I turn off all 4 of the new cloned "Per Item" modules... Does anyone have any idea why this might be happening?

Also, I noticed something interesting, if I reinstall the item.php files but keep the 4 new clones disabled the item.php module works as expected.

Zen Cart 1.3.8a
Database Patch Level: 1.3.8
Linux 2.6.24.7
PHP Version: 5.2.4 (Zend: 2.2.0)
Database: MySQL 5.0.51a-log

Any ideas?

As an aside, it dawns on me that this may not even be what I want, my client has very specific shipping options and I'm not sure the above method will work because from what I can tell the customer can pick the shipping method, we need the shipping method to be applied automatically using a flat rate "Per Item" based on whether the items are large or small:
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)

Am I using the right approach and if not how to I attach a specific shipping method to a specific product (I already figured out that I can use the weight to trick this into working, but prefer to not use weight as a customer won't understand if the weight is different than his invoice specified.

All help will be greatly appreciated!

Gary777

[Ajeh]

What happens if you remove 1 module at a time ... does it work with some or one of them?

Do you see any errors in the admin in the Modules ... Shipping ...

[Gary777]

Hi,

Thanks for the quick reply!

I tried each module 1 at a time and they all bomb the check out page, same exact thing...

When making the changes to the files I caught myself making an error (difference between Upper and Lower case "item") so I started over from scratch and made a special effort to be very careful performing the search and replace...

As I said in my post, the strange thing is that the original item module still works as expected, it's just the new clones that don't work...

Any ideas?

Thanks again,

Gary777

[Ajeh]

Sounds like typos ...

Delete from the server all of the new modules that you made and any backup files ...

What filenames are you using on these?