Zone table rates mod still not working as expected.

Your definitions only go to 3 ... you need either more definitions on the Zone or you need to set the last one to a higher amount such as:
100000:24.00

rather than:
3:24.00

Ajeh:

Your definitions only go to 3 ... you need either more definitions on the Zone or you need to set the last one to a higher amount such as:
100000:24.00

rather than:
3:24.00

Thank you so much. Now it is working!:clap::clap::clap::clap::clap::clap:

You are most welcome I am glad everything is with the right settings ... :smile:

Hello,

I installed Zone Table mod

I was able to increase the number of zones in my local server but it doesn't work in production server, what could I be missing?

I tried remove and reinstall in Admin page, doesn't work.

Thanks lots.

I read the code in zonetable.php, it says:

	function zonetable() {
		global $order, $db;
	
		$geozones = $db->Execute("SELECT * FROM " . TABLE_GEO_ZONES);
		$this->num_zones = $geozones->RecordCount();

so $this->num_zones should be determined by the number of records in $geozones.

I checked my TABLE_GEO_ZONES, it does have 12 record. I modified the zones.php and changes:

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

Then I go back to Admin, re-install "zone rates" in Admin/Module/Shipping, it still stay showing only 3 zones! Why?

Zone Table Rate zonetable works different than Zone Rates zones ...

The setting for:

		$this->num_zones = $geozones->RecordCount();

is built based on the number of Zone Definitions that you have defined ...

Do not change that setting ...

Rather than change it, first build all of your Zone Definitions complete with their DETAILS ...

Then, do the INSTALL of the Zone Table zonetable and you will now have enough settings for each of your Zone Definitions ...

If there are more than you need, just do not use them, as you will also have other Zone Definitions that you do not need for the shipping module ...

Ajeh:

Zone Table Rate zonetable works different than Zone Rates zones ...

The setting for:

	$this->num_zones = $geozones->RecordCount();

> 
> is built based on the number of Zone Definitions that you have defined ...
> 
> Do not change that setting ...
> 
> Rather than change it, first build all of your Zone Definitions complete with their DETAILS ...
> 
> Then, do the INSTALL of the Zone Table zonetable and you will now have enough settings for each of your Zone Definitions ...
> 
> If there are more than you need, just do not use them, as you will also have other Zone Definitions that you do not need for the shipping module ...

Thanks Ajeh,

Actually I found where the problem is:

In admin, the option of "Zone Table Rate" doesn't show up at all!!! The one shows up is "Zone Rates" - which is totally different!!!

But why "Zone Table Rate" doesn't show up? did I miss any steps?

Sorry for posting this "stupid" question, it works on my local and I can't recall what's the difference of the two installation and configuration.

Thank you very much for your patient and kind help. I need this to be fixed as early as I can.

Using your FTP program looks to see if the files:
/includes/modules/shipping/zonetable.php
/includes/languages/english/modules/shipping/zonetable.php

are on the server ...

When you go in the Admin to Modules ... Shipping ... do you see all of

1 the list shipping modules

2 the right side panel

3 the bottom line that reads similar to:
Module Directory: /home/yourusername/public_html/your_directory/includes/modules/shipping/

Ajeh:

Using your FTP program looks to see if the files:
/includes/modules/shipping/zonetable.php
/includes/languages/english/modules/shipping/zonetable.php

are on the server ...

When you go in the Admin to Modules ... Shipping ... do you see all of

1 the list shipping modules

2 the right side panel

3 the bottom line that reads similar to:
Module Directory: /home/yourusername/public_html/your_directory/includes/modules/shipping/

Thanks.

Both the two files are on server.

The list of shipping modules just doesn't show Zone Table Rate, please see the screenshot. I don't recall there is any place I need to do in Admin to add the Zone Table Rate there, do I?

Check the file, on the server, for:
/includes/modules/shipping/zonetable.php

if you view the file does it have CODE in it?

Check the file, on the server, for:
/includes/languages/english/modules/shipping/zonetable.php

if you view the file does it have DEFINE statements in it?

Check the directory, on the server, for"
/cache

refresh it and see if you have any new debug logs ...

Have you made any changes to the file:
/includes/modules/shipping/zonetable.php

Ajeh:

Check the file, on the server, for:
/includes/modules/shipping/zonetable.php

if you view the file does it have CODE in it?

Check the file, on the server, for:
/includes/languages/english/modules/shipping/zonetable.php

if you view the file does it have DEFINE statements in it?

Check the directory, on the server, for"
/cache

refresh it and see if you have any new debug logs ...

Have you made any changes to the file:
/includes/modules/shipping/zonetable.php

zonetable.php's content: (the other one has far more code in it, I didn't touch both, they are both the origin files from the mod)

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers                           |
// |                                                                      |   
// | http://www.zen-cart.com/index.php                                    |   
// |                                                                      |   
// | Portions Copyright (c) 2003 osCommerce                               |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
// $Id: zonetable.php 1969 2007-08-17 06:57:21Z surf7.net $
//

