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: Simple Customer Export Query

  1. 06-12-2009, 09:12 AM #1
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default Simple Customer Export Query

    Hi

    I am looking to export all of our orders to Excel or some emailable list since Jan this year as we want to reward our customers with a 10% discount.

    We don't have WSI installed as our dbase is managed by a Stakeholder. Anyway we can extract this via StoreFront?
  2. 06-12-2009, 10:55 AM #2
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    Do you want all customers, or are you trying to export based on some set of circumstances (eg. ordered more than $100 over some date range, purchased one of a particular product, ordered a product from a specific category, etc...)?
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>
  3. 06-13-2009, 06:22 AM #3
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    You could drop an xmlpackage into /admin/xmlpackages then access it via products:feeds.


    TTFN

    BFG
    Last edited by BFG 9000; 06-13-2009 at 06:22 AM. Reason: typo
    Blog - Random Blurb from BFG 9000
    Twitter - @BFG9000
  4. 06-15-2009, 01:19 AM #4
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Thanks.

    Will try that, was thinking along those lines. What we basically want is all customers since Jan 1st this year.

    But I don't have direct access to our server/database as it's hosted via a Stakeholder. I feel like a kid looking through the toy store window but the doors are locked!