Theory is helpful, but real examples make concepts click. This article presents five litbuy spreadsheet examples based on actual reseller setups. Each example includes a category focus, sample data rows, and the logic behind the column choices. You can copy these structures directly into your own template and adapt them to your supplier data. For the full setup tutorial, visit how to use litbuy spreadsheet. Return to the litbuy spreadsheet homepage anytime.
Quick Answer
Litbuy spreadsheet examples show real catalog structures for Shoes, Hoodies, Jackets, Accessories, and multi-category setups. Each example includes sample SKUs, cost data, margin calculations, and filtering strategies you can copy directly.
Example 1 — Shoes Specialist
This setup belongs to a reseller who focuses exclusively on sneakers and casual footwear. The catalog contains 200 SKUs with detailed size breakdowns.
| SKU | Name | Cost | Sell | Margin | Stock |
|---|---|---|---|---|---|
| AJ1-BRED-42 | Air Jordan 1 Bred | $85.00 | $150.00 | 38.1% | 12 |
| YZY-350-V2-43 | Yeezy 350 V2 | $110.00 | $195.00 | 40.5% | 8 |
| NB-550-WHT-41 | NB 550 White | $45.00 | $89.00 | 44.9% | 20 |
| NK-DUNK-BW-44 | Nike Dunk Black/White | $60.00 | $120.00 | 45.8% | 15 |
Key insight: High-margin SKUs like the NB 550 and Nike Dunk carry larger stock volumes. The reseller uses the margin sort to prioritize restocking the highest-margin items first.
Example 2 — Hoodies & Sweaters Focus
This catalog targets streetwear buyers in colder climates. Seasonality matters here, so the reseller added a custom Season column.
| SKU | Name | Cost | Sell | Margin | Season |
|---|---|---|---|---|---|
| HD-ESS-BLK-L | Essential Hoodie Black | $28.00 | $65.00 | 51.5% | Fall/Winter |
| SW-WOOL-CRM-M | Wool Sweater Cream | $35.00 | $78.00 | 51.3% | Winter |
| HD-ZIP-GRY-XL | Zip Hoodie Grey | $22.00 | $49.00 | 52.0% | Year-round |
| SW-CASH-NVY-S | Cashmere Sweater Navy | $55.00 | $120.00 | 50.4% | Winter |
Key insight: The Season column enables filtering by upcoming season. In October, the reseller filters to Fall/Winter and increases stock 30% before demand peaks.
Example 3 — Jackets & Outerwear
Outerwear has higher average costs but also higher margins. This example shows how to track size ranges and color variants efficiently.
| SKU | Name | Cost | Sell | Margin |
|---|---|---|---|---|
| JK-PUFF-BLK-M | Puffer Jacket Black | $42.00 | $95.00 | 53.2% |
| JK-BOMB-KHA-L | Bomber Jacket Khaki | $38.00 | $85.00 | 52.9% |
| JK-WND-BLU-XL | Windbreaker Blue | $25.00 | $59.00 | 54.2% |
| JK-FLD-CAM-S | Field Jacket Camo | $48.00 | $110.00 | 53.6% |
Key insight: Size and color are embedded in the SKU. This avoids extra columns and keeps the sheet lean while maintaining variant tracking.
Example 4 — Accessories & Headwear
Accessories have lower individual margins but faster turnover. This reseller tracks days-in-inventory closely to avoid stale stock.
| SKU | Name | Cost | Sell | Margin | Days |
|---|---|---|---|---|---|
| HW-CAP-BLK-OS | Snapback Cap Black | $8.00 | $22.00 | 60.0% | 12 |
| AC-BLT-LTH-BRN | Leather Belt Brown | $15.00 | $38.00 | 57.9% | 24 |
| HW-BNE-WHT-OS | Beanie White | $6.00 | $18.00 | 62.5% | 8 |
| AC-SCK-CRW-3PK | Crew Socks 3-Pack | $5.00 | $15.00 | 61.3% | 18 |
Key insight: Accessories move fast but margins are high. The Days column flags slow items. Anything over 30 days gets a price drop or bundle offer.
Example 5 — Multi-Category Generalist
This is the most common setup. The reseller sells across Shoes, Hoodies, T-Shirts, Jackets, and Accessories, using category filters to manage complexity.
| SKU | Category | Cost | Sell | Margin |
|---|---|---|---|---|
| AJ1-BRED-42 | Shoes | $85.00 | $150.00 | 38.1% |
| HD-ESS-BLK-L | Hoodies | $28.00 | $65.00 | 51.5% |
| TS-BSC-WHT-M | T-Shirts | $12.00 | $32.00 | 59.4% |
| JK-PUFF-BLK-M | Jackets | $42.00 | $95.00 | 53.2% |
| HW-CAP-BLK-OS | Accessories | $8.00 | $22.00 | 60.0% |
Key insight: The Category column makes filtering instant. One click shows only Shoes, Hoodies, or Accessories. The Dashboard tab auto-summarizes each category's total value and average margin.
Frequently Asked Questions
Yes. These are designed as starting templates. Replace the sample SKUs, names, and prices with your own supplier data.
Start With an Example
The fastest way to get productive is to copy one of these litbuy spreadsheet examples into your template and replace the sample data with your own supplier prices. Within 30 minutes, you will have a working catalog with real margin calculations. For optimization strategies, read litbuy spreadsheet tips.