Region Tables 1.0.0 Released!

Hi,

It gives me great pleasure to release a new, hugely configurable shipping module for Zen Cart!


The Region Tables shipping module is a very comprehensive module for Zen Cart which allows store owners to specify shipping rates based on a combination of the customer's shipping address and either the total weight or the total price of the order.

• The rate applied to an order is determined by first identifying which region a customer's shipping address is in:
  
  Each individual region is defined in the module's admin configuration in either of two ways:
  
  
  
  1. Geolocation - A region can be set as being within a certain distance from the store (in Km/Miles).
     
     
  2. Country/Postcode Matching - A region can be defined as being a country or a country and postcode range combination. (E.g. [FONT="Courier New"]GB:BT[/FONT] matches all of Northern Ireland, [FONT="Courier New"]US:070-089[/FONT] matches the state of New Jersey in the US).
     
     Countries currently supported for Postcode Matching include: Canada, Spain, France, the UK, Portugal and the US.
     
     ALL other countries supported by Zen Cart are supported, just without the benefit of postcode matching (although it's easy to add this for each country!).
  
  
  The regions defined are checked in numerical order to see if they match the customer's address, so any number of methods for determining the customer's region can be employed until a match is found.
  
  For example: the first region could be a 10Km radius "Local Delivery" region and the subsequent region could attempt to match an address based on the customer's postcode (or even their country and postcode) if they are outside that region.
  
  There's no need to mess about with Zone Definitions with this module... everything can be done based on the country and/or postcode of the customer's shipping address! :)
  
  
  
• Once the region a customer's shipping address is in has been determined, the shipping rate is calculated based either on the weight or the total price of the order:
  
  Unlike most other Zen Cart shipping modules, Region Tables allows the store owner to specify an unlimited number of “Tables” of Rates/Shipping Methods per Region, enabling the possibility of offering a “Standard Delivery” rate, an “Express Delivery (Next Day)” rate and a “Express Delivery (Next Day Before 9AM)” rate, or such like, at the same time.
  
  As the tables of rates are specific to a region, each region can have completely different shipping options, allowing for a never-before-seen level of configurability in a shipping module!
  

Downloads, a Full Feature List and Documentation are available on the module's website:


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


If you like this module, PLEASE DONATE! It has taken a huge amount of time to develop and we don't earn anything for developing it!


Enjoy! :clap:


All the best...

Conor
ceon

Hi,

I realise the docs are quite text-heavy so just to help newcomers get a better idea of what this module can do for them, here's an example from the docs for setting up three regions for the US... It should hopefully make it clear how flexible/powerful this module is...




The US

US postcodes are numeric, consisting of five digits. There is also an extended version, called "ZIP+4", which adds a hyphen and four additional digits following the main ZIP code, to identify a smaller geographical area or single large entity. Only the first 5 digits are made use of by this module.

Example: To set up a Shipping Method for the City of “Seattle”, a Shipping Method for the state of “Washington” and a Shipping Method for the “Rest of the US” you would add three regions with the following Countries/Postcodes configuration values:

Code:

---

Region 1: US:981 (Covers 98102, 98152, 98199 etc. but not 98012 or 98200 etc.)

Region 2: US:980-994 (Covers 98000, 98102, 99450 etc. but not 99500 or 99655 etc.)

Region 3: US (Covers all other states and cities in US)

---

There are quite a lists of US Zip codes. One can be found in this wikipedia article.

Example language definitions for the above regions could be as follows:

Code:

---

define('MODULE_REGION_TABLES_REGION_1', 'US Postal Service');

define('MODULE_REGION_TABLES_REGION_1_METHOD_1_TITLE', 'Postage to Seattle');

define('MODULE_REGION_TABLES_REGION_2_METHOD_1_TITLE', 'Postage to Washington State');

define('MODULE_REGION_TABLES_REGION_3_METHOD_1_TITLE', 'Postage to the US');

---

This mod is great.

I do have a few teething problems though.

I have set up the zones into 5 areas based on our carriers zone setup.

Code:

---

zone 1 = GB
zone 2 =GB:AB1-3,GB:AB10-16,GB:AB21-25,GB:AB30,GB:AB39,GB:DD1-5,GB:DD7-11,GB:KY13,GB:PH2,GB:PH11-14
Zone 3 = GB:AB31-38,GB:AB41-45,GB:AB51-56,GB:FK19-21,GB:HS1-9,GB:IV1-28,GB:IV30-32,GB:IV36,GB:IV40-49,GB:IV51-56,GB:KA27-28,GB:KW1-17,GB:PA20-49,GB:PA60-78,GB:PA80-88,GB:PH1,GB:PH5-10,GB:PH15-26,GB:PH30-44,GB:ZE1-3
Zone 4 = NI:BT,GB:IM
zone 5 = CI:GY,CI:JE,GB:TR21-25,BF

---

