Excel Import and Export
Main → Settings → Excel Import and Export
One mapping serves both directions: the columns you assign here are where imports read each field from — and where exports write it.
File format
Section titled “File format”| Setting | What it does |
|---|---|
| Choose file format | **Excel (.xls, .xlsx) or CSV (*.csv) — the format both import and export use. |
| Values separator | CSV only: the delimiter between values. |
| Skip first n row (headers) of Excel file during import | Excel only: how many header rows an imported file starts with. |
Excel file columns
Section titled “Excel file columns”Each row pairs a StoDo field with a spreadsheet column; Do not use leaves a field out. Only Item name is mandatory. In order:
Item name · SKU · Item barcode · Quantity · Group · Group path · Description · Unit of Measure · Store · Image with Exported image size (pixels) · Image Link · Purchase price / Selling price (when prices are on) · Expected quantity (stock-taking) · Minimum quantity · Tags — followed by a row per custom field.
The Image and Image Link rows appear for the Excel format only, and the price rows follow your Prices settings.
Additional Images
Section titled “Additional Images”Excel only, folded behind Show: columns for an item’s extra photos beyond the first.
Good to know
Section titled “Good to know”- The import doesn’t force this screen on you: picking a file can open an interactive preview where you assign columns by tapping the sheet’s headers — the import guide covers it.
- In StoDo Online, these settings are shared with the database and editable by the owner or an admin-profile user.
Still need help? Contact us