Product Delivery by Postcode (PDP) - [Support]

There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!

delia:

There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!

Yep, that's all I can think of too.

Would be a matter of finding out what safe character limit may be set to any given DB field and then amend the params for that field in the DB.

I wouldn't alter it for this one thing. This affects the entire cart - it's the heart of the database and could affect performance.

Sorry, have only just seen these replies. Can't believe after all that time and trouble I'm stuffed for it working as I need it too (deep sigh). Are you able to tell just how many postcodes the max limit is please?

Thanks.

denise006:

Sorry, have only just seen these replies. Can't believe after all that time and trouble I'm stuffed for it working as I need it too (deep sigh). Are you able to tell just how many postcodes the max limit is please?

Thanks.

From memory that DB field allows for max 256 characters (could be wrong though...).

For 5 digit US postcodes that would mean about 42 postcodes (5 digits for every postcode plus one separating comma for each postcode minus one comma at the end of the array).

Try that and let me know how many codes you are able to fit.

As an aside, how did Delia get your copy of PDP to work? I am interested what caused the problem and what her solution was.

Cheers / Frank

Hi Frank,

Ok thanks I'll have a play and see how many I can get in there and let you know.

Re Delia, I think she herself didn't really know as she changed a bunch of stuff and it sprung into life. I am about to use it on another site and so far do not having it working so when I get chance to play I'll see if I have more success with that one and let you know what I come up with.

Thanks again for coming back to me.

D.

denise006:

Hi Frank,

Ok thanks I'll have a play and see how many I can get in there and let you know.

Re Delia, I think she herself didn't really know as she changed a bunch of stuff and it sprung into life. I am about to use it on another site and so far do not having it working so when I get chance to play I'll see if I have more success with that one and let you know what I come up with.

Thanks again for coming back to me.

D.

Thanks D - I just PM'd Delia for some clarifications.

Cheers / Frank

Hi Frank,

I have been playing around with this and I can add 65,500 odd characters.

Today I have been trying to mind an add-on which will achieve the same result but am struggling to find anything. Are you able to get this to work just using the first portion of a UK postcode i.e SS0 up to SS99 say as even that would work for me?

Look forward to hearing from you.

Thanks.

Denise.

denise006:

Hi Frank,

I have been playing around with this and I can add 65,500 odd characters.

Yep, 65536 chrs to be precise :cool:

denise006:

Today I have been trying to mind an add-on which will achieve the same result but am struggling to find anything. Are you able to get this to work just using the first portion of a UK postcode i.e SS0 up to SS99 say as even that would work for me?

As I mentioned earlier in this thread, UK postcodes are somewhat unique - being a numerical minded person, I am struggling to come to grips with that logic .... no offense intended, they are just the way they are.

I need some time to learn about the UK postcodes and then try and incorporate a suitable code into my pending PDP v2.2

I am thinking about the 'LIKE' operand when testing for allowed postcodes - that is instead of the current '=' operand :lookaroun

Pls leave it with me - I have a little think about this.

Cheers / Frank

Indeed Frank, 65536 it is!

I have a list of the postcodes I need to allow which I can send over to you if it helps, but basically all UK postcodes start with two letters re;evant to their location i.e SS (Southend-On-Sea) followed by either 1 number (if you live close to the center of that place) or up to two numbers i.e. SS1 or SS99 if you live further away from the center. These are then followed by a space and then 1 further number and then a further two letters. In short a postcode will either have a LETTERLETTERNUMBER NUMBERLETTERLETTER or LETTERLETTERNUMBERNUMBER NUMBERLETTERLETTER format depending on location. Hope that helps but if you could modify to use just the first portion of UK postcodes that would be enough to control location and then take away the character issue within a database.

Make sense??!!

denise006:

Indeed Frank, 65536 it is!

I have a list of the postcodes I need to allow which I can send over to you if it helps, but basically all UK postcodes start with two letters re;evant to their location i.e SS (Southend-On-Sea) followed by either 1 number (if you live close to the center of that place) or up to two numbers i.e. SS1 or SS99 if you live further away from the center. These are then followed by a space and then 1 further number and then a further two letters. In short a postcode will either have a LETTERLETTERNUMBER NUMBERLETTERLETTER or LETTERLETTERNUMBERNUMBER NUMBERLETTERLETTER format depending on location. Hope that helps but if you could modify to use just the first portion of UK postcodes that would be enough to control location and then take away the character issue within a database.

Make sense??!!

In short, the first portion always is LLN or LLNN - correct?

Then there is a space followed by another 3 or 4 letters/numbers (the second part).

Is it likely that any of the combinations of the first part can also be found in the second part?

Example: if there is something like SS5 NW3 then could there be something like EE89 SS5?

I should do some googling to learn about this .....

Yep, the list would be handy - you can use the contact form in the first or second link in my signature to send them to me.

Cheers / Frank

The first portion always is LLN or LLNN - correct? - Yep 2 letters 1 number or 2 letters 2 numbers

Then there is a space followed by another 3 or 4 letters/numbers (the second part). - second part is always 1 number 2 letters

Is it likely that any of the combinations of the first part can also be found in the second part? - there could be duplication of the letters/numbers

Example: if there is something like SS5 NW3 then could there be something like EE89 SS5? - not in that order as the second part is always 1 number 2 letter

I should do some googling to learn about this ..... - not the most intersting way to spend your time but it may help I guess :)

Yep, the list would be handy - you can use the contact form in the first or second link in my signature to send them to me. - will do thanks Frank

I have submitted v 1.3 of PDP to the plugins area awaiting approval. This version has been updated to work with ZC 1.5.2 / 1.5.3

Great stuff :)

denise006:

Great stuff :)

Thanks D. Received your email with postcodes and will have a look at this soon (need to attend other unfinished business first)

Cheers / Frank

No worries.

I have gone with another solution at present but it would be really handy to have in the future if you can crack it to work with just the first portion of the postcodes.

Good luck :)

D.

frank18:

I have submitted v 1.3 of PDP to the plugins area awaiting approval. This version has been updated to work with ZC 1.5.2 / 1.5.3

PDP 1.3.1 is available for download from here

Thanks Frank,

Will let you know how I get on with it.

All the best.

D.

denise006:

Thanks Frank,

Will let you know how I get on with it.

All the best.

D.

Pls bear in mind that PDP 1.3.1 will not do the trick for you. For the UK issue you need to use the 1.4.0 RC1 I emailed you.

Cheers / Frank

PDP version 1.4.0 is now available for download.

Added function to strip last 3 characters of UK postcodes to enable entering a larger number of postcodes without reaching database field limits.