How to Organize Orders with BBDBuy Spreadsheet: A Shipping Tracker

Building the Orders Dashboard

Create a dedicated Orders tab with these columns: Order Date, Product Name, Store Link, Seller Name, Tracking Number, Carrier, Ship Date, Est. Arrival, Actual Arrival, and Status. Status should be a dropdown with values: Ordered, In Transit, Customs, Out for Delivery, Delivered, and Issue.

Color-code the Status column with conditional formatting. Green for Delivered, yellow for In Transit, red for Issue, and gray for Ordered but not yet shipped. One glance at the dashboard tells you exactly which packages need attention today.

• Order Date: when you placed the order
• Tracking Number: from the seller or agent
• Carrier: DHL, EMS, FedEx, etc.
• Est. Arrival: seller estimate + 3 days buffer
• Status: dropdown with 6 standardized values

Handling Delays and Lost Packages

International shipping delays are inevitable. The difference between a professional reseller and a stressed beginner is preparation. When a package exceeds the Est. Arrival date by 7 days, mark it as Delayed and open a polite inquiry with the seller. When it exceeds 14 days, escalate to a formal tracking investigation.

Log every communication in a Notes column. This creates a paper trail that protects you in disputes and helps you identify which carriers or sellers consistently underperform. Over time, this data guides your future seller selection.

Automating Arrival Notifications

If you use Google Sheets, install a simple script that checks the Est. Arrival column daily and sends an email when any row hits zero days remaining. This automation eliminates the need to manually scan the dashboard every morning.

For Excel users, set a recurring calendar reminder to review the Orders tab every Monday and Thursday. Two checks per week catches delays early without consuming unnecessary mental energy.