---
title: "Lightspeed eCom sales report · Hypamoon"
description: "Exporting Lightspeed eCom orders each week to see sales and margin? Get a weekly email with sales per product, category and brand, and the margin."
url: https://hypamoon.com/connect-to/lightspeed-ecom-c-series/sales-report
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Lightspeed eCom](https://hypamoon.com/connect-to/lightspeed-ecom-c-series)
3.  Sales report

For teams that run on Lightspeed eCom

# Lightspeed eCom sales report

Lightspeed eCom shows revenue, orders and conversion on its Statistics page, and sales data comes out as CSV exports. Sales per brand or category, or the margin per product, are worked out in a spreadsheet from those exports.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=lightspeed-ecom-c-series/sales-report)

## How it goes today

1.  Export last week's sales from the Exports page.
2.  Open the file from the email in a spreadsheet.
3.  Add the cost prices and group the lines by brand or category.
4.  Compare with the same week last year by hand.

## How it can go

**Sales and margin per product, category and brand, in your inbox each week.**

Each Monday you get an email with last week's sales per product, category and brand, the margin from the cost prices in Lightspeed eCom, and the same week last year next to it. Best sellers that run low and products that sold less than usual are listed apart. The figures come as a spreadsheet too, in the same columns each week.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Lightspeed eCom key in the portal, never in the chat.

Your request

> With Hypamoon, every Monday, take last week's paid orders from Lightspeed eCom and make a report of sales per product, category and brand, with the margin from the cost prices and the same week last year next to it. List best sellers that are low in stock and products that sold less than usual. Email it to me with a spreadsheet in the same columns each week.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~lightspeed-ecom-c-series/sales-report&say=a%20weekly%20sales%20and%20margin%20report%20from%20Lightspeed%20eCom%20per%20product%2C%20category%20and%20brand%2C%20compared%20with%20last%20year.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=lightspeed-ecom-c-series/sales-report)

You create the Lightspeed eCom key yourself in your back office under Settings, Store Settings, Developers, on the Advanced or Professional plan. It stays yours.

## More for teams on Lightspeed eCom

-   [**Each month I export the invoices and work out the VAT per country in a spreadsheet.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/accounting-export)
-   [**Each morning I rebuild my supplier's stock file in a spreadsheet before I can import it.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/supplier-feed)
-   [**I filter on low stock and work out per supplier what to order.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/reorder-list)
-   [**After each order I email the supplier which items to ship to which address.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/supplier-orders)
-   [**Each new business account I check by hand and add to the right customer group.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/b2b-accounts)
-   [**I enter quantity discounts product by product for each wholesale group.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/tiered-prices)
-   [**I add related products by hand, one product at a time.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/related-products)
-   [**Customers fill in their email in the checkout and leave, and nobody follows up.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/abandoned-cart)
-   [**Before each sale I change prices and old prices by hand, and again when it ends.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/scheduled-sale-prices)
-   [**Each return means a status, a credit invoice and a refund, one by one.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/returns)
-   [**I copy each tracking code from the carrier's site into the shipment.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/tracking-codes)
-   [**Each month I place the coffee subscriptions again as orders, one by one.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/subscription-orders)
-   [**After each order for a gift box I count down the stock of what is inside it.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/bundle-stock)
-   [**I copy the engraving text from each order onto a list for the workshop.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/personalisation-sheet)
-   [**Each afternoon I count up from the orders what we need to bake for tomorrow.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/delivery-day-list)
-   [**Our own driver gets a list that I sort by postcode myself.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/local-delivery-routes)
-   [**Before I make the labels I go through the orders to see which ones have alcohol in them.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/age-check-orders)
-   [**The German and French texts run behind on our new products.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/translations)
-   [**I add each new product in our Dutch store and then again in the German and Belgian ones.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/sister-shops)
-   [**A product we removed shows an error page until I add a redirect myself.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/unavailable-redirects)
-   [**I work out the price per litre for each variant myself and type it in.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/unit-prices)
-   [**An order to the UK got stuck because there was no HS code.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/hs-codes)
-   [**Whether we passed the EU threshold for sales to other EU countries, the accountant works out afterwards.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/oss-threshold)
-   [**Our business customers who pay on account, I chase per order.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/invoice-reminders)
-   [**A price list for our business customers I make by hand in a spreadsheet.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/wholesale-price-list)
-   [**Loyalty points are not available here, so I keep a list of our regular customers.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/loyalty-codes)
-   [**For each paid course or e-book I send the link myself and set the order to shipped.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/digital-delivery)
-   [**An order with half an address I only notice when the parcel comes back.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/address-check)
-   [**On my phone I do not see that a big order or a question in the comment came in.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/order-alerts)
-   [**Whether each withdrawal was refunded in time, I do not keep track of.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/withdrawal-deadlines)
-   [**With a sale I do not know whether the old price was really the lowest of the last 30 days.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/lowest-price-check)
-   [**Our product feed misses the variants and specs, so I keep a separate file.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/shopping-feed)
-   [**Customers who order food every six weeks sometimes forget, and buy it elsewhere.**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series/repeat-reminders)
-   [**Everything for Lightspeed eCom**](https://hypamoon.com/connect-to/lightspeed-ecom-c-series)
