Price book import and export
Open Settings → Price book import & export to add or change many items at once, for example when you move over from another system or put all your prices up for the new year. The page has two tabs, Services and Materials. Each tab has an import and an export.Import
1
Get the template
Open the tab for what you are importing and click Download this template. It has the right columns. The page lists the Required columns and the Optional ones.
2
Fill it in and upload it
Fill in the file, then click Choose a file or drag it here. You can use a CSV or an Excel file (
.csv, .xlsx, or .xls). Only the first sheet is read, and the limit is 10,000 rows.3
Check the review
Review before importing tells you how many items will be created, updated, and skipped before anything is saved. Rows with no price are counted, and they import at 0.
4
Import
Click Import. When it finishes you see Created, updated, and skipped counts. Any rows with problems are listed with the row number and the reason, so you can fix them and import again.
- Services match on the service, the category, and the item name. A match is updated. Anything new is created.
- Materials use a
category_pathsuch as “Parent > Subfolder”. Folders that do not exist yet are created.
Export
Export services downloads a CSV of every service line item with its current price. Export materials downloads a CSV of every material with its folder path. Edit the file and import it back to change prices in bulk.Fields, checklists, equipment, and tags
Each of these has its own page:- Fields: extra questions on jobs, customers, and estimates, plus job types and business units.
- Checklists: templates of steps your team completes, which can block finishing a visit.
- Equipment types: the equipment register, how often each type needs a visit, and the units on a customer.
- Tags: labels for records, and skill tags for crews.
