Use Lightspeed eCom's Exports tool to keep track of what's going on with your business by exporting data from your online store. For example, you can use the Exports tool to:
- create exports of your orders, invoices, and sales to monitor your sales data;
- export all your orders or shipments to be handled by a fulfillment group;
- export all your products to change their prices and images and then re-import them;
- export tax data for tax reporting.
To export data
- Navigate to Tools > Exports.
- Click New export.
- From the drop-down, choose what you want to export.
- Click Export.
The export appears as In progress. If you are exporting a large amount of data, the export can take several minutes. When the export is complete, you'll receive an email with a link to the export file or you can download the file directly on the exports page.
Types of data you can export
Below are the types of data you can export from eCom. The data you select will be exported in a .CSV file.
The product export contains product information like the name, description, prices and inventory information. It includes the image location urls as well as other information.
For a description of each column in a product export, visit our Column titles in product exports article.
Visit Editing products through import to learn how to import changes to your products.
The inventory export contains data related to inventory variants which includes many of the same fields as a Products export.
The 3 differences between the products export and the inventory export are:
The quotes export contains the quote ID and the name and email address of your customer.
|Orders||Exports your order data including the order status, product and customer details.|
|Shipment||Exports packing note data to a .CSV file.|
Exports invoice data to a .CSV file. The export includes invoice information as well as the customer's information and shipping data.
The invoice items export includes invoice information as well as information related to the financial details like discount amounts details and tax.
|Sales||Exports data for paid orders.|
Exports data for registered customers and guest accounts.
Exports data for products to which you have assigned filters, including the filters and selected values.
Exports redirect data.
|Newsletter subscriptions||Exports newsletter subscription data, which you can then use with an e-mail marketing platform as part of your marketing campaigns.
You can't send newsletters directly from Lightspeed eCom. However, Lightspeed eCom integrates with several popular external e-mail marketing platforms that you can purchase from our App store.
Read more about these reports in Exporting reports for Lightspeed Payments.
If the export is difficult to read, refer to our Fixing broken exports article.
If you get an error message stating "Only one export can be processed at a time.", refer to the following steps:
- Navigate to Tools > Exports.
- Check each export page for exports with the status "processing".
- Select all exports with "processing" status.
- Delete all using the bulk delete action button.