Default Formula Description
| Field | Description |
|---|---|
| Description | You can enter the name of the formula. This is a required field. |
| Markup % | You can enter the percent of markup for the item. For example, a $100 frame with a markup of 10% (entered to the left of the decimal point as 10.) costs $110. |
| Addon | You can enter the dollar amount you want to add to the price. For example, a $100 frame with an add-on of $7.50 costs $107.50. If a markup percentage is used, the addon is applied after the percentage increase is calculated. |
| Mask | You can enter the dollar amount that you want to use to override the price. The mask replaces the digits of the price only for the digits you enter. For example, a $27 accessory with a mask of $.99 costs $27.99 or a $55.00 accessory with a mask of $4.00 costs $54.00. The mask is applied after rounding. |
| Fixed Price | You can enter the fixed price, if applicable. When a fixed price is entered, all of the other formula fields become disabled. The fixed price becomes the calculated price. |
| Reorder Level | You can enter a quantity in this field to indicate when this item should be reordered. Quantities from this field appear on the Inventory to Reorder report, which can be used to compare in-stock levels to the reorder levels. |
| Round Price | You can select this option to round the price. Rounding is based on the first dollar position of the calculated price and is rounded up or down in five dollar increments. The following example shows how this works. Calculated Price: 60 61 62 63 64 65 66 67 68 69 70 Rounded Price: 60 60 60 65 65 65 65 65 70 70 70 |
| Taxable | You can select this option to charge tax for the item when applying the formula. |
| Category | You can select a category. The formula is applied to the selected category. This is a required field. |
| Category Type | You can select the category type. The formula is applied to the selected category type. |
| Vendor | You can select the vendor. The formula is applied to the selected vendor. |
| Brand | You can select the brand. The formula is applied to the selected brand. |
| Collection | You can select the collection. The formula is applied to the selected collection. |
| Price Range | You can enter a dollar amount to set the beginning of the price range in the Start field. Enter a dollar amount to set the end of the price range in the End field. The formula is applied to items within the price range. This is a required field. |
| Note | You can add comments about the formula. |
| Catalog Price | You can enter the catalog price for testing. |
| Outcome | You can select Test to the right of this field to test the formula and display the results of the calculations in this field. |