If i change my account postcode to a zone 2 or zone 3 postcode e.g. AB1 or PA20, the module still shows me as being in zone 1 (I have changed the txt to say the relevent zones) and still charges me the Zone 1 price (all other zones have diff prices set)

If I change my Zone and Postcode to a CI or NI area and postcode all shows correctly.

any ideas.

p.s. If anybody uses ANC those are the correct zone splits for there services.

A fantastic module for sure so far. Took some digging into all of the documentation and that Wikipedia link but it is almost there. I'm having issues with the price per weight at the moment.

I have it set up to be based off of weight and it seems to be doing something odd with the final price unless my understanding of the module description is wrong (can totally be possible).

Code:

---

Region 1 Countries/Postcodes
US30000-31999,US:39901

---

Code:

---

Region 1 Shipping Method 1 Table of Rates
15:14.00,200:98.00,400:115.00,600:150.00,800:160.00

---

When I test a few items out, the total order comes to 229lbs.

Code:

---

Total Items: 6  Weight: 229lbs  Amount: $541.50

---

According to my Table of Rates, I'd want the shipping to be 115.00. However, on the estimated shipping page it's displaying a much higher price

Code:

---

Delivery (Delivery (6 x 41.98Kg(s)))          $606.00

---

Am I completely misunderstanding how this all works?

First off I fixed my problem as i had the catch all set as first option., moved all up 1 and catch all to bottom all now workign like a pure dream.

HALLDORR:

You seem to have a mixture od Lbs and KG in that info you gave. That might be the problem?

Quote:

---

Originally Posted by dasonix

First off I fixed my problem as i had the catch all set as HALLDORR:

You seem to have a mixture od Lbs and KG in that info you gave. That might be the problem?

---

The Kg hanging around was just from the language file, have changed it to lbs, same issue.

I am either missing something or completely misunderstanding the way the by weight is supposed to work.

I want to charge a price based on the total weight of the order. So in my rates like so: 15:14.00,200:98.00

I was thinkin anything between 15-199lbs (total order weight) would be charged $14.00 for shipping. Anything 200-next level would be charged 98.00 for shipping.

15:14.00,200:98.00

means up to 15 lbs costs $14.00, 15-200 lbs costs $98.00. I'm not sure whether more than 200 lbs is also $98.00, or just undefined i.e. $0.00. It would be easy to check if you have shipping set up - just make test orders.

Hi

Quote:

---

Originally Posted by halldorr

A fantastic module for sure so far. Took some digging into all of the documentation and that Wikipedia link but it is almost there. I'm having issues with the price per weight at the moment.

---

Thanks for the compliment! :)

I admit that the documentation is a bit daunting at present. I hope to make it easier to swallow but it just takes so much time to write that you can get fed up looking at it and require a break from the whole process! :)

Code:

---

Delivery (Delivery (6 x 41.98Kg(s)))          $606.00

---

I'm baffled as to how you are getting a total of $606. The way you have configured the rates is exactly right: 229 falls within the 200-400 bracket and therefore should have a rate of $115 applied. What tax class are you using?

Could you possibly send me log in details for your site so I can debug this for you? Please send the details to the e-mail address on the module's support page.

Thanks.

All the best...

Conor

Hi,

Great to see more people using this module.. we're really pleased that people are liking it so far! :)

Quote:

---

Originally Posted by gjh42

I'm not sure whether more than 200 lbs is also $98.00, or just undefined i.e. $0.00.

---

With the example you gave, an order weighing more than 200lbs would result in an "Undefined Rate" error message being displayed to the customer. I think that behaviour is more appropriate than allowing the module to pick a random rate (like 0!).

All the best...

Conor
ceon

Hi,

Just noticed a separate issue here...

Quote:

---

Originally Posted by halldorr

Code:

---

Region 1 Countries/Postcodes
US30000-31999,US:39901

---

---

You have forgotten the colon in your first country/postcode combination... US30000-31999 should be US:30000-31999.

Actually, you don't need to specify all five digits as you have done, you could simply replace the above with:

Code:

---

US:30-31,US:39901

---

The module will then match all zip codes that start with 30 or 31 (which is the range 30000-31999).

Less typing for you then. :)

All the best...

Conor

"Undefined Rate"... that covers it well. Good thinking!

Hi Conor,

Thoughts for a future release. Would it be possible to pull the region definition and region rate language defines from regiontables.php and add them to the headings in Admin?

If you have a complex set up as in my case with 10 regions and up to 3 set of table rates per region it is easy to get lost. It would help a great deal if the headings included the info as entered in regiontables.php. For example

Region 3 Countries/Postcodes - (UK Mainland)
Region 3 Shipping Method 1 Table of Rates (Parcel Force 24)

Hope you get my drift. :smile:

Regards

Brent

Hi Conor,

Thinking about it this is probably an awful lot of coding so a simple free type text field in Admin would do. After all you'll only enter the details once but will probably tinker with the rates more often.

Regards

Brent

Hi Brent,

