You are here:  QuoteWerks Help > CHAPTER 11: Product and Service Management > Maintaining Products and Services > Editing Products and Services >

Advanced Tab

Print this Topic Previous pageReturn to chapter overviewNext page

The following describes the use of the key fields on the Advanced tab.

Availability

This field is used to record the quantity of the product that you currently have in inventory. When you convert a document to an order or an invoice you will have an option to reduce the inventory count.

Serial Number

This field is used to record a serial number for the item. Only 1 serial number can be stored.

Spec Sheet

This allows you to associate a product specification (Spec) sheet describing the product with this product. To use this feature, you must enter a unique part number in the manufacturer part number field and the vendor name must match the product database name for this product. This is required so that QuoteWerks can find the spec sheet when the part is being printed. To select a spec sheet for an item, click on the button. This will launch the “Select Spec Sheet for Product” window. From this window you can select a spec sheet from the SPECS folder or search for one on your computer or network. You can also click on the button to open the file for modification using whatever program (such as Word or Adobe Acrobat) is associated with this file type.er product record.

When printing the quote, on the File -> Print/E-mail/Deliver window there is a tab called “Spec Sheets.” This tab will display all specs sheets associated with items in the current document:

Simply, check the box next to the spec sheet(s) you want to include with this quote and they will be appended to the document when it’s created.

QuoteWerks supports RTF (Rich Text Format) and PDF (Adobe Acrobat format) formatted spec sheets. Microsoft Word for example can create, open and modify RTF files. Adobe Acrobat can create, open and modify PDF files.

We recommend that you save the spec sheet files in the \QuoteWerks\SPECS directory, although it is not required. From this spec sheet field, you can then select the spec sheet that you want to associate with this product.

PDF formatted literature files can be used as literature, however, PDF formatted spec sheets can only be used when emailing, printing, or faxing the quote using the WinFax link. They will not be included in the print preview. When you email the quote, the PDF formatted literature files will be listed as separate attachments in the email.

Note:PDF formatted specs sheeted will not be included in the print preview.

Item URL

This field enables you to specify a webpage to associate with the product. When searching for the product in the Product Lookup window, you can right click on the product and choose 'View Item URL'. QuoteWerks will then open the URL in your default browser. You can also click on the button to open the URL from the Edit Product window.

Unit Weight

This field is used to store the per unit weight of an item. The unit weight is used in conjunction with the Unit of Measure (U/M) and Unit of Measure Factor (U/MF).

Example 1

If the U/M is Per Dozen, and the U/MF is equal to 1. That would mean the Unit Weight is the total weight of 1 dozen. The table below illustrates this example.

Unit of Measure

Unit of Measure Factor

Unit Weight

Total Weight of 1 Dozen

Per Dozen

1

2 pounds (lbs)

2 pounds (lbs)

 

Example 2

If the U/M is Per Dozen, and the U/MF is equal to 12. That would mean the Unit Weight is the weight of each individual item. The table below illustrates this example.

Unit of Measure

Unit of Measure Factor

Unit Weight

Total Weight of 1 Dozen

Per Dozen

12

2 pounds (lbs)

24 pounds (lbs)

Based on what you enter as the Unit of Measure Factor will determine what you enter as the Unit Weight. Lastly, the unit weight can be used to calculate shipping costs and is discussed in The Quote Workbook.

Unit of Measure

This field is used to specify the unit of measure (U/M).

Examples of Unit of Measure:

*Each

*Per Dozen

*Box of 10

Unit of Measure > Factor

This field is used to specify the unit of measure factor (U/MF). The U/MF is based on the unit of measure and will be used to calculate the Total Shipping Weight of an item.

The Formula for Total Shipping Weight :

Total Shipping Weight = (QTY) * (UNIT OF MEASURE FACTOR) * (UNIT WEIGHT).

Example 1

If you sell 5 widgets, the U/M is per dozen, and the U/MF is 12, and the Unit Weight is 2 pounds, then the extended weight of the widgets would be 120 pounds. The table below illustrates this example.

Qty

Unit of Measure

Unit of Measure Factor

Unit Weight

Total Weight

5

Per Dozen

12

2 pounds (lbs)

120 pounds (lbs)

Unit of Pricing

This field is used to specify the unit of pricing (U/P).

Examples of Unit of Pricing:

*Each

*Per Dozen

*Box of 10

Unit of Pricing > Factor

This field is used to specify the unit of pricing factor (U/PF). The U/PF is based on the unit of pricing and will be used to calculate the EXTENDED PRICE of an item.

The Formula for Extended Price:

Extended Price = (QTY) * (UNIT OF PRICING FACTOR) * (UNIT PRICE)

Example 1

If you sell 5 pens, the pens come in a Box of 10, the Unit Price of a box of 10 pens is $50, and you sell the pens individually, the U/PF is .1, the total price of 5 pens would be $25. The table below illustrates how to configure each of the fields.

Qty

Unit of Pricing

Unit of Pricing Factor

Unit Price

Extended Price

5

Per Box of 10

.1

$50

$25

Example 2

If you sell pens that come in a box of 10, but you want to display the unit price of $5.00 for each of the 10 pens in the box, you can configure each of the fields as the table below illustrates.

Qty

Unit of Pricing

Unit of Pricing Factor

Unit Price

Extended Price

1

Per Pen

10

$5

$50

Search Keywords

These keywords can be searched on from the Product Lookup window. Separate each keyword by a space.

Note:The combined length of all the keywords cannot be greater than 254 characters.

Vendor

When you add a product to a quote from a product database, the Vendor column value in the quote for this item is automatically set to the the name of that product database. Therefore, whenever QuoteWerks needs to get an update price or other information for the product, QuoteWerks will look in the product database you took the product from.

In most cases, you'll leave this Vendor field in the product definition blank. However, sometimes you might want to obtain updated information like pricing from a product database other than the database you selected the product from. When QuoteWerks links to external product databases, it cannot edit these products' descriptions or pricing, or organize these products in folders. Often, the product descriptions in these external databases are technical, short, and cryptic which is not something you can show to the customer; however, product pricing is current in these external databases.

A solution to these limitations is to copy the product from the external database into a native "surrogate" product database and set the Vendor field to be the original external product database. This Vendor field value is your link between your native product database and the external/original database, which will allow you to always access the most up-to-date pricing information from the original external product database.

Once you copy the product into the surrogate database, you can modify the description to be more customer friendly. Then, moving forward, always select the product from the surrogate product database so it will use that description in the quote, but use the pricing information from the original external product database.

For additional information relating to the Vendor field, please see QuoteWerks Native Product Databases.

Note:When products from an external database like the Tech Data database are copied into a surrogate native product database, and these products are selected to be added to the quote from the surrogate native product database, the latest cost value will be automatically retrieved from the Tech Data database therefore getting the best of both worlds in that when the product is added to the quote, the item will have both the current cost, and your edited description.

Folder List

This window displays the folders that this item is currently associated with. Products can be associated with more than 1 folder, which allows you to visually manage and find your products. See Organizing Products in Folders for details on how to associate items with folders.

List of Items Required by this Item (Read Only)

This field is a read only list of items that will automatically be added when this item is added to the document. See the Required, Optional, and Substitute Item Features Chapter for details on how to create required items.

Version 5.2 (Build 8.12)  - July 7th, 2017