Quick Answer
To use Fishgoo spreadsheet, download the template, customize your product categories, import existing inventory, connect sales channels, and review the profit dashboard weekly for data-driven restocking decisions.
Learning how to use Fishgoo spreadsheet unlocks professional inventory management without expensive software or technical expertise. This tutorial walks through every tab, feature, and workflow so you can start tracking fashion inventory like an experienced reseller.
Need the Template First?
Grab the free Fishgoo spreadsheet before following this tutorial for the best learning experience.
Download TemplateUnderstanding the Tab Structure
Fishgoo spreadsheet organizes your business into dedicated tabs. The Inventory tab holds your product catalog. The Sales tab records every transaction. The Suppliers tab tracks sourcing relationships. The Analytics tab transforms raw numbers into visual charts showing revenue trends and category performance.
Each tab connects to the others through formulas you never need to write. When you log a sale in the Sales tab, the Inventory tab automatically reduces stock counts. When stock drops below your reorder threshold, conditional formatting highlights the row in red.
Setting Up Your Inventory Tab
Define Your Categories
Replace example categories with your actual product types: Sneakers, Hoodies, T-Shirts, Jackets, or Accessories.
Create SKU Conventions
Use a consistent format like BRAND-ITEM-COLOR-SIZE. This prevents duplicates and makes searching instant.
Enter Cost and Retail Prices
Record your exact cost including shipping from suppliers. The retail price field calculates your margin automatically.
Set Reorder Points
Enter minimum stock levels for each item. The spreadsheet alerts you when inventory runs low.
Daily Workflow for Active Resellers
- Morning: Check the low-stock alert column and place replenishment orders.
- Afternoon: Log new sales from all connected platforms into the Sales tab.
- Evening: Review the Analytics tab for daily revenue and profit summary.
- Weekly: Update supplier lead times and adjust reorder points based on sales velocity.
Advanced Features Worth Learning
| Feature | What It Does | Time Saved |
|---|---|---|
| Bulk Import | Paste CSV data directly into the template | ~2 hours |
| Auto-Sync | Connects Shopify, eBay, Amazon, Etsy | ~5 hours/week |
| Profit Dashboard | Visual charts of revenue by category | ~1 hour/week |
| Size Matrix | Grid view of all size variants per item | ~30 min/day |
| Supplier Ratings | Track reliability and lead times | ~1 hour/month |
Troubleshooting Common Issues
If formulas show errors after bulk import, check that numeric columns contain only numbers without currency symbols. If platform sync stops working, verify your API credentials have not expired. When the spreadsheet loads slowly, archive old sales data into a separate historical sheet to reduce file size.
Frequently Asked Questions
Can multiple people edit the spreadsheet simultaneously?
Yes. Store it on Google Drive or SharePoint for real-time collaboration. Enterprise plans include role-based permissions.
How do I handle returns in the spreadsheet?
What happens when I reach the item limit?
The free plan supports 500 items. Pro and Enterprise plans offer unlimited inventory capacity with no performance degradation.
Can I customize the formulas?
Absolutely. Fishgoo uses standard spreadsheet formulas you can modify. However, altering core formulas may break automatic calculations.
How often should I back up my data?
Cloud storage auto-saves continuously. For extra security, download a local copy weekly or before making major changes.
Start Using Fishgoo Spreadsheet Today
Follow this tutorial with your own template and transform how you manage fashion inventory.
Get Full AccessRelated Resources