Gift Shop Inventory Template
Designed for museum stores, hospital gift shops and tourist-town boutiques carrying lots of low-quantity, one-vendor items. Track what's on display, what's in the back and who to reorder from.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| GS-MUG-0315 | Lighthouse Ceramic Mug | Drinkware | Front Display Table | each | 14 | 6 | 6.25 | auto | auto | Harbor Gift Co. |
| GS-MAG-0902 | Enamel Fridge Magnet, State Map | Souvenirs | Spinner Rack | each | 60 | 25 | 1.1 | auto | auto | Blue Ridge Souvenir Supply |
| GS-CRD-1120 | Watercolor Greeting Card | Stationery | Card Wall | each | 48 | 20 | 1.35 | auto | auto | Paper Meadow Studio |
ƒ = 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
- Tag items as core, seasonal or local-artist consignment; consignment pieces belong in the list but not in your inventory value.
- Before trade-show buying season, sort by days since last sale to see which vendors aren't earning their shelf space.
- Record minimum order quantities per vendor in the supplier column so reorders don't stall on a $150 minimum.
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 SpreadsheetBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory TemplateJewelry Store Inventory Spreadsheet