Need Shipping Zone Help...

[hammertoe27]

Basically, I want to give free shipping in US and Canada and charge a flat rate everywhere else internationally. So as I understand it, set up two shipping zones. I am changing $this->num_zones = 1 to $this->num_zones = 2 in catalog//includes/modules/shipping. But when I go to modules/shipping and zone rates to set up the second zone, the only change that occurs is three new blank untitled fields that appear under Zone 1 handling fee. This isn't fitting the description that I've read about. Please Help!

[satish]

try multiple shipping zone contrib.

 

Satish

[Guest]

Basically, I want to give free shipping in US and Canada and charge a flat rate everywhere else internationally. So as I understand it, set up two shipping zones. I am changing $this->num_zones = 1 to $this->num_zones = 2 in catalog//includes/modules/shipping. But when I go to modules/shipping and zone rates to set up the second zone, the only change that occurs is three new blank untitled fields that appear under Zone 1 handling fee. This isn't fitting the description that I've read about. Please Help!

Make sure you unistalled the shipping module first then change the code and finally re-install it.

[hammertoe27]

Make sure you unistalled the shipping module first then change the code and finally re-install it.

 

Mark, thanks for the lead. I should have expressed the fact that I don't know what the heck I'm doing, and I'm trying to do it without having my hand held. By uninstalling the shipping module I assumed you meant removing the zone rates module, which I did, and then reinstalled it with a 2 in the zones code.

 

But I'm getting this error on the shipping module under zones: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'True', 'False'), ', now())' at line 1

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())

 

I can't find an error 1064 anywhere in the help sections, let alone finding a manual, to guide me. And helping myself is digging a deeper hole. Any advice would be greatly appreciated!

[Guest]

Mark, thanks for the lead. I should have expressed the fact that I don't know what the heck I'm doing, and I'm trying to do it without having my hand held. By uninstalling the shipping module I assumed you meant removing the zone rates module, which I did, and then reinstalled it with a 2 in the zones code.

 

But I'm getting this error on the shipping module under zones: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'True', 'False'), ', now())' at line 1

 

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())

 

I can't find an error 1064 anywhere in the help sections, let alone finding a manual, to guide me. And helping myself is digging a deeper hole. Any advice would be greatly appreciated!

you can always try the original osc file from the downloads

http://www.oscommerce.com/solutions/downloads

 

when you edit files use a regular editor, download the file from the server using an ftp tool edit it, then re-upload it. Do not edit php files on-line. The particular error comes from the mysql engine.

 

By the term installing/uninstalling I mentioned earlier, I meant via the osc Admin install/uninstall buttons for the shipping module

[hammertoe27]

you can always try the original osc file from the downloads

http://www.oscommerce.com/solutions/downloads

 

when you edit files use a regular editor, download the file from the server using an ftp tool edit it, then re-upload it. Do not edit php files on-line. The particular error comes from the mysql engine.

 

By the term installing/uninstalling I mentioned earlier, I meant via the osc Admin install/uninstall buttons for the shipping module

 

Thanks for the assistance. Here's what I did: I restored a recent backup file--in that zones.php file I had already changed the number of zones from 1 to 2 and it gave me 3 blank fields that should be for zone 2 but contains no headings. This time I edited the zones.php file using the FTP text editor instead of online . I removed the shipping zones module and then I installed it. I still got the SQL error when installed. I can't figure this one out and I don't know what other options to try. Is there anything else I can try?

[Guest]

Thanks for the assistance. Here's what I did: I restored a recent backup file--in that zones.php file I had already changed the number of zones from 1 to 2 and it gave me 3 blank fields that should be for zone 2 but contains no headings. This time I edited the zones.php file using the FTP text editor instead of online . I removed the shipping zones module and then I installed it. I still got the SQL error when installed. I can't figure this one out and I don't know what other options to try. Is there anything else I can try?

Can you post the zones.php file you're using? (the one that gives the error).

[hammertoe27]

Can you post the zones.php file you're using? (the one that gives the error).

 

No problem--thanks for looking at it...

 

