---
updatedAt: 2025-10-21T13:57:57.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Shipstation Shipments

# Overview

Shipstation Shipments represent the total number of shipments shipped via Shipstation.

> 📘 Shipstation Shipments = Number of Shipments Shipped via Shipstation

The calculation is based on data from the [Shipping](https://triplewhale.readme.io/docs/shipping-table#/) table.

***

### Detailed Breakdown

The formula above is derived from the following components:

* **Shipments** = `COUNT(1)` -->[Shipping](https://triplewhale.readme.io/docs/shipping-table#/) table
* **Shipstation** = `shipping_platform = 'shipstation'`

# Insights and Actions

Shipstation Shipments help you understand fulfillment volume managed outside major marketplaces, providing visibility into operational scale and shipping efficiency:

* **Track Fulfillment Volume Trends**: Monitor changes in Shipstation shipments over time to understand order flow, peak seasons, and fulfillment capacity needs.
* **Analyze Carrier and Cost Efficiency**: Pair shipments data with Shipstation Shipping Cost to calculate average cost per shipment and identify cost-saving opportunities with carriers or packaging.
* **Compare Channel Fulfillment Mix**: Compare Shipstation shipments to Amazon Orders or Shopify Orders to understand how your direct-to-consumer channels contribute to total order volume.

### Related Metrics

* **Shipstation Shipping Cost** – Pairs with shipment count to analyze cost per shipment and logistics efficiency.
* **Shipping Costs** – Provides a broader view of total shipping expenses across all platforms.
* **Orders** – Helps correlate overall order volume with fulfillment activity to ensure capacity and operations are aligned.

# Example Use

### Prompt

> How many Shipstation shipments were there in the last 30 days?

### Response

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

### Query

```sql
SELECT
  COUNT(1) AS total_shipstation_shipments
FROM
  shipping_table AS shipt
WHERE
  shipt.shipping_platform = 'shipstation'
  AND shipt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;
```