Joyagoo Spreadsheet Step-by-Step Guide: From Zero to Tracking

What You Need Before Starting

Open a Google Sheets or Excel account. Either works perfectly. Create a new blank spreadsheet and name it something memorable like "Haul Tracker June 2026." You also need your agent login details, a rough exchange rate (check xe.com), and an estimate of how many items you plan to buy. Write your resale platform fees down too — Depop, Grailed, and eBay all charge different percentages.

Step 1: Build the Header Row

In row one, type these exact headers across columns A through K: Product Link, Product Name, Size, Color, Yuan Price, USD Price, Weight (g), Shipping Est, Agent Fee, Resale Price, Profit. Use bold formatting and a light gray fill so the header stands out. Freeze the top row so it stays visible as you scroll. This single row is the backbone of every joyagoo spreadsheet template ever built.

Step 2: Add the Exchange Rate Formula

Pick an empty cell near the top — say M2 — and label it "Exchange Rate." Enter the current CNY to USD rate, for example 0.139. In the USD Price column (F), enter this formula for every data row: =E2*$M$2. The dollar signs lock the reference so you can copy the formula down infinitely. When the rate changes tomorrow, update one cell and every price refreshes instantly.

Step 3: Calculate Shipping Automatically

Most agents charge per gram. Create a cell labeled "Rate per Gram" and enter your agent's price, typically $0.008 to $0.015. In the Shipping Est column (H), use =G2*$N$2 where N2 holds your gram rate. For packaging buffer, add an extra row at the bottom labeled "Box & Tape" and estimate 300g. Add this to your total weight so buyers never get surprised by overweight fees.

Step 4: Profit Formula

Profit is simpler than it looks. In column K, type =J2-(F2+H2+I2). That subtracts item cost, shipping estimate, and agent fee from your resale price. Drag the formula down. Any row showing red or negative numbers means you need a higher resale price or a cheaper item. Sort by the Profit column descending to see your best earners instantly.

Step 5: Status Tracking with Color

Add a "Status" column using data validation. Set the dropdown options to Pending, Ordered, In Warehouse, Shipped, Delivered, and Sold. Apply conditional formatting: yellow for Pending, orange for Ordered, blue for In Warehouse, green for Delivered, and gray for Sold. One glance at your sheet tells you exactly where every item lives without reading a single word.

Method Comparison for Setup

Common Setup Mistakes

The biggest mistake is forgetting agent fees. Some agents charge per item, others by weight, and some have flat service charges. Ask your agent for a fee breakdown before you start. Another error is using yesterday's exchange rate. CNY moves daily; outdated rates throw every profit calculation off by dollars per item. Finally, never delete rows. Mark them Sold or Cancelled instead. Deleted rows break formula ranges permanently.