My zone rates is not working

Hi everyone..i've tried look up all over the thread, but didn't found the ones error like mines. I am from malaysia, and would like to declare Zone Based Rates for three zones - peninsular, sabah & sarawak.

I had put the codes as PEN, SH & SWK into zones definitions. Which one is my error actually as estimate shipping appears that my zone rates is not working:

Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes

Zone 1 Countries
MY,PEN

Zone 1 Shipping Table
1.1:6.00,1.54:7.00,2.2:9.00

Zone 1 Handling Fee
0

Zone 2 Countries
MY,SH

Zone 2 Shipping Table
1.1:9.00,1.54:11.00,2.2:13.00

Zone 2 Handling Fee
0

Zone 3 Countries
MY,SWK

Zone 3 Shipping Table
1.1:9.00,1.54:11.00,2.2:13.00 //copy from zone 2, will edit charges soon

Zone 3 Handling Fee
0

still waiting for helps:(

The Zone Rate zones shipping module works off the 2 character ISO code ... there is no PEN ... :unsure:

Ajeh:

The Zone Rate zones shipping module works off the 2 character ISO code ... there is no PEN ... :unsure:

actually, what should I insert...? getting confuse..huhuu:(

I have do some editing after my 1st posting..now, it goes like this,

I have assign this in Zones:

Malaysia Johor JHR
Malaysia Kedah KED
Malaysia Kelantan KEL
Malaysia Kuala Lumpur KUL
Malaysia Labuan WPL
Malaysia Melaka MLK
Malaysia Negeri Sembilan NS
Malaysia Pahang PHG
Malaysia Penang PEN
Malaysia Perak PRK
Malaysia Perlis PER
Malaysia Putrajaya WPP
Malaysia Sabah SH
Malaysia Sarawak SWK
Malaysia Selangor SGR
Malaysia Terengganu TER

Then in Zones Definition:

(Zone Name), (Zone Description)
East Malaysia, Peninsular (Number of Zones : 13)
Sabah, Borneo (Number of Zones : 2)
Sarawak, Borneo (Number of Zones : 1)

This is what I have assgin...

Then in the above posting (my 1st posting), what should I insert under zone actually?

Thanks in advance for anyone's answer

my ZC version:
Zen Cart v1.3.8a/v1.3.8

There are both the 2 character and 3 character ISO codes in the countries table ...

However ... the Zone Rate zones shipping module only works with the 2 character ISO codes for each country ... and does not let you break out more specifically within a country, such as state or region ...

What might work better for you is to build the New Zones and use the Free Software Add On for the Zone Table that lets you build Zone Definitions for your Zones ...

Ajeh:

There are both the 2 character and 3 character ISO codes in the countries table ...

However ... the Zone Rate zones shipping module only works with the 2 character ISO codes for each country ... and does not let you break out more specifically within a country, such as state or region ...

What might work better for you is to build the New Zones and use the Free Software Add On for the Zone Table that lets you build Zone Definitions for your Zones ...

May I get some idea on how to build the New Zones and where can I get the Free Software Add On for theZone Table?

Thanks in advance:smile:

If you go to the Free Shipping Add Ons at the top of the screen and do a search on:
Zone Table

you should see a link to both the Zones Table Rate (for Multiple Zones) and a link to a Zone for Malaysia ...

From that, you can build your Zone Definitions to specific regions ...

Ajeh:

If you go to the Free Shipping Add Ons at the top of the screen and do a search on:
Zone Table

you should see a link to both the Zones Table Rate (for Multiple Zones) and a link to a Zone for Malaysia ...

From that, you can build your Zone Definitions to specific regions ...

oh..thanks Ajeh for your explanation, will try n will inform here once success:smile:

Again Ajeh, correct me if i'm wrong ya...:smile:

firstly, I hv to download (table rates for multiple zones)

Author: Surf7.net
Version: 1.1
Zen Cart™ Version: v1.3.7
Update added on Aug 19 2007
Download Now!
File size: 4575 bytes

and save the file here:

Module Directory: /home/gmuslima/public_html/includes/modules/shipping/

ok..then where should I insert:

INSERT INTO zones VALUES ('', 129, 'JO', 'Johor');
INSERT INTO zones VALUES ('', 129, 'KE', 'Kedah');
INSERT INTO zones VALUES ('', 129, 'KT', 'Kelantan');
INSERT INTO zones VALUES ('', 129, 'KL', 'Kuala Lumpur');
INSERT INTO zones VALUES ('', 129, 'LA', 'Labuan');
INSERT INTO zones VALUES ('', 129, 'ME', 'Melaka');
INSERT INTO zones VALUES ('', 129, 'NS', 'Negeri Sembilan');
INSERT INTO zones VALUES ('', 129, 'PA', 'Pahang');
INSERT INTO zones VALUES ('', 129, 'PE', 'Perak');
INSERT INTO zones VALUES ('', 129, 'PR', 'Perlis');
INSERT INTO zones VALUES ('', 129, 'PP', 'Pulau Pinang');
INSERT INTO zones VALUES ('', 129, 'PT', 'Putrajaya');
INSERT INTO zones VALUES ('', 129, 'SA', 'Sabah');
INSERT INTO zones VALUES ('', 129, 'SR', 'Sarawak');
INSERT INTO zones VALUES ('', 129, 'SE', 'Selangor');
INSERT INTO zones VALUES ('', 129, 'TE', 'Terengganu');

?

I'm a bit shame to ask such question that is maybe looks easy to others...but I hv to understand well..soon, I can help others from Malaysia too:wink:

You can either use your Zen Cart Admin and use the Tools ... Install SQL Patches ... and paste those into that ...

Or, you can run that in your phpMyAdmin for your database ...

NOTE: if you use prefixes on your database tables, in the Zen Cart Admin, these are adjusted for you ... but in phpMyAdmin, you would have have to adjust them yourself ...

NOTE: on the file that you downloaded there should be 2 files that came with it ... 1 for the code and 1 for the language file ...

still working on shipping module...hurmm:dontgetit

Is that a question or a statement? :unsure:

Hi Ajeh, I'm having a problem with zone rates too.

Zone Based Rates

Enable Zones Method
True

Calculation Method
Weight

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes

Zone 1 Countries
AR,AU,BG,BL,CA,CL,CO,CZ,DK,FR,DE,GR,HK,HU,ID,IE,IT,JP,KR,MY,MX,NL,NZ,NO,RU,SG,SI,ES,SE,CH,TW,TH,TR,GB,US,VE

Zone 1 Shipping Table
60:2.50,80:3.00,100:3.50,150:4.80,200:6.00

Zone 1 Handling Fee
0

Zone 2 Countries
SG

Zone 2 Shipping Table
100:0.60,250:0.75,500:1.10

Zone 2 Handling Fee
0

Zone 3 Countries

Zone 3 Shipping Table

Zone 3 Handling Fee
0

I only have 2 zones.
My shipping fee is not shown, is it due to the shipping/packaging part? As the packaging weight has been added to the total shipping weight, therefore do i still need to input for the package tare?

Thanks.

What are your settings on the Shipping/Packaging ...

Hi Ajeh, Appreciate your help.
I had forgotten and change the initial settings as it had given me the wrong shipping fee. Therefore, i trial and error on the settings and i input 0% + 0lbs 0:0 as i do not want to have any package tare weight added on to the shipping weight again. But, this time no shipping fee is shown.

My shipping weight is set to grams instead of lbs.

What are ALL of your settings in the Shipping/Packaging ...

What weight is the order that you are testing?

What country are you testing for?

Does it work for any countries?

Settings
Country of Origin: Singapore
Postal Code : 542188
Enter the Maximum Package Weight you will ship: Nil
Package Tare Small to Medium - added percentage:weight: 0% + 0lbs 0:0
Larger packages - added packaging percentage:weight: 0% + 0lbs 0:0
Display Number of Boxes and Weight Status: 0
Order Free Shipping 0 Weight Status: 0
Shipping Estimator Display Settings for Shopping Cart : 1
Display Order Comments on Admin Invoice: 1
Display Order Comments on Admin Packing Slip : 1

What weight is the order that you are testing? 60g

What country are you testing for? Italy (IT)

Does it work for any countries? No. All countries don't work.

Enter the Maximum Package Weight you will ship: Nil

Set this to more than the highest weight or the weight gets divided by that number to make boxes ...

Nil is a word ... so it will evaluate as 0 and not work right ...

Make sure the Tare Rates are: 0:0 ... and not text in those either ...

It works!! Thank you! :smile: