Should I track the seller name or the store URL?

Both. The name is human-readable; the URL is your permanent link to the exact product page. Use adjacent columns.

How do I handle items with multiple variants?

Create one row per variant. If you bought three colors of the same shirt, that is three rows with identical names but different color and size values.

Tips

Best Items to Track in Your Itaobuy Spreadsheet

May 10, 2026 · 5 min read

The difference between a useless tracker and a life-saving tool comes down to one decision: what you choose to track. Too few columns and you miss critical details. Too many and data entry becomes a chore. After analyzing the workflows of over two hundred active shoppers, we have identified the itaobuy spreadsheet columns that deliver the highest value per minute of data entry time.

Start Using Itaobuy Spreadsheet →Read Full Guide

The Non-Negotiable Twelve

These twelve columns form the backbone of every successful tracker. Skip any of them and you will eventually feel the pain of missing information when you need it most.

Column Name	Why It Matters	Example Data
Item Name	Identifies exactly what you bought	Nike Air Force 1 White 42
Product URL	Essential for disputes and reorders	https://store.com/product/12345
Size	Prevents wrong-size disasters	US 9 / EU 42.5
Color	Avoids "I thought it was black" moments	Off-White / Sail
Unit Price	Base cost before any extras	$89.00
Domestic Shipping	Cost from seller to warehouse	$5.00
International Shipping	Cost from warehouse to you	$22.00
Total Cost	Grand total per item (auto-calculated)	$116.00
Order Date	Shows order aging and payment timing	2026-05-15
Tracking Number	The single most requested detail	LN123456789CN
Status	Lifecycle stage of the order	In Transit
Notes	Catch-all for everything else	QC photos link, agent name

Advanced Columns for Power Users

Once you have mastered the essential twelve, these additional columns unlock deeper insights and smoother workflows.

Category — Shoes, Apparel, Accessories. Enables sorting and category spend analysis.
Seller Rating — Your personal score for each store. Helps you avoid repeat bad experiences.
Payment Method — Credit, PayPal, Wise. Useful for reconciling bank statements.
Declared Value — For customs and import duty calculations on international orders.
Weight — Total package weight. Helps predict shipping costs for future similar orders.
QC Status — Pass, Fail, Pending. Separates quality control from general order status.
Resale Price — If you plan to resell, this column tracks your target selling price.

Columns Most Beginners Overlook

Three columns get skipped more than any others, and all three are eventually regretted.

Product URL — Everyone thinks they will remember where they bought something. They do not. Paste the URL immediately.

Declared Value — Customs surprises can add twenty percent to your total cost. Record the declared value the moment the agent confirms it.

QC Photos Link — Quality control photos are your only defense against damaged or wrong items. Store the link in your Notes or a dedicated QC column.

Column Order Strategy

The sequence of your columns matters more than most people realize. You read left to right, so the most frequently referenced columns belong on the left. We recommend this order: Item Name, Status, Total Cost, Tracking Number, Size, Color, Order Date, Seller, Product URL, Unit Price, Domestic Shipping, International Shipping, Notes. This places the "at a glance" information within your natural eye movement path.

Formatting Tricks That Save Time

Use data validation dropdowns for Status, Category, and QC Status to eliminate typos.
Format currency columns to show two decimal places and your local currency symbol.
Wrap text in the Notes column so long entries do not overflow into neighboring cells.
Freeze the first two columns (Item Name and Status) so they stay visible when scrolling right.
Use alternating colors every five rows to make horizontal scanning easier.

Get the complete column setup in our free templates and never wonder what to track again.

Download Free Templates