Use this guide if your import page looks like this. If your page looks different, please follow this guide.
How to get Started?
Head into your price book by clicking the 'Price Book' tab within your Dashboard navigation menu on the top left hand side of your Dashboard
Once you are in your Price Book, click into the settings gear in the top right hand corner
Click into 'Import price book materials' to get access to the import function
4. Download the Price Book Material Template and fill it out with your specific parts or materials
5. Once you have your .csv filled out, click on the upload button within the 'Price book file' section to upload. You will receive an email from Housecall Pro when your upload is completed and ready to view in your Price Book Materials section.
Note: If there is any incorrect formatting we will email you with a copy of your .csv and any rows we were not able to format. For additional assistance formatting please email datahelp@housecallpro.com.
Break down of the material import fields:
Field | Required | Description |
Category | True | This is the top level category that a material or your material sub-categories live underneath. This is required. |
Subcategory_x | False | The levels of categories a material lives within your top level category. This allows you to nest and create further categorization. |
Name | True | This is the name of your material or part. |
Description | False | Description of the material or part. |
Price | False | The amount that would be charged to the customer. Use the standard format of $0.00. |
Cost | False | The amount that this material or part costs your company. This will be used to calculate price if this is a material mark up enabled part. Use the standard format of $0.00. |
Taxable | False (defaults to false) | Whether tax should apply to this service when added to a job. |
unit_of_measure | False (defaults to each) | The unit of measure for a single unit of this item. (ex. each, square foot, gallon) |
Material mark up enabled | False (only applicable if you have enabled flat rate pricing) | This will automatically calculate price for your materials imported when true. We will calculate your cost field* material mark up tier. |