Hi. How can we help?

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;
  • export tax data for tax reporting. 

To export data

  1. Navigate to Tools > Exports.
  2. 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.

Due to differences in your store language, exports may vary from store to store. By visiting SettingsStore 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, visit our Column titles in product 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.

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.
Payouts Report

Read more about these reports in Exporting reports for Lightspeed Payments.

 

Troubleshooting

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:

  1. Navigate to ToolsExports.
  2. Check each export page for exports with the status "processing".
  3. Select all exports with "processing" status.
  4. Delete all using the bulk delete action button.

Was this article helpful?

1 out of 3 found this helpful