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.

1. Tell the app which column is which — once. Settings → Excel Import and Export maps every field to a spreadsheet column: Item name (the only required one), SKU, Item barcode, Quantity, Group or Group path, Description, Unit of Measure, Purchase price, Selling price, Minimum quantity, Tags, Image Link, and your custom fields. The same screen sets the file format (Excel or CSV), the CSV separator, and how many header rows to skip.

2. 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.

3. Confirm or adjust the column mapping when the app offers (“Do you wish to set Excel columns?”), then pick the file.

4. 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.

Good to know

• 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).