Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2005
    Posts
    67
    Plugin Contributions
    0

    Default How to change the maximum length for postcode?

    Hi,

    I just noticed that the maximum length for a postcode is 10 character. In the shop configuration I could only find how to change the minimum value. Anyone know how to change the maximum value?

  2. #2
    Join Date
    Jun 2005
    Posts
    67
    Plugin Contributions
    0

    Default Re: How to change the maximum length for postcode

    Found the following entries in the DB:
    `entry_postcode` varchar(10) NOT NULL default '',
    `customers_postcode` varchar(10) NOT NULL default '',
    `delivery_postcode` varchar(10) NOT NULL default '',
    `billing_postcode` varchar(10) NOT NULL default '',

    Would I only need to change the value 10 to something higher? Or is there more to it?

  3. #3
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,314
    Plugin Contributions
    3

    Default Re: How to change the maximum length for postcode

    Changing the 10 to something larger in each instance should do it. Back up your DB first.

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,880
    Plugin Contributions
    94

    Default Re: How to change the maximum length for postcode

    Which country has postal codes requiring more than 10 characters? You've got me curious.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  5. #5
    Join Date
    Jun 2005
    Posts
    67
    Plugin Contributions
    0

    Default Re: How to change the maximum length for postcode

    Quote Originally Posted by swguy View Post
    Which country has postal codes requiring more than 10 characters? You've got me curious.
    Got a customer who in Portugal with the following zip code: 4740-405 Fo

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,880
    Plugin Contributions
    94

    Default Re: How to change the maximum length for postcode

    Very interesting! Thank you.

    I wonder if the last 3 characters are intended to be the city?

    This

    http://algarve.angloinfo.com/countri.../postcodes.asp

    says it's nnnn-nnn format, but the city is appended to the postcode in standard address format for that country.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  7. #7
    Join Date
    Jun 2005
    Posts
    67
    Plugin Contributions
    0

    Default Re: How to change the maximum length for postcode?

    I was thinking the same thing. But he filled in city: Esposende
    Will contact the customer and check. In the meantime I I edited the database :)

 

 

Similar Threads

  1. How can I change the field length for product description?
    By 1speedbump in forum Customization from the Admin
    Replies: 11
    Last Post: 9 Nov 2014, 04:54 PM
  2. v139h How change the Length of field?
    By dmagic in forum General Questions
    Replies: 1
    Last Post: 23 Jul 2012, 08:05 AM
  3. How to make text box attribute required and maximum length?
    By dgeere in forum Setting Up Categories, Products, Attributes
    Replies: 8
    Last Post: 20 Mar 2010, 11:10 AM
  4. Setting maximum string length for admin fields
    By numinix in forum Contribution-Writing Guidelines
    Replies: 0
    Last Post: 3 Jul 2007, 07:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR