If your current order tracking system involves screenshots, browser bookmarks, and prayer, this guide is for you. Organizing orders using a fishgoo spreadsheet transforms chaotic purchasing into a streamlined pipeline you can review in 30 seconds. We will walk through the exact setup, the status system that actually works, and the weekly maintenance routine that keeps everything current. By the end, you will wonder how you ever bought without it.
The Order Status System That Works
Most beginners create too many statuses or too few. The sweet spot is 8–10 distinct stages that map to real decision points in your workflow. Here is the system we recommend.
- Researching: You found the item, but have not decided to buy
- Pending Payment: You decided, but have not paid the agent yet
- Ordered: Payment sent to agent, awaiting seller shipment
- Seller Shipped: Seller sent to agent's warehouse
- In Warehouse: Item arrived at agent, awaiting QC photos
- QC Pass: Photos look good, ready to ship internationally
- QC Fail: Defect or mismatch, initiating return
- Shipped Internationally: Left agent, in transit to you
- Arrived: Package received, ready for listing or wear
- Listed: Posted for resale on your chosen platform
- Sold: Item purchased by a customer
- Returned: Customer return or personal return to seller
Color-Coding Your Pipeline
Text statuses are fine. Color-coded statuses are faster. Apply conditional formatting to your Status column with these rules: gray for Researching through Pending, blue for Ordered through In Warehouse, yellow for QC stages, orange for Shipped, green for Arrived through Sold, and red for Returned or QC Fail.
When you open your sheet, the color pattern tells the story instantly. A wall of blue means your agent is busy. A wall of yellow means QC is your bottleneck today. A wall of green means it is time to list. No reading required.
Link Management: Never Lose a Product Page
The Store Link column is your lifeline. But raw Weidian links are ugly, long, and fragile. Use a URL shortener or create a Link Name column with human-readable labels: "Nike Dunk Panda - Weidian Store #123". Keep the raw link in a separate Raw Link column, hidden from daily view but accessible when needed.
For critical items, paste a thumbnail image directly into the sheet cell. In Google Sheets: Insert → Image → Image in cell. Now you have visual confirmation alongside text data. When a link dies, the image still proves what you ordered.
Weekly Maintenance Routine (15 Minutes)
A sheet is only useful if it is current. Set a 15-minute weekly calendar block for sheet maintenance. Here is the exact routine:
First 5 minutes: update all status changes. Check agent messages, tracking numbers, and delivery notifications. Move every item to its correct status stage. Second 5 minutes: verify financial columns. Update actual shipping costs, confirm agent fees match your estimates, and flag any items where actual cost exceeded estimated cost by more than 10%. Third 5 minutes: plan next actions. Identify items stuck in one status for over 7 days. Message your agent about stalled orders. Schedule listings for newly arrived items.
Handling Multi-Item and Multi-Agent Orders
If one order contains 3 items from 2 different sellers, use the same Order ID for all 3 rows but different Seller Name values. In the Notes column, write "Part of Haul #45" so you know they ship together. When the haul arrives, update all 3 rows simultaneously using Find and Replace.
For multi-agent buyers, add an Agent column and sort by it before communicating. Each agent gets a filtered view link showing only their items. This prevents the awkward situation of sending Seller A's links to Agent B.
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.