You can export various data lists from your eCom back office:
- Orders, invoices, and sales to monitor your sales data.
- Orders or shipments to be handled by a fulfillment group.
- Products to change prices and images and then re-import to update.
- Tax data for tax reporting.
On the Exports page, you can keep track of what data has been exported from your online store.
Exporting your data
To export your data into a CSV file:
-
Navigate to Tools > Exports.
- Click Add export.
-
From the dropdown, select what you want to export and a date range, if applicable.
- Click Export.
The export will display as Processing. If you're exporting a large amount of data, the export may take several minutes.
When the export is complete, you'll receive an email with a link to the export file. You can also download the file from the Exports page by clicking Download.
Export files on the Exports page will be automatically be deleted after 30 days.
Understanding data export types
If you have multiple languages enabled for your store (Settings > Store country), exports may vary from store to store. Languages will be abbreviated in export files.
The data you select will be exported in a CSV file:
- Products: Product information like the name, description, prices, inventory information, and image location URLs. You can read more about the column titles in product exports or learn how to import changes to your products.
- Inventory: Data related to inventory variants, including tax type, title, and variant name.
- Quotes: Quote ID and name and email address of the customer.
- Orders: Order data, including order status, product details, and customer details.
- Shipments: Packing note data.
- Invoices: Invoice data, including customer and shipping information.
- Invoice Items: Invoice data as well as financial information, such as discount amounts and tax details.
- Sales: Data for paid orders.
- Customers: Data for registered customers and guest accounts.
- Filters: Data for products that have had filters assigned, including the filters and their selected values.
- Redirects: Redirect data.
- Newsletter Subscriptions: Newsletter subscription data, which you can use with email marketing as part of marketing campaigns.
- Payouts: Data about payouts.
- Transaction Status: Data about transactions.
- Product specifications: Specifications tied to specific products.
- Specifications: Extra information about your specific product.
Troubleshooting
- Refer to Fixing broken exports.
-
- Navigate to Tools > Exports.
- Look for exports with the Processing status.
- Check the boxes next to exports with the Processing status.
-
Click the X item(s) selected button.
- Click Delete selected exports.
-
Click Delete exports.
Follow the steps in the Exporting your data section above to re-export any deleted files.