Skip to main content

Product Fields in SI Catalog

A description of all the product-related fields in SI

A
Written by Ashok P
Updated this week

A Product is a piece of equipment you will add to projects, tasks, service orders, and purchase orders.

SI has three types of products: Equipment, Speakers, and Wire. This is determined by the category type set for the Category in the Categories setting in the Control Panel.

The New Product or Edit Product form in the SI catalog has the following tabs.

General

general tab.jpg

The following are the fields in the General tab.

Field

Description

Manufacturer

The dropdown menu lists all the manufacturers in your catalog. Click the New link to create a new manufacturer.

This is a required field.

Model

This displays the model number of the product.

This is a required field.

Category

The dropdown menu lists all the categories in your catalog. Click the New link to create a new category.

This is a required field.

Phase

Here, you can set a phase for a product. Phases track the general "time" when a product will be needed or used in a project.

Examples are Pre-Wire, Trim, Finish, etc. This is an extremely powerful filter for determining what products should be ordered or installed at a particular time in the project's progress.

Part Number

Here, you can enter something other than the model number to identify a product.

URL

Here, you can set the link to a webpage for the product.

Accounting Item Name

This field will display the QuickBooks item number when using our QuickBooks integration.

You can also manually enter an "accounting ID" from your own accounting software.

System

Here, you can assign a system to the product. When adding the product to a project, if the assigned system does not exist in the project, the system will be added to the project.

System selections in the Drop Zone within a project will override this setting.

Status

Here, you can mark a product as Discontinued or Approved.

Discontinued can be used to keep a product in your catalog, but not have it display on forms by default.

Approved data automatically synchronizes to your SI Server for use by all users; unchecking this setting keeps your data changes local to your machine.

Bulk Item

Here, you can designate a product as a "bulk item."

Bulk items will maintain their quantities when a project is converted from a Quantity-Based Project to a Unit-Based Project.

Show in Product Details Report

Here, you can choose whether to display this item in the Product Details report.

You will likely only want to check "primary" equipment, e.g., check this for Amplifiers or Projectors, but don't check this box for wire and cable or brackets.

Include in Service Plan

When this box is checked, you will be prompted to add the product as a project item when creating a service plan.

Within a project, this option will be on the Service Plans tab.

Include in Submittals

When this box is checked, the product will be included, by default, on any Submittal report you generate.

Publish to Mobile Install

When this box is checked, the product will be included in the list of products and labor items you can publish to Mobile Install for use with Site Items.

Image

Here, you can add an image to a product. You can use the Add, Paste, and Clear functions or drag and drop images directly into the field.

Description

description.jpg

Field

Description

Short Description

Here, you can enter a brief description of a product for use on Internal vs. Client reports.

The maximum allowed is 255 characters.

Long Description

Here, you can enter a longer description for a product.

The maximum allowed is 2000 characters.

Tags

Here, you can add tags to help identify products while searching.

You can change the setting on whether or not to use the Long Description field on Client Reports via Report Settings in the Control Panel.

For the Description fields, you have the following options.

check spelling and snippets.jpg
  • You can insert Snippets.

  • You can also use the spell-check feature to fix spelling errors.

spelling.jpg
  • You can change the case of whatever you have selected in the Long Description field. Your options are Upper, Lower, Title, and Sentence.

update case.jpg

Price

Here, you can use the Standard or Calculated option to set your cost and price.

price tab labor types.png

The following are the fields in the Price section.

Field

Description

MSRP

Here, you can enter the "manufacturer suggested retail price." This does not add any value to the product.

Use this as a reference point for setting your unit cost and unit price. The MSRP field is commonly used in Price Rules.

Owner Furnished Equipment

Checking this option will zero out the unit cost and unit price for a product for all Price Types.

If charging for labor using labor types and labor hours, the labor will still be charged for the product.

Price Type

There are 50 Price Types available. The screenshot above shows three Price Types: Retail, Builder, and Custom.

Many users just set one unit cost and unit price per product.

The following fields are available for each Price Type.

Field

Description

Partner Set Cost

This field will display a checkmark if you are connected to a vendor partner and the unit cost was set via an update.

Unit Cost

How much does the product cost you?

Unit Cost (With Tax)

This displays the unit cost with tax if a Use tax is set for the product.

Unit Price

How much do you sell the product for?

Margin

Margin =(1 - (Unit Cost / Unit Price)) x 100.

This field calculates automatically based on the unit cost and unit price.

Markup

Markup = (Unit Price - Unit Cost) / Unit Cost * 100%.

This field calculates automatically based on the unit cost and unit price.

settings section.png

