Different maximum shipping weights for different shipping modules

[inder]

I do not know why you have this code in the Zone Rate zones shipping module:

// disable only when entire cart is free shipping
    if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_PERWEIGHTUNIT_STATUS == 'True') ? true : false);
    }

you should have in the Zone Rate zones just the new code in Red:

      // disable only when entire cart is free shipping
      if (zen_get_shipping_enabled($this->code)) {
        $this->enabled = ((MODULE_SHIPPING_ZONES_STATUS == 'True') ? true : false);
      }


// bof: turn off for weight over 2
      if (!IS_ADMIN_FLAG) {
        global $cart;
        if ($_SESSION['cart']->show_weight() > 2) {
          $this->enabled = false;
        }
      }
// eof: turn off for weight over 2

      // CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES NEEDED
      $this->num_zones = 3;

thank you Ajeh for quick response...

yes....I have same code as you told me in RED...

I have two type of shipping one for bigger orders and it is expensive and 2nd for less than 2 kgs is cheap shipping

when customers select cheap shipping and press next for checkout...on the next page total shows expensive shipping added in the invoice....

I mean it ignores the cheap selection and shows only expensive shipping on the payment information page...

I hope this time I m successful to explain you and you can guide me....

[Ajeh]

Not really ... what is the URL to your site so we can see what it is doing ...

[inder]

Not really ... what is the URL to your site so we can see what it is doing ...

thank you Ajeh....this http://zenithecig.com

cheap shipping has 2 kg limit....


thank you again for all support and quick responses....

[Ajeh]

What shipping module are you using for:
Register Mail Shipping

What is the name of the shipping file?

Where did you get this shipping module?

Do you have code changes in this file?

[inder]

What shipping module are you using for:
Register Mail Shipping

What is the name of the shipping file?

Where did you get this shipping module?

Do you have code changes in this file?

Module is multiple_shipping_zone_module_1.0,0 or you can say it is clone of zone shipping and file name is zone.php..

so far i have added below code only...and it is working perfectly fine,,


// bof: turn off for weight over 2
if (!IS_ADMIN_FLAG) {
global $cart;
if ($_SESSION['cart']->show_weight() > 2) {
$this->enabled = false;
}
}
// eof: turn off for weight over 2

[Ajeh]

Is this the filename?
multiple_shipping_zone_module_1.0,0.php

Where did you get it? How can I physically get that file?

IF you cloned the file, what is the filename and what are the contents of the code in the directory:
/includes/modules/shipping

for this file?

[inder]

Is this the filename?
multiple_shipping_zone_module_1.0,0.php

Where did you get it? How can I physically get that file?

IF you cloned the file, what is the filename and what are the contents of the code in the directory:
/includes/modules/shipping

for this file?

includes/modules/shipping/zones_5.php