Quote:

---

Originally Posted by Brent

Would it be possible to pull the region definition and region rate language defines from regiontables.php and add them to the headings in Admin?

---

Oh, that's a good idea! Should have thought of that one myself. Makes the configuration section much longer but as it is adding descriptions to the titles, it does so while at the same time making it easier to navigate!

A new version will be on its way shortly with this functionality... it won't require a database update so upgrading will be the simple matter of copying the new files over the existing files.

Quote:

---

Originally Posted by Brent

Thinking about it this is probably an awful lot of coding so a simple free type text field in Admin would do. After all you'll only enter the details once but will probably tinker with the rates more often.

---

It was a deliberate design decision not to have a text field in the admin... you only enter details once IF you use only one language on your shop... the language defines are abstracted from the main configuration and therefore clunky/unintuitive but they do allow the use of multiple languages.

All the best...

Conor
ceon

Hi,

Just realised that updating the titles in the configuration can only be done at one point... when the admin modules.php file calls the "keys()" method to read the configuration values.

This would mean that to add the titles to each configuration value the language file will have to be parsed every time the keys() method is called and the key titles updated in the database.

Would people here object to having their databases tampered with in this way? I'd of course try to find some way to make sure this only happens on the admin side otherwise it would cause multiple database updates every single time the module was queried (which would be an unnecessary load on the server). If that couldn't be done then I could of course add a switch to allow this functionality to be turned on/off as desired.

Unfortunately this behaviour is just a legacy of the way osC/ZC ahs been built and can't be avoided. (At least we can get around it though... :) ).

All the best...

Conor
ceon

Wow, thanks conor for your work and for notifying me of the update!

I have installed it and everything seems to work just fine! I've added a few post codes to the admin to test things out but I'll have to sit down a few more hours to configure the admin properly to let my customers choose between 3 shipping methods in canada and different rates for US and worldwide.

I fear I'll have a lot of work to do in order to configure that mod but nothing compared to the hours you must have spent writing the code!

Thanks again and I'll let everyone know how things are going and share my table rates with those interested!

Is there a way to set a "catch all" to indicate all two character ISO country codes that are not specifically defined?

Hi,

Quote:

---

Originally Posted by john99

Is there a way to set a "catch all" to indicate all two character ISO country codes that are not specifically defined?

---

Not currently I'm afraid.

All the best...

Conor

First of all GREAT MOD Conor!!!!

I'm from Spain which is a mess in terms of shipping... I need to shipping without taxes for the Canary Islands and with taxes to the rest of Spain... This is important as we sell mainly to other companies. Can you give me a clue. Thank you /Go raibh maith agat!!!

Congratulations on a very nice mod!. Using 'price' as the calculation method, my client can set break-points based on order value after which a different shipping method is used. The lang definitions make it clear to the customer how we plan to deliver their goods and because the module hides lower-priced methods after the break-point is reached, we know that shipments have adequate insurance cover.

Only problem I have is with the Zen Cart shipping estimator. If I select 'Ireland' as the country the IE rates appear. But with 'United Kingdom' selected (and no postal code entered) I get nothing. I thought the catchall GB region tables would display in that situation?. I tried moving GB to the bottom of the regions but still no joy.

Also, if I select 'Singapore' I was hoping for the 'We do not ship there' message, but alas not.

Any idea what I might have done wrong? Using 1.3.7 :dontgetit

have installed mod...very good.

is it possible just to have customers enter a country only, and the shipping costs are worked out from

1. country (Not [postcode)
2. weight

and how do i go about doing it?

thanxs

ok iv managed to mess about with this mod...

my aim is to basically allow the following shipping methods:

1. All UK Residents pay the same
2. All Europe customers pay the same
3. Rest of world eg US pay the same


Would that mean i have 3 regions?

how would i go about setting this up....any help wud be great..thanxs

FANTASTIC! Took no time at all to figure what I needed out. Took me longer to figure out the money conversion when I went to go donate!!

A

Quote:

---

Originally Posted by Peekay

Only problem I have is with the Zen Cart shipping estimator. If I select 'Ireland' as the country the IE rates appear. But with 'United Kingdom' selected (and no postal code entered) I get nothing. I thought the catchall GB region tables would display in that situation?.

---

Anyone else encounter this problem with the shipping estimator, or is it just me? :unsure: I badly need the 'we don't ship to your location' message.

Quote:

---

Originally Posted by Peekay

Anyone else encounter this problem with the shipping estimator, or is it just me? :unsure: I badly need the 'we don't ship to your location' message.

---

I am also having the same problem. Not sure what to do about it.

Hi,

Apologies for not replying to any messages here, didn't have notifications set up so didn't realise anyone had posted!

We're working on an even better version of the module which should make things even easier to set up as you'll be able to specify the shipping descriptions alongside the individual shipping methods, rather than having to mess about with language defines.

I'll also take a look into the shipping estimator "issue"... at the start of next week hopefully.

All the best...

Conor

Hi,

Quote:

---

Originally Posted by vik007

Would that mean i have 3 regions?

---

Yes.

You'll have to add lots of countries into the Europe and "Rest of World" regions but it's just a matter of entering them... should only take about 15 mins.

My suggestion would be to just get the list of country codes and start adding them alphabetically. E.g. you could use PHPMyAdmin to look at the countries table in Zen Cart, sort by "countries_iso_code_2" and put the appropriate countries into the appropriate region definitions...

Region 1:
GB

Region 2:
AD,AL,

(Above is Andorra, Albania...)

Region 3:
AE,AF,AG

(Above is United Arab Emirates, Afghanistan, Antigua and Barbuda... etc.)

It'll take time but it'll accomplish what you want! :)

