Real CNShopper Spreadsheet Examples

This example comes from a part-time reseller who processes 20 to 30 orders per month. Her spreadsheet has eight columns: Date, Item, Category, Buy Price, Sell Price, Profit, Status, and Notes. The Profit column uses a single formula that subtracts Buy Price from Sell Price. A second tab called Monthly Summary uses SUMIF to total profit by month. It is simple, fast, and takes under two minutes to update per order.

This reseller specializes in sneakers and streetwear. His main tab has 15 columns including Brand, Size, Colorway, Release Date, Purchase Platform, and Resale Platform. He uses a pivot table on a dashboard tab to show total profit by brand and by size. This revealed that size 10.5 sneakers had 23 percent higher margins than other sizes, so he started targeting that size in bulk.

A team of three resellers uses this comprehensive setup. It has separate tabs for Active Orders, Completed Orders, Inventory, Suppliers, Customers, and Financial Summary. The Financial Summary tab pulls data from all other tabs using IMPORTRANGE and QUERY functions. It shows cash flow, profit by team member, outstanding supplier payments, and monthly growth rate. This level of detail supports a six-figure reselling business.

Profit formula: =SellPrice-BuyPrice-ShippingFee. Profit margin: =Profit/BuyPrice formatted as percentage. Days in stock: =TODAY()-ArrivalDate. Flag low margin: =IF(ProfitMargin<0.2,"Review","OK"). These four formulas alone handle 80 percent of spreadsheet logic that most resellers need. Copy them directly into your own sheet and customize the cell references.