Items & stock setup

Docs › Setup guides

ERPNext Item & Stock Setup

ERPNext stock setup made simple: item groups, UOMs, the item master, warehouses, valuation, opening stock, reorder levels, batches, serials and barcodes.

5 min read · Updated November 2026 · By Vivek Choudhary

A good ERPNext stock setup makes every later step easier: billing is faster, stock reports are right, and purchase planning works on its own. This guide covers item groups, units, the item master, warehouses, valuation, opening stock, reorder levels, batches, serial numbers and barcodes.

Menu paths follow the current ERPNext manual. They move a little between v15 and v16. If a menu is not where we say, search for the document name in the awesome bar.

Before you start

  • Company and accounts are set up. See the company and accounts guide.
  • A clean item list in a spreadsheet: code, name, group, unit, HSN code, tax rate, and whether it is stocked. Remove duplicates first.
  • A list of physical stores, godowns or shops that hold stock.
  • A physical count of stock on the go-live date, with the value per unit.
  • Which items need batch (expiry) or serial number tracking.
  • Your valuation method choice, agreed with your accountant.

Step 1: Create item groups

Search for Item Group. It is a tree with "All Item Groups" at the top.

  1. Add groups that match how you report: for example Raw Material, Finished Goods, Trading Goods, Services, Consumables.
  2. Keep the tree shallow. Two or three levels are enough for most businesses.
  3. Set defaults on the group (such as HSN code and tax template) so new items inherit them.

Step 2: Check units of measure

Search for UOM. ERPNext ships with common units such as Nos, Kg, Meter and Box.

  1. Add any unit you need that is missing.
  2. Tick Must be Whole Number on units like Nos so nobody enters 2.5 pieces.

Step 3: Create items

Go to Stock › Items and Pricing › Item and click New, or use Data Import for large lists.

FieldWhat to enter
Item CodeA short, unique code. Cannot be changed easily later.
Item NameThe name users and customers see
Item GroupFrom Step 1
Default Unit of MeasureThe base unit for stock (Nos, Kg)
Maintain StockTick for physical goods; untick for services
Valuation MethodFIFO or Moving Average (Step 5)
Has Batch No / Has Serial NoOnly if you track these (Step 8)
UOMs tableOther units with a conversion factor, for example Box = 12 Nos

Add the HSN/SAC code and item tax template as covered in the GST guide. For a large list, import items with Data Import after testing ten rows first.

Step 4: Build the warehouse tree

Go to Stock › Settings › Warehouse and switch to Tree view. ERPNext creates a few warehouses with your company abbreviation, such as Stores and Finished Goods.

  1. Create a group warehouse for each location (tick Is Group), for example "Mumbai".
  2. Under it, add the actual stock points: Main Store, Shop Floor, Rejected, Transit.
  3. With perpetual inventory on, each warehouse is linked to a stock account. Sub-locations can share the parent's account.
  4. Set the Default Warehouse in Stock Settings so new items and transactions pick it up.

Create a warehouse only where you really count stock separately. Too many warehouses mean too many transfers.

Step 5: Choose the valuation method

In Stock Settings, set Default Valuation Method. Each item can override it.

  • FIFO: stock is valued in the order it came in. Common in trading and where prices change often.
  • Moving Average: each receipt updates an average cost. Simple and common in manufacturing.

Decide this before any transaction. Once an item has stock transactions, its valuation method is locked. Confirm the choice with your accountant.

Also review Allow Negative Stock. We suggest keeping it off. From v15, batch and serial items cannot go negative even if it is on.

Step 6: Enter opening stock

Go to Stock › Tools › Stock Reconciliation and click New.

  1. Set Purpose to Opening Stock. The Difference Account becomes Temporary Opening.
  2. Set the posting date and time to your cutover date.
  3. Add rows with Item Code, Warehouse, Qty and Valuation Rate. Add Batch or Serial numbers where the item needs them.
  4. For many items, download the template, fill it in (headers must match exactly), and upload.
  5. Save, check totals against your count sheet, then submit.

Later, for physical count corrections, use the same document with Purpose Stock Reconciliation. The difference then goes to Stock Adjustment.

Step 7: Set reorder levels

  1. In Stock Settings, tick Raise Material Request when the stock reaches re-order level. Optionally tick the email notification setting.
  2. On each item, in the auto re-order section, add a row: Check in (group), Request for (warehouse), Re-order Level, Re-order Qty and Material Request Type (Purchase, Transfer or Manufacture).

ERPNext checks stock on a daily schedule and creates draft Material Requests for items below the level. These feed the buying flow.

Step 8: Batches and serial numbers

  • Tick Has Batch No for items with lots or expiry (food, pharma, chemicals). Tick Automatically Create New Batch to make batches on Purchase Receipt.
  • Tick Has Serial No for items tracked one by one (electronics, machines). Set a serial number series to auto-number them.
  • Set these before the first transaction. They cannot be changed once stock has moved.
  • In v15 and later, batch and serial numbers on transactions are stored in a Serial and Batch Bundle. Older guides that show a plain Batch No field on the row may look different.

Step 9: Barcodes

On the item, add codes in the Barcodes table (EAN or UPC). Then a scanner can add items on Sales Invoice, POS, Delivery Note and Purchase Receipt through the scan barcode field.

Check your work

  • Stock Balance report: quantity and value per item and warehouse should match your count sheet.
  • Stock Ledger: confirm each opening entry posted on the right date.
  • General Ledger or Trial Balance: stock accounts should equal the Stock Balance value, and Temporary Opening should net to zero after all openings.
  • Make a test sale and check that stock drops in the right warehouse.

Common mistakes

  • Duplicate items with slightly different names. Clean the list before import.
  • Ticking Maintain Stock on services, which then ask for a warehouse.
  • Entering opening stock with a Stock Entry (Material Receipt) instead of Stock Reconciliation, which posts to the wrong account.
  • Leaving valuation rate empty or zero on opening stock, so profit reports are wrong.
  • Turning on batch or serial tracking after stock has moved.
  • Allowing negative stock to "save time", which hides missing receipts.

Read more in the Stock module overview.

Sources

Written from the official documentation and source code below. Menus and fields can differ between versions, so check the docs for your version.

Planning ERPNext or a Frappe app for your business? See our ERPNext implementation and Frappe development services, or talk to us.
ERPWork app icon
ERPWork: ERPNext on your phoneFree Android app for your ERPNext site: check in with location, approve documents, see sales and stock dashboards and get notifications.

Get it on Google PlayLearn more →