A fishgoo spreadsheet is only as good as the data inside it. After reviewing over 300 sheets from resellers at every experience level, we identified the same mistakes appearing again and again. Some are technical. Some are organizational. All are fixable. This guide lists the seven most common fishgoo spreadsheet mistakes in order of impact — from the ones that waste time to the ones that cost real money.
Mistake 1: Forgetting to Update the Status Column
The most common and most damaging mistake. Resellers diligently fill out every column when they place an order, then never touch the sheet again until the haul arrives. By then, they have 30 items all marked Ordered with no idea which have shipped, which are in customs, and which arrived yesterday.
Fix: Set a calendar reminder for twice-weekly sheet updates. Or better, integrate your sheet with your agent's system so status updates flow in automatically. Even a 30-second status update per item prevents hours of confusion later.
Mistake 2: Not Converting CNY to Your Local Currency
Prices on Weidian and Taobao are in Chinese Yuan. If you record them as-is and mentally convert later, you will miscalculate. Exchange rates shift daily. A 100 CNY item might cost $13.80 today and $14.20 next week. That $0.40 difference multiplied across 50 items is $20 of invisible cost.
Fix: Create a conversion rate cell at the top of your sheet. Reference it in every price column with a formula. Update the rate weekly. Now your true costs are always accurate.
Mistake 3: Overcomplicating the Layout
Beginners see advanced sheets with 30 columns, pivot tables, and scripted dashboards. They try to replicate everything on day one. The result is a fragile sheet full of broken formulas they do not understand.
Fix: Start with 10–12 columns. Master those before adding complexity. A simple sheet you use daily beats a complex sheet you avoid because it intimidates you.
Mistake 4: Neglecting Shipping Weight
A t-shirt ships for $3. A winter puffer jacket ships for $18. If your shipping estimate column uses a flat rate for every item, your profit margins are fiction.
Fix: Add a Weight (kg) column and a Shipping Rate ($/kg) cell in your Settings area. Calculate shipping per item with =Weight × ShippingRate. For mixed hauls, use the average weight of items in that category until you have exact numbers from your agent.
Mistake 5: Not Backing Up the Sheet
Google Sheets auto-saves, but it also auto-deletes if you accidentally clear a column. One wrong drag-and-fill can overwrite 500 cells. Without a backup, that data is gone.
Fix: Use File → Version History → Name Current Version once per week. For extra safety, download a CSV export monthly and store it in cloud storage. The 30 seconds this takes is insurance against disaster.
Mistake 6: Mismatched SKU Links
You copy a store link, paste it into your sheet, then two weeks later the seller changes their URL structure. Now your link is dead and you have no way to prove what you ordered if a dispute arises.
Fix: Use a short URL service or archive the product page with a screenshot tool. Better yet, include a Product Screenshot column and paste a thumbnail image directly in the cell. Visual proof is stronger than any link.
Mistake 7: Ignoring the Margin Until It Is Too Late
Resellers focus on the buy price and forget about agent fees, shipping, platform fees, and returns. An item bought for 200 CNY and sold for $35 sounds profitable. But after all costs, the margin might be 8% — not worth the risk.
Fix: Build a True Margin formula that includes every cost: item price, agent fee, domestic shipping, international shipping, platform fee (e.g., 12.9% for Grailed), estimated return rate (5–10%), and packaging cost. If the true margin is below 20%, flag the cell red.
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.