CNShopper Spreadsheet for Resellers

A general to-do app or notebook cannot handle the complexity of reselling. You are juggling purchase prices from oocbuy, resale prices across multiple platforms, shipping costs in different currencies, platform fees, refund requests, and customer messages. A cnshopper spreadsheet centralizes all of this into one dashboard where every dollar is accounted for. Without it, profit leaks through the cracks of forgotten fees and duplicated orders.

If you hold stock before listing it, you need an inventory tracker. Create a Stock tab with columns for SKU, item name, size, color, quantity on hand, unit cost, and listing status. Use conditional formatting to highlight items that have been in stock for more than 30 days, prompting you to discount or rephotograph them. This prevents dead inventory from tying up your capital.

Not all categories perform equally. Use a pivot table or SUMIF formulas to calculate average margin by product type. You might discover that sneakers average 45 percent margins while accessories average 28 percent. That insight justifies shifting your buying budget toward the higher-margin category. Update this analysis monthly and adjust your sourcing strategy accordingly.

When you grow from 10 orders per month to 200, your spreadsheet must scale too. Add tabs for Suppliers, Customers, and Monthly Reports. Link them with VLOOKUP or XLOOKUP formulas so entering an order ID auto-populates the supplier name and average delivery time. As you hire helpers, share the cloud-based sheet with view-only or edit permissions so they can update statuses without seeing your cost prices.

Come tax season, a well-maintained cnshopper spreadsheet becomes your best friend. Filter all Completed orders by calendar year, sum the profit column, and export the data for your accountant. Keep receipts and tracking numbers in a linked folder with matching filenames. This level of organization turns a stressful week of receipt hunting into a 30-minute export session.