CnFans Spreadsheet

Spreadsheet
OVER 10000+

With QC Photos

Back to Home

Decoding the CNFans Spreadsheet: A Q&A Guide to Group Buys and Split J

2026.02.262 views6 min read

Decoding the Matrix

Opening your first community spreadsheet feels a bit like staring into the Matrix. The rows are endless, the links are overwhelming, and the notes section is filled with cryptic acronyms. I remember my first time trying to coordinate a collective order with a few friends using a CNFans sheet. I almost abandoned the whole project because I didn't understand half the slang the agent and the community were throwing at me.

Here's the thing: mastering this terminology is the only way to successfully pull off group buys (GBs) and splits without losing your mind—or your money. Let's break down the most common questions I get about community logistics and spreadsheet slang.

What exactly is a 'GB' and why does 'MOQ' dictate everything?

Q: I keep seeing 'GB' and 'MOQ' linked together on wholesale spreadsheets. What do they mean for me?

A: GB stands for Group Buy. This is when multiple buyers pool their orders together to buy an item in bulk. You usually do this to unlock wholesale pricing or to convince a seller to produce a specific custom item.

This ties directly into MOQ, or Minimum Order Quantity. Let me paint a picture. You find the perfect batch of blank, heavy-weight vintage hoodies on a 1688 link. You want three of them. But the seller's MOQ is 50. If you try to order three through CNFans, the agent will simply cancel the order and leave a note saying the MOQ wasn't met. To bypass this, you organize a GB. You gather 15 people from a Discord server, everyone agrees to buy a few, and suddenly you've hit that 50 MOQ. Your spreadsheet tracks who gets what.

How do 'Splits' actually work?

Q: People keep talking about doing a 'Split' to save on shipping. Are we splitting the items or the shipping cost?

A: It can actually mean both, depending on the context of your spreadsheet.

    • Order Splits: If you successfully pull off a GB, all 50 hoodies arrive at your CNFans warehouse under one primary account. An 'order split' is the logistical nightmare (and I do mean nightmare) of asking the agent to separate those items into different parcels for different people. Some agents hate doing this, so it requires meticulous spreadsheet tracking to tell the agent exactly which item goes in which box.
    • Shipping Splits: This is much more common. You and two friends ship all your items together in one massive 15kg haul to a single address to take advantage of cheaper volumetric shipping rates. Once the box arrives at your house, you physically split the haul and hand off the items to your friends. The spreadsheet is used to calculate exactly what percentage of the international shipping cost each friend owes based on the weight of their specific items.

    What does it mean to 'GP' an item for the group?

    Q: The spreadsheet notes say 'Need someone to GP this link.' Should I do it?

    A: GP stands for Guinea Pig. It means the seller is unverified, or the item is a brand new batch, and no one in the community has bought it yet to check the quality.

    If you volunteer to GP, you are taking the risk for the group. You buy it, wait for it to hit the CNFans warehouse, and share the QC (Quality Control) photos. If it looks terrible, you take the hit (and hopefully can get a refund). If it looks amazing, you give it a GL (Green Light), and everyone else in the group buy swoops in to order. I usually only recommend GPing if you have a bit of disposable budget and don't mind the hassle of potential returns.

    The dread of the 'B&S'

    Q: A user commented that a seller pulled a 'B&S' on our group buy. What happened?

    A: That's Bait & Switch, and it's infuriating. It happens when a seller posts gorgeous, high-quality photos on their store page (the bait), but ships a cheap, flawed, lower-tier batch to your CNFans warehouse (the switch).

    In a group buy scenario, a B&S is chaotic. Imagine 20 people ordering an item based on the GP's great photos, only for the seller to swap the batch for the remaining 19 orders. This is why strict quality control checks at the warehouse are non-negotiable. If you spot a B&S, you immediately give it an RL (Red Light) and tell your agent to return it.

    Navigating 'OOS' vs 'Pre-sale' in collective orders

    Q: Half our group buy is labeled 'OOS' and the other half is 'Pre-sale.' Why is my agent pending forever?

    A: These two terms are the biggest delays in community logistics.

    • OOS (Out of Stock): The seller simply doesn't have it. Sometimes they won't tell the agent for a week. Your order just sits on 'Purchased' until the agent finally cancels it.
    • Pre-sale (or Presell): The seller is collecting funds before manufacturing the item. They might say it ships in 15 days, but in reality, it could take two months.

If you are coordinating a shipping split with friends, one person buying a pre-sale item will hold up the entire parcel. The golden rule of collective orders: never mix in-stock items with pre-sale items in the same warehouse shipment unless everyone is perfectly fine waiting indefinitely.

Understanding Weight: 'Volumetric' vs 'Actual'

Q: When we calculate how to split the shipping costs, should we use actual weight or volumetric weight?

A: This is where friendships are tested. Always, always check if your chosen shipping line charges by Volumetric Weight or Actual Weight.

Actual weight is exactly what it sounds like—put the hoodie on a scale, it weighs 800 grams. Volumetric weight calculates the physical space the item takes up (Length x Width x Height / Divisor). If your friend orders a giant, lightweight plush toy, its actual weight might be 500g, but its volumetric weight could be 3kg. If your shipping line charges volumetrically, and you split the bill based on actual weight, you are subsidizing your friend's shipping costs. Use the CNFans parcel estimation tool to get the volumetric data before you ask your friends for their share of the shipping money.

A Final Piece of Advice

Managing a group buy or a shipping split requires more than just understanding the slang; it requires serious organization. Don't rely on DMing your friends back and forth. Set up a dedicated Google Sheet with locked formulas that automatically calculate shipping splits based on warehouse weights. When everyone can see the math transparently, it prevents arguments over logistics and keeps the focus exactly where it should be: securing great finds at a fraction of the cost.

M

Marcus Thorne

Community Logistics Coordinator

Marcus has organized over 50 large-scale community group buys and shipping splits. He specializes in cross-border logistics and building automated spreadsheets for collective purchasing.

Reviewed by Editorial Team · 2026-03-16

Sources & References

  • r/FashionReps Community Terminology Wiki
  • RepArchive Agent Glossary
  • CNFans Official Logistics and Volumetric Weight Guidelines

CnFans Spreadsheet

Spreadsheet
OVER 10000+

With QC Photos