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 7 of 7

Thread: Blank Customer Records

  1. #1
    sduffy77 is offline Senior Member
    Join Date
    Feb 2010
    Location
    Lancaster, PA
    Posts
    142

    Default Blank Customer Records

    Can anyone think of a situation on the site that would create Blank Customer Records?

    We have a client that just went live on Monday 01/10/2011 and they already have 305 blank customer records.

    If a users sessions times out, does it create a blank customer record? That's my best guess without looking through all the code.

    Thanks,
    Shaun

  2. #2
    ZachJ85 is offline Senior Member
    Join Date
    Apr 2010
    Location
    Philadelphia, PA
    Posts
    99

    Default

    My guess would be this line from the manual.

    "A record is created for them in the Customer table (and other tables if necessary) in the database with just the basic information to save their session data."

    Do you have other valid records of customers in your database?
    SQL 2008, Visual Studio 2010
    Source: C#
    Version: AspDotNetStorefront ML 8.0.1.1/8.0.1.1
    Framework: .Net 4.0 (Running)

  3. #3
    sduffy77 is offline Senior Member
    Join Date
    Feb 2010
    Location
    Lancaster, PA
    Posts
    142

    Default

    Thanks for the quick reply.

    Yes we have about 2000 valid customers in the db currently and hundreds of orders already.

    None of these Blank Customer records are associated with an order, address, or anything else that I can see.

  4. #4
    sduffy77 is offline Senior Member
    Join Date
    Feb 2010
    Location
    Lancaster, PA
    Posts
    142

    Default

    Maybe this bit of info may help.
    All of the Blank Customer records have IsRegistered set to 0.

    We're using Phone Order Entry quite a bit, could it be related to that?

  5. #5
    ZachJ85 is offline Senior Member
    Join Date
    Apr 2010
    Location
    Philadelphia, PA
    Posts
    99

    Default

    Do you allow anon checkout? Phone order entry shouldn't have any play with that issue. I think that IsRegistered gets triggered to 1 when the person signs up for the site.
    SQL 2008, Visual Studio 2010
    Source: C#
    Version: AspDotNetStorefront ML 8.0.1.1/8.0.1.1
    Framework: .Net 4.0 (Running)

  6. #6
    sduffy77 is offline Senior Member
    Join Date
    Feb 2010
    Location
    Lancaster, PA
    Posts
    142

    Default

    More info:
    I was able to get it to create the blank customer record by clearing my browser cache, then going to the sign while not logged in, then going to the shoppingcart.aspx page.

    For some reason this creates a blank record when you browse it while not logged in.

  7. #7
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Sounds like they are anon customers. Running the Monthly Maintenence from within the admin screen will purge any you have.

    Backup your DB first!