Exporting data [NB]

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

Data you can export

Products

A product export contains product variants and information.

When you export product data this information is not included:

  • Specifications
  • Custom fields
  • Filters 
  • Quantity discounts
  • Related products
  • Product URLs 
  • Google categories
  • Index settings (Do not index function)
If you want to import changes to products, you can import the changes. In the left menu of the Back Office go to Tools > Import inventory. When you export your inventory, you export only the product and stock information. Options such as product images, categories and tags are not exported.
Inventory This export is similar to the Products export, but excludes many of the fields found in the Product export. Instead, the Inventory export is geared towards providing data on settings related to inventory variants.
Orders Exports your order data. The order status is not included. All orders are exported.
Shipment Exports packing note data to a .CSV file.
Invoices Exports invoice data to a .CSV file. The export includes all data related to each invoice in the system, including customer information.
Invoice items This export is similar to the Invoices export, but excludes many of the fields found in the Invoices export. Instead, the Invoice items export provides more focused data on the products in each invoice. 
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. To configure redirects go to Settings > 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.
Tax reports This report is an upcoming feature that may not yet be available to all eCom users.

Exports taxes you've collected within a specified time period to a .CSV file (up to a maximum of 3 months). This includes the name of each tax class and country of origin, as well as the tax rate associated with each class and the corresponding dollar amount for the specified time period. Here's an example:

Setting a text delimiter

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.

To export data

  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.

    If you select Tax report, specify a date range:

     

    NOTE: You can only export tax data for a up to a maximum of 3 months.

  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.

Have more questions? Submit a request