If you've ever tried to track prices across a dozen stores, compare specs between similar products, or coordinate a group buy through a shopping agent, you already know the chaos of scattered notes and screenshots. The CAFANS method — a practical approach built around one central spreadsheet — turns that chaos into a clean, repeatable workflow. This spreadsheet guide walks you through the entire system, from your first shopping spreadsheet to a full product comparison spreadsheet and even an agent shopping spreadsheet for overseas purchases.

What Is CAFANS?

CAFANS is best understood as a checklist framework: Collect, Arrange, Filter, Analyze, Negotiate, Save. Each step maps directly onto columns, tabs, and formulas inside a single spreadsheet. Because spreadsheets are free, flexible, and familiar, they make an ideal home for your shopping data. Whether you're a bargain hunter, a reseller, or someone buying through an online shopping agent, the same structure works.

Step 1: Collect — Build Your Shopping Spreadsheet

Start with a shopping spreadsheet that captures every candidate item. At minimum, include these columns: item name, product link, brand, model number, unit price, shipping cost, coupon code, seller rating, availability, and notes. Add a date added column so you know when a price was recorded — prices move fast, and stale data misleads.

Use data validation for fields like category and status so entries stay consistent. A simple dropdown with options like shortlisted, ordered, and rejected prevents messy free text. If you're working with imports, add columns for currency and exchange rate early — converting later is painful.

Step 2: Arrange — Structure Beats Volume

A good spreadsheet is organized, not just full. Create separate tabs for each stage: a wishlist tab, a price tracking tab, a product comparison spreadsheet tab, and an orders tab. Freeze the header row, apply filters, and use conditional formatting to highlight price drops or items that have been sitting untouched for 30 days.

Group related items with a category column (electronics, home, apparel). If you shop across multiple marketplaces, add a platform column — Amazon, Taobao, AliExpress, or a local retailer. This makes later filtering trivial.

Step 3: Filter — Narrow the Field

Filtering is where the spreadsheet earns its keep. Use the filter view to hide rejected items, then sort by total landed cost rather than sticker price. Total landed cost should include shipping, tax, duties, and agent service fees. A cheap item with expensive shipping is rarely a bargain.

Build a shortlist column with a simple yes/no flag, then create a pivot table summarizing average price per category. Pivot tables are the fastest way to spot which category is draining your budget.

Step 4: Analyze — The Product Comparison Spreadsheet

This is the heart of the CAFANS method. A product comparison spreadsheet puts contenders side by side. Use one row per product and one column per attribute: price, warranty, weight, dimensions, material, battery life, return policy, review score, and review count. Add a weighted score column with a formula that reflects your priorities — for example, price at 40%, quality at 40%, and warranty at 20%.

Standardize units before comparing. Mixing centimeters and inches, or grams and ounces, produces false winners. Add a unit price column (price per gram, per liter, or per unit) to compare different package sizes fairly. A value score based on unit price plus review score often reveals the true best buy.

Step 5: Negotiate — The Agent Shopping Spreadsheet

Buying through an online shopping agent adds layers: service fees, domestic shipping within the source country, international freight, and consolidation. An agent shopping spreadsheet should track each of these separately. Include columns for agent name, order number, item cost, domestic shipping, international shipping, service fee percentage, consolidation fee, insurance, and estimated delivery date.

Use a formula to calculate the effective markup — the difference between the listed price and what you actually pay. This is essential for negotiation and for deciding whether an agent is worth it. Keep a separate tab for communication logs (dates, questions asked, answers received) so nothing gets lost in chat threads.

Step 6: Save — Close the Loop

Finally, record outcomes. Add an actual price paid column next to your estimate, plus delivery date and condition on arrival. Over time this becomes a personal price database. A savings summary tab that compares estimated versus actual spend shows exactly how much the CAFANS workflow saved you.

Practical Tips for Your Spreadsheet Guide

  • Back up regularly and use version history — shopping data is surprisingly hard to rebuild.
  • Keep formulas simple; complicated nested formulas break when rows are inserted.
  • Use a template and duplicate it per shopping trip rather than editing one master file.
  • Timestamp every price; a price without a date is a guess.
  • Share a read-only view with family or teammates when coordinating group purchases.

With a single well-structured spreadsheet, you move from impulse buying to informed decisions. The shopping spreadsheet collects, the product comparison spreadsheet analyzes, and the agent shopping spreadsheet controls costs. Follow this spreadsheet guide once, and the CAFANS workflow becomes second nature.