<?php

/*

 

$Id: zones.php,v 1.20 2003/06/15 19:48:09 thomasamoulton Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

 

USAGE

By default, the module comes with support for 1 zone. This can be

easily changed by editing the line below in the zones constructor

that defines $this->num_zones.

 

Next, you will want to activate the module by going to the Admin screen,

clicking on Modules, then clicking on Shipping. A list of all shipping

modules should appear. Click on the green dot next to the one labeled

zones.php. A list of settings will appear to the right. Click on the

Edit button.

 

PLEASE NOTE THAT YOU WILL LOSE YOUR CURRENT SHIPPING RATES AND OTHER

SETTINGS IF YOU TURN OFF THIS SHIPPING METHOD. Make sure you keep a

backup of your shipping settings somewhere at all times.

 

If you want an additional handling charge applied to orders that use this

method, set the Handling Fee field.

 

Next, you will need to define which countries are in each zone. Determining

this might take some time and effort. You should group a set of countries

that has similar shipping charges for the same weight. For instance, when

shipping from the US, the countries of Japan, Australia, New Zealand, and

Singapore have similar shipping rates. As an example, one of my customers

is using this set of zones:

1: USA

2: Canada

3: Austria, Belgium, Great Britain, France, Germany, Greenland, Iceland,

Ireland, Italy, Norway, Holland/Netherlands, Denmark, Poland, Spain,

Sweden, Switzerland, Finland, Portugal, Israel, Greece

4: Japan, Australia, New Zealand, Singapore

5: Taiwan, China, Hong Kong

 

When you enter these country lists, enter them into the Zone X Countries

fields, where "X" is the number of the zone. They should be entered as

two character ISO country codes in all capital letters. They should be

separated by commas with no spaces or other punctuation. For example:

1: US

2: CA

3: AT,BE,GB,FR,DE,GL,IS,IE,IT,NO,NL,DK,PL,ES,SE,CH,FI,PT,IL,GR

4: JP,AU,NZ,SG

5: TW,CN,HK

 

Now you need to set up the shipping rate tables for each zone. Again,

some time and effort will go into setting the appropriate rates. You

will define a set of weight ranges and the shipping price for each

range. For instance, you might want an order than weighs more than 0

and less than or equal to 3 to cost 5.50 to ship to a certain zone.

This would be defined by this: 3:5.5

 

You should combine a bunch of these rates together in a comma delimited

list and enter them into the "Zone X Shipping Table" fields where "X"

is the zone number. For example, this might be used for Zone 1:

1:3.5,2:3.95,3:5.2,4:6.45,5:7.7,6:10.4,7:11.85, 8:13.3,9:14.75,10:16.2,11:17.65,

12:19.1,13:20.55,14:22,15:23.45

 

The above example includes weights over 0 and up to 15. Note that

units are not specified in this explanation since they should be

specific to your locale.

 

CAVEATS

At this time, it does not deal with weights that are above the highest amount

defined. This will probably be the next area to be improved with the

module. For now, you could have one last very high range with a very

high shipping rate to discourage orders of that magnitude. For

instance: 999:1000

 

If you want to be able to ship to any country in the world, you will

need to enter every country code into the Country fields. For most

shops, you will not want to enter every country. This is often

because of too much fraud from certain places. If a country is not

listed, then the module will add a $0.00 shipping charge and will

indicate that shipping is not available to that destination.

PLEASE NOTE THAT THE ORDER CAN STILL BE COMPLETED AND PROCESSED!

 

It appears that the osC shipping system automatically rounds the

shipping weight up to the nearest whole unit. This makes it more

difficult to design precise shipping tables. If you want to, you

can hack the shipping.php file to get rid of the rounding.

 

Lastly, there is a limit of 255 characters on each of the Zone

Shipping Tables and Zone Countries.

 

*/

 

