Zen Cart Logo

Per item two zones?

Locked

Views: 874

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
23 Sep 2009, 9:49 PM
#1
lisel avatar

lisel

New Zenner

Join Date:
Sep 2009
Posts:
5
Plugin Contributions:
0

Per item two zones?

Hi - I am very much a newbie doing my first Zen Cart installation.

My client has two shipping rates on a per-item basis - one domestic and one international. I figured out this means I need to use zones. However, under the zones panel, I am not seeing the means to set differing per item rates. I see that I can select to calculate based on items, but it looks like I have to create a table for a rate for each number of items possible. (i.e. one rate for 5 or less items, another for 5 - 8 items, etc). I just need to set $1 per item (plus handling) for US orders and $2 per item (plus handling) for non-US. Do I really need to create at table that says 1 item is $1, 2 items are $2 ...100 items are $100?

Thanks!

25 Sep 2009, 2:33 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Per item two zones?

What would work better is to clone the Item Rate item shipping module and then build two Zones, one for:
United States All Zones

and one for the Rest of the World excluding the United States ...

Building the Rest of the World can be time consuming but this will build it quickly for you:

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added)
VALUES (20, 'Not US', 'All Countries Except the US', NULL, CURDATE());

INSERT INTO zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added)
SELECT countries_id , 0, 20, CURDATE()
FROM countries
WHERE countries_iso_code_3 != 'USA';

Back up your database and then that SQL code can be run in your Tools ... Install SQL Patches ... in your Zen Cart Admin to make a new Zone called All Countries Except the US that includes everything except the United States ...

To learn more on Cloning the Item Rate item shipping module, do a search on:
clone item
clone flat

for numerous examples ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!