GTBuy Spreadsheet for Resellers: Scale from 10 to 1000 SKUs

Reselling at volume is a different game. Ten items is a hobby. One hundred items is a business. One thousand items is an operation. At each stage, your spreadsheet strategy must evolve. This guide shows you exactly how.

Stage 1: The Pipeline View (10-50 items)

At this stage, your biggest risk is losing track of items. Create a pipeline view with columns for Ordered, Shipped, Received, Listed, and Sold. Each status change moves the row visually through your sheet. Conditional formatting makes the pipeline obvious: yellow for incoming, green for ready to list, blue for listed.

Stage 2: Vendor Scoring (50-200 items)

With more vendors comes more variability. Create a Vendor Score sheet that tracks average ship time, defect rate, and communication speed per supplier. Use AVERAGEIF and COUNTIF to auto-calculate scores from your main sheet. Drop vendors who score below 3 out of 5. This single practice can improve your margins by 15%.

Stage 3: Batch Analytics (200+ items)

At volume, you stop thinking about individual items and start thinking about batches. Which category had the best margin last quarter? Which vendor improved the most? Which size sells fastest? Pivot tables answer these questions in seconds. Add a Dashboard sheet with monthly profit charts, category breakdowns, and inventory aging alerts.