All the best...

Conor

Hi Conor,

Great module...good work.:smile:

I was wondering if your module could enable a customer to select a different region and not have it rely on the one that the address is compatible with. For example, my shop needs to allow users to select one of the following shipping options:

UK - £0.00
Europe - £6.00
Rest of the World - £9.00

I basically need their address to be independent of their shipping destination, since I don't request their billing address until after.

If your module can't do this, could you provide hints on how to go about this? Any suggestions would be really helpful.

Many thanks.

Hi,

Iv created my products and given each product there weight.

Eg Cricket balls : 1Kg

when you add to cart it states at the top weight is 1Kg..which is fine:

But when you click next i see the following:

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


Why does it calculate it for 4 Kg???

Where is he extra 3kg coming from??

thanks

Have a peek in the FAQ. :smile:

Brent

Quote:

---

Originally Posted by Brent

Have a peek in the FAQ. :smile:

Brent

---

Your a star:-)


quick question....how do i change the text it shows???

eg (10km) etc....

/includes/languages/english/modules/shipping/regiontables.php but you would be well advised to read Conor's very comprehensive instructions to get the best out of this module.

Brent

PS. And don't forget to send him a donation if you find the mod useful. :smile:

Hi Conor,

Can this mod apply to this table rate as listed here->http://www.pos.com.my/v1/?C=/V1/PosL...PoslajuEMS.htm ?

For every NEXT 500 gram I got to add the given rate.

Hi,

Quote:

---

Originally Posted by CJJUNE

For every NEXT 500 gram I got to add the given rate.

---

If you were to decide on either using the Document Rate or the Merchandise Rate, it could be done.

You'd have to set up each weight limit individually though,

E.g, for Argentina:

0.5:90,1:130,1.5:170,2:210... etc, right up to the weight limit (if no limit you'd have to pick one to decide to stop at! :) )

(Adding on 500 grams and the rate each time).

It would take time but it would work.

All the best...

Conor

Quote:

---

Originally Posted by conor

Hi,



If you were to decide on either using the Document Rate or the Merchandise Rate, it could be done.

You'd have to set up each weight limit individually though,

E.g, for Argentina:

0.5:90,1:130,1.5:170,2:210... etc, right up to the weight limit (if no limit you'd have to pick one to decide to stop at! :) )

(Adding on 500 grams and the rate each time).

It would take time but it would work.

All the best...

Conor

---

:laugh: Ha ha yes i guess have to decide what is the weight limit. OK will try it and I am using ZC 1.3.7. Is it compatible?

Hi,

Quote:

---

Originally Posted by CJJUNE

:laugh: Ha ha yes i guess have to decide what is the weight limit. OK will try it and I am using ZC 1.3.7. Is it compatible?

---

It is indeed! :)

The site's down at the minute, if you haven't got the module PM me or use the contact link on the website and I'll send it to you.

We're re-doing the site and it'll be up again sometime later this week.

All the best...

Conor

Quote:

---

Originally Posted by conor

Hi,



It is indeed! :)

The site's down at the minute, if you haven't got the module PM me or use the contact link on the website and I'll send it to you.

We're re-doing the site and it'll be up again sometime later this week.

All the best...

Conor

---

Hi Conor

I PM you but you wont be able to receive the message as your INBOX is full.

I want to use this mod but when I clicked its official site, it says under development.

i.e.
Region Tables

The information for, and downloads of, Region Tables will be available again soon... we're just building the new website!

So, please can anyone attach your latest version of this mod?
Thanks

You don't have to look very far for the answer. Just read the two posts prior to yours. :smile:

@conor
Any joy with the shipping calculater issue? It's the only thing that doesn't work AFAIK. Looking forward to using this mod on a live site. :bigups:

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,

Quote:

---

Originally Posted by 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,

Quote:

---

Originally Posted by Peekay

Shipping estimator now works. :D

---

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

Quote:

---

