Products with SKUs, costs and prices, where stock on hand is calculated live from every stock-in, sale, return and adjustment.
A product inventory template is a ready-made database that lists every product you sell with its SKU, cost and price, and records each unit that comes in or goes out, so stock on hand, reorder needs and the value of your stock are always up to date.
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
Products, Stock movements
Fields
25
Views
grid, cards, dashboard, calendar, form
Updated
2026-11-19
The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
16 fields · 4 sample rows
| ProductText | SKUBarcode | PhotoAttachment | CategorySingle select | SupplierText | Unit costCurrency | Selling priceCurrency | MarginFormula | Opening stockNumber | MovementsLink to another table | Units inRollup | Units outRollup | On handFormula | Reorder pointNumber | Stock statusFormula | Stock valueFormula |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Vitamin C face serum 30 ml | SKN-VC-030 | Skincare | Glow Labs, Mumbai | ₹210 | ₹699 | 70% | 120 | 9 Nov 2026, 11 Nov 2026, 18 Nov 2026 | 3 | 89 | 34 | 40 | Reorder | ₹7,140 | |
| Onion hair oil 200 ml | HAR-ON-200 | Haircare | Ayur Naturals | ₹140 | ₹449 | 69% | 60 | 13 Nov 2026, 14 Nov 2026 | 100 | 72 | 88 | 30 | In stock | ₹12,320 | |
| Sandalwood soap (pack of 3) | BTH-SW-003 | Bath & body | Mysore Soaps Co. | ₹95 | ₹299 | 68% | 200 | 15 Nov 2026 | 0 | 6 | 194 | 50 | In stock | ₹18,430 | |
| Festive gift box | GFT-FS-001 | Gift sets | In-house | ₹620 | ₹1,799 | 66% | 25 | 17 Nov 2026 | 0 | 14 | 11 | 15 | Reorder | ₹6,820 |
9 fields · 7 sample rows
| DateDate | ProductLink to another table | TypeSingle select | QuantityNumber | InFormula | OutFormula | ReferenceText | Recorded byText | NotesLong text |
|---|---|---|---|---|---|---|---|---|
| 9 Nov 2026 | Vitamin C face serum 30 ml | Sale | 48 | 0 | 48 | Nykaa PO 55120 | ||
| 11 Nov 2026 | Vitamin C face serum 30 ml | Sale | 41 | 0 | 41 | Website orders wk 45 | ||
| 13 Nov 2026 | Onion hair oil 200 ml | Stock in | 100 | 100 | 0 | GRN-0981 | Farhan Qureshi | |
| 14 Nov 2026 | Onion hair oil 200 ml | Sale | 72 | 0 | 72 | Amazon FBA shipment | ||
| 15 Nov 2026 | Sandalwood soap (pack of 3) | Damaged | 6 | 0 | 6 | Crushed in transit | ||
| 17 Nov 2026 | Festive gift box | Sale | 14 | 0 | 14 | Corporate order – Infosys | ||
| 18 Nov 2026 | Vitamin C face serum 30 ml | Return | 3 | 3 | 0 | RMA-221 |
Form view “Record a stock movement” asks for: Date, Product, Type, Quantity, Reference, Recorded by, Notes.
SKU is a barcode field, so codes stay consistent across the catalogue and your packing slips. Photo feeds the Catalogue gallery view. Category and Supplier let you filter stock by range or by who you reorder from.
Both prices are in rupees, and Margin shows (selling price minus unit cost) divided by selling price as a percentage. It flags products whose margin has slipped after a cost increase.
Instead of overwriting a stock number, the template starts from an opening count and adds up the movements. Units in and Units out are rollups of the ledger, and On hand is opening stock plus in minus out, so every change can be traced to a dated movement.
Set the level at which you want to reorder each product. Stock status reads Out of stock at zero or below, Reorder at or below the reorder point, and In stock otherwise, which drives the Stock health dashboard.
On hand multiplied by unit cost gives the value of stock held per product, and summed across the table it shows how much money is tied up in inventory.
Type is Stock in, Sale, Return, Damaged or Adjustment. Formulas turn the quantity into units in (stock in and returns) or units out (sales, damaged and adjustments), so the person recording a movement only enters a positive quantity and the right type.
Reference ties a movement to a GRN, purchase order or order batch, and Recorded by shows who logged it, which helps when a count does not match. The form view makes logging quick from a phone in the warehouse.
This product inventory template has two linked tables. Products holds each item with its name, SKU (a barcode field), photo, category, supplier, unit cost and selling price in rupees, a margin formula, the opening stock and a reorder point. Stock movements is a ledger: every stock-in, sale, return, damaged item or adjustment is a row with its date, product, quantity, a reference such as a GRN or order number, who recorded it and notes. Formulas split each movement into units in and units out, the product rolls them up, and On hand is calculated as opening stock plus units in minus units out. A Stock status formula then labels each product In stock, Reorder or Out of stock, and Stock value multiplies on-hand units by unit cost. Views include a product grid, a catalogue gallery, a stock health dashboard, a ledger calendar and a Record a stock movement form.
It fits D2C brands, small retailers, online sellers on marketplaces and wholesalers that keep a few dozen to a few hundred SKUs and track stock in a spreadsheet today. The sample data is a personal care brand with suppliers in Mumbai and Mysuru and references to marketplace purchase orders and website orders, but the same structure works for apparel, electronics accessories, packaged food or stationery. Because stock is calculated from movements rather than typed over, it also suits teams where more than one person receives goods or records sales.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.
Edit the Category options, then replace the sample products with yours: SKU, supplier, unit cost, selling price, today's count as Opening stock and a sensible Reorder point for each.
Delete the sample stock movements, then record every goods receipt, sale, return and write-off as a movement from now on, with a reference such as the GRN, invoice or order number.
Share the Record a stock movement form with the people who receive goods or pack orders so movements are logged as they happen.
Check the Stock health dashboard and filter Products by Stock status = Reorder before you place purchase orders with your suppliers.
Every stock movement — receipt, transfer, write-off or count correction — is signed off by the inventory manager and routed to the warehouse team that has to act on it.
7 steps · 4 rolesEdesy AgentsInventory Management AgentTurns quick messages into structured inventory management entries — dates, numbers and notes — so records stay complete and consistent.
Tracking · 2 actionsEdesy SignPurchase Order with AcceptanceA purchase order that the supplier accepts by signing, confirming items, prices, delivery date and terms in one record.
2 signer roles · 26 fieldsEdesy FormsBulk Wholesale Purchase OrderUse a bulk wholesale purchase order to collect what customers want, how many and when they need it, plus delivery or pickup. Sample products and prices are included for you to replace.
12 questionsOn hand = Opening stock + Units in - Units out. Units in sums stock-in and return movements for the product, and Units out sums sales, damaged items and adjustments, so the figure updates as soon as a movement is recorded.
Record an Adjustment movement for the difference with a note such as the audit date. Adjustments count as units out in this template, so for a count that is higher than expected, record the extra units as Stock in with an audit reference instead.
Yes, with an automation. Use a record-matches-filter trigger on Products where Stock status is Reorder, and have it post to a connected Slack channel, call a webhook, or create a row in another table you use for purchase requests.
Not out of the box: the template tracks one stock pool per product. Add a Location select field to Stock movements and filter or group by it, or keep one copy of the base per warehouse.
Yes. Import a CSV or Excel (.xlsx) file into the Products table and map columns such as name, SKU, cost and price. Put today's counted quantity into Opening stock so On hand starts from the right number.
No. Prices and costs are single rupee amounts without tax fields. If you need tax-inclusive values, add a GST rate percent field and a formula for the price including GST.
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.
Catalogue 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 fields