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

Thread: 9.0.1.2 Not All Customers showing in Customer List

  1. 10-06-2010, 06:23 AM #1
    cc9537 is offline Member
    Join Date
    May 2009
    Posts
    40

    Default 9.0.1.2 Not All Customers showing in Customer List

    When I log in to the admin panel and click on customers, it displays a list of customers it shows 1-15 of 1141. But if I run and ad-hoc query against my customer table "select * from customer" it returns 2693 rows.

    I was looking for 1 customer in particular when I discovered this, and he is not in the list in customers in the admin panel, but is in the list from the ad-hoc query.

    Any ideas?


    Thanks, Clint.
  2. 10-06-2010, 06:41 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    The list in the admin site will be only registered customers; your ad-hoc query includes anonymous customers (those who have put something in their basket, but not registered).
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!
  3. 10-06-2010, 06:45 AM #3
    ssgumby is offline Senior Member
    Join Date
    Feb 2009
    Posts
    683

    Default

    Try changing your ad-hoc to select * from customer where isregistered=1 (column may be just registered but I cant recall from memory)