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: Export customer purchase history

  1. 01-21-2012, 06:34 AM #1
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default Export customer purchase history

    How would i create a sql query to export a list of customer records (just the email addy) plus purchase history

    so....

    Email, SKU1, SKU2, SKU3

    We want to do some analysis in Excel

    Many thanks if you can help
    8.0.1.4 W2008R2 64-bit MSSQL2005
  2. 01-21-2012, 08:09 AM #2
    Alkaline is offline Senior Member
    Join Date
    May 2006
    Posts
    459

    Default

    Mike,

    the query would be easier if each item was its own row, I will post a query for you to use in commander shortly.
    Simrun AspDotNetStoreFront Development
    Preferred AspDotnetStorefront Development Partner
    ahsan[@]simrun[.]com
    remove the "[]" for email

    Have a Nice Day
  3. 01-21-2012, 11:29 AM #3
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    ok thanks very much - what is commander btw ?

    We are simply trying to filter emails into mailing lists based on what they have previously bought....we can then email offers/promos for related products that they haven't yet bought

    Thanks for your help
    8.0.1.4 W2008R2 64-bit MSSQL2005
  4. 06-18-2012, 06:57 AM #4
    joemeta is offline Junior Member
    Join Date
    Nov 2011
    Posts
    3

    Default

    Was the query ever provided to you?