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;
- or export tax data for tax reporting.
In this article
To export data
NOTE: The following instructions include steps regarding tax reports. This is an upcoming feature that may not yet be available to all eCom users.
- On the left menu of the Back Office go to Tools > Exports.
- At the top of the EXPORTS page 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.
NOTE: Due to differences in your store language, exports may vary from store to store. By visiting Settings > Store country, you can see which languages you have enabled for your store. Then, visit the language table to see how each language is abbreviated in an export, here.
| Products |
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, click here. Visit Editing products through import to learn how to import changes to your products. |
| Inventory |
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:
|
| Quotes |
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. |
| Invoices |
Exports invoice data to a .CSV file. The export includes invoice information as well as the customer's information and shipping data. |
| Invoice items |
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. |
| Customers |
Exports data for registered customers and guest accounts.
|
| Filters |
Exports data for products to which you have assigned filters, including the filters and selected values.
|
| Redirects |
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. |
Setting a text delimiter
When you download your CSV and open it, all information should be divided into easy to read columns. If all of your data is illegible and all appearing in the first column, you may have the incorrect text delimiter set in your eCom Back Office. The required text delimiter may be dependent on your geographic location and your spreadsheet software.
If needed, you can specify your preferred text delimiter for all your exports: either commas (,) or semicolons (;). Keep in mind that the delimiter applies to ALL exports.
To change or specify the text delimiter:
- In the left menu of the Back Office go to Settings > STORE SETTINGS > Workflow > BACK OFFICE > CSV delimiter.
- Use the drop-down to select between comma or semicolon delimiters.