Kakobuy Garden Spreadsheet 2026

Spreadsheet
OVER 10000+

With QC Photos

Back to Home

Strategic Planning: Organizing CNFans Spreadsheets for Sales

2026.01.015 views4 min read

The Logic of Timing

Impulse buying on agent platforms like CNFans leads to inflated shipping costs and missed opportunities. The most effective users treat their purchasing habits as a logistical operation. This requires documenting potential purchases in a structured spreadsheet and executing transactions only when market conditions—specifically major sales events—are favorable.

By decoupling the "finding" phase from the "purchasing" phase, you gain control over your budget and inventory flow. This guide details how to organize your finding spreadsheet specifically to capitalize on global e-commerce events like 11.11 and 6.18.

The Spreadsheet Architecture

A standard list of links is insufficient. To maximize efficiency during sales windows, your spreadsheet requires specific data points. Create a dedicated tab named "Pending Acquisition" with the following columns:

    • Item Name: Clear identifier.
    • W2C Link: Typical Weidian/Taobao/1688 raw link (avoid agent conversion links to ensure longevity).
    • Base Price (RMB): The current retail price.
    • Historical Low (RMB): Use price tracking tools to fill this.
    • Priority Level (1-3): 1 being essential, 3 being a "filler" item for weight.
    • Domestic Shipping Cost: Often waived during sales events.
    • Weight Estimate (g): Crucial for shipping calculations later.

    Action Step: Populate this sheet continuously. Do not buy immediately. Let items sit for at least 7 days to cure impulse desires.

    Key Sales Events Calendar

    Timing is everything. Chinese domestic e-commerce operates on a different rhythm than Western retail. Mark these dates in your planning calendar:

    6.18 (Mid-Year Shopping Festival)

    • Dates: June 1st to June 18th.
    • Focus: Second largest event. Massive clearance on winter inventory and discounts on summer tech/accessories.
    • Strategy: Purchase heavy winter items (outerwear) at rock-bottom prices. Store in the CNFans warehouse until autumn to defer shipping costs.

    11.11 (Singles' Day)

    • Dates: Early November to November 11th.
    • Focus: The largest shopping event globally. Peak discounts on almost all categories.
    • Strategy: This is the time for bulk acquisition. Sellers offer steep coupons (e.g., 300-50 RMB off).

    12.12 (Double 12)

    • Dates: December 12th.
    • Focus: Clearing remaining annual stock before Chinese New Year.
    • Strategy: Last call for shipping before the logistics freeze of Lunar New Year.

    Execution Strategy: The Pre-Load

    The biggest mistake buyers make is attempting to find items during the sale. By then, sizes are out of stock and agent websites are slow due to traffic. The spreadsheet method allows for pre-loading.

    Phase 1: Verification (T-Minus 14 Days)

    Two weeks before the event, run through your spreadsheet. Click every link to verify the item is still in stock. Update prices if sellers have started "warm-up" pricing. Delete items with dead links.

    Phase 2: Coupon Collection (T-Minus 7 Days)

    Sellers often release coupons on their main Taobao/Weidian store pages. Check the stores associated with your Priority 1 items. Note any stackable discounts in a "Notes" column on your spreadsheet.

    Phase 3: The Purchase (Day 0)

    When the sale starts, execute purchases for Priority 1 and 2 items immediately. Do not hesitate. Popular batches sell out in minutes. Input the orders into CNFans rapidly using your pre-verified links.

    Logistics and Warehousing

    Using sales events for purchasing does not mean you must ship immediately. CNFans generally offers 90 days of free warehousing. Use this to your advantage.

    The Staggered Approach:

    1. Buy Phase: Purchase all items during the sale to lock in the product price.
    2. Process Phase: Allow 3-7 days for items to arrive at the warehouse. Expect delays; local logistics are overwhelmed during 11.11.
    3. QC Phase: Review quality control photos calmly. Do not rush. Return/Exchange windows still apply.
    4. Ship Phase: Wait for the post-sale shipping lull. International shipping lines often raise prices during the sale due to volume. Waiting 2-3 weeks can sometimes yield better shipping rates or unforeseen coupons from the agent side.

Managing Filler Items

Your Priority 3 items (Socks, keychains, cardholders) play a vital role. In your spreadsheet, calculate the total estimated weight of your Priority 1 and 2 items. If your haul is at 3.6kg, you are likely paying for 4kg or 5kg depending on the line's volumetric steps.

Consult your Priority 3 list. Add enough small, lightweight items to maximize the weight bracket you are already paying for. This effectively reduces the shipping cost per item.

Conclusion

Organization reduces risk. By maintaining a clean, data-driven spreadsheet and syncing your activity with the global sales calendar, you transition from a consumer to a logistician. You secure better prices, ensure availability, and optimize your shipping workflow.