Load Price Levels

(Load Price Levels)

Access

Use this routine to apply the values in one or more price levels to one or more selected products. The system

1. selects products based on the criteria you specify at the prompts below,

2. retrieves the selected products' current Pricing Level Table, and

3. calculates the selected price levels using formulas in the Pricing Level Control Table.

ProductEnter the code for one or more products for which you want to load price levels. If you click on the Search button, you access the Product/Description/Vendor Model Word Search window, from which you can choose a product.  If you click on the Action button, the Multiple Product Selection window appears from which you can select one or more products. To load price levels for all products, leave the field blank. Your selection appears to the right of the field.

If you select a single product at the Product field , the Group, Category, Vendor, and Collection fields are not active. Those fields are used to restrict your product list if you select multiple products.  

GroupEnter the code for one or more product groups for which you want to load price levels. If you click on the Search button, you access the Group search window from which you can search for and select one or more product groups. If you click on the Action button, the Multiple Product Group Selection window appears from which you can select one or more product groups. To load price levels for all groups, leave the field blank. Your selection appears to the right of the field.

CategoryEnter the code for one or more product categories for which you want to load price levels. If you click on the Search button, you access the Category search window from which you can search for and select one or more categories. If you click on the Action button, the Multiple Category Selection window appears from which you can select one or more product categories. To load price levels for all categories, leave the field blank. Your selection appears to the right of the field.

VendorEnter the code for one or more vendors for which you want to load price levels. If you click on the Search button, you access the Vendor Cross Reference window from which you can search for and select a product. If you click on the Action button, the Multiple Vendor Selection window appears where you can select one or more vendors. To load price levels for all vendors, leave the field blank. Your selection appears to the right of the field.

CollectionEnter the code for one or more product collections for which you want to load price levels. If you click on the Search button, you access the Collection search window from which you can search for and select a product collection. If you click on the Action button, the Multiple Collection Selection window appears where you can select one or more product collections. To load price levels for all collections, leave the field blank. Your selection appears to the right of the field.

Price LevelEnter the code for one or more price levels you want to update for the products selected above.  If you click on the Action button, the Multiple Price Levels Selection window appears where you can select one or more price levels. To select all price levels, leave the field blank.

Level Price Rounding

When loading price levels, the system rounds off level price calculations using the following rules:

1. The initial calculation is done using a 2 digit [cents] rounding factor with a 5/4 normal rounding.

2. The next calculation is done using a 5/4 normal rounding function to get the Selling Price to a whole dollar number. Thus, the system rounds all prices are rounded to whole dollars.

3. The next calculation is an adjustment based upon the unit dollar amount as follows:

a. If the unit dollar amount is 0, replace it with 0.

b. If the unit dollar amount is 1 to 5, replace it with 5.

c. If the unit dollar amount is 6 to 9, replace it with 9.

Thus, all adjusted selling prices are in whole dollars and end in a 0, 5 or 9.  

Example

For example, assume pricing level two for a given product is 100.00.