Confession: I Used to Treat My CNFans Spreadsheet Like a Junk Drawer
I’m not proud of this, but my early CNFans hauls were chaotic. I’d paste links into my spreadsheet at 1:00 a.m., promise myself I’d “optimize later,” then panic-ship random items because one hoodie finally arrived at the warehouse. Result? Expensive parcels, weird weight brackets, and that painful feeling that I was paying more for shipping than strategy.
Here’s the thing: once I actually understood the terminology, combining orders became less of a mystery and more of a game. A very nerdy, very satisfying game. This post is my diary-style breakdown of the words that mattered most and how I now combine orders for maximum savings.
The CNFans Spreadsheet Terms That Changed Everything
1) "Warehouse Arrival" vs "Purchased" vs "QC Passed"
At first I treated these as basically the same stage. They are not. Purchased means your agent bought it. Warehouse Arrival means it physically landed. QC Passed means you reviewed photos and accepted it. I only combine when items are actually warehouse-ready and QC-cleared. Anything earlier is wishful thinking.
2) "Consolidation" (the money word)
Consolidation is combining multiple warehouse items into one parcel. This is where shipping savings happen. I used to ship item by item because I got impatient. Now I wait and consolidate by category and timing.
3) "Actual Weight" vs "Volumetric Weight"
This one stung. I had a light puffer jacket that cost more to ship than a heavier denim piece because the puffer took up volume. Carriers often charge whichever is higher: actual or volumetric. So in my sheet, I track both estimated grams and "boxy/bulky risk." If an item is likely volumetric-heavy, I pair it with dense items to improve cost efficiency per kilogram.
4) "Rehearsal Packaging"
I slept on this feature for too long. Rehearsal packaging gives a more accurate pre-ship weight/size estimate after packing. It helps avoid the "whoa why did my shipping jump" moment. I now run rehearsal for bigger hauls, especially shoes plus outerwear combos.
5) "Sensitive/Restricted Goods"
Batteries, liquids, magnets, branded risk categories, and certain materials can limit which shipping lines you can use. If you combine restricted and non-restricted items carelessly, you can force the whole parcel onto a pricier line. I separate these in my spreadsheet with a red flag column.
6) "Declaration Value"
This is customs-facing declared parcel value. I don’t guess blindly anymore. I note target declaration ranges by destination in my sheet and stay consistent with local rules. Random declarations create random stress.
7) "Free Storage Days"
This is your clock. If one item has been sitting for weeks and another is still in seller delay, your "perfect combine" can become storage fees plus rushed shipping. I added a simple "days in warehouse" column and color-coding. It sounds small, but it changed my behavior.
How I Combine Orders for Maximum Shipping Savings (My Real Routine)
Step 1: I group items by shipping compatibility
Group A: standard apparel, easy lines, low restriction risk.
Group B: shoes and bulky items (high volumetric risk).
Group C: sensitive/restricted items that may need special lines.
Parcel plan X: 5.8 kg single box (volumetric risk high)
Parcel plan Y: 3.1 kg + 2.4 kg split (better line access)
Does every item fit the selected line restrictions?
Is volumetric estimate acceptable after rehearsal?
Is declaration value aligned with destination norms?
Is any item better moved to a second parcel?
Item name + link
Category (apparel, shoes, accessories, sensitive)
Status (purchased, warehouse, QC passed)
Estimated actual weight (g)
Volumetric risk (low/med/high)
Restriction flag
Warehouse arrival date
Storage days used
Combine batch ID (Batch 1, Batch 2)
Planned shipping line
Rehearsal result
Final shipped cost per item
I do not mix C with everything else unless I’ve checked line rules first.
Step 2: I target weight brackets, not just "one big box"
A rookie mistake is assuming bigger always equals cheaper. Sometimes 2 medium parcels beat 1 huge parcel because of line pricing tiers and volumetric penalties. I check estimated post-pack weight, then split at natural pricing breakpoints.
In my notes, I literally write mini scenarios like:
Whichever lands lower all-in cost wins. Emotion stays out of it.
Step 3: I use a "hold window" so I stop panic-shipping
I gave myself a rule: once first item arrives, I wait 5-7 days before finalizing consolidation (unless storage urgency says otherwise). This tiny pause catches late-arriving pieces and improves combine efficiency. My shipping cost per item dropped noticeably after this.
Step 4: I remove retail packaging when it hurts value
I love pristine boxes, but not enough to overpay every time. For many non-fragile items, dropping bulky packaging cuts volumetric weight. I keep boxes only for pieces where resale, gifting, or protection really matters.
Step 5: I run a quick "line fit" checklist before paying
This two-minute ritual has saved me from expensive mistakes more than once.
My Personal Spreadsheet Columns (The Ones I Actually Use)
I know it looks extra. But once you track final shipping cost per item, your future buying decisions get way sharper.
What I Wish I Knew Earlier
I used to obsess over product price and ignore logistics. Big mistake. A cheap item with terrible shipping efficiency isn’t really cheap. The spreadsheet jargon felt intimidating at first, but now it’s just vocabulary for better decisions.
If you’re starting today, steal this one rule from me: only combine items after QC pass, then choose parcel splits based on shipping tiers and volumetric impact, not vibes. It sounds unsexy, but it’s the most reliable way I’ve found to lower shipping totals without sacrificing haul quality.
Practical move for this week: set up three columns right now: Volumetric Risk, Restriction Flag, and Storage Days. Those three alone will prevent most expensive combining mistakes.