Region Tables 1.0.0 Released!

Hi,

We're very pleased to announce the release of Region Tables 1.2.0RC1!

The following changes and bugfixes are part of this release:

[UPDATED] COMPATIBILITY BREAK! Upper limits are now INCLUSIVE, rather than exclusive as they were previously. E.g. 100-200 now includes 200 and reads as “Weight/Price equal to 100 or above, but not over 200” (Up to and including 200).
[ADDED] Support for fallover/catchall wildcard (‘’) added for country codes.
[ADDED] A wildcard (‘’) can now be used within ranges as an upper limit of “unlimited” for weights/prices. E.g. 30-*
[ADDED] Support for Australian postcodes added (4 digit codes). No country-specific docs yet.
[BUGFIX] Problems with Shipping Estimator not displaying error messages fixed.

The new website is online!

Check it out for more info and downloads...

http://dev.ceon.net/web/zen-cart/

We hope you like this new release! (As it is a Release Candidate, not all docs are finished... the code seems fine though!).

We've received lots of suggestions for updates. We'll be posting a list of these soon to see what everyone else thinks.

If you like this module please consider donating, it will help to make developing and supporting it worthwhile! :-)

Have a good weekend!

All the best...

Conor
Ceon

Hi Conor,

I've read about the mod you've made and I like the idea very much. I haven't tested it, though. Do you think this would work well with Google Checkout?

-Pete

Hi Pete,

kebeid:

Do you think this would work well with Google Checkout?

I don't know anything about google checkout really but if it works like all the other payment modules then I don't see why there would be a problem.

If the customer has to supply a shipping address, this module will allow you to charge them for shipping, irrespective of what payment module(s) you are using.

All the best...

Conor

Shipping estimator now works. :D

I have one question. The 'we can not ship to your location' warning is preceded by the words 'Flat rate' which is the default fall-back title in the config. I was going to change this, or make it blank, but I wondered in what other circumstances might this title be displayed?

Hi,

Peekay:

Shipping estimator now works. :D

Indeed it does! I hope that means you can make full use of the module now! :)

Peekay:

I have one question. The 'we can not ship to your location' warning is preceded by the words 'Flat rate' which is the default fall-back title in the config. I was going to change this, or make it blank, but I wondered in what other circumstances might this title be displayed?

Each shipping module in Zen Cart has a code and a title. The title is used to inform the user about the rate selected and is stored in the database against a completed order's details. If you don't ship to a region a customer is in then they won't be able to use the Region Tables shipping method so this information won't get recorded. So there's no harm in setting your default title to be something more descriptive like "Shipping to Region Unavailable". However, you must then be sure that there is a title/fallback title for every region that you have set up. Otherwise it'd be very confusing for the customer!

Hope that helps!

All the best...

Conor

Is anyone else having problems with the shipping estimator and region tables 1.2, it dose not handle weights over 400kg & i need to ship products up to 18 tone.

Also using weight based shipping if i express shipping method 1 as "1000:70,2000:180" and method 2 as "*:0" then enter a test order of 3000kg the estimater still offers a rate for method 1

Any sugestions please :(

Hi,

sylk:

Is anyone else having problems with the shipping estimator and region tables 1.2, it dose not handle weights over 400kg & i need to ship products up to 18 tone.

I'm talking to John privately about this.... obviously something is wrong with his installation of Zen Cart as the shipping estimator shouldn't fail at any specific weight.

This issue can be considered closed on this thread, please post any comments about it to myself or John privately as there is no point taking up any more room here!

All the best...

Conor

I guess I missed something. I love the idea of this module - the only one that will work for my needs. However, when I tested the module, the weight is in kg but I want lb. Is this possible or should I convert everything over to kg?

Thanks again.

treewoman:

the weight is in kg but I want lb. Is this possible or should I convert everything over to kg?

Don't worry, this is just a matter of changing your language file!

Open regiontables.php located in includes\languages\english\modules\shipping

All you'll have to do is changing this line:
define('MODULE_REGION_TABLES_UNITS_TEXT', 'Kg(s)');

Good luck! :wink:

Thanks Fred,

Just got in there before me! :)

All the best...

Conor
dev.ceon.net

Thanks for the help. Next problem - I am shipping heavy items. When I ran the test (and have done this many times) for the shipping weights, I find the items are calculating very incorrectly.

For example, an item that weighs 104 lbs is displaying 3 x 34.67 lbs and adding three shippings together.

Any ideas what I'm doing wrong?

Thanks again.

Hi Treewoman.

