BoostExcel main content

 

See also: Add New Products - Edit Existing Products

 

The Product Edit window provides a number of fields that you may optionally store data in. The only required field on this window is the Description field. However, you will want to fill in other fields like price, and stock if applicable.

the Product Edit window

First, let us look at the Command List bar.

Button Action
Save Whenever you edit or add a product you want to be sure to save your changes!
Delete Deleting a product totally removes the product record from the database. This does not affect previously created invoices.
Sync Cost By default, the product cost of an invoice item is set to the cost value of that product when you create an invoice, and the total cost of the invoice is calculated based on that cost. However, you can use this button to update all invoice items related to the product and to set their cost value to the product's current cost.
Category This button displays the Product Category window where you can add, edit, and delete product categories.
Report This button displays the Reports window where you can create new reports.
Refresh Reload data from the database. This command is used basically in a network environment where multiple users open the same database. You can use this button to refresh data modified by other uses.

 

Below is a description of some important fields on the Product Edit window.

Field Name Description
Category The category field helps you organize products. Click the Product Category button on the Command List bar to manage categories.
Product ID The ID value uniquely identifies a product. This value is generated automatically if left blank.
Description The product's description is the only required information you must enter. It is a free-form text field.
Status Potential values are Active and Inactive. Only active products will be displayed when you click the Select Product icon button on the Invoice worksheet.
Is a service Check this box If you do not maintain a physical inventory for the product.