A spreadsheet is just a tool. The real power comes from the workflow you build around it. In this guide, we show you the complete order tracking workflow that gets the most out of the acbuy spreadsheet.
This workflow covers the entire order lifecycle: from the moment you find an item on oocbuy.com, through ordering, tracking, receiving, and finally archiving. Each step has specific actions and timeframes.
Order Placement Workflow
The workflow starts when you decide to buy an item. The first step is adding the item to your acbuy spreadsheet before you place the order. This is critical. Many users add items after ordering, which defeats the purpose of tracking.
Enter the Product Name, Category, Price, and Seller. Set the Status to "Ordered". Add the Order Date. Leave the Tracking Number blank for now. You will fill it in later when the seller provides it.
Add a link to the product page in the Notes column. This makes it easy to find the item again if you need to reorder or check details. The link should be a clickable hyperlink, not plain text.
Pre-Order Entry
Add the item to your spreadsheet before placing the order. This prevents forgetting and gives you a budget check before committing.
Place the Order
Buy the item on oocbuy.com. Copy the order number and paste it into the Notes column of your spreadsheet.
Update Status
Change the status to "Processing" immediately after placing the order. This keeps your tracking current.
Record Shipping Info
When the seller provides a tracking number, add it to your spreadsheet. Add the carrier name and estimated delivery date.
Update Status Timeline
As the order moves through stages, update the status: Processing -> Shipped -> In Transit -> Delivered.
Daily Tracking Routine
A good tracking workflow includes a daily routine. Spend 5 minutes every morning checking the status of your active orders. This prevents surprises and keeps your data current.
The daily routine is simple: open the spreadsheet, sort by Status to show pending orders, check the carrier websites for updated tracking, update any status changes, and check for any orders that are past their estimated delivery date.
Set a reminder on your phone. The 5-minute investment prevents hours of problems later. A delayed package that you notice early is a package you can follow up on. A delayed package you do not notice becomes a lost package.
Delivery Confirmation Process
When a package arrives, you are not done. The delivery confirmation process is critical for accurate records. First, verify the item matches the order. Check for damage, wrong size, or wrong color.
Update the status to "Delivered" in your spreadsheet. Add the actual delivery date. This helps you calculate average delivery times by carrier. If you know EMS takes 14 days on average and a package is 20 days late, you know it is a problem.
If the item is for resale, update the status to "In Stock" instead of "Delivered". This moves it into your inventory system. The reseller workflow adds listing and selling steps after this.
Archiving and Reporting
After delivery, the order does not need to stay in your active sheet. The archiving process keeps your active sheet fast while maintaining a complete history.
Move delivered orders to a Completed Orders sheet after 7 days. This gives you a week to review the order before archiving. The 7-day delay is a buffer for returns and disputes.
At the end of each month, generate a summary report. The report should include: total orders, total spending, average order cost, delivery success rate, and any issues. This monthly review helps you spot trends and improve your buying process.
Frequently Asked Questions
How long does the daily routine take?
The daily routine takes 3-5 minutes for 10-15 orders. It scales to about 10 minutes for 50+ orders if you use the paid auto-tracking feature.
What if I forget to update the spreadsheet?
Set a phone reminder. The auto-tracking feature in the paid version also helps by automatically updating statuses when carriers update tracking.
Should I archive immediately after delivery?
Wait 7 days. This gives you time to review the order, handle any issues, and process returns before archiving.
How do I handle returns?
Do not archive returned orders. Change the status to "Returned" and move them to a separate Returns sheet for tracking.