Product Inventory Template

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

Inventory

Tables

Products, Stock movements

Fields

25

Views

grid, cards, dashboard, calendar, form

Updated

2026-11-19

Tables, columns and sample rows

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.

Products

16 fields · 4 sample rows

  • Products (Grid)
  • Catalogue (Cards)
  • Stock health (Dashboard)
ProductTextSKUBarcodePhotoAttachmentCategorySingle selectSupplierTextUnit costCurrencySelling priceCurrencyMarginFormulaOpening stockNumberMovementsLink to another tableUnits inRollupUnits outRollupOn handFormulaReorder pointNumberStock statusFormulaStock valueFormula
Vitamin C face serum 30 mlSKN-VC-030SkincareGlow Labs, Mumbai₹210₹69970%1209 Nov 2026, 11 Nov 2026, 18 Nov 20263893440Reorder₹7,140
Onion hair oil 200 mlHAR-ON-200HaircareAyur Naturals₹140₹44969%6013 Nov 2026, 14 Nov 2026100728830In stock₹12,320
Sandalwood soap (pack of 3)BTH-SW-003Bath & bodyMysore Soaps Co.₹95₹29968%20015 Nov 20260619450In stock₹18,430
Festive gift boxGFT-FS-001Gift setsIn-house₹620₹1,79966%2517 Nov 20260141115Reorder₹6,820
Field details
Product · Text
SKU · Barcode
Photo · Attachment
Category · Single select
Skincare, Haircare, Bath & body, Gift sets
Supplier · Text
Unit cost · Currency
INR
Selling price · Currency
INR
Margin · Formula
IF({Selling price} > 0, ({Selling price} - {Unit cost}) / {Selling price}, BLANK())
Opening stock · Number
Movements · Link to another table
Links to Stock movements
Units in · Rollup
sum of In via Movements
Units out · Rollup
sum of Out via Movements
On hand · Formula
{Opening stock} + {Units in} - {Units out}
Reorder point · Number
Stock status · Formula
IF({On hand} <= 0, 'Out of stock', IF({On hand} <= {Reorder point}, 'Reorder', 'In stock'))
Stock value · Formula
{On hand} * {Unit cost}

Stock movements

9 fields · 7 sample rows

  • Ledger (Grid)
  • Calendar (Calendar)
  • Record movement (Form)
DateDateProductLink to another tableTypeSingle selectQuantityNumberInFormulaOutFormulaReferenceTextRecorded byTextNotesLong text
9 Nov 2026Vitamin C face serum 30 mlSale48048Nykaa PO 55120
11 Nov 2026Vitamin C face serum 30 mlSale41041Website orders wk 45
13 Nov 2026Onion hair oil 200 mlStock in1001000GRN-0981Farhan Qureshi
14 Nov 2026Onion hair oil 200 mlSale72072Amazon FBA shipment
15 Nov 2026Sandalwood soap (pack of 3)Damaged606Crushed in transit
17 Nov 2026Festive gift boxSale14014Corporate order – Infosys
18 Nov 2026Vitamin C face serum 30 mlReturn330RMA-221
Field details
Date · Date
Product · Link to another table
Links to Products
Type · Single select
Stock in, Sale, Return, Damaged, Adjustment
Quantity · Number
In · Formula
IF(OR({Type} = 'Stock in', {Type} = 'Return'), {Quantity}, 0)
Out · Formula
IF(OR({Type} = 'Sale', {Type} = 'Damaged', {Type} = 'Adjustment'), {Quantity}, 0)
Reference · Text
Recorded by · Text
Notes · Long text

Form view “Record a stock movement” asks for: Date, Product, Type, Quantity, Reference, Recorded by, Notes.

Why each part of the base is there

Product details: SKU, Photo, Category and Supplier

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.

Unit cost, Selling price and Margin

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.

Opening stock, Units in, Units out and On hand

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.

Reorder point and Stock status

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.

Stock value

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.

Stock movements ledger: Type, Quantity, In and Out

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, Recorded by and the movement form

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.

About the Product Inventory Template template

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.

Who it is for

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.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    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.

  3. 3

    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.

  4. 4

    Share the Record a stock movement form with the people who receive goods or pack orders so movements are logged as they happen.

  5. 5

    Check the Stock health dashboard and filter Products by Stock status = Reorder before you place purchase orders with your suppliers.

Connected templates in other Edesy apps

Product Inventory Template: frequently asked questions

On 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.

About the app

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.

Related templates