USFANS: How to Combine Multiple Seller Orders Using the USFANS Spreadsheet
International shipping can become costly when dealing with multiple sellers and separate shipments. USFANS provides a powerful solution through order consolidation - combining purchases from different sellers into single, optimized shipments. This guide will walk you through using the USFANS spreadsheet to streamline this process.
Why Combine Orders?
- Reduced Freight Costs:
- Consolidated Tracking:
- Optimal Packaging:
- Customs Efficiency:
- Consolidated Tracking:
Step-by-Step Consolidation Process
Step 1: Download the USFANS Consolidation Spreadsheet
Access the template from your USFANS dashboard under "Shipping Tools" or request it from your account manager.
Step 2: Gather Order Information
Collect data from all your sellers including:
- Seller name and contact information
- Order numbers and dates
- Item descriptions and SKUs
- Quantity, weight, and dimensions for each item
- Item values for customs declaration
Step 3: Input Data into Spreadsheet
Enter all order information into the designated columns:
| Column | Description | Example |
|---|---|---|
| Seller ID | Unique identifier for each seller | US-AMZ-12345 |
| Order Date | Date order was placed | 2024-01-15 |
| Product Description | Clear item description | Wireless Bluetooth Headphones |
| Weight (lbs) | Individual item weight | 0.75 |
| Dimensions (L×W×H) | Item dimensions in inches | 6×4×2 |
| Declared Value | Customs declaration value | $45.99 |
Step 4: Use Consolidation Formulas
The USFANS spreadsheet includes built-in formulas to:
- Calculate total shipment weight
- Optimize box combinations
- Estimate dimensional weight charges
- Sum total declared value
These automated calculations help you identify the most cost-effective consolidation options.
Step 5: Plan Shipment Groups
Based on the spreadsheet analysis, group orders by:
- Destination country
- Delivery timeframe
- Product compatibility
- Optimal weight brackets
- Delivery timeframe
Step 6: Generate Consolidation Report
Use the "Export Report" function to create a consolidation summary including:
- Consolidated packing list
- Customs declaration form
- Shipping cost comparison
- Carrier selection recommendations
Best Practices for Order Consolidation
Regular Consolidation Schedule
Set specific days for consolidation (e.g., Tuesdays and Fridays) to balance speed and cost efficiency.
Monitor Weight Thresholds
Most carriers offer significant rate reductions at specific weight breakpoints (10 lbs, 20 lbs, 50 lbs).
Understand Destination Restrictions
Some countries have limitations on consolidated shipment values or specific item restrictions.
Communicate with Sellers
Inform sellers about your consolidation process to ensure they include proper documentation.
Common Cost-Saving Scenarios
Scenario 1: Small Items from Multiple Sellers
Combining five 1-pound packages from different sellers into one 5-pound shipment typically reduces costs by 40-60% compared to individual shipments.
Scenario 2: Mixed Weight Optimization
Pairing heavy items with lightweight but bulky items can optimize both actual weight and dimensional weight calculations.
Scenario 3: Time-Sensitive Consolidation
For urgent shipments, consolidate only from sellers who can deliver to your USFANS address within your timeframe.
Conclusion
The USFANS consolidation spreadsheet transforms complex multi-seller shipping into an efficient, cost-effective process. By systematically combining orders and leveraging bulk shipping rates, you can significantly reduce international freight costs while maintaining reliable delivery service. Start implementing these strategies today to maximize your international shipping efficiency.
Need Help?