Shoe Store Inventory Template
For footwear shops that track every style by size and width, from kids' sneakers to dress shoes. Spot size-run gaps before customers walk out.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| RUN-220-10.5-D | Neutral Running Shoe, Men's 10.5 D | Athletic | Backroom / Wall 2 | pair | 3 | 2 | 54 | auto | auto | Stride Footwear Wholesale |
| BT-410-8-M | Chelsea Boot, Women's 8 M | Boots | Backroom / Wall 5 | pair | 2 | 1 | 61 | auto | auto | Westfield Shoe Co. |
| KD-115-13-M | Kids' Velcro Sneaker, Size 13 | Kids | Backroom / Wall 7 | pair | 4 | 2 | 19.5 | auto | auto | Stride Footwear Wholesale |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Make size and width part of the SKU (RUN-220-10.5-W); a missing half size is the most common lost sale.
- Reorder the middle of the size curve (men's 9 to 11, women's 7 to 9) more aggressively than the ends.
- Store backstock by style then size in the same order as the SKU so counts are quick and accurate.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template