Skip to main content

Cnfans Support Spreadsheet 2026 Research Hub

Browse CNFans Spreadsheet Research
OVER 10000+

Curated finds, current listing checks, QC research, sizing guidance, and shipping context.

Back to Home

Decoding CNFans Spreadsheet Jargon: Your Complete Guide to Combining Orders for Maximum Shipping Savings

2026.01.310 views5 min read

Every experienced CNFans shopper knows the secret to significant savings isn't just finding great deals—it's mastering the art of order consolidation. But between cryptic abbreviations and warehouse jargon, many newcomers leave money on the table simply because they don't understand the language. This comprehensive guide demystifies every term you'll encounter while building cost-effective combined shipments.

The Essential Vocabulary of Order Consolidation

Before you can optimize your shipping strategy, you need to speak the language fluently. Here's your definitive glossary of consolidation terminology:

Warehouse Terms You Must Know

  • Consolidation Period: The timeframe your items can sit in the warehouse before incurring storage fees, typically 90-180 days
  • Volumetric Weight: Calculated as (Length × Width × Height) ÷ 6000, often more expensive than actual weight
  • Dead Weight: The actual physical weight of your package on a scale
  • Chargeable Weight: Whichever is higher between volumetric and dead weight—this is what you pay for
  • Parcel Rehearsal: Pre-packaging service that estimates final shipping costs before you commit

Spreadsheet-Specific Abbreviations

  • W2C: Where to Cop—links to purchase items
  • GP: Guinea Pig—first person to order and review an item
  • OOS: Out of Stock
  • B&S: Bait and Switch—seller sends different item than pictured
  • RL/GL: Red Light (reject) / Green Light (approve)

Problem #1: My Shipping Costs More Than My Items

This is the most common complaint among new users, and it stems from misunderstanding how shipping is calculated.

The Solution: Strategic Weight Distribution

Shipping carriers charge by brackets, not linear increments. Understanding these thresholds is crucial:

  • 0-500g: Base rate applies, often the worst value per gram
  • 500g-1kg: Slightly better rate, still not optimal
  • 1-2kg: Sweet spot begins here for most carriers
  • 2-5kg: Optimal value zone—aim for this range
  • 5kg+: Best per-gram rates but higher total cost

The key insight: A 450g package might cost nearly the same as a 900g package. Always try to fill your weight bracket completely. Use the spreadsheet's weight estimates to plan your haul around these thresholds.

Problem #2: Volumetric Weight Is Destroying My Budget

You ordered five lightweight items, but the box is massive. Now you're paying for air.

The Solution: Vacuum Packing and Strategic Item Selection

Request these specific services when submitting your parcel:

  • Vacuum Seal: Compresses soft goods by up to 70%, dramatically reducing volumetric weight
  • Remove Packaging: Eliminates bulky retail boxes that inflate dimensions
  • Simple Packaging: Items wrapped in plastic rather than placed in branded boxes
  • Fold Items: Specific instruction for jackets and pants to minimize height

Pro tip: When browsing the spreadsheet, mentally categorize items as "volume-heavy" (puffer jackets, shoes with boxes) versus "volume-friendly" (t-shirts, accessories). Balance your haul accordingly.

Problem #3: I Don't Know When to Ship

Timing your consolidation requires understanding several interconnected factors.

The Solution: The Consolidation Calendar Method

Create a personal shipping schedule based on these principles:

  • Seller Processing Time: Budget 3-7 days for items to reach the warehouse
  • QC Photo Window: Allow 24-48 hours to review and approve each item
  • Exchange Buffer: If items need returning, add 7-14 days
  • Consolidation Sweet Spot: Ship when 80% of your items arrive; waiting for stragglers rarely pays off

Mark these dates in your calendar: Order Date → Expected Warehouse Arrival → QC Deadline → Ship-By Date. This prevents costly storage fees and rushed decisions.

Problem #4: My Items Keep Getting Separated

You ordered from multiple sellers, but items are shipping in different packages.

The Solution: Understanding Warehouse Logistics

Items from different sellers arrive at different times. Here's how to ensure they combine:

  • Hold for Consolidation: Explicitly select this option for each order
  • Parcel Grouping: Create a named parcel group in your dashboard before ordering
  • Timing Coordination: Order items with similar processing times together
  • Warehouse Notes: Add "Please combine with order #XXXXX" in shipping remarks

Problem #5: I Can't Calculate True Item Cost

The spreadsheet shows ¥199, but what's the real price delivered to your door?

The Solution: The Complete Cost Formula

Use this calculation for every item:

True Cost = Item Price + Domestic Shipping + (Estimated Weight × Shipping Rate per gram) + Service Fees

For a practical example: A ¥200 hoodie (estimated 600g) shipping via EMS at ¥0.12/g after first 500g:

  • Item: ¥200
  • Domestic shipping: ¥10
  • International shipping share: ¥72 (600g portion of combined shipment)
  • QC photos: ¥5
  • Total: ¥287 (~$40 USD)

Advanced Consolidation Strategies

The "Anchor Item" Technique

Start each haul with one heavy, compact item (belts, small leather goods, jewelry). This establishes a weight base that lighter items can "piggyback" on without significantly increasing volumetric calculations.

The "Seasonal Batch" Method

Instead of shipping items as you find them, build themed hauls:

  • Summer Batch: Lightweight tees, shorts, accessories (optimal for air shipping)
  • Winter Batch: Heavy outerwear, boots (better value via sea shipping despite longer transit)
  • Accessories Batch: Small items that fill dimensional gaps in larger shipments

The "Split Shipment" Decision Tree

Sometimes two smaller packages beat one large one. Consider splitting when:

  • Total value exceeds customs thresholds for your country
  • Mix of fragile and durable items creates packaging conflicts
  • Volumetric weight of combined items exceeds sweet spot brackets
  • Different urgency levels (ship time-sensitive items separately)

Quick Reference: Shipping Line Terminology

Different shipping options have their own jargon:

  • Tax-Free Line: Carrier handles customs duties, price included
  • Tax-Inclusive: Same as above
  • Sensitive Line: Accepts items other carriers reject (branded goods, batteries)
  • Triangle Shipping: Routes through third country to avoid direct customs scrutiny
  • DDP (Delivered Duty Paid): All fees included in quoted price
  • DDU (Delivered Duty Unpaid): You may owe customs fees on delivery

Your Action Plan

Now that you're fluent in consolidation terminology, implement these steps for your next haul:

  1. Create a spreadsheet tracking item weights and dimensions before ordering
  2. Set a target weight bracket (2-3kg recommended for beginners)
  3. Order items with similar processing times simultaneously
  4. Request vacuum sealing and packaging removal for all soft goods
  5. Use parcel rehearsal before committing to any shipping line
  6. Calculate true item cost using the formula above

Understanding this terminology isn't just about comprehension—it's about empowerment. Every term you master translates directly into dollars saved and smarter purchasing decisions. The spreadsheet is your tool; this vocabulary is your instruction manual.

C

Cnfans Support Spreadsheet 2026 Editorial Team

Shopping Research and Quality Review Desk

The editorial team reviews spreadsheet research, seller context, listing evidence, QC photo checks, sizing notes, shipping constraints, source links, and reader corrections before publication.

Reviewed by Cnfans Support Spreadsheet 2026 Editorial Team · 2026-07-11

Cnfans Support Spreadsheet 2026 Research Hub

Browse CNFans Spreadsheet Research
OVER 10000+

Curated finds, current listing checks, QC research, sizing guidance, and shipping context.

Browse articles by topic