Exporting data

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
• Data you can export
• Setting a text delimiter

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.

1. On the left menu of the Back Office go to Tools > Exports.
2. At the top of the EXPORTS page click New export. 
3. From the drop-down, choose what you want to export.

   

4. 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 complete list of product information you can export, click here to visit the Products section of the Column titles in exports article. 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: Tax type - For example, Electronic service (European). Title - The title of the product containing the variant. Variant - The name of the variant.
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. For a complete list of customer information you can export, click here to visit the Customer section of the Column titles in exports article. Visit Importing customers to learn how to import changes to your customers.
Filters	Exports data for products to which you have assigned filters, including the filters and selected values. For a complete list of filter information you can export, click here to visit the product filter value section of the Column titles in exports article. Visit Importing product filter values to learn how to import changes to your filters.
Redirects	Exports redirect data. For a complete list of redirect information you can export, click here to visit the redirect section of the Column titles in exports article. Visit Importing redirects to learn how to import changes to your redirects.
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:

1. In the left menu of the Back Office go to Settings > STORE SETTINGS > Workflow > BACK OFFICE > CSV delimiter.
2. Use the drop-down to select between comma or semicolon delimiters.