How often should I update shipping status?

For express shipping (3-7 days), check daily. For standard shipping (10-20 days), check every 2-3 days. Bulk buyers should schedule a weekly "shipping update" block and batch-process all orders at once.

What do I do if tracking shows no movement for 10 days?

First, verify the tracking number with the carrier directly. Then check with the seller via oocbuy messaging. If the item was shipped via postal service, 10-day gaps are normal during customs. Only escalate after 20 days of no movement.

Should I track delivery dates or only shipping dates?

Track both. Record the ship date, the estimated delivery window, and the actual delivery date. Comparing estimated vs actual delivery builds a personalized dataset that helps you predict future arrival times and plan reselling timelines.

How to Track Shipping in a Cnshopper Spreadsheet

LogisticsMay 10, 202610 min read

The thrill of clicking "buy" on oocbuy fades fast when you are staring at a blank tracking page for weeks. Shipping from overseas involves multiple carriers, customs checkpoints, and unpredictable delays. Without a system, you forget what you ordered, miss delivery windows, and waste hours digging through emails for tracking numbers. A dedicated cnshopper spreadsheet for shipping transforms chaos into controlled, trackable logistics.

The Shipping Tracker Layout

A shipping-focused spreadsheet starts with your existing order data and adds logistics columns. The goal is one row per order with every piece of tracking information visible at a glance. No more opening five browser tabs to check where your packages are.

Product	Tracking #	Carrier	Ship Date	Est. Arrival	Status	Days
Jordan 1	LN12345678CN	EMS	05/01	05/15	Delivered	14
Dunk Low	SF98765432	SF Express	05/05	05/18	Customs	10
Yeezy 350	CP12345678	China Post	05/08	05/28	Shipped	3

The Days column uses a simple formula: =TODAY()-ShipDateCell. This auto-calculates how long each package has been in transit. When a package exceeds your typical delivery window, the cell turns red via conditional formatting. You spot delays instantly without manually checking each tracking number.

Carrier Comparison for Oocbuy Orders

Different carriers offer different tradeoffs between speed, cost, and tracking granularity. Your spreadsheet should record which carrier handled each shipment so you can build a personal performance database over time.

Carrier	Speed	Tracking	Cost	Best For
SF Express	5-10 days	Excellent	High	Urgent orders, resellers
EMS	10-18 days	Good	Medium	Regular orders, good balance
China Post Air	15-30 days	Basic	Low	Non-urgent, budget buyers
DHL	3-7 days	Excellent	Very High	Premium items, time-sensitive

After tracking 20+ shipments, sort your spreadsheet by carrier and average the Days column. You will have personalized data on which carrier actually delivers fastest to your specific address — far more valuable than generic carrier marketing claims.

Automated Status Updates

Manually checking 15 tracking numbers every morning is unsustainable. Smart shoppers use two shortcuts. First, create a column of clickable tracking URLs using the HYPERLINK formula: =HYPERLINK("https://www.sf-express.com/tracking?number="&B2,"Track"). One click opens the carrier tracking page with the number pre-filled.

Second, use a shipping aggregator service like 17track.net or AfterShip. These platforms accept a CSV export of your tracking numbers and check all carriers simultaneously. Export your Tracking # and Carrier columns weekly, upload to the aggregator, and review all statuses on one dashboard. Then paste the updated status back into your spreadsheet.

Get the Shipping Tracker Template

Download our pre-built shipping tracker with carrier formulas, conditional formatting, and status color codes included.

Download Template

Handling Customs and Delays

Customs delays are the most anxiety-inducing part of international shopping. Your spreadsheet can reduce that anxiety by systematizing the process. Add a Customs Status column with dropdown values: Not Yet, In Review, Cleared, Duty Owed. When a package hits customs, update the status and set a reminder for 7 days. If it is still in review after a week, check with the carrier. This prevents both panic and forgetfulness.

For packages requiring import duties, create a Duties column. Record the amount owed, payment date, and receipt number. This documentation is essential for resellers who deduct import costs from taxable revenue. Casual buyers benefit too — seeing the true total cost (product + shipping + duties) prevents sticker shock and helps you budget accurately for future orders.

Frequently Asked Questions

Yes. Add columns for Carrier, Origin Country, and Tracking URL. International orders take longer, so use a separate tab or color-code rows by region to keep domestic and international shipments visually distinct.

Continue Reading

Cnshopper spreadsheet guide Organize orders Products to track Back to homepage

Never lose track of a package again. Start building your shipping tracker today.

Start Tracking