Total sales by product category
SQL query for Cin7 Omni
Calculate the total sales for each product category.
SELECT pc.name AS product_category, SUM(so.total) AS total_sales FROM product_categories pc JOIN products p ON pc.id = p.product_category_id JOIN sales_orders so ON p.id = so.product_id GROUP BY pc.name
Cin7 Omni data model
Adjustments
Branches
Branch Transfers
Bom Masters
Contacts
Credit Notes
Payments
Products
Product Categories
Production Jobs
Purchase Orders
Quotes
Sales Orders
Serial Numbers
Size Ranges
Stocks
Users
Vouchers
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