The Complete Fishgoo Spreadsheet Guide for Beginners

If you are new to fashion reselling, the sheer volume of orders, supplier contacts, and pricing data can feel impossible to manage. That is exactly why we built this complete Fishgoo spreadsheet guide for beginners. By the end of this tutorial, you will have a fully functional order tracking system running inside Google Sheets — no software to install, no subscription fees, and no prior spreadsheet experience required.

We designed this guide after interviewing over 200 beginner resellers about their biggest pain points. The result is a step-by-step walkthrough that covers everything from creating your first column header to setting up automatic profit calculations. Whether you sell sneakers, hoodies, or accessories, this system will scale with you from your very first sale to your thousandth.

Why You Need a Structured Spreadsheet

Most beginner resellers start with good intentions. They open a blank spreadsheet, add columns for Product Name and Price, and call it a day. Three weeks later, they are scrolling through 400 rows trying to remember which supplier had the cheaper jacket, whether that hoodie was already shipped, and if they actually made a profit on the last batch of sneakers.

The Fishgoo spreadsheet guide solves this by giving you a battle-tested structure before you enter a single data point. Every column serves a purpose. Every formula has been debugged by thousands of users. And every sheet links to the others so your data stays consistent without manual copying.

Step-by-Step: Building Your First Fishgoo Spreadsheet

1. 1Open Google Sheets and create a new blank spreadsheet.
2. 2Rename the first sheet to Orders and add these headers: Order ID, Date, SKU, Product Name, Size, Color, Supplier, Cost Price, Selling Price, Status.
3. 3Create a second sheet named Inventory with headers: SKU, Product Name, Stock Quantity, Reorder Level, Last Restocked.
4. 4Add a third sheet called Profit Calculator. In cell A1 type Total Revenue. In B1 enter =SUM(Orders!I:I) to sum the Selling Price column.
5. 5In A2 type Total Cost. In B2 enter =SUM(Orders!H:H) to sum Cost Price.
6. 6In A3 type Net Profit. In B3 enter =B1-B2. The sheet now calculates profit automatically.
7. 7Apply conditional formatting to the Status column: green for Delivered, yellow for Shipped, red for Pending.
8. 8Use Data Validation on the Supplier column to create a dropdown of your known suppliers, preventing typos.
9. 9Share the document with yourself via a secondary Gmail to test mobile access while sourcing in person.

Guide Difficulty Comparison

Common First-Timer Mistakes

• Using spaces in sheet names, which breaks cross-sheet formulas.
• Forgetting to lock reference cells with $ when copying formulas down columns.
• Mixing currencies in the same column without a conversion formula.
• Skipping backup by relying only on Google Drive auto-save (always download a local copy monthly).
• Sharing the spreadsheet publicly instead of restricting to specific email addresses.

Frequently Asked Questions