How do I find products that are losing money with iDBQuery?
Ask iDBQuery which products lose money and it ranks every product by margin, flags the ones where cost, discounts or returns exceed revenue, and cites the exact rows behind each figure. You get a defensible list of loss-makers in seconds, not a week of spreadsheet work.
Every catalogue has quiet loss-makers: products that sell but cost more to make, ship, discount or return than they bring in. Finding them by hand means reconciling revenue, COGS, freight and refund data across systems. iDBQuery does it from a plain-language question.
- It joins sales, cost, discount and returns data into one live queryable model
- It calculates net margin per product and surfaces anything negative or below a threshold you name
- It shows a cited breakdown so you can see whether it is high cost, deep discounting or high returns dragging a product down
- You can drill in with a follow-up like *why is this SKU unprofitable?* and get the contributing factors
For instance, ask *which products had negative gross margin after discounts and returns last quarter?* iDBQuery returns the offenders with the numbers behind each, so you can decide whether to reprice, stop discounting, or discontinue.
The key difference from a black-box AI is that iDBQuery cites every figure back to the source rows. When you tell a product owner their favourite line is losing money, you can show exactly which orders, costs and refunds prove it, which turns an argument into a decision.
Updated 2026-06-22