Looking for a quick way to organize your orders? Check out our free cssbuy spreadsheet templates or dive into the complete cssbuy spreadsheet guide.
Why Resellers Need a Different Spreadsheet
A basic cssbuy spreadsheet tracks what you bought. A reseller spreadsheet tracks what you bought, what you paid, where you listed it, what you sold it for, and how long it sat in inventory. Those extra columns turn a shopping list into a business tool.
Resellers who skip proper tracking end up with mystery inventory. They find a shoebox in the closet and cannot remember if they already listed it on eBay. They sell an item for eighty dollars and forget they paid sixty, so they think they made a profit when they barely broke even after fees.
Essential Columns for Reseller Tracking
Start with the standard columns: Link, Name, Size, Color, Cost. Then add Reseller Price, Platform, Listing Date, Sale Date, Platform Fee, Shipping to Buyer, and Net Profit. Net Profit formula is =Reseller Price - Cost - Platform Fee - Shipping to Buyer.
Add an Inventory Status column with values: In Warehouse, Listed, Sold, Shipped to Buyer, Returned. That status chain tells you exactly where every item sits in your pipeline. Nothing gets lost between warehouse and PayPal.
Days in Inventory is a calculated column: =IF(Sale Date="", TODAY()-Listing Date, Sale Date-Listing Date). High numbers here identify slow movers. If an item sits for ninety days, drop the price or move it to a different platform.
Want the easiest way to get started?
Visit Main Store — Buy It NowUsing Data to Pick Better Inventory
After six months of tracking, sort your cssbuy spreadsheet by Net Profit. The top ten items reveal patterns. Maybe Jordan 1 Mids always profit. Maybe oversized hoodies never sell. Data replaces guesswork.
Create a Seller Scorecard tab. List every seller you have bought from, average profit per item, return rate, and QC accuracy. Stop buying from sellers who cost you money. Double down on sellers who deliver profit.
Quick Comparison
| Column | Formula | Decision It Enables | Priority |
|---|---|---|---|
| Net Profit | =Sell-Cost-Fees-Ship | Keep or cut item | Must |
| Days in Inventory | =TODAY()-Listed | Price drops | Must |
| Platform Fee | Percentage | Platform choice | Must |
| Seller Score | Average profit | Seller loyalty | Should |
| ROI | =Profit/Cost | Investment ranking | Should |
Frequently Asked Questions
1Should I track every platform separately?
Yes. eBay, Grailed, Depop, and Instagram all have different fees and buyer behavior. Separate tracking shows which platform earns you the most.
2How do I handle returns?
Add a Return Status and Return Reason column. Track whether returns are your fault, buyer remorse, or seller defects. Patterns here protect your reputation.
3Can I use the same sheet for personal and resale items?
Yes, but use a Type column to tag each row. Filter by Type when you want pure business data or pure personal data.
Ready to Start Tracking?
Grab a free template, set up your first sheet, and never lose track of an order again.