How to Use CNShopper Spreadsheet Step-by-Step

Learning how to use a cnshopper spreadsheet is the fastest way to transform your reselling admin from chaos into clarity. Whether you are tracking ten orders or ten thousand, a well-structured spreadsheet keeps every detail in one place. This guide walks you through every step from your first login to your hundredth order.

Step 1: Choose Your Platform

Google Sheets is the most popular choice for best cnshopper spreadsheet users because it is free, cloud-based, and works on every device. Excel Online is a close second if you prefer Microsoft tools. Both allow real-time collaboration and automatic backups.

Step 2: Set Up Your Workbook Structure

• Catalog Tab — Product names, links, supplier info, base cost, and images.
• Orders Tab — Customer details, quantities, sale price, and order status.
• Profit Summary Tab — Auto-calculated revenue, costs, and net profit.
• Suppliers Tab — Vendor contact info and reliability ratings.

Step 3: Input Your First Product

1. Open the Catalog tab and enter the product name in the first row.
2. Paste the supplier link in the URL column for quick reference.
3. Enter your base cost (what you pay the supplier) in the Cost column.
4. Add your target selling price in the Price column.
5. Watch the Margin column auto-calculate using the pre-built formula.

Step 4: Log Orders as They Come In

Every time a customer places an order, switch to the Orders tab and fill in the row. Use dropdown menus for status fields like "Pending," "Shipped," and "Delivered." This keeps your order organization clean and searchable.

Step 5: Review Profits Weekly

FAQ