Build Your Own Joyagoo Spreadsheet from Scratch

Designing Columns for Your Actual Workflow

Do not copy someone else headers blindly. Instead, walk through your last three purchases mentally. What information did you look up repeatedly? Was it the product URL, the agent quote, the tracking number, or the resale listing? The columns you touch most often should sit closest to the left edge of the sheet.

Our recommended core columns for a custom build are: Timestamp, Item Name, Source URL, Agent, Unit Price CNY, Unit Price USD, Domestic CNY, International USD, Resale USD, Net Margin, Status, Notes. The Timestamp column auto-fills with =NOW() so you always know when a row was added.

Formulas You Should Write Yourself

Exchange Rate Converter: Place your live rate in cell B1. In every USD column, reference =B1*CNY_cell. Lock B1 with dollar signs. This lets you update one cell and refresh the entire sheet.

Net Margin: =(Resale - Landed_Cost) / Resale. Format as percentage. If you sell on a platform that charges 10%, subtract that inside the formula: =(Resale*0.9 - Landed_Cost) / Resale.

Days Since Update: In a helper column, use =TODAY()-Timestamp_cell to see how long an item has been sitting in a status. Anything over fourteen days in Purchased status might be a lost order or a slow agent.

Formatting That Prevents Errors

Apply data validation to the Status column. Restrict input to a dropdown list: Researching, Quoted, Purchased, Shipped, Arrived, Listed, Sold, Issue. This prevents typos like Shippedd from breaking your conditional formatting.

Add alternating row colors. Select the entire data range, go to Format then Alternating colors, and choose a subtle gray. This makes horizontal scanning easier on the eyes when you have fifty rows open.

Freeze the first two rows instead of one. Row 1 holds headers. Row 2 holds your live constants: exchange rate, shipping rate, and platform fee percentage. With both rows frozen, you never lose sight of your assumptions.

Backup and Version Control

Google Sheets keeps version history automatically, but you should also create manual checkpoints. Before every major haul, go to File then Version history then Name current version. Label it with the haul ID and date. This lets you roll back cleanly if a bulk paste goes wrong.

For paranoid resellers, set up a weekly automated email backup using Google Apps Script. A ten-line script can export your sheet as a PDF and email it to you every Sunday. The script lives inside Extensions then Apps Script and runs on a trigger you define.

Component Matrix

Continue Learning

Frequently Asked Questions