Zones Table Rate Shipping Module

nicksc:

In my shipping modules section of the control panel, all I have enabled is "Store Pick Up" and "Zone Rates." Do I need to have the USPS module enabled?

DOY! :shocking:

It has nothing to do with USPS - I have that module on my brain.
Soooooooooo sorry!

A link to your site would help.

Try this and see what happens.
You may need to enter a ZIP code in order to get a shipping estimate returned.

or You may need to enable freeshipper.

Tina

The site is https://www.shop3smartcookies.com

I enabled the freeshipper mod, and that didn't work. The problem also isn't with the "estimate shipping" field, it's when I hit checkout, and I'm at "Step 1 of 3 - Delivery Information." It comes up with the option of "Store Pickup" and below that it says "Zone Rates" and the "No shipping available to the selected country" message.

Am I doing this the correct way by naming my Zone Definitions, and then using that name in my setup of the Zone Rates where it asks for a country code?

Just for some more info, this is what I have inserted in the Zone Rates module.

The weights/prices are just filler for now to test it out.

Zone 1 Countries
1 (This is the name of one of my Zone Definitions that I created)

Zone 1 Shipping Table
5:10,7:15,99:20.00

Zone 1 Handling Fee
0

Zone 2 Countries
2

Zone 2 Shipping Table
5:11,7:15,99:20.00

Zone 2 Handling Fee
0

Zone 3 Countries
3

Zone 3 Shipping Table
5:12,7:15,99:20.00

Do all of your products weigh 0 pounds?????

That may be the issue.

Tina

I am using this module for the first time. When using with price it works fine but whenever i use it with weight it is creating lots of problems.

I have currently only one zone and zone table is

1000:100,2000:170,3000:240

If my weight is 10 i am getting 100
If my weight is 90 i am getting 300
If my weight is 600 i am getting 1400

Can anyone suggest what is the problem??

Even my normal table rate module gives the same.

Right now everything does weigh 0 lbs. But that's not the point right now as I set one of the weights, and that is coming up properly. I have different prices set for the different zones, so it should be different when shipping to Georgia than it is to California when the weight is under 10 lbs.

Check the affect of the Shipping/Packaging settings and see if anything in there is throwing things off and let us know ...

I'm not sure if the last comment was for me, but if it was, then that is fine.

I guess my main question is, can you use a Zone Definition Same as a Country Code when setting up Zone Rates?

This is what it says (I'm sure you know)

"Zone 1 Countries
Comma separated list of two character ISO country codes that are part of Zone 1.
Set as 00 to indicate all two character ISO country codes that are not specifically defined."

And inside the text box below that I put "1" b/c I created a Zone Definition and named it "1." 1 contains nine different states.

If I can't do this, then how do I use that Zone definition... or if I am doing it wrong, how would I setup those 9 states to have a set shipping rate, then setup other states to have another?

Ajeh:

Check the affect of the Shipping/Packaging settings and see if anything in there is throwing things off and let us know ...

Thanks buddy it worked!!! Just problem with shipping and packaging configuration.

Thanks for helping.

I guess that wasn't for me :(

How do I add extra zones? I have setup 9 zones but the zonetable module defaults to allow only 7?

If you made the Zones after installing, you will want to EDIT and save your settings, then REMOVE and INSTALL ... then reconfigure it ...

In my 'Shopping Cart' page I recieve:

Warning: shipping::include_once(includes/languages/english/modules/shipping/zonetable.php) [function.shipping-include-once]: failed to open stream: No such file or directory in /home/reverse/public_html/catalog/includes/classes/shipping.php on line 44

Warning: shipping::include_once() [function.include]: Failed opening 'includes/languages/english/modules/shipping/zonetable.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/reverse/public_html/catalog/includes/classes/shipping.php on line 44

Can anybody help me out please. I am trying to set up separate pricing for 7 states in Australia.

Cannot go beyond 3 zones. Iniatially i created 12 zones for Malaysia. When i insert the shipping rates into the 12 zones. It cannot work. Then i slowly removed each one and only 3 zones left, and it works. This is the error after i enabled the 4th zone.

Warning: Variable passed to each() is not an array or object in /home/simplyvc/public_html/jintex/includes/classes/db/mysql/query_factory.php on line 114
Should i remove all zones and reinstall again.

Thanks

Hi there, I am trying to set up 3 different shipping zones:

1. NSW,ACT
   2.QLD, VIC
2. TAS,SA,NT,WA

There would be 3 different shipping prices for each zone:

1. Less than 2kg=$8.50 2-5kg=$10.00 5-10kg=$12.50
2. Less than 2kg=$10.00 2-5kg=$13.50 5-10kg=$20.00
3. Less than 2kg=$11.50 2-5kg=$23.00 5-10kg=$35.00

There will also be a $5 handling fee for each order.
Can anyone please help me thanks...Im sure theres an easy way but im probably confusing myself???

I tried removing all the zones that i setup and remove zones table rates. I Ftp the contribution again and setup the zones defintions again. Then i install zones table rates again and insert all the shipping rates again. But still nor working. I cannot go beyond 4th zones. The first 3 works. After inserting the 4th error as follow :

Warning: Variable passed to each() is not an array or object in /home/simplyvc/public_html/jintex/includes/classes/db/mysql/query_factory.php on line 114

Thanks
Kevin

Now, i have ran out of ideas. No matter what i do, it still not working. Just now i created 14 zones and in zones table rate, it appeared , so i put in the shipping rates, then viola.... not working. This is the error in my index page:

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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLA
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20080902 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

I think i suspect is the version of my SQL in my server. It's version [MySQL 4.0.27-standard]. Does it requires version 5.0?

I just disabled it for the time being.

Thanks
Kevin

Please ignore this post, I have found a solution after having read other post in this thread.

Original question: "Hi, how can i increase the number of 'Shipping Zone' from default 4 to 20? could you please advise which file or code to tweak, thank you in advance!!!"

This may have been entered somewhere, but I have spent a whole day searching the forum to no avail.....

I need to increase the maximum characters in the zone shipping tables and zone countries, but cannot find how.

All the FAQ says is "Lastly, there is a limit of 255 characters on each of the Zone Shipping Tables and Zone Countries. This can be changed in the database to suit your needs."

I have looked through the db but cannot see where the shipping is configured (or even where the tables have to go:frusty:

I am using version 1.3.8a and wishing I had never upgraded....

Actually, the limit was removed in v1.3.7 or v1.3.8 ...

You will see it if you see the:
00 means all other countries no listed

If you don't see that, first, save all settings to NotePad, as all settings will be lost, and REMOVE, INSTALL and configure ...