---
updatedAt: 2025-10-19T08:47:30.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Amazon Items Sold

product_quantity_sold_in_order

# Overview

Amazon Items Sold refers to the total number of individual items or products that were purchased by customers on Amazon.

> 📘 Amazon Items Sold = The total quantity of product units ordered on Amazon

The calculation is based on data from the [Orders](https://triplewhale.readme.io/docs/orders) table.

### Detailed Breakdown

The formula above is derived from the following components:

* Items Sold = `SUM(product_quantity_sold_in_order)` --> [Orders](https://triplewhale.readme.io/docs/orders-table) table
* Amazon Sales = `where platform = 'amazon'`
* Excluding Canceled Orders = `amazon_fulfillment_status != 'Canceled'`

> 🚧 **Why Summary Page Values May Differ**
>
> The Summary page **excludes canceled orders**, while queries in Moby/Dashboards/SQL builder include all orders unless explicitly filtered.
>
> To match the Summary page using SQL, use a filter to exclude canceled orders: `WHERE amazon_fulfillment_status != 'Canceled'`

# Insights and Actions

Amazon Items Sold measures unit-level sales volume on Amazon, giving insight into demand patterns and product performance:

* **Track Product Demand**: Monitor how many items are sold over time to spot growth trends, seasonality, or declining products.
* **Evaluate Average Order Size**: Compare items sold against order counts to calculate units per order and assess customer purchasing behavior.
* **Optimize Inventory Planning**: Use unit sales trends to align stock levels with demand, reducing risks of overstock or stockouts.

### Related Metrics

* **Units Sold**: Total units sold across all platforms, useful for benchmarking Amazon’s share of sales volume.
* **Amazon Orders**: Amazon order counts, providing context for calculating units per order.
* **Gross Sales**: Total revenue across all platforms, to see whether Amazon drives higher unit volume or higher-value sales compared to other channels.

# Example Use

### Prompt

> How many Amazon items were sold over the last 30 days?

### Response

<Image border={false} src="https://files.readme.io/6f8574c6c9f29d3ad83c13c7baed941157e3fff23764e62b30f0d94184876de8-image.png" />

### Query

```sql
SELECT
  SUM(ot.product_quantity_sold_in_order) AS total_units_sold
FROM
  orders_table AS ot
WHERE
	ot.platform = 'amazon'
	AND ot.amazon_fulfillment_status != 'Canceled'
  AND ot.event_date BETWEEN CURRENT_DATE() - INTERVAL 30 DAY AND CURRENT_DATE()  - INTERVAL 1 DAY;
```