How to Use Basetao Spreadsheet: Step-by-Step Tutorial 2026

Understanding the Basetao Spreadsheet Structure

A well-built basetao spreadsheet has three core tabs: Active Orders, Completed Orders, and Summary Dashboard. The Active Orders tab holds everything currently in progress. Completed Orders serves as your archive. The Summary Dashboard auto-calculates totals and trends from both tabs.

Within the Active Orders tab, the standard column sequence runs left to right: Order Number, Item Name, Product URL, Seller, Date Ordered, Item Price, Agent Fee, Shipping Estimate, Total Cost, QC Status, Tracking Number, Shipping Method, Estimated Arrival, and Notes. Every column exists for a reason. Skip none of them.

Filling in Your First Order Row

Start by creating a unique order number. Use a simple format like BTS-001, where BTS stands for basetao and 001 increments with every new order. This number becomes your anchor across all future references.

Paste the basetao product URL directly into the URL column. Do not shorten it. The full link preserves your ability to return to the exact product page months later when you want to reorder or check for price changes.

Enter the item price exactly as quoted by the seller, in your local currency. In the Agent Fee column, enter the percentage your agent charges. The Total Cost column should contain a formula that adds Item Price plus (Item Price times Agent Fee percentage) plus Shipping Estimate.

Managing QC Photos and Approval Workflow

QC status is the heartbeat of your basetao spreadsheet. Create a dropdown with these exact options: Awaiting QC, QC Received, Approved, Rejected, and Return Requested. Never type status manually; typos break your filtering later.

When QC photos arrive, download them into a dated folder on your device. In the spreadsheet, change the status to QC Received and add a note like "Photos in folder 2026-05-20." If you approve the item, flip the status to Approved. If you reject it, mark Rejected and immediately message your agent through the platform.

The key discipline here is speed. Update your spreadsheet within ten minutes of every QC event. Delays compound into lost return windows and forgotten complaints.

Shipping and Tracking Integration

Once an item ships, your agent provides a tracking number. Paste it into the Tracking Number column immediately. In the Shipping Method column, note whether it is EMS, DHL, FedEx, or a line-specific option. This matters for delivery speed estimates and customs risk profiling.

Use conditional formatting to highlight tracking numbers older than fourteen days without a delivery scan. A soft orange background draws your eye to stalled packages before they become real problems. When the item arrives, update the status to Delivered, verify the contents, then cut the entire row and paste it into the Completed Orders tab.

Pro Tips

Frequently Asked Questions