Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Inventory & store/Import items from a CSV with opening stock/Script

    Recording script: Import items from a CSV with opening stock

    4 shots · about 40 s of finished video · lesson 4 of Inventory & store

    Record as

    Accountant (demo_accountant)

    Sign in at /demo on a demo-mode build

    Screens

    /inventory/items/import /inventory/items

    Length

    40 s

    narration at ~150 words/min + screen time

    Status

    Not yet recorded

    Before recording

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

    Intro voice-over

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

    #ScreenAction (on screen)Must be visibleVoice-over~s
    1/inventory/items/importOpen Inventory → Items and click Import CSV.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.Column headers can be in any order. Items whose name already exists are skipped, so re-running the file is harmless.12
    2/inventory/items/importPrepare the sheet: kind is consumable, store_item or asset; is_sellable is yes/no; opening_qty with opening_rate posts opening stock dated today. Save as CSV.The placeholder in the text box shows a sample row: Chalk box,Stationery,consumable,box,9609,12,10,no,,40,,20,40.Prepare the sheet with the column names shown on the page and save it as CSV.10
    3/inventory/items/importChoose the file (or paste the rows) and click Import items.

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

    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.Choose the file and import. Errors are listed per row so you can fix and retry.10
    4/inventory/itemsOpen Inventory → Items.The new items with SKUs; those with opening quantities show stock and value and an Opening line in their ledger.The imported items appear in the list with their new SKUs.8

    Outro voice-over

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

    After the video is published

    Add its YouTube id under inventory-import-csv in src/lib/help/videos.ts, with a chapters map of step number → seconds. The lesson page then shows the video and a “Watch this step” link on every step. See the video production guide.