Lily, your assistant
Say what's on the shelf, or snap it. Lily writes it up.
Moving off a spreadsheet, or starting from a box of parts? Tell Lily what you have in plain words, like "add the E24 resistors from 1k to 910k", and she drafts the categories, parts and stock in one go.
Or take a photo: of a part, its label or barcode, a tray of parts, or a supplier's packing slip. Got the invoice, packing slip or datasheet as a PDF? Send her that instead. Lily reads what's printed on it, matches it to the parts you already have, and drafts the stock or the order for you to check. She asks when she isn't sure, and neither the photo nor the PDF is kept.
She can also raise purchase and sales orders, adjust stock and answer questions about your inventory. Nothing changes until you've looked over her plan in a table and applied it.
Every plan includes assistant requests. See how many.