Track every bottle by type, age, ABV and proof, count partial bottles, and see pour cost per 30 ml against your menu price.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Bottles
Fields
17
Views
grid, dashboard
The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.
17 fields · 7 sample rows
| ProductText | TypeSingle select | OriginText | Age (years)Number | ABVPercent | Proof (US)Formula | Bottle size (ml)Number | Full bottlesNumber | Open bottle levelPercent | Bottles on handFormula | ParNumber | Stock statusFormula | Cost per bottleCurrency | Cost per 30 mlFormula | Menu price (30 ml)Currency | Pour cost %Formula | Stock valueFormula |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glenfiddich 12 | Whisky | Scotland | 12 | 40.0% | 80 | 750 | 3 | 60% | 3.6 | 4 | Reorder | ₹4,800 | ₹192 | ₹750 | 25.6% | ₹17,280 |
| Amrut Fusion | Whisky | India | 50.0% | 100 | 750 | 2 | 25% | 2.3 | 3 | Reorder | ₹4,200 | ₹168 | ₹690 | 24.3% | ₹9,450 | |
| Old Monk XXX | Rum | India | 7 | 42.8% | 86 | 750 | 8 | 50% | 8.5 | 6 | In stock | ₹700 | ₹28 | ₹180 | 15.6% | ₹5,950 |
| Grey Goose | Vodka | France | 40.0% | 80 | 750 | 0 | 30% | 0.3 | 3 | Reorder | ₹5,200 | ₹208 | ₹650 | 32.0% | ₹1,560 | |
| Hapusa Himalayan Dry Gin | Gin | India | 43.0% | 86 | 750 | 4 | 80% | 4.8 | 3 | In stock | ₹3,400 | ₹136 | ₹520 | 26.2% | ₹16,320 | |
| Patrón Silver | Tequila | Mexico | 40.0% | 80 | 750 | 1 | 10% | 1.1 | 2 | Reorder | ₹6,500 | ₹260 | ₹900 | 28.9% | ₹7,150 | |
| Baileys Irish Cream | Liqueur | Ireland | 17.0% | 34 | 750 | 2 | 50% | 2.5 | 2 | In stock | ₹2,900 | ₹116 | ₹420 | 27.6% | ₹7,250 |
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
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 fields