Originally Posted by 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,

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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
[FONT=Verdana](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
[/FONT]

Hi,

Quote:

---

Originally Posted by 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.1 0,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

Hi,

How are you?

Quote:

---

Originally Posted by mattys

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?

---

You haven't been reading the instructions! :)

You can change the text which is displayed for each Region and/or Shipping method by editing the language file:

includes/languages/english/modules/shipping/regiontables.php

Quote:

---

Originally Posted by mattys

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!?

---

Now that is odd! I'm not sure why that's happening... can you please contact me via the contact form on the website and I'll do what I can to help you!

Thanks.

All the best...

Conor
Ceon

Hi Conor

I did email you a few days a go. Did you get email?

Conor

The system is essentially working, but seems to be replacing the shiiping costs i have input with random (but prob not that random) figures, e.g. for anything up to 1 kg it should be £2.30, but shows £1.22, for anything between 1 kg and 5 kg it should be £4.99, but shows £2.64.

Just checking my site settings but can't see anything obvious.

sorted!!

so, was nothing to do with software

so, easy to install and works, thus far

Hi Matt,

Quote:

---

Originally Posted by mattys

Just checking my site settings but can't see anything obvious.

---

I was going to reply to you this morning, we've been snowed under getting our payment modules ready for the payment gateway's system changeover this morning. (Our Protx modules).

I'm uncertain as to what is causing your errors but the prices you have stated have exactly the same percentage ratio!

This leads me to believe that it could be some sort of currency conversion error.

I'll be contacting you privately about this.. there's no need for you to reply here as this is definitely a specific issue with your Zen Cart setup (and therefore information about its fix is probably not of use to others).

All the best...

Conor

Hi Conor, I am wondering if you could help...

I wish to allow delivery to SW1 but not SW17. However if someone has the postcode SW17 7XX, this will be accepted.

I can see I could use the negator i.e. GB:!SW17, but this will stop SW1 7XX from being accepted.

Is this something you experience or have I configured things incorrectly?

BTW, GREAT MOD!!!

Hi,

Quote:

---

Originally Posted by vp143

I wish to allow delivery to SW1 but not SW17. However if someone has the postcode SW17 7XX, this will be accepted.

---

Yes, you've found a bug in the module... we'll release an update shortly.

Basically, we'd gotten so used to people using ranges that we forgot to apply the same restrictions on only validating the full outbound code to single postcodes as well... ranges only use the full outbound code but as you've found out, single codes can match partial outbound codes - not good!

Until a new version is released you can use the kludge of defining the SW1 region as:

GB:SW1-1

This will match SW1 but not SW17.

Quote:

---

Originally Posted by vp143

BTW, GREAT MOD!!!

---

Thanks, but obviously not that great when there are still bugs like that in it!

I'll post here when the updated version is released!

All the best...

Conor

Thanks Conor, that seems to work great... nice little workaround for the time being.

I saw the "BT2 3JJ shouldn't be mistaken for BT23 3JJ" comments so I was pretty sure you had thought about it.

Hi,

Quote:

---

Originally Posted by vp143

I saw the "BT2 3JJ shouldn't be mistaken for BT23 3JJ" comments so I was pretty sure you had thought about it.

---

Yeah, which is why it's such a silly bug to have missed out for single postcodes... ah well, as you've said, the workaround does its job for the minute!

All the best...

Conor

Hi again, I have few more issues... I have out GB:N1-22. These are all postcodes in North London. However NG13 is being accepted. Have I done something wrong?

Hi,

Have to make this quick as I am currently in hospital...

That is a known bug with UK postcodes and has been fixed in the development version. It will be released sometime shortly after I'm out.

Sorry but support for this module has been suspended until then!

All the best...
Conor

Thanks for the update

Hey Conor, take care of yourself and get well soon!

Yeah get well soon...

I already complete my cart but i am stills struggling with SEO :frusty:

Hello,

first i want to say thanks for this more than useful mod. When i try to set it up for our german store i've got this message : Module configuration error: Method for determining matching postcode range for country "DE" has not been defined! (Please create the method "_getRegionMatchingRangeDE()");

the postcode for the testing order is 79227 and the tables for the region 1 are:

DE:79

50:2.50,100:200

If i put only the ISO-Code in the postcode table it works, if i add the postcodes in it , not

can anybody help ??

many thnx in advance

Olias

Hi,

How are you? I'm glad you like our software! :)

Quote:

---

Originally Posted by Olias

Module configuration error: Method for determining matching postcode range for country "DE" has not been defined! (Please create the method "_getRegionMatchingRangeDE()");

---

This message is letting you know that you have tried to use a postcode for a country not yet supported by the module.

We would be happy to add postcode matching support to the module for Germany but this is a feature request and therefore we will have to bill for the work involved.

If you'd like us to add support for German postcodes please contact us privately and we will give you a quote. :yes:

All the best...

Conor
Ceon

Hi Conor, hope you are fully recovered from whatever made you go to the hospital.

First off all thanks for this great module, it fits all my needs and is easy to configure.

I have a question, a dumb one, I installed the module and it is working perfectly, but I have two more languages besides English, and I would like my clients from Portugal and Spain to see the description off the shipping methods in their languages but I don’t know how to do that.
After installing and configuring the module this is what those clients can see

http://img529.imageshack.us/img529/6328/checkoutkq4.png

How do I change MODULE_REGION_TABLES_DEFAULT_METHOD_TITLE ?

First I thought that I would have to create a regiontables.php for every language, so I copied one and made the necessary changes to it and then put it in /includes/languages/portugues/modules/shipping/
But that didn’t work, it makes that I can´t even open the check out page. Can you give me a hand please?

Thank’s

This is a great module and as I'm here you'll know I've hit a snag. I'm having no luck getting the module to hand shipping charges to Google Checkout. I've installed Google Checkout on another cart (not using Regiontables) and it worked fine so I'm thinking it's module specific. Has anyone had this problem and fixed it? I'll continue working on it and certainly let you know if I get it.

Cheers

Hi,

Quote:

---

Originally Posted by tempestade

First off all thanks for this great module, it fits all my needs and is easy to configure.

---

Thanks for the nice comments.. they're appreciated! :)

Quote:

---

Originally Posted by tempestade

I have a question, a dumb one

---

It's not dumb at all! What you've done should be all that's needed.. for some reason your shop isn't loading the language file correctly.

I'm afraid I don't have any idea why this would be... it might be a good idea to ask in the general support forum?

Do your other multilingual shipping methods load their language definition files okay?

Hi,

Quote:

---

Originally Posted by ArtOak

This is a great module and as I'm here you'll know I've hit a snag. I'm having no luck getting the module to hand shipping charges to Google Checkout.

---

I'm afraid that this must be a problem with the Google Checkout module itself then as the final shipping charges are handled in the same way as every other shipping module... there is no custom/non-standard coding in this module in that regard.

Please try posting in the google checkout module's thread, hopefully someone there will be able to help you!

Quote:

---

Originally Posted by conor

Do your other multilingual shipping methods load their language definition files okay?

---

yes they do, I will unistal the module and reinstal it again to see if that helps.

Thank's Conor!

regards,

Is it possible to use wildcard matching for a region's country code listing? I need everything outside of the US in a region. So can I do:

!US,*

Or do I need to list them all except 'US' (dumped from the countries database):
AX,AF,AL,DZ,AS,AD,AO,AI,AQ,AG,AR,AM,AW,AU,AT,AZ,BS,BH,BD,BB,BY,BE,BZ,BJ,BM,BT,BO ,BA,BW,BV,BR,IO,BN,BG,BF,BI,KH,CM,CA,CV,KY,CF,TD,CL,CN,CX,CC,CO,KM,CG,CK,CR,CI,H R,CU,CY,CZ,DK,DJ,DM,DO,TP,EC,EG,SV,GQ,ER,EE,ET,FK,FO,FJ,FI,FR,FX,GF,PF,TF,GA,GM, GE,DE,GH,GI,GR,GL,GD,GP,GU,GT,GN,GW,GY,HT,HM,HN,HK,HU,IS,IN,ID,IR,IQ,IE,IL,IT,JM ,JP,JO,KZ,KE,KI,KP,KR,KW,KG,LA,LV,LB,LS,LR,LY,LI,LT,LU,MO,MK,MG,MW,MY,MV,ML,MT,M H,MQ,MR,MU,YT,MX,FM,MD,MC,MN,MS,MA,MZ,MM,NA,NR,NP,NL,AN,NC,NZ,NI,NE,NG,NU,NF,MP, NO,OM,PK,PW,PA,PG,PY,PE,PH,PN,PL,PT,PR,QA,RE,RO,RU,RW,KN,LC,VC,WS,SM,ST,SA,SN,SC ,SL,SG,SK,SI,SB,SO,ZA,GS,ES,LK,SH,PM,SD,SR,SJ,SZ,SE,CH,SY,TW,TJ,TZ,TH,TG,TK,TO,T T,TN,TR,TM,TC,TV,UG,UA,AE,GB,UM,UY,UZ,VU,VA,VE,VN,VG,VI,WF,EH,YE,YU,ZR,ZM,ZW

Here are all of the ISO country codes (including the US) in aphabetic order for anyone who wants to cut-and-paste to save some typing:

AD,AE,AF,AG,AI,AL,AM,AN,AO,AQ,AR,AS,AT,AU,AW,AX,AZ,BA,BB,BD,BE,BF,BG,BH,BI,BJ,BM ,BN,BO,BR,BS,BT,BV,BW,BY,BZ,CA,CC,CF,CG,CH,CI,CK,CL,CM,CN,CO,CR,CU,CV,CX,CY,CZ,D E,DJ,DK,DM,DO,DZ,EC,EE,EG,EH,ER,ES,ET,FI,FJ,FK,FM,FO,FR,FX,GA,GB,GD,GE,GF,GH,GI, GL,GM,GN,GP,GQ,GR,GS,GT,GU,GW,GY,HK,HM,HN,HR,HT,HU,ID,IE,IL,IN,IO,IQ,IR,IS,IT,JM ,JO,JP,KE,KG,KH,KI,KM,KN,KP,KR,KW,KY,KZ,LA,LB,LC,LI,LK,LR,LS,LT,LU,LV,LY,MA,MC,M D,MG,MH,MK,ML,MM,MN,MO,MP,MQ,MR,MS,MT,MU,MV,MW,MX,MY,MZ,NA,NC,NE,NF,NG,NI,NL,NO, NP,NR,NU,NZ,OM,PA,PE,PF,PG,PH,PK,PL,PM,PN,PR,PT,PW,PY,QA,RE,RO,RU,RW,SA,SB,SC,SD ,SE,SG,SH,SI,SJ,SK,SL,SM,SN,SO,SR,ST,SV,SY,SZ,TC,TD,TF,TG,TH,TJ,TK,TM,TN,TO,TP,T R,TT,TV,TW,TZ,UA,UG,UM,US,UY,UZ,VA,VC,VE,VG,VI,VN,VU,WF,WS,YE,YT,YU,ZA,ZM,ZR,ZW

Hi,

Quote:

---

Originally Posted by transmobius

Or do I need to list them all except 'US' (dumped from the countries database):

---

The wildcard matches everything and can't be used in combination with other country codes.

However, it doesn't need to be in your case as regions are matched on a first come, first served basis so all you need to do is have US address matched by a region and then the wildcard matching a following region won't ever apply to the US as US address will already have been matched.

Hope it's easy enough to get your head around that logic! ;-)

Excellent.

So
Region 1 = US
and
Region 2 = *

Correct?

Also looking at including the US territories and possessions for US postal mail
Region 1 = US,AS,GU,MP,PR,PW,VI
(American Somoa, Guam, Mariana Islands, Puerto Rico, Palau, US Virgin Islands)
As these all require the same postage as the actual US.

Hi,

Quote:

---

Originally Posted by transmobius

Also looking at including the US territories and possessions for US postal mail
Region 1 = US,AS,GU,MP,PR,PW,VI
(American Somoa, Guam, Mariana Islands, Puerto Rico, Palau, US Virgin Islands)
As these all require the same postage as the actual US.

---

Yes, so as you've hinted, you'd set up two regions as:

Region 1 = US,AS,GU,MP,PR,PW,VI
Region 2 = *

Didn't know there were any US postal services that covered all of those other countries... interesting! :)

Glad you find the module useful!

Hi Ceon,

The module seems great so far. One small gotcha I can't seem to get around and would love to have your expertise on. Thanks in advance for your time.

- Our Zone 1 is US. I want 1) $10 ground shipping under order total of 300, free if 300 or over 2) $20 2 day ship 3) $30 overnight 4) in store pickup for free