You also have the following options.

  • Price Settings - Here, you can choose the behavior of other price fields when you change the Unit Cost field.

  • Price Rules - Clicking this link allows you to use Price Rules to set the pricing fields for your product.

  • Manage Product Price Types - Clicking this will allow you to manage your 12 available Price Types.

uom for partner cost.png
  • UOM for Partner Cost - Default = Use Partner UOM. If a product has a unit of measure (UOM) from a Vendor Partner, the unit cost of the product will be divided by the UOM when you update pricing from the vendor partner. If, for any reason, you prefer to manually set your UOM Units in SI vs. relying on the vendor partner data, choose the "Use SI UOM" option. Lastly, if you do not want the unit cost from a vendor partner to be divided by UOM, choose "Ignore UOM".

The UOM field is stored on the Order tab and is used when products are added to purchase orders.

estimated install price column.png

Estimated Installation Price

Clicking the View link in this column will show you the estimated installation price for the chosen Price Type for the product.

This view includes all product pricing, labor, taxes, and price adjustments, if applicable.

estimated installation price.png

Labor Types Section

This section of the Price tab allows you to add multiple labor types to a product and set a value for labor hours for each labor type.

labor types section of price tab.png

Here, you can assign multiple labor types to a product. Labor types determine what labor rate should be applied to the product multiplied by the labor hours you set.

Tax Section

This section of the Price tab will vary based on your Tax Settings.

Taxable

This checkbox determines whether a product is taxable and displays when taxes are the same for all taxable products and labor.

taxable option.png

Tax and Labor Tax

These fields will display when taxes are set specifically for each product and labor.

tax each item separately.png

Use Tax

This allows you to apply tax to the unit cost of a product. This field only displays if you have enabled Use tax in your Tax Settings.

use tax.png

Order

This tab allows you to associate multiple vendors with a product. Vendors are used on purchase orders.

You can set one vendor as "Preferred"; if only one vendor is added to a product, it will default to "Preferred."

Fields that Apply to All Vendors

The following are the fields that apply to all vendors.

Field

Description

Do Not Order

This option will filter out the products when creating purchase orders.

Vendors

Here, you can add the vendors who supply this product.

Click Add to add the vendor and select the vendor name from the Vendor field on the right.

Order this product in a different unit than you sell

This option allows you to identify products in your catalog bought in different units than those sold.

This is useful for creating purchase orders, ensuring accurate quantities are calculated. Examples are speakers that you buy in pairs but sell as singles.

This method is recommended in SI if you utilize Visio or AutoCAD's drawing functionality.

This way, you will get a unique shape (and Component ID) for each speaker. Also, bulk wire is another example that we recommend you sell by the foot, but you buy the wire on spools of some length.

Order UOM

Here, you can enter your Unit of Measure for the product.

Number of units in Order UOM

Here, you can enter the number of units in your Unit of Measure.

Vendor-Specific Fields

Each Vendor that you add to a Product will have the following fields.

Field

Description

Vendor

This is the name of the vendor.

Preferred

One vendor must be marked as "Preferred" and is your default vendor.

If this vendor is a vendor partner that you receive pricing updates from, your unit cost for the product will be set based on your Unit of Measure set for the product and your setting for the UOM for the Partner Cost field.

Purchase Cost

This field is where you can enter the purchase cost for a product if it varies from your unit cost.

When populated, this value will be used for the unit price when products are added to a purchase order, overriding the unit cost of the product. This can be for bulk wire to avoid rounding issues, or it can be used if you purchase a product in a different currency than your default currency.

If you are getting your pricing from vendor partners, this field will automatically be set for you for bulk items with the unit cost not divided by the unit of measure (if set). Also, if additional vendors (not "Preferred") are vendor partners, this field will be populated for those vendors.

Partner Set Purchase Cost

This field will automatically be set if the purchase cost was provided by a vendor partner.

Partner Updated On

The time the cost was last updated by the vendor.

Partner Checked On

The time the cost was last checked by the vendor.

Purchase Currency

If you purchase a product in a currency different from your default currency, designate the currency here.

Inactive

This field indicates whether a Vendor has been marked as "Inactive."

Specifications

The fields in this tab depend on the Category Type of the product.

Equipment

The following example is of an Equipment-type product.

specifications v19.png

The following are the fields in the Specifications tab for Equipment.

Field

Description

Height

Here, you enter the height of the product. Enter the height in inches, millimeters, or centimeters.

Width

Here, you enter the width of the product. Enter the width in inches, millimeters, or centimeters.

Depth

Here, you enter the depth of the product. Enter the depth in inches, millimeters, or centimeters.

Weight

Here, you enter the weight of the product. Enter the weight in pounds, kilograms, or ounces.

Rack Mounted

Checking this box changes the look of the elevation shape or block for the product.

Rack Units

