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:
- From your Ecwid admin, go to My Sales → Orders.
- Scroll to the bottom of the page and find the Export Orders block:
- If you want to export all of your orders, click Export All.
- 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.
- You will see a popup with the export settings.
- In the top left corner select the delimiter for the data in exported file (what is it?) — semicolon, comma or tab:
- 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:
To export all product options and their values into one dedicated column, choose "Item options" in the dialog. To export each product option into a separate column, choose "Item options (split into columns)".
- Click Download CSV file.
- Open the downloaded file with a spreadsheet editor for further use.
We recommend OpenOffice and Google Sheets as spreadsheet editors— 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: