Docs › Basics

Import items from a CSV

No Jobber account, or bringing prices from a spreadsheet? Use Import CSV on the Catalog tab. Pick the pricebook the price column should fill, then upload a file or paste rows.

Column format

The first row must be a header. Recognized columns:

ColumnMeaning
nameRequired — the item name.
skuOptional. Used to match and update existing items; falls back to name matching.
categoryOptional. Created automatically if it doesn't exist.
unitOptional. Defaults to each.
costOptional number. Defaults to 0.
priceOptional number. Sets the price for the selected pricebook.

Extra columns are ignored, and rows without a name are skipped.

Safe to re-run

A catalog snapshot is taken automatically before every import, so you can roll back from the History tab if something looks wrong. Re-importing the same file updates matched items in place instead of duplicating them.

Ready to put your price book to work?
Bulk pricing, markup schedules, Jobber sync, and QuickBooks export — free for 14 days.
Start your free trial

More guides

Getting started with Pricebookr

Set up your catalog, pricebooks, and markups in your first 15 minutes.

Connect your Jobber account

Link Jobber so you can import your catalog and push prices back.

Import your catalog from Jobber

Pull every Jobber product and service into Pricebookr in one click.