define('MODULE_SHIPPING_ZONETABLE_TEXT_TITLE', 'Zones Table Rate');
define('MODULE_SHIPPING_ZONETABLE_TEXT_DESCRIPTION', 'Set separate table rate for different shipping zones');
define('MODULE_SHIPPING_ZONETABLE_TEXT_WAY', '');
define('MODULE_SHIPPING_ZONETABLE_TEXT_WEIGHT', 'Weight');
define('MODULE_SHIPPING_ZONETABLE_TEXT_AMOUNT', 'Amount');
?>

cache folder:

installerConfigKeys|a:1:{s:8:"language";s:7:"english";}logfilename|s:27:"Oct-27-2010_08-38-55-h2jhEd";installerConfigInfo|a:0:{}

I might have to leave after 10:30am but will return in the afternoon maybe 3pm, if you didn't hear me responding you, that's because I am not home.

Thank you very much Linda, I can't describe how it is appreciated.

That is the language file ...

Do you have a code file in:
/includes/modules/shipping/zonetable.php

Ajeh:

That is the language file ...

Do you have a code file in:
/includes/modules/shipping/zonetable.php

Yes, it is the original file, I forgot to mention initially but I later updated my post, you probably didn't notice that, sorry. I have uploaded the file here.

It just sounds like you do not have the files in the right directories if they are not loading ...

You see the CODE file in:
/includes/modules/shipping/zonetable.php

where you see the:
/includes/modules/shipping/flat.php
/includes/modules/shipping/freeoptions.php
/includes/modules/shipping/freeshipper.php
/includes/modules/shipping/item.php
etc. etc. ... correct?

Ajeh:

It just sounds like you do not have the files in the right directories if they are not loading ...

You see the CODE file in:
/includes/modules/shipping/zonetable.php

where you see the:
/includes/modules/shipping/flat.php
/includes/modules/shipping/freeoptions.php
/includes/modules/shipping/freeshipper.php
/includes/modules/shipping/item.php
etc. etc. ... correct?

The zonetable.php does exist in the same folder like all the other shipping modules, please see the attachments.

Thanks.

Can you check if you have two directories for zen cart?

It looks from your FTP that the files are in:
/public_html/includes/modules

but your admin looks like it is looking in:
/public_html/ibnest/includes/modules

NOTE: I may not have the spelling right for ibnest as I cannot read that image well ...

Hi Linda,

Thanks for all the effort and patience on helping me out of this mist:

I figured out what's the problem:

On the server: for unknown reason there are duplicated file structure, I should look for \public_html\mywebsite...., but the mod was installed on to \public_html

So that's why I don't see the option appears in Shipping option.

Sorry for wasting you so much time:blush::blush::blush:

Heartiest thank to you. ::hug::hug::hug:

Thanks for the update that you were able to sort this out ... :lamo:

Hello,

Couple days ago I posted a question regards to set up different zones for Canadian users, the shipping mod I am using is Zone Table Rates.

I finally get the mod set up on prod with the help of Ajeh (big thanks)

However, today I found there are still problems!

1. I set different rates for different Zones, for example:

AB: 1:20.00,2:35.00, 3:45.00, 10000:45.00
NB: 1:20.00,2:35.00, 3:45.00, 10000:45.00
QC: 1:16.00,2:28.00, 3:36.00, 10000:36.00
BC: 1:22.00,2:38.00, 3:49.00, 10000:49.00
ON: 1:8.00,2:14.00, 3:18.00, 10000:18.00

Using one item as example, presumably the shipping cost should be $8 if customer is from ON, and so on.

However, it automatically adds up little amount to $8.83 instead of $8.00, for two items it would be $15.46 instead of $14.00.

Where is the little amount from? Thanks.

2. For unknown reason, the system doesn't really recognize the customer's postcode because it mess up some zones:

MB: used AB
NB: used YT
NFL: used YT
NS: used YT
PEI: used AB
QC: used AB
SK: used AB
YT: used AB

From the screenshot you will see it does recognize MB postcode but uses AB's rate instead.

How do I troubleshoot this issue?

Thank you very much.
How can this happen and how to fix it?

You can visit the prod to see what's going on there.

The module takes the Total not the individual Products ...

Also see if you have Tax setup on the shipping module ...