How do I check my Google Sheets sync for missed orders?
Compare the orders in Shopify that match a sync with the orders in your Google sheet, to find any order the sync missed. Columna also does this on its own once a week and adds the missing orders.
Before you start
- The sync is saved and has run at least once (see “How do I sync new orders to Google Sheets?”).
- The check reads the sheet’s Order ID (sync key) column. Keep that column in the tab the sync writes to.
Check for missed orders
- In the app, open Settings and pick Google Sheets sync. For one of your other syncs, open it from More syncs.
- In the Status section, find Missed orders.
- Set Orders placed from and Orders placed to. The check starts on the last 7 days, today included. A range can be at most 31 days.
- Click Check for missed orders.
The check only reads. Nothing is changed in Shopify or in your sheet.
The weekly check
Once a week Columna checks every saved sync on its own, on every plan.
- It compares the orders placed in the last 31 days, up to the sync’s last run, with the Order ID (sync key) column of the sheet. It counts only the orders that match the sync’s filters.
- It adds the missing orders to the sheet the same way a sync run adds them, up to 250 per check. Any others are added by the next weekly checks.
- It skips the check when more than 10,000 orders match the sync in those 31 days, and says so. Use Check for missed orders on shorter ranges instead.
The result shows under Weekly check in the Status section, for example “All 1,234 orders from the last 31 days are in the sheet.” or “Added 3 missing orders to the sheet.”, with the date of the check and the orders it covered. Before the first check you see what it will do.
If you delete rows of orders placed in the last 31 days, the weekly check adds them back. Rows of older orders stay deleted.
If the sync started writing to a new tab, for example “Orders 2” after you changed the template’s columns, the check reads only the current tab. Orders that are only in the older tab count as missing and are added to the current tab.
If a check fails, you see the reason and the check runs again a few hours later. When it keeps failing you get the same email as for a sync that stopped working, and Shopify Flow workflows that start with Columna export failed run (see “How do I start a Shopify Flow workflow when an export stops working?”).
Verify it worked
After step 4 you see one of these results, with “Checked orders placed from … to …” under it:
- No missed orders, with “Shopify: … orders · exported: … · missing: 0”.
- Orders missing, with the counts and “These orders match the sync but are not in the sheet’s Order ID column. Contact support and we will look into it.”
- “No orders matching this sync were placed in this range.”
The check counts only the orders that match the sync’s filters, such as Payment status or Tagged with.
Troubleshooting
You see “Pick a range of at most 31 days.” Shorten the range.
You see “The end date must be on or after the start date.” Swap the dates.
You see “There are more than 25,000 orders in this range, too many to compare. Pick a shorter range and check again.” Shorten the range and check again.
You see “The sync has not added any orders yet. Check again after its first run.” Wait for the first run, or click Sync now.
You see “This sync only adds orders placed since it started, up to its last run. Pick dates in that period.” Pick dates on or after the date shown in “Adds orders placed since …”.
You see “This sync’s template writes a report, not rows per order, so its orders cannot be compared.” The sync uses a summary template, such as a tax report. The check works only with templates that write rows per order.
You see “Shopify could not count the orders right now. Try again in a few minutes.” Wait a few minutes and check again.