class zones {

var $code, $title, $description, $enabled, $num_zones;

 

// class constructor

function zones() {

$this->code = 'zones';

$this->title = MODULE_SHIPPING_ZONES_TEXT_TITLE;

$this->description = MODULE_SHIPPING_ZONES_TEXT_DESCRIPTION;

$this->sort_order = MODULE_SHIPPING_ZONES_SORT_ORDER;

$this->icon = '';

$this->tax_class = MODULE_SHIPPING_ZONES_TAX_CLASS;

$this->enabled = ((MODULE_SHIPPING_ZONES_STATUS == 'True') ? true : false);

 

// CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED

$this->num_zones = 2;

}

 

// class methods

function quote($method = '') {

global $order, $shipping_weight, $shipping_num_boxes;

 

$dest_country = $order->delivery['country']['iso_code_2'];

$dest_zone = 0;

$error = false;

 

for ($i=2; $i<=$this->num_zones; $i++) {

$countries_table = constant('MODULE_SHIPPING_ZONES_COUNTRIES_' . $i);

$country_zones = split("[,]", $countries_table);

if (in_array($dest_country, $country_zones)) {

$dest_zone = $i;

break;

}

}

 

if ($dest_zone == 0) {

$error = true;

} else {

$shipping = -1;

$zones_cost = constant('MODULE_SHIPPING_ZONES_COST_' . $dest_zone);

 

$zones_table = split("[:,]" , $zones_cost);

$size = sizeof($zones_table);

for ($i=0; $i<$size; $i+=2) {

if ($shipping_weight <= $zones_table[$i]) {

$shipping = $zones_table[$i+1];

$shipping_method = MODULE_SHIPPING_ZONES_TEXT_WAY . ' ' . $dest_country . ' : ' . $shipping_weight . ' ' . MODULE_SHIPPING_ZONES_TEXT_UNITS;

break;

}

}

 

if ($shipping == -1) {

$shipping_cost = 0;

$shipping_method = MODULE_SHIPPING_ZONES_UNDEFINED_RATE;

} else {

$shipping_cost = ($shipping * $shipping_num_boxes) + constant('MODULE_SHIPPING_ZONES_HANDLING_' . $dest_zone);

}

}

 

$this->quotes = array('id' => $this->code,

'module' => MODULE_SHIPPING_ZONES_TEXT_TITLE,

'methods' => array(array('id' => $this->code,

'title' => $shipping_method,

'cost' => $shipping_cost)));

 

if ($this->tax_class > 0) {

$this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);

}

 

if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title);

 

if ($error == true) $this->quotes['error'] = MODULE_SHIPPING_ZONES_INVALID_ZONE;

 

return $this->quotes;

}

 

function check() {

if (!isset($this->_check)) {

$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES_STATUS'");

$this->_check = tep_db_num_rows($check_query);

}

return $this->_check;

}

 

function install() {

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())");

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_ZONES_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())");

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_ZONES_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");

for ($i = 2; $i <= $this->num_zones; $i++) {

$default_countries = '';

if ($i == 2) {

$default_countries = 'US,CA';

}

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Zone " . $i ." Countries', 'MODULE_SHIPPING_ZONES_COUNTRIES_" . $i ."', '" . $default_countries . "', 'Comma separated list of two character ISO country codes that are part of Zone " . $i . ".', '6', '0', now())");

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Zone " . $i ." Shipping Table', 'MODULE_SHIPPING_ZONES_COST_" . $i ."', '3:8.50,7:10.50,99:20.00', 'Shipping rates to Zone " . $i . " destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone " . $i . " destinations.', '6', '0', now())");

tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Zone " . $i ." Handling Fee', 'MODULE_SHIPPING_ZONES_HANDLING_" . $i."', '0', 'Handling Fee for this shipping zone', '6', '0', now())");

}

}

 

function remove() {

tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");

}

 

function keys() {

$keys = array('MODULE_SHIPPING_ZONES_STATUS', 'MODULE_SHIPPING_ZONES_TAX_CLASS', 'MODULE_SHIPPING_ZONES_SORT_ORDER');

 

for ($i=1; $i<=$this->num_zones; $i++) {

$keys[] = 'MODULE_SHIPPING_ZONES_COUNTRIES_' . $i;

$keys[] = 'MODULE_SHIPPING_ZONES_COST_' . $i;

$keys[] = 'MODULE_SHIPPING_ZONES_HANDLING_' . $i;

}

 

return $keys;

}

}

