Top Selling Products
SQL query for LightSpeed eCom
Retrieve the top 10 best-selling products based on the total quantity sold.
SELECT p.product_name, SUM(ol.quantity) AS total_quantity_sold FROM products p INNER JOIN orderlines ol ON p.product_id = ol.product_id GROUP BY p.product_name ORDER BY total_quantity_sold DESC LIMIT 10;
LightSpeed eCom data model
Orders
Carts
Products
Customers
Discount Coupons
Subscriptions
Categories
Customer Groups
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed