A cnshopper spreadsheet is only useful if you know how to use it properly. This step-by-step guide breaks down every action from creating your first sheet to generating monthly profit reports. Whether you use Google Sheets, Excel, or Notion, these instructions apply universally.
Want the best spreadsheet tools?
Get Best Spreadsheet ToolsStep 1: Download the Template
Visit our resources page and download the latest cnshopper spreadsheet template for your preferred platform. Save it to a dedicated folder named after your store or brand. If you are using Google Sheets, make a copy to your own Drive so you have full editing rights.
Step 2: Customize Column Headers
Open the template and review the default columns. Standard headers include Order ID, Date, Item Name, Category, Supplier, Cost Price, Shipping Fee, Total Cost, Selling Price, Profit, Status, and Notes. Add or remove columns based on your workflow. For example, if you photograph every item before shipping, add an Image Link column.
Step 3: Enter Your First Order
Log into oocbuy and copy the product name and URL from your most recent order. Paste these into the first empty row of your cnshopper spreadsheet. Fill in the cost price, shipping fee, and any discount codes used. In the Selling Price column, enter the price you plan to charge your customer. The Profit column should auto-calculate if the template formula is active.
Ready to level up your reselling?
Visit Our Main WebsiteStep 4: Set Up Status Tracking
Use the Status column to track where each order sits in your pipeline. Common values are Ordered, Shipped, Arrived, Listed, Sold, and Completed. You can add color coding so a quick glance tells you how many orders are stuck in shipping. This is one of the most powerful visual features of a well-built spreadsheet.
Step 5: Generate Weekly Reports
At the end of each week, filter your sheet by the Date column to see orders placed in the last seven days. Sum the Profit column to see your weekly earnings. Over time, you will spot trends such as which days yield the highest margins and which product categories perform best.
Comparison Table
| Step | Time Required | Difficulty | Impact |
|---|---|---|---|
| Download template | 2 min | Easy | Foundation |
| Customize columns | 5 min | Easy | Personalization |
| Enter first order | 5 min | Easy | First data point |
| Status tracking | 10 min | Medium | Workflow clarity |
| Weekly reports | 8 min | Medium | Business insight |
Frequently Asked Questions
Q:What if a formula breaks?
Do not panic. Most templates use simple subtraction and SUM formulas. If a cell shows an error, check that the Cost and Selling Price cells contain numbers, not text.
Q:Can I track multiple stores in one sheet?
Yes. Add a Store Name column and use filters to view one store at a time. Alternatively, create separate tabs for each store.
Q:How often should I update the spreadsheet?
Update immediately after placing or receiving an order. For high-volume resellers, a daily 10-minute update session works best.
Start Using CNShopper Spreadsheet Today
Transform your reselling workflow with our free guides, templates, and expert tips.