Data Panda brings your Lightspeed eCom 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 eCom traces back to SEOshop, an Amsterdam-based ecommerce platform that Lightspeed bought in October 2015 and rebranded. That heritage shows in the customer base: the Netherlands is the second-largest eCom market by store count after the United States, and Belgian retailers sit close behind. A typical eCom merchant is an independent shop that needed a webshop in their own language, with multi-currency, abandoned-cart flows and a real product taxonomy, not a marketplace listing.
The data model on Lightspeed eCom holds carts, categories, customer groups, customers, discount coupons, orders, products and subscriptions. That is enough to answer the questions a webshop owner really asks, but the answers sit across the storefront, the till, the accounting package and the email tool. Pulling eCom into a warehouse is where the cart that did not convert, the loyal customer who walked into the shop instead, and the subscription that quietly churned, finally land in the same picture.
Cart, conversion and category performance beyond the eCom back office.
Turn eCom orders and cart events into timely actions across finance, marketing and stock.
Use webshop history to sharpen recommendations, retention and forecasting.
Internal tools that replace the spreadsheet between marketing, the shop and the warehouse.
A list of concrete reports, automations and AI features we have built on Lightspeed eCom data. Pick the one that matches your situation.
Which categories really convert from cart to paid order?
Started carts joined to paid orders, broken down by category and traffic source. Surfaces the categories where cart-recovery is worth the effort and the ones where the cart is mostly window-shopping.
How is the subscription book really doing?
Active, paused and cancelled subscriptions per cohort, with MRR and churn rate. Shows whether the recurring side of the shop is growing or quietly bleeding while new orders mask the trend.
Are webshop and shop customers the same people?
Customer records joined across Lightspeed eCom and Lightspeed Retail (R-Series) by email and phone. Tells you which loyal customers buy in both channels and which only ever shop one side, so retention work has the right target.
Daily booking of webshop revenue into the accounting package, in the right currency and VAT split. Subscription MRR and churn are visible alongside one-off orders, so the recurring book stops being a guess.
Marketing sees which categories really convert and which campaigns lifted incremental orders past the discount given. Wholesale and loyalty customer groups show up with their own margin picture.
Cart abandonment by category, refund rate by SKU and stock alerts that include webshop sell-through plus shop-floor stock. Reorder decisions stop ignoring the online side of the business.
For retailers running Lightspeed Retail (R-Series) in the shop and Lightspeed eCom online, Data Panda joins customers, orders and SKUs across both. Loyalty, returns and group reporting work on one customer record instead of treating the same person as two unrelated profiles.
Lightspeed eCom orders, refunds and subscription invoices land daily in Exact Online with the right VAT split per country and the matching payment events for bank reconciliation. The webshop revenue stops needing a month-end Excel job to close cleanly.
Cart, order and subscription events from Lightspeed eCom flow into Klaviyo as profile properties and timeline activity. Recovery emails target the categories that really convert, post-purchase flows are grounded in what people really bought, and subscription win-back campaigns get a real churn signal.
Sendcloud shipping events are joined to the eCom order they belong to, so carrier choice, shipping cost and on-time rate sit next to the margin on each order. Repeat returners and the categories with the worst delivery experience surface before they show up in the support queue.
These are the 8 tables we currently pull from Lightspeed eCom into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.
Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.
You keep the reporting tool you already have. We connect it to the warehouse where your Lightspeed eCom 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. Lightspeed eCom is the webshop product that traces back to SEOshop, the Amsterdam platform Lightspeed bought in 2015. Lightspeed Retail (R-Series) is the in-shop POS. Many independent retailers in Belgium and the Netherlands run both. Data Panda has a separate connector for each, and stitches them in the warehouse on customer and SKU.
Yes. The subscriptions table from Lightspeed eCom lands in the warehouse with status, plan and renewal events intact. Active, paused and cancelled subscriptions are visible per cohort, so MRR and churn are first-class numbers next to one-off orders rather than a manual count.
Orders keep their original currency and the FX rate at order time. Reporting can show revenue in the original currency for marketing and a single reporting currency for finance, without having to redo the conversion in Excel each month.
We review your Lightspeed eCom setup and the systems around it. Together we pick the first thing worth building.