Inventory Tracker
Marigold & Rye Candle Co. · Stock control · Albuquerque, NM
Esme Calloway makes and sells candles and uses this to see what is low on stock, which purchase orders are still on the way and what sold this week.
Use this templateAll suppliers
Suppliers| Supplier | Contact | Phone | Lead time (days) | Rating | Payment terms | |
|---|---|---|---|---|---|---|
| Beeswax Brothers | Garrett Linde | garrett@beeswaxbrothers.net | (505) 555-0161 | 9 | Net 30 | |
| Glassworks North | Imelda Rossi | imelda@glassworksnorth.net | (505) 555-0162 | 21 | 50% upfront | |
| Wick & Wonder Supply | Tobias Eke | tobias@wickandwonder.net | (505) 555-0163 | 6 | Net 15 |
Tables
Suppliers
3 sample rows · 10 columnsWho you buy from and how reliable they are.
| Supplier | Contact | Phone | Lead time (days) | Rating | Payment terms | |
|---|---|---|---|---|---|---|
| Beeswax Brothers | Garrett Linde | garrett@beeswaxbrothers.net | (505) 555-0161 | 9 | Net 30 | |
| Glassworks North | Imelda Rossi | imelda@glassworksnorth.net | (505) 555-0162 | 21 | 50% upfront | |
| Wick & Wonder Supply | Tobias Eke | tobias@wickandwonder.net | (505) 555-0163 | 6 | Net 15 |
Products
10 sample rows · 16 columnsEverything you sell or use to make what you sell.
| Product | Category | Unit cost | Price | Opening stock (units) | Reorder point (units) | Supplier |
|---|---|---|---|---|---|---|
| Amber Fig 8oz candle | $6.40 | $28 | 120 | 40 | Beeswax Brothers | |
| Cedar & Smoke 8oz candle | $6.90 | $28 | 96 | 40 | Beeswax Brothers | |
| Sea Salt Orchid 8oz candle | $6.10 | $28 | 30 | 40 | Beeswax Brothers | |
| Wild Sage travel tin | $3.20 | $16 | 150 | 60 | Glassworks North | |
| Lavender Honey travel tin | $3.40 | $16 | 0 | 60 | Glassworks North | |
| Holiday trio gift set | $14.50 | $64 | 22 | 25 | Beeswax Brothers | |
| Cotton wick pack, 50 count | $8 | $0 | 40 | 10 | Wick & Wonder Supply | |
| Amber glass jar, 8oz | $1.30 | $0 | 300 | 120 | Glassworks North | |
| Soy wax flakes, 10 lb bag | $42 | $0 | 5 | 6 | Beeswax Brothers | |
| Fragrance oil sampler | $19 | $0 | 12 | 5 | Wick & Wonder Supply |
Purchase orders
7 sample rows · 14 columnsStock on order from suppliers.
| Purchase | PO number | Status | Quantity | Cost each | Ordered | Expected |
|---|---|---|---|---|---|---|
| Amber Fig 8oz candle restock | — | Received | 60 | $7.90 | Sep 24, 2026 | Oct 3, 2026 |
| Cedar & Smoke 8oz candle restock | — | Received | 60 | $8.49 | Sep 24, 2026 | Oct 3, 2026 |
| Sea Salt Orchid 8oz candle restock | — | Ordered | 80 | $7.55 | Oct 13, 2026 | Oct 22, 2026 |
| Lavender Honey travel tin restock | — | Shipped | 200 | $4.36 | Oct 6, 2026 | Oct 16, 2026 |
| Soy wax flakes, 10 lb bag restock | — | Ordered | 12 | $49.91 | Oct 16, 2026 | Oct 25, 2026 |
| Amber glass jar, 8oz restock | — | Received | 500 | $1.88 | Sep 8, 2026 | Sep 29, 2026 |
| Holiday trio gift set restock | — | Ordered | 30 | $17.46 | Oct 17, 2026 | Oct 29, 2026 |
Sales orders
8 sample rows · 11 columnsOrders from customers.
| Customer | Order number | Status | Quantity | Unit price | Ordered | Product |
|---|---|---|---|---|---|---|
| Hollis Maddox | — | Delivered | 8 | $28 | Oct 6, 2026 | Amber Fig 8oz candle |
| Priscilla Banda | — | Delivered | 6 | $28 | Oct 8, 2026 | Cedar & Smoke 8oz candle |
| Craft fair booth | — | Delivered | 24 | $16 | Oct 9, 2026 | Wild Sage travel tin |
| Lena Okafor-Wright | — | Delivered | 14 | $16 | Oct 10, 2026 | Lavender Honey travel tin |
| Corporate gifts, Adler Insurance | — | Shipped | 10 | $64 | Oct 15, 2026 | Holiday trio gift set |
| Dmitri Volkov | — | Packed | 5 | $28 | Oct 17, 2026 | Sea Salt Orchid 8oz candle |
| Rosalind Tran | — | New | 4 | $28 | Oct 18, 2026 | Amber Fig 8oz candle |
| Online order batch | — | New | 9 | $16 | Oct 18, 2026 | Wild Sage travel tin |
Also included
- Mark received
- Mark shipped
- Mark delivered
Related templates
- Boutique clothing storeWickerby Lane Boutique4 tables · 5 views · 1 form · 1 dashboard · 1 digest · 1 row action · 1 agentGallery
- DTC e-commerce brandEmberfield Candle Co.4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentDashboards
- FloristWillowmere Creek Flowers4 tables · 6 views · 1 form · 1 dimension set · 1 dashboard · 1 digest · 2 stage rule sets · 1 agentImports
- Garden centerBurrowes Mill Garden Center5 tables · 7 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 notification · 1 stage rule set · 1 agentDimensions
- Marketplace sellerDeep Groove Audio4 tables · 6 views · 1 form · 1 dashboard · 1 digest · 1 notification · 1 agentImports
- Subscription boxWesterly Heights Box Co.4 tables · 5 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 document · 1 agentDimensions