Inventory database templates keep stock in a table where quantities, reorder levels and values are calculated rather than typed in. Choose the template that matches what you count, from products and fixed assets to kitchen ingredients and bar bottles.
13 templates
Products with SKUs, costs and prices, where stock on hand is calculated live from every stock-in, sale, return and adjustment.
2 tables · 25 fieldsArt Inventory TemplateCatalogue every artwork with images, medium, location, provenance and pricing, linked to the artists you represent.
2 tables · 24 fieldsAsset Inventory TemplateA fixed-asset register with tags, assignees, warranty dates and straight-line depreciation to today’s book value.
1 table · 18 fieldsBar Inventory TemplateCount spirits, beer, mixers and bar equipment against par levels, see what to order from which supplier and what your stock is worth.
2 tables · 21 fieldsBook Inventory TemplateTrack titles, ISBNs, copies on the shelf and margins for a bookstore or library, with low-stock flags and cover gallery.
1 table · 17 fieldsEquipment Inventory TemplateKnow where every piece of equipment is, when it is due for service, and who has it checked out right now.
2 tables · 27 fieldsHome Inventory TemplateRoom-by-room record of what you own, with photos, receipts, warranties and replacement values — ready for an insurance claim.
1 table · 16 fieldsLiquor Inventory SpreadsheetTrack every bottle by type, age, ABV and proof, count partial bottles, and see pour cost per 30 ml against your menu price.
1 table · 17 fieldsOffice Inventory TemplateKeep office supplies and small equipment stocked — serials, purchase dates, minimum levels — and let staff request what they need.
2 tables · 23 fieldsOrder TrackerFollow every order from placed to delivered — items, totals, payment, courier and tracking — with lifetime value per customer.
2 tables · 24 fieldsPantry Inventory TemplateKnow what is in the kitchen, what is running low and what expires soon — and get a ready-made shopping list.
1 table · 13 fieldsPersonal Property SheetCollect each owner’s details and a documented list of their belongings, with proof of ownership and insured value per owner.
2 tables · 25 fieldsRestaurant Inventory TemplateCount ingredients and supplies against par, flag use-by dates, and log kitchen waste so you can see what it is costing you.
2 tables · 23 fieldsThis category holds 13 inventory templates for Edesy Tables. For businesses that sell, the Product Inventory Template keeps products with SKUs, costs and prices, and works out stock on hand from a linked table of stock movements: every purchase, sale, return or adjustment is a row. The Order Tracker follows each order from placed to delivered with items, payment and courier details, linked to customers. For things you own rather than sell, the Asset Inventory Template is a fixed-asset register with tags, assignees, warranty dates and depreciation, the Equipment Inventory tracks who has which item checked out and when it is due for service, and the Office Inventory lets staff request supplies through a form. Hospitality teams get Restaurant, Bar and Liquor templates that count stock against par levels, flag use-by dates and log waste, while the Book, Art, Home and Pantry templates and the Personal Property Sheet cover catalogues and household records. Each template uses typed fields, so quantities stay numbers and categories stay consistent, and formulas or rollups produce low-stock flags, totals and values automatically. Gallery views show items with photos, dashboards summarise stock value, and calendar views show expiry or service dates. You can import a current stock list from CSV or Excel and export it again at any time.
Keep each product's SKU, cost and price, and let stock on hand update from every stock-in, sale and return you record.
Register laptops, machines and furniture with tags, assignees, warranty dates and book value, and see who has borrowed what.
Count ingredients and bottles against par levels, flag what expires soon, and log waste so you can see what it costs.
Track stationery and small equipment with minimum levels, and take supply requests from staff through a form.
Catalogue books, artworks or household items with photos, values and locations, ready for a stock check or an insurance claim.
| Template | Use it when |
|---|---|
| Product Inventory Template | You sell products and want stock on hand calculated from purchases, sales and returns. |
| Order Tracker | You need to follow customer orders from placed to delivered, with payment and courier details. |
| Asset Inventory Template | You keep a register of company assets with assignees, warranties and depreciation. |
| Equipment Inventory Template | Equipment is lent out and serviced, and you need to know who has each item. |
| Restaurant Inventory Template | A kitchen counts ingredients against par levels and wants to track waste. |
| Office Inventory Template | You stock office supplies and want staff to request items through a form. |
Decide whether you are tracking stock you sell, assets you own, or consumables, and pick the matching template.
Open it, click Use this template, sign in with your Edesy account and click Use template in the preview.
Adjust categories, units, locations and reorder levels to your own items and warehouse or shop layout.
Delete the sample rows and import your current stock list from a CSV or Excel file.
Record each stock movement or checkout as a row, and add an automation that posts to Slack or calls a webhook when an item falls below its reorder level.
Yes, in templates built on movements. In the Product Inventory Template, stock on hand is a formula over rollups of the linked stock movements (opening stock plus units in minus units out), so adding a sale or purchase row changes the quantity without editing the product.
The templates flag items below their reorder or par level with a formula. To be told about it, add an automation that runs when a record matches that filter and posts to a connected Slack channel or calls a webhook.
Yes. Attachment fields hold images and files, and gallery views show items as cards with their photo, which helps with art, book and asset catalogues.
Add a location field, or a locations table linked to stock movements, and create a filtered view per location. Totals across all locations stay in the main products table.
Yes. Export any table or view to CSV or Excel, for example a filtered view of the month's stock movements or the current stock value.
Start from a template or a blank base, import a spreadsheet, and work in grid, kanban, calendar, form and dashboard views.