If a person has over $300 in their cart, the free ground shipping is already selected. They don't have the option for in store pickup, or the more expensive, quicker options. We would like all those displayed as well. Any tips on how to get around this?

Here is my setup:

I have Region Tables as my Sort Order #1, Store Pickup as my #2. Below are my Region Tables Settings:

Region 1 Definition Method
Country/Postcode Matching
Region 1 Countries/Postcodes
US
Region 1 Distance From Store
10
Region 1 Shipping Method 1 Table of Rates
299.99:10,*:0
Region 1 Shipping Method 2 Table of Rates
*:20
Region 1 Shipping Method 3 Table of Rates
*:30
Region 1 Shipping Method 4 Table of Rates

Region 1 Handling Fee
0

Hi,

Quote:

---

Originally Posted by donplay

The module seems great so far. One small gotcha I can't seem to get around and would love to have your expertise on. Thanks in advance for your time.

---

I'm glad you appreciate our work! :)

Quote:

---

Originally Posted by donplay

We would like all those displayed as well. Any tips on how to get around this?

---

I'm not sure what is up with your store but that configuration works just fine on our servers (as it should). The only thing you have done wrong is to leave the Region 1 Shipping Method 4 Table of Rates empty whereas it should be:

*:0

Have you only one region defined or do you have several? I can't think of any reason that all four rates wouldn't be displayed if the value of the cart is above $300 (and if you've set up Method 4 correctly as above).

I'm afraid the only thing I can offer is to log into your site and debug your store manually. If it is doable in a short time I won't charge anything, if I can't find a quick solution then I'm afraid we'd have to talk about a consultancy fee for the work involved.

Please contact me using the contact form on our website:

http://dev.ceon.net/contact_us

Sorry I can't be of more help than that straight off but as I said it works here! :)

(You are using the latest version of the module of course?)

Hi Ceon,

I am using version 1.2.0 of Region Tables which I downloaded from your site a few weeks ago.

I remember during the installation I seemed to lose connectivity or get interrupted partially through, so perhaps things didn't get installed properly. I'd like to try to resolve this myself by uninstalling and then re-installing this module. I didn't run any SQL scripts. Would I just do the following steps?

1) Note my settings
2) Delete the following files

