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
Load the whole item master from a spreadsheet, creating categories as needed and posting opening stock in one go.
| # | Screen | Action (on screen) | Must be visible | Voice-over | ~s |
|---|---|---|---|---|---|
| 1 | /inventory/items/import | Open 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/import | Prepare 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/import | Choose 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/items | Open 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 |
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.