Skip to content
Nabeeh Nabeeh Help Center Open the app

Import inventory items

Add your account's inventory items from an Excel file with their initial stock, or update existing items from the exported file: name, description, status, SKU, unit, default vendor and prices.

Use this import to add many items to Inventory at once, each with the stock it starts with, or to update your existing items from the exported file. It covers your account's own inventory items only; a service provider's stock is managed from Stock Transfers.

The import is available while the inventory module is on for your account (Enable Inventory Module in Account settings). When it is turned off, the Inventory Items list, its Import and Export buttons and the Center's Inventory Items row are hidden, and an import that has not finished stops without writing anything more.

Where to start

  • In Inventory, open Inventory Items and select Import next to the page title, or
  • open the Import & Export Center and select Import on the Inventory Items row.

Import shows for anyone with the Import Inventory Items permission; the account admin always has it, and gives it to other roles under Users › Roles. Updating existing items also needs Update Inventory Items. The import then follows the steps in Import your data.

Fill in the template

Select Download template. The Inventory Items sheet has one row per item, with the Add Item form's fields:

Column What to enter
Name (Arabic), Name (English) and Name (Urdu) At least one name. On a new row, a language left empty first shows the name entered in another one, then is translated automatically shortly after the import. Two items may share a name, as on the form.
Description (three languages) Optional. Written in one language, it is translated automatically into the languages left empty.
Status Active or Inactive, as on the inventory items list; left empty on a new row, the item is active.
SKU Optional, up to 100 characters, and never shared by two items of your account's inventory.
Unit Optional. Choose it from the list (Pieces, Kilograms, Meters, Liters, Box, Set); any other word is a row error — we never guess a unit for you.
Default vendor Optional. Choose it from the list, which holds your account's active vendors only. The import never creates a vendor: a name that is not one of your vendors is a row error. When two vendors share a name, the template's list leaves that name out, and a row that has it is excluded until you pick one of them in the review — we never pick for you. To add many vendors first, see Import vendors and vendor categories.
Initial stock quantity New items only: a number of zero or more with up to 2 decimals.
Minimum Stock Level Optional. When filled, it replaces the general low stock threshold for this item.
Unit Price and Cost Price Optional. A number of zero or more with up to 2 decimals and no currency symbol.

Your account keeps one stock balance per item and prices are plain numbers, so the template has no warehouse column and no currency column.

Initial stock

  • A new row with a quantity above zero adds the item, then records the quantity in its transactions as Stock In with the note Initial stock, exactly like adding it from the form. The item and its transaction are saved together or not at all, and the transaction is never recorded twice, even when the import is retried.
  • Zero or an empty cell adds the item without stock.
  • A negative number, text, or more than 2 decimals is a row error.
  • On an update row the import never changes the quantity: a quantity there shows a warning and the rest of the row still updates. To change the stock, use Add Stock or Adjust Stock on the inventory items list.

New, updated or unchanged

  • A row with the Inventory item ID (from the exported file) updates that item; every row without an ID adds a new item.
  • When a new row has the SKU of an existing item, the review offers Switch to update to anyone who can update items, so the row updates that item instead of adding a duplicate. When two rows of the file share a SKU, the second one is excluded.
  • A SKU is checked against the SKUs saved before the import: when a row changes an item's SKU, a later row of the same file cannot take the old SKU, and two items cannot swap SKUs in one file. Change the SKU and import first, then use the old SKU in a second file.
  • On an update row, an empty cell keeps the current value and [CLEAR] empties an optional field: the description, SKU, unit, default vendor, minimum stock level and prices. A name cannot be cleared.
  • A row that changes nothing shows as No change.
  • The ID of an item in a service provider's stock is refused: those items are neither imported nor exported here.
  • The warning "This inventory item was changed in Nabeeh after the export" can also show on an update row whose item's stock moved after the export (Add Stock or Adjust Stock, materials used on a maintenance request, or a transfer), because every movement updates the item itself. The import never changes the quantity, so when nobody edited the item's details after the export, the file replaces no change.

Edit all your items in Excel

On Inventory Items, select Export to get your account's inventory items — the ones shown in the list, or all of them — in the same columns, starting with Inventory item ID (do not edit), and with Current quantity (reference only) and Created At at the end for reference: editing them changes nothing. Edit the file, then import it to update the items; a file you did not change reads back as No change. Service providers' stock is not in the file. See Export your data.

What's next