Reselling at scale is a numbers game. The resellers who grow past $5,000 monthly revenue do not have better taste or luck — they have better systems. This article reveals the complete fishgoo spreadsheet workflow used by top resellers to source, track, QC, list, and analyze 200+ items per month. Every phase, every column, every formula is included. Copy it exactly or adapt it to your niche.
Phase 1: Sourcing (Research Tab)
Before buying anything, top resellers build a Research tab. Columns: Item Name, Store Link, Seller Rating, Estimated Buy Price, Estimated Shipping, Potential Resale Price, Margin %, Competition Level (Low/Med/High), Trend Score (1–10), Decision (Buy/Skip/Maybe).
They fill this tab during dedicated sourcing sessions — usually 2–3 hours twice per week. The Decision column is based on Margin > 25%, Competition < High, and Trend > 6. Items marked Buy move to the main Order sheet. Everything else stays in Research for future reference.
Phase 2: Ordering (Main Order Sheet)
Approved items from Research are copied to the main sheet. The Order sheet has 20+ columns covering identification, financials, and operations. Every item gets a unique Order ID (format: YYYYMM-###). This ID is used in agent communication, photo folders, and listing descriptions.
Financial columns are locked with protected ranges so formulas cannot be accidentally overwritten. Agent communication happens through a shared read-only link to a filtered view showing only Ordered and In Warehouse items.
Phase 3: Warehouse & QC (Photo Pipeline)
When items arrive at the agent's warehouse, the agent uploads QC photos to a shared folder. The reseller cross-references each photo with the Order ID in their sheet. Status updates from Ordered to In Warehouse to QC Pass or QC Fail.
Failed QC items trigger a Return column entry with reason (wrong size, defect, color mismatch, seller bait-and-switch). Return rates are tracked monthly. Any seller with a return rate above 8% is blacklisted from future Research tabs.
Phase 4: Shipping & Arrival
Once QC passes, items are consolidated into shipping batches. The sheet tracks: Batch ID, Shipping Line (EMS/DHL/Sea), Weight, Cost, Tracking Number, Shipped Date, and Expected Arrival. When the package arrives, status changes to Arrived and the Actual Shipping Cost column is updated.
Actual shipping often differs from estimates. Top resellers use this data to refine their future shipping estimates. A small tab called Shipping History aggregates past batch data to predict costs for new hauls.
Phase 5: Listing & Selling
Arrived items move to the Listing tab. Columns: Item, Platform (Grailed/Depop/eBay/Instagram), Listing Price, Listing Date, Views (weekly), Offers Received, Sold Date, Sold Price, Platform Fee, Net Profit. The Listing tab connects directly to the Order sheet via Order ID so financial data flows through automatically.
Items that do not sell within 60 days trigger a Price Drop alert. The reseller either lowers the price by 10–15% or moves the item to a clearance bundle. Nothing sits unsold indefinitely — it either sells or it teaches a lesson about demand.
Phase 6: Monthly Analysis (Dashboard)
At month end, the Dashboard tab tells the story. Key metrics: Total Items Sourced, Total Investment, Items Sold, Revenue, Gross Profit, Net Profit (after all fees), Average Margin, Best Category, Best Seller, Worst Seller, Return Rate, and Month-over-Month Growth %.
This analysis feeds back into Phase 1. If Jackets had a 45% margin and T-Shirts had 15%, next month's Research tab weights Jackets higher. If Seller X had a 2% return rate and Seller Y had 12%, Seller X gets priority. The sheet is not just tracking — it is learning.
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.