What is the difference between "Shipped" and "In Transit"?

"Shipped" means the seller has handed the package to the carrier but tracking may not yet show movement. "In Transit" means the carrier has scanned the package and it is actively moving through the logistics network. This distinction matters because "Shipped" with no tracking update for 5+ days often indicates a problem.

Should I archive completed orders or keep them visible?

Archive orders older than 90 days to a separate "History" tab. Keep the active sheet lean for fast loading and easy scanning. The History tab serves as your purchase record for returns, warranty claims, and tax documentation. Use a formula or script to auto-move rows when Status changes to "Delivered" and Date is older than 90 days.

How do I handle cancelled or refunded orders?

Do not delete cancelled orders — they are valuable data. Change the Status to "Cancelled" or "Refunded" and add a Refund Amount column. This tracks your refund success rate and helps identify problematic sellers. A high cancellation rate from a specific seller is a red flag for future orders.

Cnshopper Order Status Guide

TrackingApril 24, 20268 min read

Every oocbuy order passes through a predictable lifecycle. Understanding each stage — what it means, how long it should take, and when something has gone wrong — transforms anxious waiting into managed expectations. A well-structured cnshopper spreadsheet with clear status stages is your early warning system for delays, your reassurance that progress is happening, and your documentation if disputes arise.

The Complete Order Lifecycle

These are the standard stages every international oocbuy order moves through. Your spreadsheet should use these exact labels (or a subset) so your status data is consistent and comparable over time.

Status	Meaning	Typical Duration	Action Required
Wishlist	Item saved but not yet ordered	Indefinite	Monitor price, wait for budget
Ordered	Purchase completed, payment sent	1-3 days	Wait for seller confirmation
Processing	Seller preparing item for shipment	2-5 days	Wait, check after 5 days
Shipped	Handed to domestic carrier	1-2 days	Watch for tracking update
In Transit	Moving through logistics network	5-15 days	Track periodically
Customs	Held at destination customs	1-7 days	Wait, check if over 7 days
Delivered	Arrived at your address/agent	—	Inspect, update spreadsheet
Archived	Completed and moved to history	—	Tax record, no action

The Processing stage is where most delays originate. Sellers on marketplace platforms may take 3-7 days to ship even when they promise "24-hour shipping." Set a conditional formatting rule that highlights any row with Status="Processing" and Days Since Order > 5. This auto-flagging prompts you to message the seller before the delay becomes unrecoverable.

When to Escalate: Delay Thresholds

Patience is a virtue, but blind patience is expensive. Every stage has a reasonable window. Exceeding that window is your signal to act. These are the exact escalation thresholds experienced shoppers use.

Status	Normal Max	Escalate At	Escalation Action
Processing	5 days	7 days	Message seller
Shipped (no tracking)	3 days	5 days	Request tracking #
In Transit	15 days	20 days	Check with carrier
Customs	7 days	10 days	Contact customs office
Delivered (not received)	2 days	3 days	File missing package claim

Add an "Escalation Date" column to your spreadsheet using formulas: =IF(Status="Processing",OrderDate+7,""). This auto-calculates the exact date when each order crosses into escalation territory. Sort by this column weekly and proactively address items before they become problems.

Color-Coded Status System

Visual processing is faster than reading. A color-coded status system lets you scan 50 orders and instantly identify which ones need attention. Apply these colors as conditional formatting rules in your spreadsheet.

Green: On Track

Wishlist, Ordered, Processing (under 3 days), In Transit (under 10 days), Delivered. These orders require no action. Green means relax.

Yellow: Watch

Processing (3-5 days), In Transit (10-15 days), Customs (under 7 days). These orders are within normal ranges but approaching thresholds. Yellow means monitor.

Red: Act Now

Processing (over 5 days), In Transit (over 15 days), Customs (over 7 days), Delivered but not received. These orders have crossed escalation thresholds. Red means act.

The exact color rules should live in a hidden "Rules" tab or in your spreadsheet documentation. This ensures anyone who edits the sheet understands the color logic and maintains consistency. Without documented rules, conditional formatting drifts into chaos over time.

Get the Status Tracker Template

Pre-configured with all status stages, color coding, escalation formulas, and auto-calculated delay warnings.

Download Status Template

Automated Status Updates

Manual status updates are the first thing shoppers skip when busy. Automation keeps your data current without daily effort. The simplest automation uses spreadsheet formulas to infer status from dates. If an order has a Tracking Number but no Delivery Date, and it is been 3+ days since shipment, the status auto-updates to "In Transit." If it has been 15+ days, it auto-updates to "Check Carrier."

For advanced users, Google Apps Script can query carrier APIs and auto-update tracking status directly in your spreadsheet. This requires a script and API access but eliminates manual tracking updates entirely. A middle-ground approach uses a tool like 17track.net to bulk-check tracking numbers, then paste the updated statuses back into your sheet in a single weekly operation.

Frequently Asked Questions

For most shoppers, 6-8 stages is optimal: Wishlist, Ordered, Processing, Shipped, In Transit, Customs, Delivered, Archived. Fewer stages lack granularity. More stages create unnecessary maintenance overhead. Group buyers may add "Payment Pending" and "Ready for Pickup" stages.

Continue Reading

Cnshopper spreadsheet guide Shipping tracking Organize orders Back to homepage

Know where every order is, when to worry, and when to wait.

Track Orders