<?php
/**
* @package shippingMethod
* @copyright Copyright 2003-2009 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: zones_5.php 2010-08-16 11:20:16Z totalsam $
* @modifications for allowing multiple zones rates modules to be used on one store
*/
/*

USAGE
By default, the module comes with support for 3 zones_5. This can be
easily changed by editing the line below in the zones_5 constructor
that defines $this->num_zones_5.

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_5.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_5:
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_5 {
var $code, $title, $description, $enabled, $num_zones_5;

// class constructor
function zones_5() {
$this->code = 'zones_5';
$this->title = MODULE_SHIPPING_ZONES_5_TEXT_TITLE;
$this->description = MODULE_SHIPPING_ZONES_5_TEXT_DESCRIPTION;
$this->sort_order = MODULE_SHIPPING_ZONES_5_SORT_ORDER;
$this->icon = '';
$this->tax_class = MODULE_SHIPPING_ZONES_5_TAX_CLASS;
$this->tax_basis = MODULE_SHIPPING_ZONES_5_TAX_BASIS;

// disable only when entire cart is free shipping
if (zen_get_shipping_enabled($this->code)) {
$this->enabled = ((MODULE_SHIPPING_ZONES_5_STATUS == 'True') ? true : false);
}

// bof: do not show if weight > 2
global $cart;
if (!IS_ADMIN_FLAG && $_SESSION['cart']->weight > 2) {
$this->enabled = false;
}
// eof: do not show if weight > 2



// CUSTOMIZE THIS SETTING FOR THE NUMBER OF ZONES_5 NEEDED
$this->num_zones_5 = 3;

if (IS_ADMIN_FLAG === true) {
// build in admin only additional zones_5 if missing in the configuration table due to customization of default $this->num_zones_5 = 3
global $db;
for ($i = 1; $i <= $this->num_zones_5; $i++) {
$check = $db->Execute("select * from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES_5_COUNTRIES_" . $i . "'");
if ($this->enabled && $check->EOF) {
$default_countries = '';
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Countries', 'MODULE_SHIPPING_ZONES_5_COUNTRIES_" . $i ."', '" . $default_countries . "', 'Comma separated list of two character ISO country codes that are part of Zone " . $i . ".<br />Set as 00 to indicate all two character ISO country codes that are not specifically defined.', '6', '0', 'zen_cfg_textarea(', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Shipping Table', 'MODULE_SHIPPING_ZONES_5_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/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone " . $i . " destinations.<br />You can end the last amount as 10000:7% to charge 7% of the Order Total', '6', '0', 'zen_cfg_textarea(', now())");
$db->Execute("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_5_HANDLING_" . $i."', '0', 'Handling Fee for this shipping zone', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box Zone " . $i . " (when by weight)' , 'MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_" . $i."', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");
}
}
} // build in admin only

if ($this->enabled) {
global $db;
for ($i = 1; $i <= $this->num_zones_5; $i++) {
// check MODULE_SHIPPING_TABLE_HANDLING_METHOD is in
$check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_" . $i . "'");
if ($check_query->EOF) {
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box Zone " . $i . " (when by weight)' , 'MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_" . $i."', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");
}
}
}
}

// class methods
function quote($method = '') {
global $order, $shipping_weight, $shipping_num_boxes, $total_count;
$dest_country = $order->delivery['country']['iso_code_5'];
$dest_zone = 0;
$error = false;

$order_total_amount = $_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices() ;

for ($i=1; $i<=$this->num_zones_5; $i++) {
$countries_table = constant('MODULE_SHIPPING_ZONES_5_COUNTRIES_' . $i);
$countries_table = strtoupper(str_replace(' ', '', $countries_table));
$country_zones_5 = preg_split("/[,]/", $countries_table);
if (in_array($dest_country, $country_zones_5)) {
$dest_zone = $i;
break;
}
if (in_array('00', $country_zones_5)) {
$dest_zone = $i;
break;
}
}

if ($dest_zone == 0) {
$error = true;
} else {
$shipping = -1;
$zones_5_cost = constant('MODULE_SHIPPING_ZONES_5_COST_' . $dest_zone);

$zones_5_table = preg_split("/[:,]/" , $zones_5_cost);
$size = sizeof($zones_5_table);
$done = false;
for ($i=0; $i<$size; $i+=2) {
switch (MODULE_SHIPPING_ZONES_5_METHOD) {
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Weight'):
if (round($shipping_weight,9) <= $zones_5_table[$i]) {
$shipping = $zones_5_table[$i+1];

switch (SHIPPING_BOX_WEIGHT_DISPLAY) {
case (0):
$show_box_weight = '';
break;
case (1):
$show_box_weight = ' (' . $shipping_num_boxes . ' ' . TEXT_SHIPPING_BOXES . ')';
break;
case (2):
$show_box_weight = ' (' . number_format($shipping_weight * $shipping_num_boxes,2) . MODULE_SHIPPING_ZONES_5_TEXT_UNITS . ')';
break;
default:
$show_box_weight = ' (' . $shipping_num_boxes . ' x ' . number_format($shipping_weight,2) . MODULE_SHIPPING_ZONES_5_TEXT_UNITS . ')';
break;
}

// $shipping_method = MODULE_SHIPPING_ZONES_5_TEXT_WAY . ' ' . $dest_country . (SHIPPING_BOX_WEIGHT_DISPLAY >= 2 ? ' : ' . $shipping_weight . ' ' . MODULE_SHIPPING_ZONES_5_TEXT_UNITS : '');
$shipping_method = MODULE_SHIPPING_ZONES_5_TEXT_WAY . ' ' . $dest_country . $show_box_weight;
$done = true;
if (strstr($zones_5_table[$i+1], '%')) {
$shipping = ($zones_5_table[$i+1]/100) * $order_total_amount;
} else {
$shipping = $zones_5_table[$i+1];
}
break;
}
break;
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Price'):
// shipping adjustment
if (($_SESSION['cart']->show_total() - $_SESSION['cart']->free_shipping_prices()) <= $zones_5_table[$i]) {
$shipping = $zones_5_table[$i+1];
$shipping_method = MODULE_SHIPPING_ZONES_5_TEXT_WAY . ' ' . $dest_country;
if (strstr($zones_5_table[$i+1], '%')) {
$shipping = ($zones_5_table[$i+1]/100) * $order_total_amount;
} else {
$shipping = $zones_5_table[$i+1];
}
$done = true;
break;
}
break;
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Item'):
// shipping adjustment
if (($total_count - $_SESSION['cart']->free_shipping_items()) <= $zones_5_table[$i]) {
$shipping = $zones_5_table[$i+1];
$shipping_method = MODULE_SHIPPING_ZONES_5_TEXT_WAY . ' ' . $dest_country;
$done = true;
if (strstr($zones_5_table[$i+1], '%')) {
$shipping = ($zones_5_table[$i+1]/100) * $order_total_amount;
} else {
$shipping = $zones_5_table[$i+1];
}
break;
}
break;
}
if ($done == true) {
break;
}
}

if ($shipping == -1) {
$shipping_cost = 0;
$shipping_method = MODULE_SHIPPING_ZONES_5_UNDEFINED_RATE;
} else {
switch (MODULE_SHIPPING_ZONES_5_METHOD) {
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Weight'):
// charge per box when done by Weight
// Handling fee per box or order
if (constant('MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_' . $dest_zone) == 'Box') {
$shipping_cost = ($shipping * $shipping_num_boxes) + constant('MODULE_SHIPPING_ZONES_5_HANDLING_' . $dest_zone) * $shipping_num_boxes;
} else {
$shipping_cost = ($shipping * $shipping_num_boxes) + constant('MODULE_SHIPPING_ZONES_5_HANDLING_' . $dest_zone);
}
break;
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Price'):
// don't charge per box when done by Price
$shipping_cost = ($shipping) + constant('MODULE_SHIPPING_ZONES_5_HANDLING_' . $dest_zone);
break;
case (MODULE_SHIPPING_ZONES_5_METHOD == 'Item'):
// don't charge per box when done by Item
$shipping_cost = ($shipping) + constant('MODULE_SHIPPING_ZONES_5_HANDLING_' . $dest_zone);
break;
}
}
}
$this->quotes = array('id' => $this->code,
'module' => MODULE_SHIPPING_ZONES_5_TEXT_TITLE,
'methods' => array(array('id' => $this->code,
'title' => $shipping_method,
'cost' => $shipping_cost)));

if ($this->tax_class > 0) {
$this->quotes['tax'] = zen_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']);
}

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

if (strstr(MODULE_SHIPPING_ZONES_5_SKIPPED, $dest_country)) {
// don't show anything for this country
$this->quotes = array();
} else {
if ($error == true) $this->quotes['error'] = MODULE_SHIPPING_ZONES_5_INVALID_ZONE;
}

return $this->quotes;
}

function check() {
global $db;
if (!isset($this->_check)) {
$check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES_5_STATUS'");
$this->_check = $check_query->RecordCount();
}
return $this->_check;
}

function install() {
global $db;
$db->Execute("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_5_STATUS', 'True', 'Do you want to offer zone rate shipping?', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Calculation Method', 'MODULE_SHIPPING_ZONES_5_METHOD', 'Weight', 'Calculate cost based on Weight, Price or Item?', '6', '0', 'zen_cfg_select_option(array(\'Weight\', \'Price\', \'Item\'), ', now())");
$db->Execute("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_5_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'zen_get_tax_class_title', 'zen_cfg_pull_down_tax_classes(', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Tax Basis', 'MODULE_SHIPPING_ZONES_5_TAX_BASIS', 'Shipping', 'On what basis is Shipping Tax calculated. Options are<br />Shipping - Based on customers Shipping Address<br />Billing Based on customers Billing address<br />Store - Based on Store address if Billing/Shipping Zone equals Store zone', '6', '0', 'zen_cfg_select_option(array(\'Shipping\', \'Billing\', \'Store\'), ', now())");
$db->Execute("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_5_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Skip Countries, use a comma separated list of the two character ISO country codes', 'MODULE_SHIPPING_ZONES_5_SKIPPED', '', 'Disable for the following Countries:', '6', '0', 'zen_cfg_textarea(', now())");

for ($i = 1; $i <= $this->num_zones_5; $i++) {
$default_countries = '';
if ($i == 1) {
$default_countries = 'US,CA';
}
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Countries', 'MODULE_SHIPPING_ZONES_5_COUNTRIES_" . $i ."', '" . $default_countries . "', 'Comma separated list of two character ISO country codes that are part of Zone " . $i . ".<br />Set as 00 to indicate all two character ISO country codes that are not specifically defined.', '6', '0', 'zen_cfg_textarea(', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Zone " . $i ." Shipping Table', 'MODULE_SHIPPING_ZONES_5_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/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone " . $i . " destinations.<br />You can also use percentage amounts, such 25:8.50,35:5%,40:9.50,10000:7% to charge a percentage value of the Order Total', '6', '0', 'zen_cfg_textarea(', now())");
$db->Execute("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_5_HANDLING_" . $i."', '0', 'Handling Fee for this shipping zone', '6', '0', now())");

$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box Zone " . $i . " (when by weight)' , 'MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_" . $i."', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");

}
}

function remove() {
global $db;
$db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key like 'MODULE\_SHIPPING\_ZONES_5\_%'");
}

function keys() {
$keys = array('MODULE_SHIPPING_ZONES_5_STATUS', 'MODULE_SHIPPING_ZONES_5_METHOD', 'MODULE_SHIPPING_ZONES_5_TAX_CLASS', 'MODULE_SHIPPING_ZONES_5_TAX_BASIS', 'MODULE_SHIPPING_ZONES_5_SORT_ORDER', 'MODULE_SHIPPING_ZONES_5_SKIPPED');

for ($i=1; $i<=$this->num_zones_5; $i++) {
$keys[] = 'MODULE_SHIPPING_ZONES_5_COUNTRIES_' . $i;
$keys[] = 'MODULE_SHIPPING_ZONES_5_COST_' . $i;
$keys[] = 'MODULE_SHIPPING_ZONES_5_HANDLING_' . $i;
$keys[] = 'MODULE_SHIPPING_ZONES_5_HANDLING_METHOD_' . $i;
}

return $keys;
}
}
?>

[Ajeh]

You need to rename the files:
includes/modules/shipping/zones_5.php
includes/languages/english/modules/shipping/zones_5.php

to be called:
includes/modules/shipping/zones5.php
includes/languages/english/modules/shipping/zones5.php

without the underscore ...

and change the:
zone_5 to zone5
ZONE_5 to ZONE5

again without the underscore ...

Now these should work and be selectable ...

[inder]

You need to rename the files:
includes/modules/shipping/zones_5.php
includes/languages/english/modules/shipping/zones_5.php

to be called:
includes/modules/shipping/zones5.php
includes/languages/english/modules/shipping/zones5.php

without the underscore ...

and change the:
zone_5 to zone5
ZONE_5 to ZONE5

again without the underscore ...

Now these should work and be selectable ...

thank you so much for you support...and its working perfectly fine as it required...thank you again..

[Ajeh]

You are most welcome ... thanks for the update that this is working for you now ...