Data Panda brings your Lightspeed Retail data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.
Lightspeed Retail (R-Series) is the POS behind a lot of independent Belgian and Dutch retailers: fashion boutiques, bike shops, jewellers, pet stores, specialty sport. It is the evolution of Vend, which Lightspeed bought in 2021, bolted onto the Canadian Lightspeed platform that started in Montreal in 2005. Unlike an ecom-first system, R-Series begins at the counter and extends outward to a webshop, not the other way around.
Inside R-Series you have sales, sale lines, payments, items, item matrices, inventory counts, categories, shops, registers, employees, customers, vendors, purchase orders and vendor returns. That is a rich operational picture, but the reports your accountant, your buyer and your merchandiser need sit across that data and your accounting, your marketing tool and your ecom channel. Pulling R-Series into a warehouse is where those questions stop needing a spreadsheet.
Margin, stock and sales performance in a single view instead of three R-Series tabs.
Turn till data and stock events into timely actions in the rest of the stack.
Use your sales and inventory history to sharpen buying and clienteling decisions.
Shop-floor and buyer-facing tools that replace the export-and-mail-around routine.
A list of concrete reports, automations and AI features we have built on Lightspeed Retail (R-Series) data. Pick the one that matches your situation.
Which SKUs are making money per shop?
Sale lines joined to item cost and current landed cost, split by shop and category. Shows which items carry the store and which ones sell well but leave no margin once the supplier invoice is in.
Where is inventory drifting between shops?
Stock on hand per shop against sell-through rate per shop. Surfaces the SKU that is selling in the Antwerp shop and gathering dust in Ghent, so a transfer goes out instead of a fresh purchase order.
Does the end-of-day reconcile to the accounting ledger without a spreadsheet?
Register totals, payment-type splits and refunds pushed daily into Exact Online or Yuki as structured journal lines. The bookkeeper opens a clean day, not a tab full of R-Series exports.
Daily till reconciliation with the accounting ledger, not a month-end catch-up. Real margin per shop after supplier invoices and markdowns, ready on the first of the month.
Buyers see margin, cover and supplier lead time in one screen, so reorder decisions sit on numbers instead of gut feel. Store managers see today against plan before the afternoon rush.
Inventory drift between shops, dead stock and supplier fill rate surface before they hurt. Transfers replace a second purchase order when the same SKU already sits in another shop.
Register totals, payment types and refunds from Lightspeed Retail land daily in Exact Online as journal entries with the right VAT split. The end-of-day reconciles on its own, and the bookkeeper stops chasing exports to close the month.
For retailers running R-Series in the shop and Shopify online, Data Panda stitches the same customer, SKU and order across both. Sales, returns and loyalty reporting hold up at group level instead of living in two disconnected dashboards.
Customer purchase history from the till flows into Klaviyo as profile properties and events. In-store buyers receive campaigns based on what they bought in the shop, not just what they clicked, and flows stop treating a shop-only customer as a cold lead.
Enriched product records from Akeneo flow into R-Series items and item matrices, with the same descriptions, attributes and media the webshop uses. Staff on the floor see the same product story the customer saw online, and catalogue updates stop being a double data-entry job.
You keep the reporting tool you already have. We connect it to the warehouse where your Lightspeed Retail (R-Series) data lives.
OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.
Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.
We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.
We set up the foundation. Your team builds on top.
Best fit Teams that already have a BI analyst or data engineer and want to own the build.
We build the whole thing, end to end.
Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.
You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.
Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.
No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.
No. R-Series is the retail POS (the former Vend product, which Lightspeed bought in 2021). Lightspeed eCom (the former SEOshop webshop that Lightspeed bought in 2015) is the webshop product and K-Series is the restaurant POS. Data Panda has separate connectors for each, and if you run more than one we stitch them in the warehouse.
Items and their variants land in the warehouse with the matrix relationship intact, so a parent style and every colour-size SKU sit together. Margin and sell-through reports roll up and drill down without the variants exploding into flat rows.
Each shop comes across with its own identifier, and sales, inventory and staff are joined to the right shop. Group reporting, transfers and same-store comparisons are ordinary queries in the warehouse instead of a merge job in Excel.
We review your Lightspeed Retail (R-Series) setup and the systems around it. Together we pick the first thing worth building.