Templates are great, but understanding how to build a fishgoo spreadsheet from scratch gives you full control. You will know exactly what each column does, why each formula matters, and how to adapt the structure when your workflow evolves. This guide walks you through every step — from blank canvas to a fully functional tracking system — in under 20 minutes.
Phase 1: Design Your Column Structure
Before touching a formula, decide what you need to track. A well-designed fishgoo spreadsheet has three types of columns: identification (what is it), financial (what does it cost), and operational (where is it now).
- Identification: Order ID, Item Name, Store Link, Size, Color, Category
- Financial: Item Price (CNY), Agent Fee (%), Domestic Shipping, International Shipping, Total Cost, Local Currency Conversion, Resale Price, Profit, Margin (%)
- Operational: Order Date, Agent Name, Status, Warehouse Photo Link, QC Notes, Listing Platform, Listing Date, Sale Date
Phase 2: Build the Core Formulas
Formulas are where your spreadsheet becomes intelligent. Here are the essential calculations every fishgoo spreadsheet needs.
Total Cost Formula
In the Total Cost column, enter: =ItemPrice + (ItemPrice × AgentFee) + DomesticShipping + InternationalShipping. This gives you the true landed cost of every item, not just the sticker price. Many beginners lose money because they forget agent fees add up fast.
Profit and Margin Formulas
Profit is simple: =ResalePrice − TotalCost. For margin, use: =Profit / TotalCost and format as a percentage. A healthy reseller margin is typically 25–40% after all fees. Anything below 15% is risky once you factor in returns and platform fees.
Currency Conversion Formula
Create a small Settings area in the top-left of your sheet with the current exchange rate. Label a cell CNY_RATE and enter the live rate. Then in every price column, use: =CNYPrice × CNY_RATE. When the exchange rate shifts, one cell update refreshes your entire financial picture.
Phase 3: Add Data Validation
Data validation prevents typos and keeps your sheet consistent. Set up dropdowns for Size (S, M, L, XL, XXL, OS, 28, 29, 30...), Color (Black, White, Gray, Navy, Beige, Custom), Status (Researching, Ordered, In Warehouse, Shipped, Arrived, QC Pass, QC Fail, Listed, Sold, Returned), and Category (Shoes, Hoodies, T-Shirts, Jackets, Pants, Accessories, Other).
Phase 4: Create a Dashboard Tab
Add a second sheet tab named Dashboard. Use COUNTIF formulas to show: Total Items, Items Ordered, Items Arrived, Items Sold, Total Investment, Total Revenue, Total Profit, Average Margin. This gives you a bird's-eye view without scrolling through hundreds of rows.
For visual impact, add a simple bar chart showing monthly profit trends. Select your Order Date and Profit columns, insert a chart, and set the X-axis to aggregate by month. Over time, this chart reveals your best and worst months — invaluable for planning.
Phase 5: Test With Real Data
Before trusting your sheet with a real haul, run a test. Enter 5–10 past orders with known outcomes. Check that every formula calculates correctly, every dropdown works, and the dashboard numbers match your memory. Fix any issues now, before your live data depends on it.
Common bugs to watch for: circular references in profit formulas, division-by-zero errors when Total Cost is blank, and currency cells formatted as text instead of numbers. A 10-minute test run prevents days of frustration later.
Put Your Spreadsheet to Work
All the planning in the world means nothing without action. Visit our main fashion store and turn your organized research into real purchases.
Frequently Asked Questions
Common questions about fishgoo spreadsheets answered.