Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Missing Zipcode

  1. #1
    Rita is offline Senior Member
    Join Date
    Mar 2009
    Posts
    124

    Default Missing Zipcode

    We imported some of the customer information from another database which has empty values in Zip code field. but those customers can also be able to place an order successfully. So we are wondering how it can be possible as because we would need zipcode as mandatory field when we are updating address information. So why our ASPDNSF is not checking for customer's zipcode while checking out?

    Thanks in advance.

  2. #2
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    If you did not import addresses with your customers, then your customers were forced to create billing and shipping addresses when they checked out where they would have to enter their zip. I suspect that if you check the dbo.Address table and reference the customer IDs you'll find that the customers that do not have zips that have placed orders have matching address records that have a valid zip.
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>

  3. #3
    Rita is offline Senior Member
    Join Date
    Mar 2009
    Posts
    124

    Default

    No, We imported all other fields(address1, address2, city, state, country) other than Zipcode. In these fields, only zipcode field doesn't have any value in dbo.address table for those imported customers.
    Last edited by Rita; 02-05-2010 at 08:36 AM.

  4. #4
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    We're only going to check that they have an address during checkout, not each individual field within the address record. That level of validation is only done when initially creating or editing the address.

    You'll need to either nuke the addresses entirely so that customers have to add complete addresses before they can check out, or properly import the addresses so that you get the zip code too.