How to export my Order data
In this article:
Where to find the Order export
What information is shown in Order export
How to open the Order export file
Why is my order export loading so long?
Where to find the Order export
If you want to export your email list and/or order data, please follow these steps:
- Log in to your Sellfy account
- In your sidebar menu, navigate to Orders > Export
- Select your preferred date range in the top bar
- Click Request report
- Once the report is generated, you can find it in your Export history below
- Click Download to save the report to your computer or laptop
What information is shown in the Order export
Important! If you're requesting the order export report for marketing purposes, please pay close attention to the Opt-in column. You may notice that not every customer agreed to the "Consent to receive newsletters" column. It is important to comply with the
- Product
- Product key
- Order No
- Status
- Date
- Time (GMT)
- Payer email
- Payment processor
- Consent to receive newsletters
- Country (only if you have enabled taxes for the buyer's location in your Tax settings)
- State
- Buyer IP
- Currency
- Subtotal
- Discount
- Tax
- Total
- Quantity (of product)
- Variant name (if the product includes variants)
- Discount name
- Coupon code
- Invoice
Note: Your Order export contains Buyer information only. To obtain subscriber emails you may request a recipient list instead.
How to open the Order export file
Note: The exported file is in .csv format and must be opened using the appropriate application to view it as a spreadsheet. Once you have downloaded and saved your Order export on your computer, open the exported file in Google Sheets, Microsoft Excel, or OpenOffice Calculator to display the data coherently. If you're using a Mac computer, you can use the Numbers app as well.
To open and view Order export online in Google Sheets:
- Sign in to your Gmail account
- Select Google Sheets from your Google apps
- Start a new spreadsheet by selecting a Blank sheet
- In the top left corner, navigate to File → Open from the dropdown menu
- In the pop-up window, click Uploads in the top bar on the far right
- Click Select a file from your device
- Select the Order export .csv file and click Open
- The report will automatically import into Google Sheets
- View your report online
- To save the report in your preferred format on your computer, navigate to File → Save as
To open and view Order export in Office Microsoft Excel:
- Open Microsoft Excel on your computer
- Select New Workbook
- In the top bar, navigate to File → Open from the dropdown menu
- Select the Order export .csv file and click Open
- The report will automatically import into Excel
- You might see a pop-up in the top bar warning of Possible Data Loss
- On the far right, click Save As
- In file format, select Excel Workbook .xls from the drop-down menu and click Save
To open and view Order export in Numbers on Mac:
- In Finder, click Applications in the left-hand sidebar
- To open Numbers, double click Numbers application
- In the pop-up window, select Order export .csv file and click Open
- The report will automatically import into Numbers
- Numbers will display the data on one-page → scroll right to view all columns
- To adjust the page size, navigate to % tap above Zoom in the top left corner and adjust to %75
Why is my data export loading so long?
Depending on your order volume, the report can take some time to generate. A large volume of orders will take a longer time, so don't worry if it doesn't show up immediately.
Generating the Order export can take a longer time to load if any of the following apply to you:
- You've got a large volume of orders
- You've selected a long time frame (over 1 month)
- You requested the Order export for the first time