Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Inventory & store/Lesson 4

    Import items from a CSV with opening stock

    Load the whole item master from a spreadsheet, creating categories as needed and posting opening stock in one go.

    Open /inventory/items/importRecording script
    5 min4 stepsOwner, Admin, Principal, AccountantDemo: sign in as Accountant

    Before you start

    Finish first: Add categories and items

    • A CSV with a header row; only name is required. Keep the file under 2 MB.

    Steps

    0 of 4 done
    1. You should see: Import items from CSV with a file picker, a CSV text box to paste rows, an Import items button and a Columns panel listing name, category, kind, unit, hsn_code, gst_rate, reorder_level, is_sellable, selling_price, cost_price, barcode, opening_qty, opening_rate.

      Open /inventory/items/import
    2. You should see: The placeholder in the text box shows a sample row: Chalk box,Stationery,consumable,box,9609,12,10,no,,40,,20,40.

    3. You should see: A toast "N items imported" with "M already existed" and a result box: "N created · M skipped (already exist) · E errors", listing "Row 7: …" for any bad rows.

      Fix the listed rows and import the same file again; the good rows are not duplicated.

    4. You should see: The new items with SKUs; those with opening quantities show stock and value and an Opening line in their ledger.

      Open /inventory/items

    What you have now

    • The item master and opening stock loaded in one step, with a row-by-row error report.

    If something goes wrong

    "File too large · Keep it under 2 MB."
    Split the sheet into two files.
    "Import failed"
    The text is not CSV (no header row, or an Excel .xlsx file). Save as CSV UTF-8 and try again.
    Row errors about gst_rate
    Use one of 0, 5, 12, 18, 28.

    Related guides

    • Add categories and items
    • Record opening stock and do a stock-take
    Record opening stock and do a stock-takeNext: Add vendors and check their purchase history