Run product-based queries in Query Builder

Create these product-related queries in Query Builder to get answers that affect the bottom line.

Query Builder can provide insights that aren't readily surfaced in the dashboards by letting you build custom, no-code queries specific to your data. For an introduction, see Get started with Query Builder.

In this article

• Find out which products are losing money
• List orders that are out-of-stock

Find out which products are losing money 

To find out how a brand (and its related products) is performing in the marketplace, return a list of product SKU numbers based on their profitability margin. This helps you identify products that are losing money. 

1. From the Query Type menu, select Product
2. Specify products whose gross profit was less than 1 USD. Select the following settings from the drop-down menus:  
   

   Category	Product attributes
   Field	gross profit
   Operator	less than
   Value	0 (zero)

List orders that are out-of-stock 

Use this query to determine if any of the products ordered have zero inventory and can't be fulfilled.

Related resources

Check open orders for delivery latency in Query Builder

Get started with Query Builder