Best Items to Track with CNShopper Spreadsheet

Not all data is equally valuable. A bloated spreadsheet with fifty columns is harder to use than a lean one with fifteen well-chosen fields. This guide breaks down the best items to track in your cnshopper spreadsheet so you spend less time on admin and more time on profit.

Catalog-Level Tracking

Your Catalog tab is the foundation. These fields feed every other calculation in your cnshopper spreadsheet system.

• SKU — Unique code per product variant. Non-negotiable.
• Product Name + Variant — Include size, color, or edition in the name.
• Supplier URL — One-click reordering without hunting through chat history.
• Base Cost + Shipping — Total landed cost per unit.
• Category — Shoes, hoodies, accessories. Helps with reporting.
• Image Link — Visual confirmation to avoid ordering the wrong colorway.

Order-Level Tracking

Financial Tracking

Revenue is vanity. Profit is sanity. Track these financial metrics for true business health:

• Sell Price per Unit — What the customer actually paid.
• Payment Processor Fee — PayPal, Stripe, or platform fees per transaction.
• Shipping to Customer — Postage or courier cost.
• Net Profit per Order — Formula: Sell Price - Landed Cost - Fees - Shipping.
• Return / Refund Log — Separate tab for lost revenue tracking.

Optional: Advanced Metrics

Once your core system is stable, add these advanced fields for deeper insights:

• Days to Sell — Inventory turnover speed.
• Supplier Response Time — Who is fastest to ship?
• Customer Repeat Flag — Identify your most loyal buyers.
• Return Rate by SKU — Spot quality issues early.

FAQ