What to Track in Your Joyagoo Spreadsheet

The Seven Non-Negotiable Fields

Item Name: Use the exact product title from the source page, not a nickname you invent in the moment. Six months later you will not remember what Fire Hoodie means, but you will remember Supreme Box Logo Hoodie Black M.

Product URL: Paste the full Weidian, Taobao, or Yupoo link. Shortened links die. Screenshots get lost. The URL is the only proof of what you actually ordered if a wrong item arrives.

Size and Color: Separate columns. Never combine them. Agents often need size for warehouse picking and color for QC confirmation. Combined fields force manual parsing and invite errors.

Unit Price in Source Currency: Record the CNY price exactly as listed. Do not convert it here. A raw number in a dedicated column prevents rounding drift and keeps your formulas honest.

Agent Name: Track which agent quoted or purchased each item. When a quote feels wrong, you need to know who provided it. When an item goes missing, you need to know who to message first.

Status: A single controlled vocabulary. Researching, Quoted, Purchased, Shipped, Arrived, Listed, Sold, Issue. Every other status is a variation of one of these eight. Consistency lets you filter and summarize instantly.

Notes: The catch-all for anything that does not fit. Agent messages, deadline reminders, customer requests, refund tracking numbers. If it matters and it is not a number, it goes here.

The Five Financial Fields That Protect Profit

Exchange Rate on Quote Day: Do not use a live rate for past orders. Record the rate you actually used when calculating the order. This preserves historical accuracy when you audit margins months later.

Domestic Shipping CNY: Easy to forget because it is small per item. Across fifty items it adds up. Track it so your total cost estimate is honest and your margin calculations are real.

International Estimate USD: Usually based on weight. Record the estimate your agent gave you at checkout, not a guess. Compare it to the final invoice later to calibrate future estimates.

Resale Price USD: Your target selling price when the item lands. This field turns a tracking sheet into a planning tool. Without it, you are just collecting data, not running a business.

Net Margin Percent: Calculated, not typed. Formula-driven and locked. If you type margins manually, optimism will creep in. Let the math keep you honest.

Three Optional Fields Worth Adding Later

QC Photo URL: Essential if you resell high-value items. Links to the agent warehouse photo for dispute evidence. Skip it if you mostly buy basics under $30 where disputes are rare.

Haul ID: A code like H01, H02 that groups items into batches. Critical when you run multiple parallel hauls. Overkill when you buy one item every two weeks.

Days in Status: A formula that calculates how long an item has sat in a given state. Useful for identifying slow agents or stale inventory. Not needed when your volume is low enough to remember every item.

Fields You Should Probably Skip

Product Description: Long text that duplicates the source page. You have the URL. Do not double-store data you can look up in ten seconds.

Seller Name: Unless you are building a seller blacklist or whitelist, this rarely affects your workflow. The URL contains the shop info if you ever need it.

Exact Weight in Grams: Your agent provides this at shipping. Track it there, not in the master sheet. Adding it early creates a maintenance task with no decision value.

Field Priority Matrix

Continue Learning

Frequently Asked Questions