Exporting orders

When you need to generate a sales report, create a report of collected sales taxes, or simply get a list of orders with their details, you can use the export tool in your store. The exported order data will be saved on your computer as a CSV file. You can open CSV file in any text editor or in a spreadsheet and arrange data there in a preferred way.

To export order information from your Ecwid store:

  1. From your Ecwid admin, go to My Sales → Orders.
  2. Scroll to the bottom of the page and find the Export Orders block:

    ex-or.png

  3. If you want to export all of your orders, click Export All.
  4. If you want to export just some of the orders, tick the ones you need and click Export Selected.
    You can filter necessary orders first using some criteria, then tick the found orders and click Export Selected.  For example, you can filter orders by date, by a payment or shipping status, by products or customers
  5. You will see a popup with the export settings.
  6. In the top left corner select the delimiter for the data in exported file (what is it?) — semicolon, comma or tab:

  7. Select the order data which you want to see in the downloaded file - you can use the ready filters in the top right corner (All, All but item details, None) or pick the data for export manually:

  8. Click Download CSV file.
  9. Open the downloaded file with a spreadsheet editor for further use.

We recommend OpenOffice and Google Sheets — they are free and do not corrupt CSV files. Here you can find an example of exported order details after importing the downloaded CSV file into a Google Sheet:

Related articles

Basic reports and sales stats
Import/Export CSV files to Excel

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
10 out of 36 found this helpful
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline