Resources & guides Getting started
Import your materials and products from a spreadsheet
Bring what you already track in Excel, Google Sheets or Numbers into Batcher in a couple of minutes, and see every change before it's saved.
Where to find it
Go to Inventory. Tap Import or update from a spreadsheet at the bottom of the list. If a tab is still empty, use the Import from a spreadsheet button there instead.
Step by step
- Choose a file. Batcher reads Excel files (.xlsx) and CSV files, up to 2,000 rows at a time.
- Older Excel file (.xls)? Open it in Excel and choose Save As → Excel Workbook (.xlsx), or save it as CSV.
- Numbers? Choose File → Export To → Excel, then upload that file.
- Google Sheets? Choose File → Download → Microsoft Excel (.xlsx).
- Match your columns. Batcher guesses which column is which, and skips any title rows above your column names. Tap a field to change its column, or choose Not in my sheet.
- If your file has more than one sheet, choose the one to import.
- If you have no Type column, tell Batcher what the rows are: Materials, Products or Parts you make.
- Check the preview. Every row is sorted into one of four groups:
- New: things Batcher doesn't have yet.
- Updates: what changes, shown as old value → new value.
- No change: already up to date.
- Can't import: the row number and what needs fixing.
- Import. Everything is saved together. Rows that can't be imported are skipped, so fix them in your file and import it again. Rows you've already imported will simply match, so nothing gets doubled.
Columns Batcher understands
Only Name is required. Everything else is optional, and your column names don't need to match exactly. For example, "Qty on hand", "Stock" and "In stock" all work.
| Field | What to put in it | Also recognised as |
|---|---|---|
| Name | The material or product name | Item, Material, Product, Description |
| Type | Material, Part or Product | Kind, Item type |
| SKU / code | Your own code for it | Code, Item code, Part number |
| Unit | How you count it: yd, m, g, kg, oz, lb, ml, cups, sheets, reams, board feet, troy oz, sides, hides, spools, units… | UOM, Unit of measure |
| On hand | How many you have right now | Qty, Quantity, Stock, In stock |
| Reorder point | Warn me when stock drops below this | Min, Minimum, Reorder level, Par |
| Cost per unit | What you pay per unit | Cost, Unit cost, Cost each, Purchase price |
| Selling price | What you sell it for | Price, Sale price, Retail price |
| Time to make | Minutes or hours to make one | Labor minutes, Labour hours, Make time |
| Supplier | Where you buy it | Vendor, Source |
Numbers can include currency signs and commas: "$1,234.50" works. Units can be written out or shortened, singular or plural: "yards", "yd" and "yard" all work.
How updates work
- Matching: a row updates something already in Batcher if it has the same SKU. If there's no SKU, it matches on the same name (capital letters don't matter).
- Blank cells change nothing. Leave a cell empty to keep what's already in Batcher.
- Units and types stay put. Changing an existing item's unit or type would upset your recipes and stock, so Batcher keeps them and flags the row.
- Stock counts are saved as adjustments. If your sheet says you have 12 and Batcher says 9, Batcher records a +3 adjustment, so the item's history still adds up.
- New suppliers are added for you.
Good to know
- Bags, bottles, jars, packs and boxes are counted as units. The preview flags these so you can check.
- A cost on a product is saved as its bought-in cost: what you paid for it if you buy it ready-made, like a sourced vintage piece. Batcher adds it to whatever the product's recipe costs. For things you make from scratch, leave it blank and the recipe works out the cost.
- Recipes (which materials go into each product) aren't imported yet. Build them in Recipes after your materials are in.
Starting from scratch?
Download the import template: a spreadsheet with the columns ready to fill in. It's also on the import screen.
Common fixes
| Message | What to do |
|---|---|
| "…isn't a number" | Remove words from number cells, e.g. change "12 yd" to "12" and put "yd" in the Unit column. |
| "Unit … isn't one Batcher knows" | Use a unit from the table above, or leave it blank to count in units. |
| "Same item as row …" | The same SKU or name appears twice. Delete or merge the duplicate. |
| "Type … isn't one we know" | Use Material, Part or Product. |
| "No name" | Every row needs a name. |