Juggling orders from multiple suppliers? Discover how the FishGoo Consolidation Spreadsheet turns chaos into clarity.
The Challenge of Multi-Seller Order Management
When sourcing products from platforms like 1688, Taobao, or AliExpress, orders quickly become fragmented. You’re left tracking different invoices, QC photos from various agents, and scattered shipping updates. This disorganization leads to costly errors, delays, and frustration.
The FishGoo Order Consolidation Spreadsheet
How to Set Up & Use Your FishGoo Spreadsheet
Step 1: Create Your Master File
Start with a blank spreadsheet. Create the following core columns:
- Order ID (FishGoo #): Your unique internal tracking number.
- Seller/Source: Supplier name and platform.
- Product Link & Description: Direct URL and specs.
- Quantity & Unit Price (CNY): Item cost in local currency.
- Domestic Shipping: In-China freight to FishGoo warehouse.
- Item Total Cost: Calculated field (Quantity * Unit Price + Domestic Shipping).
- QC Status & Image Link: Hyperlink to approved inspection photos.
- FishGoo Warehouse Inbound Date: Date received for consolidation.
- International Shipping Method: e.g., Sea Freight, Air DDP.
- Tracking Number & Progress: Final tracking with live updates.
Step 2: Consolidate Orders During Purchase
As you place orders with different sellers, immediatelyFishGoo Order ID
Step 3: Integrate QC & Warehouse Data
When your FishGoo agent sends QC (Quality Check) photos and confirms receipt at their warehouse:
- Upload the QC images to a cloud folder (Google Drive, Imgur).
- Paste the direct image links into the QC Image Link
- Update the QC StatusWarehouse Inbound Date.
This creates a visual audit trail for every item.
Step 4: Track Consolidation & Final Shipping
Once all items for an Order ID are in the FishGoo warehouse:
- Your agent will weigh, pack, and quote international shipping.
- Record the chosen Shipping Method
- Enter the Tracking NumberProgress
- Use simple conditional formatting to turn cells green when a milestone is complete.
- Enter the Tracking NumberProgress
Key Benefits of the FishGoo System
Total Cost Transparency
See the real landed cost of each item by summing product price, domestic freight, and international shipping share. No hidden fees.
Instant Visual QC Access
Hyperlinked QC images are stored alongside order data. Quickly verify products without digging through emails or messaging apps.
Proactive Shipping Management
Monitor the status of your consolidated parcel in real-time. Identify delays early and keep customers informed automatically.
Scalability
One spreadsheet can manage 10 orders or 10,000. Use filters and sheets per month or product category for even greater control.
Pro Tips for Maximum Efficiency
- Use Dropdowns:
- Leverage Formulas:
- Share with Your Agent:
- Archive Weekly:
- Leverage Formulas: