marql

POS / Checkout

Lightspeed reporting across multiple stores: each store's daily sales and receipts in one morning view.

The Lightspeed integration reads the daily sales total and the number of sales from Lightspeed Restaurant or Lightspeed Retail, read-only, for each Lightspeed account you connect. In marql every store sits on the same page as the others and next to the data from your other tills, accounting and e-commerce, so a chain running Lightspeed in some sites and another POS in others still gets one picture of the estate.

What data flows

What marql reads from Lightspeed

Daily sales for each Lightspeed account

Number of sales, and the average transaction value they give

Each account shown as its own store, compared and totalled across the chain

Lightspeed Restaurant and Lightspeed Retail

Read alongside your other POS, accounting and e-commerce data

Why connect

What you get with Lightspeed connected

  • Every Lightspeed store on one page

    Each Lightspeed account appears in marql as a store of its own. Daily sales and receipts line up store by store and add up to a chain total, so a morning look at the estate does not mean logging in to each account in turn.

  • Lightspeed sites next to sites on other tills

    Chains often run more than one POS: Lightspeed in some sites, something else in others. marql reads each in its own way and puts daily sales and receipts side by side, so the comparison does not depend on which till a site happens to use.

  • Average transaction value without an export

    With sales and the number of sales for each day, marql shows the average transaction value per store and how it moves. The connection is read-only: it does not change menus, products, prices or settings in Lightspeed.

Guide

Lightspeed reporting for multiple stores

When a chain grows past a few sites, the question is rarely about one store. It is which stores are up on last week, which are down, and whether the chain as a whole is on track. marql answers that from the figures Lightspeed already keeps.

For each Lightspeed account you connect, marql reads the day's sales total and the number of sales. Each account is a store in marql, so sales, receipts and average transaction value can be ranked across stores, compared with the same day last week and added up for the chain.

Stock across Lightspeed stores

The Lightspeed connection reads sales and receipts. For a stock report across stores, marql takes stock levels from the system that holds them: an accounting or ERP connection, an e-commerce platform, or a scheduled export mapped once, the way marql takes any system without a connector.

Once stock comes in from one of those, it sits in the same view as Lightspeed sales, so slow sellers and stock tied up in each store can be read next to what each store sells. The same goes for cost prices and margin.

Lightspeed integrations: what marql connects today

Lightspeed has its own marketplace of integrations for payments, accounting, e-commerce and reporting. marql is a reporting one: it reads from Lightspeed and changes nothing in it.

Today marql reads Lightspeed at account level: for each account you connect, the day's sales total and the number of sales, for Lightspeed Restaurant or Lightspeed Retail. It checks for new figures every few minutes and reads the last seven days on every sync, so history in marql starts when you connect rather than reaching back.

Connecting Lightspeed

You need an API key and the account ID from Lightspeed, and to choose Lightspeed Restaurant or Lightspeed Retail. Each Lightspeed account is connected once and appears in marql as its own store.

How it works

From Lightspeed to your daily briefing in three steps

01

Connect

We set up a read-only connection to Lightspeed. No data is written back. Your existing workflow stays unchanged.

02

Sync

marql pulls data on your schedule — hourly or daily. All data is normalised into a single model across all your integrations.

03

Briefing

Your daily operating briefing is ready each morning with revenue, margin, alerts, and store benchmarks — including data from Lightspeed.

History starts when you connect; older periods can come from an export.

FAQ

Common questions about the Lightspeed integration

Yes. Each Lightspeed account is connected separately and appears as its own store, so daily sales, receipts and average transaction value can be compared store by store and added up across the chain.

marql reads Lightspeed at account level, so shops that share one account appear as one store with their combined daily total. Shops on accounts of their own appear separately.

Not from the Lightspeed connection, which reads daily sales and receipts. Stock levels and cost prices come into marql from an accounting or ERP connection, an e-commerce platform or a mapped export, and then sit next to your Lightspeed sales store by store.

Lightspeed Restaurant and Lightspeed Retail. For each account marql reads the daily sales total and the number of sales.

No. The connection is read-only. Nothing in Lightspeed is created, changed or deleted.

It reads the last seven days on every sync, so history in marql starts when you connect. Older periods can be brought in from a Lightspeed export.

Related connectors

What else chains running this system connect

All integrations

Ready to see
the euros it found?

Connect your POS, stock and accounting in a day. Read-only access, no POS replacement, €200 a month per location and less as you grow.

0
Replacement of stack
1
Chat. Whole business.