This must be filled in for racks in your catalog to use the SI Elevation Rack shape in the Visio interface.

You can certainly fill this in for any other products where you want to track the height in rack units, in addition to the actual height, or use the Compute button to calculate it for you based on Height.

Amps

Here, you enter the Amperage of the product.

Volts

Here, you enter the Voltage of the product.

Watts

Here, you enter the Wattage of the product.

BTU

Here, you enter the BTU / hour of the product.

PoE (Power over Ethernet)

These fields are used in the PoE View within the Project Editor to help make associations between Power Source Equipment (PSEs) and Powered Devices (PDs).

PoE Type

By default, this is set to "None" for all products, but here is where you can set a product as a PSE (Power Source Equipment) or a PD (Powered Device).

Power Budget

Set the power budget in Watts for a PSE. This is a required field for products marked as a PSE.

Available Ports

Read-only field that displays how many PoE ports the device has available, i.e., those not associated with a PD.

Min. PoE Class

Set the minimum PoE class for a PD. This is a required field for products marked as PD.

Speakers

The products of Category Type "Speaker" have an additional field for dispersion on the Specifications tab. This field doesn't calculate from anything but can be populated if desired for your reference.

dispersion.jpg

Wire

The products of Category Type "Wire" have completely different fields on the Specification tab.

wire specs.jpg

Field

Description

Diameter

Here, you enter the diameter of the wire. Enter the diameter in inches, millimeters, or centimeters.

Checking this box will treat the wire on a per-foot/meter basis (based on your Windows settings). When using this option, you will enter your unit cost, unit price, and labor hours per foot/meter.

Use this option for the wire that comes on a spool. The wire that is marked as "Bulk Wire," when added to a project, will trigger a prompt for the head end and wire length.

Start Terminal

Here, you can set the terminal type of the start or "source" of the wire.

End Terminal

Here, you can set the terminal type of the end or "destination" of the wire.

The Start and End terminals are used on the Wire Terminal Count report. These fields can also be used to display specific images on the ends of Finish Wire shapes in Visio.

I/O's

This displays the Inputs and Outputs (I/O's) assigned to a product. There are buttons for adding and deleting I/Os.

I/O's are used to populate the Schematic shape or block in our Visio and AutoCAD interfaces.

ios v19.png

Custom Fields

Here, you can add the values for the Custom fields of the product. There are 26 custom fields you can add for products in the Item Custom Fields setting in the Control Panel.

Check out this article for more details.

custom fields.jpg

Accessories

Here, you can add products and labor items to a product.

accessories tab.jpg

Alternates

Here, you can add alternate products to a product.

alternates.jpg

Large Image

Here, you can add a larger image than the thumbnail image displayed on the General Tab. This image will be used in Visio when creating a Line View page.

You can use the "Find in D-Tools Library" or "Find in Google Images" links to help you find an image. Use the Add, Paste, and Clear links to manage your image.

Generate thumbnail from large image - This will generate a smaller image on the General Tab that will be used in some Proposal reports. If you want to maintain separate images, uncheck this box. The default is checked.

large image.jpg

Shapes and Blocks

Here, you can set overrides for the default Visio shapes and AutoCAD blocks that drop on pages in our Visio and AutoCAD interfaces.

You can override the defaults for all Page types: Line, Elevation, Plan, Schematic, and the side view displayed on Elevation pages. You can use other SI Visio shapes, AutoCAD blocks, or your own custom shapes or blocks. You can use the Assign and Clear buttons to manage your selections.

Another way to manage your shape assignments is directly in the Visio interface: Assign Shapes to Categories, Assign Categories to Shapes, and Assign Product and Category.

Check out this collection of articles for more details.

shapes and blocks.jpg

Files

The Files tab allows you to add files or links to files for products. These files and links are used for Submittal reports.

The default file categories are Spec Sheets, User Guides, Install Manuals, Images, and Back Panel Images, which correspond to files that may be available for the product in the D-Tools Library. You can add additional categories or subcategories if needed.

files tab.jpg

Check Partner Price

If the product is from a Vendor partner, you can click this button to update the unit cost to the current value from the Vendor.

check partner price.png

Find Usages

Here, you can find all usages of the product in your existing projects, purchase orders, and service orders.

find usages.png

Web

The Web tab allows you to search online for more information about a product.

web.jpg

Option

Description

URL

This opens a browser to whatever link you have in the URL field on the General tab.

Library

This opens a browser to this product within the D-Tools Library viewer.

Google

The search is based on the manufacturer and model fields. You can choose between Search, Products, or Images.

Amazon

This searches Amazon based on manufacturer and model.

Additional Product Fields

When a product has been added to a project, additional fields are added to the product.

Check out this article for more details.

Did this answer your question?