Shopify Analytics: Order Lookup & Sales Insights in Ask Lightspeed

Last month we launched the initial Shopify connection — read-only access to your product catalog and basic order data. That was just the foundation. Today’s update turns Lightspeed into a true Shopify command center: your team can now ask natural-language questions about orders, customers, and sales performance and get instant, accurate answers without ever leaving Lightspeed.

Ask Lightspeed About Your Orders

Ask Lightspeed now has two dedicated Shopify tools it can call automatically based on your question:

• Order lookup — Ask “What’s the status of order #1042?” or “Find orders for jane@example.com” and Lightspeed queries the Shopify API in real time. You’ll see order status, tracking numbers, fulfillment details, line items, and payment information — all formatted in a clean, readable summary.
• Customer search — Ask “Look up customer John Smith” and Lightspeed pulls the full customer profile including contact details, order history, and lifetime spend. Perfect for resolving support tickets without tab-switching.

These tools work conversationally. You can ask follow-up questions like “Was that order refunded?” or “What else has this customer ordered?” and Lightspeed maintains the context.

Summarize Your Sales Data

Beyond individual lookups, Ask Lightspeed can now summarize your entire store’s sales performance. Ask questions like:

• “How did sales look last week?”
• “What are our top-selling products this month?”
• “Compare this month’s revenue to last month”
• “Which province generates the most orders?”

Lightspeed pulls from pre-computed analytics tables that sync with your Shopify store via ShopifyQL — server-side aggregation that scales to stores with hundreds of thousands of orders without performance issues.

Full Analytics Dashboard

For teams that want a visual overview, the new Shopify Analytics Dashboard gives you everything at a glance:

• KPI cards — Total sales, order count, average order value, and conversion rate with period-over-period comparisons
• Sales trends — Interactive line charts with daily, weekly, or monthly granularity and toggles for net sales, gross sales, and order volume
• Top products — Ranked table showing your best sellers by revenue with percentage-of-total breakdowns
• Sales by channel — Donut chart breaking out direct, app, point-of-sale, and other channels
• Regional breakdown — See where your orders are coming from by province and country
• Price point analysis — Revenue distribution across price buckets to understand your product mix
• Live order feed — Real-time stream of your most recent orders with status badges

The dashboard loads instantly from locally synced data and supports preset date ranges (today, last 7/30/90 days, month-to-date, year-to-date) plus CSV and PDF export.

Real-Time Webhooks

Your analytics stay current automatically. Lightspeed registers webhooks with Shopify for order creation, updates, refunds, and fulfillment events. When a new order comes in or a refund is processed, your dashboard and AI context update within seconds — no manual sync required.

How It All Connects

The Shopify data isn’t siloed in a dashboard. It flows into every AI tool across the platform:

• Response Assistant — Automatically detects order numbers and emails in customer inquiries and injects the relevant Shopify context into the AI prompt
• Draft Assistant — Reference real sales numbers when drafting campaign emails or board reports
• Ask Lightspeed — Full conversational access to orders, customers, and analytics summaries

All data access remains read-only. Lightspeed can never modify your Shopify store, process refunds, or change order status. Your credentials are stored with industry-standard encryption and data is transmitted over encrypted connections.