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: How to export order details to Excel

  1. 06-24-2011, 09:52 AM #1
    Jatinder Singh is offline Junior Member
    Join Date
    Oct 2007
    Posts
    11

    Default How to export order details to Excel

    How to export the order details like customer id, order number, address, shipping info, email, phone, product SKU, Description, Product Order Quantity, etc etc to Excel.

    Thanks
  2. 06-27-2011, 03:27 AM #2
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    You can use WSI or many approved developers have developed bespoke feeds that convert orders into csv format.
  3. 10-25-2011, 01:15 AM #3
    mskVenus is offline Junior Member
    Join Date
    Aug 2011
    Location
    China
    Posts
    25

    Default

    Quote Originally Posted by Jatinder Singh View Post
    How to export the order details like customer id, order number, address, shipping info, email, phone, product SKU, Description, Product Order Quantity, etc etc to Excel.

    Thanks
    Hi, I have the same trouble with you. Did you solved this question? Does some one can give me some ideas?

    Many Thanks!
  4. 10-25-2011, 01:18 AM #4
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Do you have access to SQL Server Studio Management Express on your webserver? If so you can get the data from there and copy'n'paste to Excel.
    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!