What if I accidentally delete a formula?

Google Sheets has version history. Go to File > Version History > See Version History to restore any previous state.

How do I share only part of my spreadsheet with an agent?

Create a separate tab with just the columns the agent needs, then share only that specific tab or range.

Does the spreadsheet work offline?

Google Sheets has an offline mode you can enable in settings. Excel works offline by default if saved locally.

Tutorials

How to Use Itaobuy Spreadsheet Step-by-Step

May 18, 2026 · 12 min read

Learning how to use the itaobuy spreadsheet properly can cut your order management time by seventy percent. This tutorial walks you through every stage — from opening your first blank sheet to running advanced filters that show exactly which orders need attention today. No shortcuts, no assumptions. Just clear steps you can follow immediately.

Start Using Itaobuy Spreadsheet →Read Full Guide

What You Will Learn in This Tutorial

How to structure your spreadsheet for maximum clarity.
The exact columns every smart shopper needs.
How to use formulas that auto-calculate totals and flag delays.
Filtering tricks that surface urgent orders instantly.
Sharing settings for collaborating with agents or friends.

Part 1: Building the Foundation

Choose Your Platform

Google Sheets is the best starting point for most users. It is free, cloud-based, automatically saves, and works on every device. Microsoft Excel offers more formula power but requires local storage unless you subscribe to OneDrive. For this tutorial, we use Google Sheets, but every step translates directly to Excel.

Create Your Header Row

Row one is sacred. It defines every column in your tracker. Here are the essential headers in recommended order: Item Name, Seller / Store, Product URL, Size, Color, Unit Price, Domestic Shipping, International Shipping, Total Cost, Order Date, Tracking Number, Status, Notes.

Bold your header row and freeze it so it stays visible when you scroll. In Google Sheets, go to View > Freeze > 1 Row. This small step prevents endless scrolling back to remember column names.

Part 2: Data Entry Best Practices

Copy the exact item name from the product page. This prevents confusion when you have three similar jackets.

Paste the full product URL into its column. Shortened links expire; full URLs are permanent.

Record the price in your local currency. If the seller lists in USD, note both currencies in the Notes column.

Add tracking numbers the moment they arrive. Do not wait — memory fades fast.

Update the Status column religiously: Ordered, QC Received, Shipped, In Transit, Delivered, Issue.

Part 3: Formulas That Save Hours

Manual math is where most trackers fall apart. These three formulas solve ninety percent of spreadsheet math needs.

Formula Purpose	Google Sheets Formula	What It Does
Auto Total Cost	=UnitPrice+DomesticShip+IntlShip	Sums all cost components per row
Total Spend	=SUM(TotalCostColumn)	Grand total at bottom of sheet
Count Pending	=COUNTIF(StatusColumn,"In Transit")	Shows how many orders are in transit

Place your Total Spend formula at the very bottom of the Total Cost column. Place your Count Pending formula in a corner cell where it is always visible. These two numbers alone transform how you think about your shopping budget.

Part 4: Filtering and Sorting

Once you have twenty or more rows, manual scanning becomes impossible. Filters are your new best friend.

Select your entire header row.

Go to Data > Create a Filter.

Click the filter arrow on the Status column.

Uncheck "Delivered" to see only active orders.

Sort the Order Date column by newest first to spot recent purchases.

Part 5: Collaboration and Sharing

If you work with a purchasing agent or share bulk orders with friends, your itaobuy spreadsheet becomes a communication tool. Set sharing permissions to "Anyone with the link can comment" so agents can flag issues directly inside your sheet. Use the Notes column for QC photo links, size confirmations, and special packaging requests. Everything stays in one thread instead of scattered across chat apps.