Products & Services List Updated May 18, 2022 14:27

Overview

The products and services list in your settings is where you can add default products and services so that the details like the name, description, and unit price are already entered for you when adding line items to quotes, jobs, or invoices. If you're on the Grow Plan, this is where you can add an image and markup to your saved products and services too. 

To view your products and services list, click the Gear Icon > Settings > Products & Services.

Create and update products and services

Your default products and services are managed from the Gear Icon > Settings > Products & Services. This is where new products and services can be added, updated, or deleted.

To add a new product or service, click the + Add Service or + Add Product button.

Then enter:

• Item type dropdown: Select if this is a product or service. If you accidentally select the wrong item type originally, it can be switched. 
• Name: The name of the product or service. 
• Description: A description of the product or service. 
• Unit cost ($): The expenses you incur to provide a product or service. This option is available on the Grow Plan. 
• Markup: The percentage added to the unit cost to calculate the unit price. This option is available on the Grow Plan. 
• Unit price ($): The amount you charge customers for a  product or service.
• Photo: An image of the product or service. This option is available on the Grow Plan. 
  • Note: Line item images are only available on quotes and do not appear on PDFs. 
• Checkboxes: Check the box for "exempt from tax" if tax is not charged on this item.
  • Note: When editing a product or service after it has been created, there is another checkbox for "available on quotes, jobs, and invoices". When this is deselected, this item is considered "inactive" and isn't available on quotes, jobs, or invoices. 

To update or delete an item once it is created, click on the item in the list to open the item details. From the pop-up, make your changes and click Update to save those changes. To delete the item, click Delete in the bottom left corner. Updating or deleting an item does not change this line item on any quotes, jobs, or invoices where it already has been added.

Note: If you are syncing with QuickBooks Online, the item will need to be edited in QuickBooks as this program is dominant for products and services.

Add to products & services from a quote, job, or invoice

You can also add a product or service to your list when working on a quote, job, or invoice, by typing in a new item name that is not yet in your saved list. The system will then prompt you to Add to Products & Services which saves this item to your products and services list in Settings so that it can be used again in the future. 

To keep the new item a custom item that isn't saved in your list, continue to enter in the name, description, quantity, and cost, without clicking Add to Products & Services. This will keep it as a custom line item since it will only appear on the quote, job, or invoice where you have entered it. Custom line items are good fits for things that are unique to this client only, such as special pricing, images of their property, or discounts. 

Importing and updating products and services

To import your products & services list, click on the Gear icon > Settings > Products & Services. Navigate to the Import Products & Services section. This is where you can upload your .csv file of products and services to import them into Jobber. Your .csv file will need to be in a specific format with the headings matching the files in Jobber, we have two sample files that can be used to format your spreadsheet:

• If you are on the Grow Plan, this sample file can be used to upload your products and services list including unit prices and unit costs. Markup will be calculated automatically based on the unit price and unit cost, so if you want to increase your prices and pass the costs to your clients, both the unit cost and unit price will need to be updated to maintain margins as costs are increasing. 
• If you are on any of the other plans, this sample file can be used to upload your products and services list.

To format your .csv file, keep the headings in the sample file the same, but add your own products and services under the headings. 

The headings you'll need in your .csv file are:

• Name (title of the product or service)
• Description
• Unit Price
• Taxable (this will be either TRUE or FALSE – TRUE for if that item is taxable, and FALSE if it is not a taxable item)
• Category (this will be either Service or Product)

If you need to update your products and services en masse (for example, if you were to raise your prices across the board), rather than editing each item individually you can use the import tool to update your products and services by updating those fields on your .csv spreadsheet and then re-importing it into Jobber. 

The fields that can be updated by re-importing the .csv spreadsheet are:

• unit price
• unit cost (available as on option on the Grow Plan)
• description
• taxable status
• item type

Select your .csv file, then check the box to Update existing items. Then click Import data. 

If your spreadsheet contains the same products and services that already exist in your list, then you will see a checkbox for Update existing items. Checking this box will update and overwrite products and services that have previously been added in Jobber with the unit cost, unit price, description, taxable status and/or category that has been updated in the .csv spreadsheet you've selected to upload. If there is no change to that product or service in your .csv spreadsheet, then that item will stay the same when re-imported into Jobber. 

Note: If you are syncing with QuickBooks US, you won't be able to update your products and services list with an import since those updates need to happen in QuickBooks to keep everything in sync. If you are syncing with QuickBooks Global, products and services can be updated through an import, but you'll see a warning that data will be overwritten from the next sync with QuickBooks. For both QuickBooks US and QuickBooks Global, a best practice is to update your products and services in QuickBooks and then run a sync to bring those updates into Jobber. 

If you're on the Grow Plan and want to update your markup, it will be recalculated during the import when a new unit cost or unit price is updated through the import–there is no markup column in the sample file. If new costs are added without updating the unit price, the price will remain the same and the markup will be adjusted. 

Exporting products and services

To export your Products & Services list, click on the Gear icon > Settings > Products & Services. You'll find the export box near the bottom of the page:

When you click Export to CSV, you will get an email shortly that contains a .csv file with your products and services list. If you have over 1500 items, you will receive multiple emails with your products and services list split so that each .csv file contains 1500 items or less. 

If you have less than 50 products or services, the file will download automatically rather than being sent by email. 

Important things to note

There is a limit for importing 5000 items at one time, so if you have a large list, you will have to split it into multiple .csv files.

In the Unit Cost and Unit Price columns, make sure to only have a numeric value, as a $ symbol will cause an issue with the import.

Use the Category column to specify if this is a Product or a Service. If this field is left blank it will default as a Product.

The Taxable column is a true or false value. If this field is left blank, then the system will default to assume that this item is taxable.