Plan your first multi-item order without overspending. Our free haul planning template includes cost tracking, shipping estimation, size conversion, and QC checkpoints.
Why Every Haul Needs a Spreadsheet Plan
Impulse buying on OopBuy is expensive. Without a plan, you add items to cart until your balance runs low, then realize shipping costs more than expected, and end up with a haul that is either too small to justify shipping or too large for your budget. A spreadsheet plan solves this by forcing you to model the full cost before placing a single order.
This article provides a free haul planning framework that we use internally. It works in Google Sheets, Excel, or any spreadsheet tool. The template includes item tracking, price conversion, size conversion, shipping estimation, and QC checkpoints. By the time you finish the spreadsheet, you will know exactly what you are buying, what it costs landed in the USA, and which items to prioritize if you need to trim the list.
The Haul Planning Template Structure
| Column | Purpose | Example |
|---|---|---|
| Item Name | Short description you will recognize | Jordan 1 Chicago |
| Seller | Seller name or store ID | PK Store |
| Batch Code | Specific batch if known | LJR |
| CNY Price | Listed price in yuan | 380 |
| USD Price | CNY divided by 6.2 | $61.29 |
| Weight (g) | Estimated or listed weight | 1200 |
| Size | Your converted size | US 10 / EU 44 |
| QC Priority | High/Med/Low based on risk | High |
| Need By | Date you want to receive it | 2026-06-15 |
| Status | Ordered / QC / Shipped / Received | Ordered |
Step-by-Step: From Wishlist to Final Order
create a wishlist tab with everything you want. Do not worry about cost yet. Include links, photos, and batch codes. This is your raw brainstorm.
research each item. Search Reddit for recent in-hand photos of the batch and seller. Read the last ten comments on each thread. If the recent consensus is negative, mark the item red and consider removing it.
convert sizes. Every item on your list needs a converted size based on the seller size chart, not generic country conversions. A US Large in one store might be an XL in another. Add a size conversion column and fill it carefully.
calculate total landed cost. Sum the USD price column for product cost. Estimate shipping using the per-kilogram rates from our shipping calculator article. Add 10% for unexpected fees. This is your real budget number.
prioritize and trim. If your total exceeds your budget, sort by a priority score. We recommend a simple formula: want divided by price, where want is a 1 to 10 rating you assign subjectively. Higher scores are better value-for-desire and should survive budget cuts.
place orders in batches. Do not order everything simultaneously if some items are from unvetted sellers. Order from trusted sellers first, wait for their QC, and then place secondary orders. This reduces the risk of locking up your balance in bad orders.
Shipping Estimation: The Math Made Simple
Accurate shipping estimation is the hardest part of haul planning because volumetric weight is unpredictable before warehouse packing. Here is our rule of thumb for first-time planners.
For clothing only hauls, estimate 15% to 20% of product cost for shipping on EMS or SAL. A $100 clothing haul ships for roughly $15 to $20. For shoe hauls, estimate 40% to 60% of product cost because shoes are heavy and volumetrically inefficient. A $100 shoe haul ships for $40 to $60 unless you remove boxes.
Mixed hauls fall in between. A $150 haul with two shoes and three clothing items ships for $35 to $50 with consolidation and box removal. Use these ranges for budgeting, then refine after OopBuy provides the actual packed weight.
Timeline Planning: When to Order for Seasonal Needs
If you need items by a specific date, work backwards from delivery.
For express lines like DHL or FedEx, allow twenty-one days from order to delivery. That breaks down as seven days for seller-to-warehouse, three days for QC and consolidation, and eleven days for international transit.
For standard lines like EMS, allow thirty-five days. Add buffer for seasonal delays during November, December, and January.
For budget lines like SAL, allow fifty-six days. Budget lines are unpredictable, and planning around them for time-sensitive needs is risky.
Order at least two weeks before your ideal timeline if you are using a new seller. Established sellers with fast warehouse processing can sometimes beat these estimates, but new sellers often take longer to ship to the warehouse.
