Service Catalog

Example Price Books You Can Use For HVAC

 

Here you can choose brands of your choice to use in thermoGRID. Once you download the files you can update the equipment cost column and supplier name or send them to your supplier to update.

• Starter Service Catalog
• Amana
• Bryant
• Carrier
• Goodman
• Lennox
• Rheem
• Trane

In ThermoGRID - Change Price or Add/ Delete Items

Add Items to the Price Book

How to Add a Single Item to the Catalog - add

• Select the “Administrative” section
• Select “Manage Service Category” located at the bottom left
• Select “ + New Item”
• All required information will appear
• First select the type of unit you’re working with (anything can go under tools and equipment)
• Type the Department
• Type Department Number
• Type a Description of the item (this will appear on the customers invoice, as well as what the sales reps will be looking up)
• Type the Brand
• Type the Product Number (this is the number that supply companies use to look up the item, some use model numbers)
• Type Model Number
• Select Supplier name from the drop-down list
• You can type an expiration date if you’d like this to be a only available for a limited time, but the date is automatically set to 19999, so your item will always remain in your category (if you choose an expiration date, the item will be removed from the reps catalog on designated date, but will remain in the companies catalog, so it can be reactivated at any time)
• Type the Material Cost
• Type the Labor Cost (Techs pay rate multiplied or divided by the Labor hours)
• Type the Labor Hours
• Recommended to select “Yes” to the “Auto Add with Parent”
• Make sure everything on the page is correct (such as all the yes/no questions)
• Save the page

Note: If you want an item to always be a certain price, no matter what the costs are, type the predetermined price in the “Retail override Amt” section under “Prices”. Then make sure you change the “Allot retail override” to “Yes” and the “Calculate retail using gross margins” to “No”.

 

Auto Add With Main Component

Yes  -  Means this item will be brought in to the Order Estimate page when the main component is seletced.

Can Remove From Main Component

 If  yes you can remove it off the Order Estime, if no you will not be able to remove this item no matter what.

Can Add Without Main Component

 If yes then the item will be part of your price book and can add on any job, if no then the item will not appear in the price book when you are looking for items.

Applies to Commision Basis

 If yes Reps with a commision scale will get commission on this item. If no no commission will be calculated in the retail price or giver to a Rep.

Allow Retail Override

 If yes a rep can change the retail of this item anytime and this would act as full price for itrem as commssions are concerned or client invoivce. If no the rep can change selling price at the top of the order estimate page but it will show client received a discount and if it is commissionable it will reflect commission based on the discount given.

Allow Description Override

 If yes a Rep can change the name of this item on the order estimate page to anything, anytime. This is good to have an item like this to cover items not in the pricebook.

Gross Margin Override

"0.650" - What you set this number to be will be the gross margin for this item. If you change the company settings default gross margin it will only change itemss you did not override at this location.

Calculate Retail Using Gross Margin

 If yes it takes into account all cost: equipment, material, labor, fees, commission, tax, etc. to acheive the gross marging set forth. If no then it will populate the amount typed in in the middle of the page "Retail Override Amt"

 

 

Tag Items

 

How to Tag an Item / One Component Tag

• Select the “Administrative” section
• Select “Manage Service Catalog” (located on the bottom left)
• Select the pencil icon next to the item you want to be the Main Component Tag
• Scroll to the bottom of the page, to the left there is a section you will see “Tags and Flags"
• The main component will be the item you will go to select in the price book on the Order Estimate page.
• When you are addding Tags in ThermoGRID from the Service Catalog you do not need the "#" in front of the tag name, you only need this on the export function.
• After adding your tag click save.
• Then go to the item you want tagged to that item as an accessory item and click the pencil icon. (Accessory Item meaning it appears on the Order Estimate automatically because you chose the Main Component.
• Scroll down to the same location of the page where the "Tags and Flags" are.
• Type, paste, or click the tag icon to add in the tag for the Accessory Tag from your pervious item.
• Change “Auto Add with Main Component” to “Yes” (located to the right of the tags section)
• Click Save
• You can use the tag for as many main components as you wans and as many accessory companents as you want, just note that any time you select a main component with a tag example "AC" all accessory components with matching Accessory Component Tag "AC" will be pulled in.

Generic Tag Example:

2 ton ac needs a lineset but you dont want to be specific.

2 Ton AC (Main Component Tag "AC")

3 Ton AC (Main Component Tag "AC")

Lineset (Accessory Component Tag "AC")

Specific Tag Example:

AC needs a  a specific size lineset.

3 Ton AC (Main Component Tag "3/4")

4 Ton AC (Main Component Tag "7/8")

3/4 " Lineset (Accessory Component Tag "3/4")

7/8 " Lineset (Accessory Component Tag "7/8")

This way any time you select the 3 ton AC on the Order Estimate page when pricing options the 3/4" lineset will automatically come in.

* Make sure you do not have one item where the Main Component Tag and the Accessory Component are the same... this will cause a loop and add thousands of items to you order estimate.

Do not do this:

http://nebula.wsimg.com/0db8df49a6c0b1d59bf4f5339b1c3fe5?AccessKeyId=AA19C13E8A4EF537D068&disposition=0&alloworigin=1

This is how it should look:

Air Conditioner

http://nebula.wsimg.com/817962c97af18dfddd1ee50d9a7d0db4?AccessKeyId=AA19C13E8A4EF537D068&disposition=0&alloworigin=1

Thermostat or other accessory:

http://nebula.wsimg.com/3e471a1b4464cc5f7fd55351ee60150e?AccessKeyId=AA19C13E8A4EF537D068&disposition=0&alloworigin=1

 

Now anytime you create a purchase order with your original item you selected (the Accessory Component Tag), your tagged item will appear below it in somewhere your purchase order automatically.

Export to Excel - Change Prices or Add/Delete Items

Add Items to the Price Book

 

How to tag multiple items by exporting it to Excel

• Select “Administration”
• Select “Manage Service Catalog”
• In the right corner of the page locate the Setting Drop-down list, it will be an icon, below your user name and above the “ Next and Last”
• Select “Export Catalog”
• Click open on the pop up and Excel will launch
• Enable editing
• Select the item you want to be working with from the row at the bottom of your sheet
• Widen the “Tag” category
• You will be able to see the items with no tags
• In the Tag category type #(the name of the tag)
• Right click and select “Copy”
• Hold down your curser and drag it down all the categories you want the tag in
• With the categories still selected right click and select “Paste”
• To add multiple tags, type a comma followed by #(name of the tag) you can add as many tags as you’d like
• Save
• Go back to Thermogrid
• Select the Setting Drop-down list
• Select “Import Catalog”
• Search and select document
• Validate
• Import File

Tag Items

 

How to tag multiple items by exporting it to Excel

• Select “Administration”
• Select “Manage Service Catalog”
• In the right corner of the page locate the Setting Drop-down list, it will be an icon, below your user name and above the “ Next and Last”
• Select “Export Catalog”
• Click open on the pop up and Excel will launch
• Enable editing
• Select the item you want to be working with from the row at the bottom of your sheet
• Widen the “Tag” category
• You will be able to see the items with no tags
• In the Tag category type #(the name of the tag)
• Right click and select “Copy”
• Hold down your curser and drag it down all the categories you want the tag in
• With the categories still selected right click and select “Paste”
• To add multiple tags, type a comma followed by #(name of the tag) you can add as many tags as you’d like
• Save
• Go back to Thermogrid
• Select the Setting Drop-down list
• Select “Import Catalog”
• Search and select document
• Validate
• Import File