Batcher

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

  1. 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).
  2. 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.
  3. 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.
  4. 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.

FieldWhat to put in itAlso recognised as
NameThe material or product nameItem, Material, Product, Description
TypeMaterial, Part or ProductKind, Item type
SKU / codeYour own code for itCode, Item code, Part number
UnitHow 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 handHow many you have right nowQty, Quantity, Stock, In stock
Reorder pointWarn me when stock drops below thisMin, Minimum, Reorder level, Par
Cost per unitWhat you pay per unitCost, Unit cost, Cost each, Purchase price
Selling priceWhat you sell it forPrice, Sale price, Retail price
Time to makeMinutes or hours to make oneLabor minutes, Labour hours, Make time
SupplierWhere you buy itVendor, 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

Good to know

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

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