?>

[Guest]

ok change this line:

 

	  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())");

 

to this

	  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");

 

And I am not sure how you endup with the slashes stripped. Now if that was due to an editor (use a regular one, edit files in your local PC), it may caused other problems.

 

If that error goes away and you see another one, go back get the original files and re-do the changes with a good editor.

[hammertoe27]

ok change this line:

 

	  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())");

 

to this

	  tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");

 

And I am not sure how you endup with the slashes stripped. Now if that was due to an editor (use a regular one, edit files in your local PC), it may caused other problems.

 

If that error goes away and you see another one, go back get the original files and re-do the changes with a good editor.

 

Mark, thanks again. I'm going on vacation and won't have a chance to check this for another couple of weeks. I'll get back with you then. Thanks so much again!

[hammertoe27]

Mark, thanks again. I'm going on vacation and won't have a chance to check this for another couple of weeks. I'll get back with you then. Thanks so much again!

Mark, hi again. Just so you don't have to read thru everything again, I was the guy 2 weeks ago who was having a hard time getting multiple zones because of code errors, and you gave me the area where the code needed to be changed...I made the change in the code that you suggested, and it was right, sort of. It flip-flopped to where there are blank fields where zone 1 should be, and now there is a zone 2 below those fields (I copied and pasted the side bar to show you; the blank space below is where the blank fields are inserted). Hopefully there is a quick and easy fix on this one. Thanks!

 

Zone Rates

Enable Zones Method

Do you want to offer zone rate shipping?

 

True

False

 

Tax Class

Use the following tax class on the shipping fee.

--none--Taxable Goods

 

Sort Order

Sort order of display.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Zone 2 Countries

Comma separated list of two character ISO country codes that are part of Zone 2.

 

 

Zone 2 Shipping Table

Shipping rates to Zone 2 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 2 destinations.

 

 

Zone 2 Handling Fee

Handling Fee for this shipping zone

[Guest]

Mark, hi again. Just so you don't have to read thru everything again, I was the guy 2 weeks ago who was having a hard time getting multiple zones because of code errors, and you gave me the area where the code needed to be changed...I made the change in the code that you suggested, and it was right, sort of. It flip-flopped to where there are blank fields where zone 1 should be, and now there is a zone 2 below those fields (I copied and pasted the side bar to show you; the blank space below is where the blank fields are inserted). Hopefully there is a quick and easy fix on this one. Thanks!

 

Zone Rates

Enable Zones Method

Do you want to offer zone rate shipping?

 

True

False

 

Tax Class

Use the following tax class on the shipping fee.

--none--Taxable Goods

 

Sort Order

Sort order of display.

Zone 2 Countries

Comma separated list of two character ISO country codes that are part of Zone 2.

Zone 2 Shipping Table

Shipping rates to Zone 2 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 2 destinations.

Zone 2 Handling Fee

Handling Fee for this shipping zone

make sure you first uninstall the shipping module then do the code changes and then install it again. Because the fields are different in the database when you change the number of zones.

[hawthorn]

make sure you first uninstall the shipping module then do the code changes and then install it again. Because the fields are different in the database when you change the number of zones.

Hi, I don't know if you solved this yet, but I had a similar problem, I updated the other zones but the system wouldn't save them.

 

I had to make the following change to the modules catalog/includes/functions/compatibility.php and catalog/admin/includes/functions/compatibility.php

 

add reset ($ar) to the magic_quotes function so it looks like this..

 

function do_magic_quotes_gpc(&$ar) {

if (!is_array($ar)) return false;

 

while (list($key, $value) = each($ar)) {

if (is_array($ar[$key])) {

do_magic_quotes_gpc($ar[$key]);

} else {

$ar[$key] = addslashes($value);

}

}

reset($ar);

}

 

Works ok now.