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

Before You Start: What You Need

To follow this tutorial, you only need two things: a Google account and access to your basetao agent order pages. If you prefer Excel, the steps are nearly identical. We recommend Google Sheets for beginners because it auto-saves, works on mobile, and supports real-time collaboration.

Gather your recent order details before opening the spreadsheet. You will need item names, purchase prices, agent fees, shipping estimates, and any tracking numbers you have received. Having this data ready makes the setup feel instant rather than tedious.

Step 1: Open the Template

Start by opening the basetao spreadsheet template in Google Sheets. Go to File > Make a Copy to create your own editable version. Rename it something memorable like 'Basetao Orders 2026.' This copy is yours alone. No one else can see it unless you share the link.

Take a moment to look at the column headers. You will see Item Name, Category, Purchase Price, Agent Fee, Shipping Cost, Total Cost, Resale Price, Profit Margin, Status, Tracking Number, and Notes. Do not worry if some columns feel unnecessary right now. You can hide them later without breaking anything.

Step 2: Enter Your First Order

Click the first empty row below the headers. Enter the exact item name as it appears on your agent page. This precision matters because you will reference this sheet weeks later when memory fades.

In the Purchase Price column, enter the yuan amount you paid. The adjacent column converts this to your local currency using a live exchange rate formula. Next, enter the agent service fee. Most agents charge between five and ten percent. Check your order confirmation if unsure.

Leave Shipping Cost blank for now unless your agent has already provided a quote. The Total Cost column will sum Purchase Price, Agent Fee, and Shipping automatically. Watch the formula work in real time. That instant feedback is why spreadsheets beat manual tracking.

Step 3: Set Status and Track Progress

The Status column is your command center. Use the dropdown options: Ordered, In Warehouse, Shipped, Delivered, or Cancelled. This single column tells your entire order story at a glance.

When your item arrives at the agent warehouse, update the status to In Warehouse. When it ships, change to Shipped and paste the tracking number into the Tracking Number column. The tracking number becomes a clickable link if formatted correctly.

Step 4: Calculate Profit Margins

Profit tracking is where the basetao spreadsheet truly shines. In the Resale Price column, enter what you expect to sell the item for. The Profit Margin column instantly calculates your percentage return.

A healthy margin for most resellers falls between twenty and forty percent. If you see a margin below fifteen percent, reconsider whether the item is worth buying. This data-driven approach prevents emotional purchases and protects your cash flow.

Step 5: Organize with Filters and Sorting

Once you have twenty or more rows, scrolling becomes inefficient. Google Sheets offers powerful filtering tools that transform your workflow. Select the header row, then click Data > Filter Views > Create new filter view.

Now you can filter by status to see only shipped items. Sort by profit margin to identify your best performers. Search by category to compare how Shoes perform against Hoodies. These views take seconds to create and save hours of analysis.

Step 6: Back Up and Share Securely

Your basetao spreadsheet is a business asset. Protect it. Google Sheets auto-saves to the cloud, but you should also download a monthly backup. Go to File > Download > Microsoft Excel.

If you work with a team, use Google Sheets sharing controls. Click Share in the top right, then set permissions to 'Viewer' or 'Commenter' rather than 'Editor' unless you trust the person completely. Never publish your spreadsheet to the web.