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: Archive or Delete Customer Data

  1. 10-14-2011, 10:49 AM #1
    Contour is offline Junior Member
    Join Date
    Apr 2006
    Posts
    22

    Default Archive or Delete Customer Data

    Hi All - I'm looking for a script to run against our ASPDNSF SQL db to clean up and reduce the customer data from all tables. We've been running ASPDNSF for roughly 5 years and would like to offload (separate table, xls download, etc) all customer data say for customers who have not placed an order or logged in since 2009.

    Has anyone done this or have advice?

    Many thanks.
  2. 10-17-2011, 01:51 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    As far as I know, there is no column which records when a customer last logged in, therefore you could only do this based on last order. And then what happens if you have a customer who is browsing but hasn't ordered and you go and delete their record?
    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-18-2011, 01:15 PM #3
    Contour is offline Junior Member
    Join Date
    Apr 2006
    Posts
    22

    Default

    I'm assuming query can be where sign up date < 01/01/2010 and last order < 01/01/2010, then delete/archive would work.

    Jeff
    Jeff Conklin
    e-Commerce Manager
    http://www.contourliving.com