USFANS: How to Combine Multiple Seller Orders Using the USFANS Spreadsheet
Consolidate data across sellers to plan shipments efficiently and reduce international freight costs.
For cross-border shoppers and sourcing agents, managing orders from multiple sellers on platforms like Amazon US, Walmart, or eBay can quickly become a logistical challenge. The USFANS consolidation spreadsheet is a powerful, free tool designed to streamline this process. By merging all your order data into a single, intelligent worksheet, you can optimize your shipping strategy and significantly cut down on international freight expenses.
The Step-by-Step Process
Step 1: Gather Your Order Data
Export order details from each individual seller or platform. Key information to collect includes:
- Product Details:
- Quantity & Price:
- Physical Dimensions:
- Shipping Info:
- Quantity & Price:
Step 2: Input Data into the USFANS Spreadsheet
Download the template from the USFANS resource center. Enter the data from all sellers into the designated columns. Tip:
Step 3: Clean and Standardize Your Entries
Ensure consistency for error-free consolidation:
- Use the same unit system (e.g., all pounds or all kilograms).
- Verify address formats for warehouse locations.
- Correct any obvious typos in product identifiers.
Step 4: Utilize Built-in Analysis Tools
The USFANS spreadsheet typically includes features like:
- Pivot Tables:
- Cost Calculators:
- Consolidation Suggestions:
- Cost Calculators:
Step 5: Plan and Book Your Consolidated Shipment
Based on the spreadsheet's output:
- Instruct sellers to ship items to your chosen USFANS consolidation warehouse
- Once all packages arrive, USFANS will weigh, measure, and repack them into a single, optimized international parcel.
- Use the final dimensions from the spreadsheet to compare freight quotes (Air, Sea, Express) and book the most cost-effective option.
Key Benefits of Using the Spreadsheet
Cost Reduction
Combining shipments reduces the number of individual international parcels, helping you avoid base rate charges and unlock volume discounts from carriers.
Enhanced Visibility
Gain a single-pane-of-glass view of all your pending orders, their status, and associated logistics metrics, making planning proactive rather than reactive.
Informed Decision-Making
Data-driven comparisons between shipping methods (e.g., air freight vs. sea freight) become straightforward, allowing you to balance speed and cost effectively.
Error Minimization
Automated calculations minimize manual errors in weight, volume, and cost estimation, preventing unexpected surcharges.