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 table.

Detailed Breakdown

The formula above is derived from the following components:

• Shipments = COUNT(1) -->Shipping 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

Query

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;