Strange name! :)

You must have set up your Zen Cart store with a maximum shipping weight of 34.67lbs... you can change the maximum weight you can ship using the admin (Configuration > Shipping/Packaging).

Hopefully that's you sorted now!

All the best...

Conor

Ok, it helped out a lot!

(By the way, the treewoman nickname is because we grow Christmas trees, my husband is nicknamed the treeman and so they started calling me the treewoman. Not that strange...well...maybe a little...) :smile:

Thanks again for the help!

Totally off topic but treeman in the province of Quebec is the name of a drinking game! :laugh:

Hi, great module. I think this one may be the solution to something I've been grappling with for some time. But I am getting the following errors which at first I thought had to do with the SEO URLs contribution. I removed the SEO URLs contribution and received the same errors minus the ones for /includes/classes/seo.url.php

Warning: Variable passed to each() is not an array or object in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1248

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/init_includes/init_templates.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line **1248

And the main page gets this:
**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_DISPLAY_UPCOMING_PRODUCT' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, 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 >=20070713 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Thanks!

Can you say what is your PHP version?, MySQL version? and whether you have PHP register_globals 'on' or 'off'? This info will help the developer provide an answer to your issues. The SQL error sounds like a MySQL version conflict to me, but the 'headers sent' error is often caused by a badly edited or corrupt PHP file.

Plus... yesterday was Friday the 13th :blink:

Hi, thanks. Here is my server/version info I got from my admin:**
Server OS: ** Linux 2.6.19.2-UP
** Database: ** MySQL 4.1.20-max-log
** Server Date: ** 07/13/2007 20:14:38 **
Database Date: ** 07/13/2007 20:14:38
** Server Up Time: ** 8:14pm up 15 days, 8:06, 0 users, load average: 1.39, 2.12, 2.16
** PHP Version: ** 4.3.11 (Zend: 1.3.0)
** HTTP Server: ** Apache

My register globals is:
php_flag register_globals 0
(I think that means off, right? Sorry, I'm still new at this)

... and it's still Friday the 13th on this side of the ocean :lookaroun ...

:D

Hi,

fepb:

But I am getting the following errors

Those errors normally occur because your database isn't refreshing its cache of Zen Cart configuration options.

This is a bug in Zen Cart and/or your MySQL server when SQL caching is enabled.

I'm not sure why it occurs, that is, I'm not sure why ZC/MySQL doesn't flush the configuration cache but you can fix this by either manually emptying the Zen Cart cache table yourself or making the following change:

in includes/configure.php change your SQL_CACHE_METHOD to:

define('SQL_CACHE_METHOD', 'none');

Hope that helps!

All the best...

Conor

Hi Conor,

Thanks a bunch, that did the trick! Now I can use your great module which is *exactly *what I've been looking for. Thanks again!

:yes:

Hi

If I can get this module working it will be great!

I have successfully loaded module and set up two regions, for UK.

The first region is for free shipping to postcodes GB:EX31-35, so ex31, ex32, ex33, ex34 and ex35 addresses get free shipping. When i add a product to cart and begin to check out and Estimate Shipping it does say 0.00 for rate, great, but under the 'Available Shipping Methods' bit it says:

Local Delivery (Personal Delivery (within 10km): Free if Order Total Over £50, £1.50 if Under (1 x 1.00Kg(s)))

I can't remember setting anything up for it to say this. Anyone any ideas?

The same thing occurs for Region two, but it says 'Local Delivery (Personal Delivery (within 75km): Free if Order Total Over £50, £4.50 if Under (1 x 1.00Kg(s)))'??

Please note that for Region 2 I have set up just 1 post code, for test purposes, but is a catch all GB:SM - to test i just use a bogus postcode, e.g 'sm33 2el'.

It also seems to be calculating the incorrect shipping fee, which is £1.22 - I don't have a a £1.22 fee set up!? My table rates for this postcode are as follows:

1:2.30,5:4.99,20:5.95,21:6.25,22:6.55,23:6.80,24:7.10,25:7.40,26:7.70,27:8.00,28:8.30,29:8.70,30:9.00,31:9.30,32:9.60,33:9.90,34:10.20,35:10.50,36:10.80,37:11.10,38:11.40,39:11.70,40:12.00,41:12.30,42:12.60,43:12.90,44:13.10,45:13.40,46:13.70,47:14.00,48:14.30,49:14.60,50:14.90

The product i am testing it on has a weight of 1, so, should cost £2.30, but doesn't seem to be doig this?

Help would be very much appreciated