Best Joyagoo Spreadsheet for Beginners: 2026 Setup Guide

The Problem: Why Most First Hauls Fail

Beginners lose money in three predictable ways. First, they forget to convert yuan to dollars and underestimate the real cost. Second, they miscalculate shipping by ignoring packaging weight. Third, they lose track of which items are in which agent warehouse. A single mistake can turn a profitable flip into a loss. Manual notes in your phone simply do not scale past three items.

The Solution: Joyagoo Spreadsheet Workflow

A free joyagoo spreadsheet solves all three failure points at once. Pre-built columns handle currency conversion automatically. Shipping estimates factor in box weight. Color-coded statuses show exactly where every item sits — ordered, in warehouse, shipped, or delivered. You stop guessing and start knowing.

Step-by-Step Setup Guide

Download the beginner template — Head to our templates page and grab the Basic Order Tracker. It opens in Google Sheets or Excel with zero compatibility issues.

Set your exchange rate — Find the yellow highlighted cell labeled "Exchange Rate." Enter today's CNY-to-USD value. Every price column updates instantly.

Add your first product row — Paste the Weidian link in column A, write the product name in column B, size in C, color in D, and yuan price in E. The sheet does the rest.

Enter estimated weight — In the grams column, type your best guess. Hoodies run about 400g, sneakers about 800g, accessories about 150g. The total auto-sums at the bottom.

Add your selling price — In the resale column, type what you plan to charge buyers. The profit column subtracts cost, shipping, and fees automatically.

Update status as you go — Change the dropdown from "Pending" to "Ordered," then "In Warehouse," then "Shipped." Color coding makes progress obvious at a glance.

Option Comparison for Beginners

Real Example: Sarah's First 15-Item Haul

Sarah started with our Basic Order Tracker. She listed twelve items totaling ¥3,200. The sheet converted that to $444 at her exchange rate, added estimated shipping of $89, and showed agent fees of $22. Her total landed cost was $555. She priced resale at $780 and saw a projected profit of $225 before she even placed the first order. That visibility gave her confidence to expand to thirty items on her second haul.

Pro Tips for New Users

Bookmark your spreadsheet link so you can update it from your phone while browsing Weidian. Use a consistent naming format like "Brand — Item — Size" so you never confuse similar products. Round shipping estimates up, not down. Extra grams cost less than surprise overage fees. Duplicate the template for each new haul instead of overwriting old data. History matters. Share view-only links with group-buy partners so everyone sees costs without editing formulas.