Service Notification
Visit our Status Page for more details.
eCom Help Center
ECOMMERCE RETAIL ONSITE RESTAURANT

    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

    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.

      Screen_Shot_2018-06-01_at_1.34.05_PM.png

    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.

      Fixing broken exports

      If the export is not formatted correctly and is difficult to read, click here.

    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:

    • 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.