How to Use CNShopper Spreadsheet Step-by-Step (Full Tutorial)

Open Google Sheets in your browser and click the blank template. Immediately rename the document to 'CNShopper Tracker' plus the current year. This tiny habit prevents confusion when you inevitably create multiple versions.

Before adding data, adjust the default settings. Turn off gridlines for a cleaner look. Set the font to Inter or Arial for readability. Widen column A to at least 200 pixels so product names do not wrap awkwardly. These cosmetic tweaks make the sheet feel professional and encourage daily use.

In cell A1, type 'Item Name'. Move across the row adding these headers: Category, Seller URL, Size, Color, Local Price, Home Price, Shipping, Rating, Status, Notes, Date. Freeze this row so it stays visible while scrolling. In Google Sheets, use View > Freeze > 1 row.

Format the header row with a dark background and white text. This visual separation prevents you from accidentally typing data into the header row months later. Apply bold formatting and center alignment for maximum clarity.

The Status column should never contain free-text entries. Click the Status column header, go to Data > Data Validation, and set the criteria to a list. Enter these exact values separated by commas: Researching, Ordered, Shipped, Arrived, Returned, Resold. Now every status entry is consistent and filterable.

Apply the same logic to the Category column. Common categories include Shoes, Hoodies, T-Shirts, Jackets, Accessories. Consistent categories let you build pivot tables later that show spending per category. This becomes invaluable during tax season or budget reviews.

Do not wait for the perfect moment. Find five items you are genuinely considering buying. Enter their names, paste the seller URLs, note the sizes and colors, and record the prices. Leave the Status column set to 'Researching' for now.

This initial data serves as your training set. You will spot formatting issues, column width problems, and missing headers immediately. Fix them now while the sheet is small. It is infinitely easier to restructure five rows than five hundred.

At the bottom of your Home Price column, add a SUM formula. Click the empty cell below your last price entry and type =SUM(F2:F6) assuming F is your Home Price column. This single cell shows your total committed spending.

Next, add a COUNTIF in a blank cell to track how many items are 'Ordered' but not yet 'Arrived'. Type =COUNTIF(J2:J6, 'Ordered'). Replace J with your actual Status column letter. These two formulas transform your sheet from a static list into a live dashboard.

Conditional formatting turns your cnshopper spreadsheet into a visual command center. Highlight the entire Status column, go to Format > Conditional Formatting, and set three rules. If text contains 'Arrived', fill green. If text contains 'Returned', fill red. If text contains 'Shipped' for more than 30 days, fill yellow.

Apply a second rule to the Rating column. If the value is less than 3, fill the cell orange. This creates an instant visual warning system. You will spot problematic orders and risky sellers without reading a single word.

A spreadsheet is only as good as its data freshness. Set a recurring calendar reminder every Sunday evening for a fifteen-minute review. Update statuses, add newly discovered items, and archive completed orders to a secondary tab.

During review, check your SUM formula. Are you still within budget? Check your COUNTIF. Are there stuck shipments that need follow-up? This weekly ritual turns your tracker from a passive archive into an active buying assistant.