# Orders stuck unshipped

> Paid orders can sit unshipped because of stock gaps, address issues or a slow warehouse, and late orders turn into refunds and bad reviews. Connect Shopify to Claude and ask it to list paid orders older than 3 days that have not shipped and chart average time to ship per week. Clear the backlog and fix the bottleneck.

Type: Leak (something broke or wastes money)
Run it: Daily
Source: https://gooseworks.ai/playbooks/shopify-orders-not-shipped

## 1. Connect

Give your AI assistant read-only access to Shopify.

## 2. Ask

```text
List every paid order older than 3 days that hasn't shipped, with its age, value and products. Also chart the average time from order to shipment per week for the last 12 weeks.
```

## 3. Act

Clear the backlog. If the average is rising, find the bottleneck before the complaints start.

## Steps

1. Connect Shopify read-only, through a Claude connector or MCP server if you use one, or upload an unfulfilled orders export.
2. Run the prompt to list paid orders older than 3 days that have not shipped and chart weekly ship times.
3. Exclude pre-orders and made-to-order items, which are meant to ship later.
4. Clear the backlog, and find the bottleneck if average time to ship is rising.
5. Ask Claude to re-run the check every day.

## What it tends to find

23 orders were more than 5 days old and still not shipped. (Illustrative example, not a result from a named store.)

## Watch out

Pre-orders and made-to-order items should be excluded.

## FAQ

### How do I find unshipped orders in Shopify?

Filter orders by paid and unfulfilled, then sort by date. The prompt does this and adds age, value and products so you can act fast.

### How long is too long to ship an order?

It depends on what you promise at checkout. Use your own shipping promise as the line, and act on anything older. Shoppers judge you against the date you showed them.

### Can other assistants run this?

Yes. The prompt works with ChatGPT, Grok, Muse or any assistant that can read your Shopify orders, through a connection or an export. The order data is what matters.

### Why should I track average ship time?

A rising average warns you before complaints and chargebacks arrive. It points to a bottleneck in stock, packing or the carrier. Weekly tracking makes the trend easy to see.