includes/languages/english/modules/shipping/regiontables.php
includes/languages/english/modules/shipping/YOUR_TEMPLATE/regiontables.php
includes/modules/shipping/regiontables.php
includes/modules/shipping/regiontables/geolocation_gb.php
includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_shipping_default.php

3) And then go through the install instructions from the beginning?

thanks,
Don

Conor,

It's sorted now. Didn't have to re-install...essentially I had another setting in the admin that was configured when I was originally trying to set up my rules that was interfering with the Region Tables.

In Modules->Order Total Modules-> Shipping ot_shipping I had it set (and still enabled) to give free shipping if the order were over 299.99. So when it was going over 300 it was superceding your module.

Wish I could say I figured it out on my own...it was actually my wife that found it. She won't let me hear the end of it and has gotten into the habit of saying, "who's the computer guru NOW...." :)

Anyhow thanks for the prompt reply, I believe all is well now. Thanks.

-Don

Hi Don,

Quote:

---

Originally Posted by donplay

She won't let me hear the end of it and has gotten into the habit of saying, "who's the computer guru NOW...." :)

---

lol Well she sounds like a proper guru... give her my appreciation and thanks! :)

I'm glad that everything's working as expected... enjoy the module! :)

Just wanted to let you know that I solved the problem with the language files and the module is now working just fine.

