Streamline Your Data and Slash International Freight Costs
For cross-border shoppers and USFANSconsolidate your orders, plan efficient shipments, and significantly reduce your international freight costs.
Why Combine Orders? Key Benefits
- Cost Reduction:
- Simplified Tracking:
- Better Planning:
- Reduced Warehousing Fees:
- Simplified Tracking:
Step-by-Step: Using the USFANS Consolidation Spreadsheet
Step 1: Data Collection & Template Setup
Create a spreadsheet (Google Sheets or Excel) with the following columns:
| Column Header | Description |
|---|---|
| Order ID | Seller order number (e.g., Amazon #) |
| Seller Name | Amazon, eBay, [Brand Name] Store |
| Item Description | Brief title and key specs (color, size) |
| Quantity (Qty) | Number of units |
| Unit Price (USD) | Price per item |
| Total Value (USD) | Qty * Unit Price |
| Estimated Weight (lbs) | From product page or listing |
| Dimensions (LxWxH in) | If known, for large items |
| Warehouse Arrival Date | Estimated delivery to your US address |
| Consolidation Batch # | Your assigned group (e.g., BATCH-01) |
Step 2: Input All Pending Orders
As you make purchases, immediately log each item into your spreadsheet. Use your forwarding address (e.g., USFANS
Step 3: Group into Logical Shipments
Once multiple orders arrive at the warehouse, analyze your data:
- Group by Arrival Date:
- Group by Urgency:
- Group by Type/Value:
- Assign a Batch Number
- Group by Urgency:
Step 4: Calculate & Compare Shipping Quotes
For each batch, use the spreadsheet's SUM
Enter this consolidated data into your forwarder's (e.g., USFANS) quote calculator to compare costs for a single large shipment vs. multiple small ones.
Step 5: Initiate Consolidation & Ship
In your forwarder's dashboard, select all packages belonging to the same batch. Request repacking into one box (if desired). The spreadsheet provides the exact item list for accurate customs declaration. Submit the batch for international shipping.
Pro Tips for Maximum Savings
- Communicate with Your Forwarder:USFANS
- Monitor Warehouse Storage Windows:
- Update in Real-Time:
- Consider Volumetric Weight:
- Monitor Warehouse Storage Windows: