Skip to main content
To change one price, you don’t need settings. Open Price book in the main sidebar, change the item, and save. Tax rate names and rates are under Tax.

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.
How Jomioz decides whether a row is new or an update:
  • Services match on the service, the category, and the item name. A match is updated. Anything new is created.
  • Materials use a category_path such 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.