Order Sync WatchGuide

Shopify orders missing in Click & Drop: how to find exactly which

Updated 2026-10-10 · by Hieu Tran, written with AI agents and checked against the sources below

When the Click & Drop sync stops, the hard part isn't fixing it, it's knowing which orders never arrived. Compare a Shopify export with a Click & Drop export for the same dates and the gap is your list.

Compare the two lists

1. In Shopify admin, export orders for the date range (Orders → Export, CSV). The order number is in the Name column, like #1001.
2. In Click & Drop, export orders for the same dates, including every status (new, despatched, archived).
3. Normalise the order numbers: drop the # and any prefix so #1001 and 1001 match.
4. Shopify exports one row per line item: keep one row per order.
5. Remove cancelled and refunded orders and anything without a shipping address.
6. Every Shopify order left that isn't in the Click & Drop list is missing.

Then

• Import the missing orders into Click & Drop by CSV, or trigger a re-sync, then repeat the comparison.
• Check dispatched parcels whose tracking never came back to Shopify; customers chase those next.
• Recent Click & Drop app reviews describe orders stopping without warning, so run this comparison daily until you trust the sync again.