Help regarding zones & postal codes

[industry]

Ok, we have set up some shipping methods which is fine but now we need to filter them by postcode - i see you can set up zones and include postcodes but here is where we run into problems: the free text field where you can input the postcode has a limit to the amount of characters you can use, so we only get through about 40 of our postcodes (out of around 3000) before it wont accept anymore.

Is there any way of either:

a) increasing the max-length of characters you can put into that field
or
b) have it so it excludes certain postcodes rather than include

Thanks in advance if you can help - just say if you need more information

[mazhar]

If excluding certain post code doesn't require much work then it would be OK other wise you can increase length in both the Admin/Shipping/Zones/EditShipZone.aspx page and in database table. Secondly have you noticed that you can use * wild card with Postal Codes. You can make use of wild card to mark a range of postal codes.

[industry]

If excluding certain post code doesn't require much work then it would be OK other wise you can increase length in both the Admin/Shipping/Zones/EditShipZone.aspx page and in database table. Secondly have you noticed that you can use * wild card with Postal Codes. You can make use of wild card to mark a range of postal codes.

Thats great - thanks....

How would we go about excluding certain post codes btw?

Yep the wildcard feature is great, its just we need to include the first two letters and then the number (eg, YO31), which does narrow the postal codes in England from 1.7m to 3000.

[robgrigg]

Hi, I am facing the same problem. Did you get this resolved?

[jessthib]

If excluding certain post code doesn't require much work then it would be OK other wise you can increase length in both the Admin/Shipping/Zones/EditShipZone.aspx page and in database table. Secondly have you noticed that you can use * wild card with Postal Codes. You can make use of wild card to mark a range of postal codes.

I too would like to lengthen the maximum characters in the post codes. I changed it in EditShipZone.aspx but how do I access the database table to change it there?

Thanks!

[mazhar]

You can use SQL server management studio for that purpose. You can connect it your database server and then change the desired table' s column information.