Thanks again for this great module :clap::clap:

Can anyone help with this problem? I installed Regiontables with great success and it works perfectly with PayPal and 2CO. I recently installed Googlecheckout and for some reason the shipping costs are not being handed over to Google. I've run the shipping handler thing and followed all instructions (I think).

I was wondering if it is to do with this array comment in includes/module/payment/googlecheckout.php

$this->shipping_support = array("flat", "item", "table", 'freeoptions', 'freeshipper', 'perweightunit', 'storepickup', 'itemnational', 'iteminternational');

I've tried adding 'regiontables' in here and in related areas but still no luck. My brain is starting to fail on me. :shocking: Any pointers would be greatly appreciated.

Marcus

Hi,

Quote:

---

Originally Posted by tempestade

Just wanted to let you know that I solved the problem with the language files and the module is now working just fine.

---

What was the problem? How did you fix it?

Quote:

---

Originally Posted by tempestade

Thanks again for this great module :clap:

---

Glad you like it! :)

Hello,

I have installed the latest release of Region Tables. I have 8 regions setup with all my US zip codes identified as follows:

Region 1 - US:900-908,US:910-918,US:919-921,US:922-928,US:930-935
Region 2 - US:863-864,US:889-891,US:936-939

and so on. My shipping I was hoping I could setup like this:

0:$10, 100:10%

Calculation Method = Price.
For $0.00 $99.99 the rate would be $10
For anything over $100 the rate would be 10% of sub-total. This method seems to work in the MZMT shipping module and I was hoping it worked here. Does anyone know how to add percentage of total to shipping for the Region Tables mod? Or is there another mod that would work better for this and 8 regions (or zones) too?

Any help is appreciated.

Thanks,
Steve

Hi,

Quote:

---

Originally Posted by swiker

I Does anyone know how to add percentage of total to shipping for the Region Tables mod?

---

This is a feature a few people have asked for, along with many others.

Subsequently we are developing a replacement for Region Tables called "Advanced Shipper" which we hope to release soon. (It's much more flexible than the Region Tables module and there'll be no need to mess with language defines any longer as the titles can be specified alongside the options for a region/method through the completely new admin system! :clap:)

Development is taking a lot longer than expected but we're aiming to release within the next week or so.

More info will be posted here as it becomes available! ;)

All the best...

Conor
Ceon

This is a really neat module!
For anyone that's using Australia Post I have attached a simple text document that breaks down all of the post codes available today into Australia Post Regions, v1, v2 etc. Hopefully this will save people some time

Just a slight fix for the function _regionMatchesRangeAU in the regiontables.php module

_almost_ all postcodes in Australia are 4 digits in length, however there's two 3 digit ranges
800-909 and 200-221.

replace line 636 with

Code:

---

if (!ereg('(^[0-9][0-9][0-9][0-9])|(^[8-9][0-9][0-9])|(^[0-2][0-2][0-9])', $dest_postcode)) {

---

My regex foo is weak so I didnt get too fancy with it
it just checks if the number is between 800 and 999 as well as 200 and 229

Hi
I have installed this module and it works great, but, I am using it in weight mode but I also want to add a price threshold for free p&p, eg if they spend £50 or more they get free shipping.

I have the freeshipper module installed as well but it doen't seem to be picking it up.

Could anyone help?

Hello

My client wants to calc the shipping price based on the post code but also the number of products they order (they are large and require one pallet each). I've noted that this contrinbution allows for calculation on price and weight - but not quantity... is that right?

Andy