How to Use CNShopper Spreadsheet Step-by-Step

Phase 1: Create Your Header Row

Open Google Sheets or Excel and create a new blank workbook. In row one, enter these exact column headers from left to right: Order ID, Date Ordered, Seller Name, Item Name, Category, Size or Variant, Unit Price, Shipping Cost, Total Cost, Tracking Number, Status, Arrival Date, Condition, Resale Price, Profit Margin, Notes. Select the entire first row, make it bold, and apply a light gray background fill so it stands out from data rows.

Freeze the first row so it remains visible when scrolling. In Google Sheets, click View then Freeze then 1 row. In Excel, use the View tab and select Freeze Top Row. This small detail prevents massive frustration when your sheet grows past fifty orders.

Phase 2: Add Your First Real Order

Enter one complete order manually before adding any formulas. Use real data from a recent purchase so you understand what each column receives. For Order ID, use a simple system like ORD-001. Write the seller name exactly as it appears on the platform to avoid confusion later. Enter the unit price in your local currency and note the shipping cost separately.

In the Status column, create a dropdown list with these options: Ordered, Paid, Shipped, In Transit, Customs, Delivered, Listed, Sold. Dropdown lists prevent typos that break filters later. In Google Sheets, select the Status column, click Data, then Data Validation, and enter the list separated by commas.

Phase 3: Build Essential Formulas

The Total Cost column should automatically add Unit Price and Shipping Cost. Enter a SUM formula in the first data row that references those two cells, then drag it down to apply to the entire column. The Profit Margin column calculates your percentage gain using the formula: Resale Price minus Total Cost, divided by Total Cost, formatted as a percentage.

Add a COUNTIF formula on a second sheet named Dashboard to show total orders. Add SUMIF formulas to calculate total spending and total projected resale revenue. These three dashboard numbers give you a weekly snapshot without scrolling through hundreds of rows. Keep the dashboard simple at first. Complexity grows naturally as your needs evolve.

Phase 4: Apply Conditional Formatting

Color-coding transforms a boring grid into an actionable command center. Apply these rules to the Status column: yellow fill for Ordered, orange for Shipped, light blue for In Transit, gray for Delivered, and green for Sold. In the Profit Margin column, use light green fill for margins above forty percent and light red for margins below ten percent.

Conditional formatting works slightly differently in Google Sheets and Excel but follows the same logic. Highlight the column, open conditional formatting rules, and set color thresholds based on cell values or text matches. The visual feedback makes your entire portfolio readable in under three seconds.

Phase 5: Build a Weekly Review Habit

A perfect spreadsheet delivers zero value if you never open it. Schedule a fifteen-minute review every Sunday evening. Update every status that changed during the week. Add resale prices for delivered items that you intend to sell. Check the dashboard summary to spot trends, such as a specific seller who consistently ships late or a category that generates unexpectedly high margins.

Export a backup copy monthly. In Google Sheets, click File then Download as Microsoft Excel. Store the backup in a cloud folder separate from your working file. This habit protects you from accidental deletion and gives you historical snapshots for year-end tax calculations.

Comparison Table

Pro Tips

• Use dropdown lists for Status and Category columns to prevent typos that ruin filters.
• Always separate Unit Price and Shipping Cost instead of combining them. You need both numbers for accurate seller comparisons.
• Back up your sheet monthly by downloading a local copy even if it lives in the cloud.

Frequently Asked Questions