Skip to content

Import from Excel

Main → Goods → → Import from Excel

If your inventory already lives in a spreadsheet, don’t retype it. StoDo reads **Excel (.xls, .xlsx) and CSV (*.csv) files and turns rows into catalog items — optionally with their stock quantities — and you map the columns right on a preview of your own file.

  1. In Goods, open → Import from Excel. The app asks what to import — Choose import option:

    • only goods list — item properties without quantities;
    • add quantity to stock — quantities too. These arrive as a real Incoming operation in the store, so imported stock has a paper trail like everything else.
  2. Pick the file. Its File preview opens: your rows as a grid, with the instruction that matters — “Tap a column header to assign a field”. An unassigned header reads Select field; once assigned it shows the field’s name. Rows to skip arrives pre-filled (1 by default), the skipped header row struck through and Rows to import counted — confirm it, or adjust if your file starts differently; for a CSV, pick the separator too. Only Item name is mandatory — the app insists (“Assign a column to the field “Item name”.”) and won’t let one field sit on two columns.

  3. Tap Start import and read the result: items processed / added / updated / ignored / errors — with an error log offered when rows failed. A row updates an existing item when its name and barcode (and group, if you map one) match; otherwise it adds a new item. Rows without a name are ignored.

The File preview: demo goods rows under column headers assigned to Item name and Item barcode, the header row struck through, Rows to skip at 1, and the Start import button

  • The mapping you build is remembered — it’s written into Settings → Excel Import and Export, so the next import of the same layout starts pre-assigned. Leaving the preview without importing keeps your mapping too.
  • The Do not show again switch on the preview turns it off for future imports — they then run the classic flow, with the mapping coming from that same Settings screen. A file the preview can’t read falls back to the classic import by itself.
  • Need a field that doesn’t exist yet? Create your own field… in the field picker closes the preview and opens Item fields — restart the import once the field exists. Custom fields switched off there aren’t offered in the picker.
  • Importing with quantities targets the store you’re working in — in All Stores mode the app asks which store first.
  • Re-importing the same file is safe: matching rows update instead of duplicating. That also makes a spreadsheet a handy way to mass-edit prices or descriptions — export, edit, import back.
  • The Image Link column can pull item images in during the import.
  • Suppliers and customers import the same way from their screens, and the Operations screen can build an operation from a spreadsheet too (except returns) — the preview appears there as well.
  • In StoDo Online, the preview is offered to the owner and admin-profile users; everyone else imports the classic way.

Still need help? Contact us