Step-by-Step Joyagoo Spreadsheet Tutorial

Prep Work: What You Need Before Opening a Spreadsheet

Before you touch a single cell, gather three things: a reliable CNY-to-USD exchange rate source, a list of your agent options with their per-kg rates, and a rough idea of your resale platform fees. These three numbers drive every formula in your sheet. If one is wrong, every margin calculation downstream becomes fiction.

Most resellers check the exchange rate once per week and update a single cell at the top of the sheet labeled Rate. That cell is then referenced by every price column. Change it once, and the entire sheet updates instantly.

Building the Core Structure (Minutes 1-8)

Open a blank Google Sheet and create two tabs: Active Haul and Archive. The first tab is your workspace. The second is your long-term memory. Every completed haul gets copied into Archive so your Active tab never slows down.

In row 1 of Active Haul, type these exact headers: Item Name, Product URL, Size, Color, Unit Price CNY, Domestic Shipping CNY, Agent, International Estimate USD, Resale Price USD, Margin Percent, Status, QC Photos URL, Agent Notes. Freeze row 1 immediately so your headers stay visible as you scroll.

Set the entire sheet font to Inter or Roboto at size 11. Use bold only for headers. Consistent formatting makes a fifty-row sheet feel readable instead of intimidating.

Formulas That Do the Heavy Lifting (Minutes 9-14)

Unit Price USD: In a helper column next to Unit Price CNY, enter =E2*$B$1 where B1 is your Rate cell. The dollar signs lock the reference so you can copy the formula down hundreds of rows without it drifting.

Total Landed Cost: Add a column that sums unit price USD, domestic shipping USD, and international estimate. This is the true cost per item, not just the tag price. Use =G2+H2+I2 or equivalent references.

Margin Percent: The formula everyone wants. Use =(K2-J2)/K2 where K is Resale Price and J is Total Landed Cost. Format the cell as Percentage with one decimal place. A value below 0.15 means you are barely covering platform fees and shipping overhead.

Status Color Logic: Select the Status column. Apply conditional formatting with custom formulas. If the text contains Purchased apply a light green fill. If it contains Shipped apply light blue. If it contains Issue apply a pale red. Visual status eliminates the need to read every row.

Daily Workflow: How to Update Without Chaos

Every morning, scan the Status column. Anything marked Issue gets your first ten minutes. Message the agent, update the Notes field, and change the status to Awaiting Reply once you send the message. This single habit prevents small problems from becoming refund nightmares.

When a new tracking number arrives, paste it into Agent Notes and change the status to Shipped. If you run multiple hauls per month, add a Haul ID column and prefix every item with a code like H03. Later you can filter by H03 and see exactly what that batch contained.

Once every Sunday, review the Archive tab. Look for patterns. Which agent consistently delivers lower international estimates? Which product category shows the highest average margin? Your sheet becomes a decision-making tool, not just a list.

Sharing Safely with Your Agent

Never share the full sheet with edit permissions unless you trust the person completely. Instead, create a view-only link and paste it into your agent chat. If they need to update statuses, create a separate tab called Agent Updates with only Item Name, Status, and Notes. Share that tab alone.

To share a single tab, right-click the tab, choose Copy to then New spreadsheet. This creates a disconnected copy. Share the copy. Your original stays private. Update it manually when the agent reports changes.

Step-by-Step Overview

Continue Learning

Frequently Asked Questions