Create Fishgoo Spreadsheet Step-by-Step

Sometimes the best tool is the one you build yourself. Creating a fishgoo spreadsheet from scratch gives you complete control over columns, formulas, and layout. This step-by-step guide walks you through building a professional inventory tracker that matches your exact resale workflow.

Step 1: Choose Your Platform

Both Excel and Google Sheets work perfectly for inventory tracking. Choose based on your access needs. Google Sheets excels at real-time collaboration and automatic cloud backup. Excel offers more powerful data analysis tools and offline reliability. Most resellers start with Google Sheets for convenience and migrate to Excel if they outgrow the feature set.

Step 2: Create the Header Row

Open a blank spreadsheet and create your header row in row 1. These are the columns that define your tracking system. Freeze row 1 so headers remain visible as you scroll through hundreds of items. Here is the essential column structure for a fashion resale tracker:

• A: Item ID (unique code like SHOE-001)
• B: Item Name (descriptive name customers recognize)
• C: Category (dropdown: Shoes, Hoodies, T-Shirts, etc.)
• D: Size (US sizing, S/M/L, or specific measurements)
• E: Color (primary color or colorway name)
• F: Purchase Price (what you paid, excluding shipping for now)
• G: Selling Price (target listing price)
• H: Profit (auto-calculated formula)
• I: Status (dropdown: Available, Listed, Sold, Returned)
• J: Purchase Date (when you acquired the item)
• K: Notes (special details, flaws, authentication status)

Step 3: Add Data Validation

Data validation prevents typos and inconsistent entries. Apply it to columns that should have fixed options. In Google Sheets, select the Category column, click Data > Data Validation, and enter your category list: Shoes, Hoodies/Sweaters, T-Shirts, Jackets, Pants/Shorts, Headwear, Sets, Underwear, Jersey, Accessories.

Do the same for the Status column: Available, Listed, Sold, Returned. Now anyone entering data can only choose from valid options. No more "Shoe" versus "Shoes" breaking your pivot tables.

Step 4: Build the Profit Formula

The profit formula is the heart of your spreadsheet. In cell H2 (the first Profit cell), enter this formula:

This subtracts Purchase Price from Selling Price. For a more accurate view that includes fees, expand it:

The 0.13 multiplier estimates a 13% platform fee. Adjust based on your actual marketplace rates. Copy this formula down column H for all rows by dragging the fill handle or using Ctrl+D.

Step 5: Format for Readability

A spreadsheet that hurts to read will not get updated. Apply these formatting rules to keep your tracker clean and usable:

• Bold the header row and freeze it at the top.
• Format currency columns (Purchase Price, Selling Price, Profit) as currency with two decimal places.
• Left-align text columns (Item Name, Category, Notes) and right-align number columns.
• Add alternating row colors (light gray every other row) to improve horizontal scanning.
• Set column widths so content fits without truncation. Auto-resize by double-clicking column borders.

Step 6: Add Conditional Formatting

Make your spreadsheet speak visually. Apply these conditional formatting rules to surface important information instantly:

• Profit > $100: Green background. These are your star items.
• Profit < $20: Light red background. Consider whether these items are worth the effort.
• Status = "Sold": Gray out the entire row or add a strikethrough to Item Name.
• Purchase Date > 90 days ago AND Status = "Available": Yellow background. Time to discount or relist.

Step 7: Create a Summary Dashboard

Add a new sheet tab called "Dashboard." Use formulas to summarize your main inventory sheet. Key metrics to display: Total Items, Items Sold This Month, Total Profit, Average Profit Margin, Best Category, and Items Needing Attention (stale inventory).

Use COUNTIF, SUMIF, and AVERAGE formulas to pull these metrics automatically. The dashboard updates itself every time you modify your main inventory sheet. No manual recalculation needed.

Frequently Asked Questions

Conclusion: Build Your System

Creating a fishgoo spreadsheet from scratch is an investment in your business infrastructure. The time you spend building it pays dividends every day you use it. Start with the essential columns, add complexity only when needed, and let your tracker grow alongside your inventory.