eSuite – Item Tables – Price

Information

The eSuite software uses relational tables to store item information. The Price table contains all the standard pricing and special event information for the item.

To find a price record for the item, eSuite uses a unique key made up of three fields: the main item UPC, the target and the price level. This means that each UPC can have more than one price record in the Price table, as long as the target and/or the price level change.

This very flexible combination of target and price level means two things for every item:

• Every UPC can have as many price records as there are targets (stores/regions). For example: separate pricing for Store 1, Store 2, Store 3, etc. 
• Every target (store/region) can have as many records as there are unique price levels for them. For example: if desired, Store 3 can set four (4) different prices, that is price level 1, 2, 3 or 4.  

Your day-to-day pricing is maintained in the regular column and there are three (3) additional columns allowing for various price events. If there is pricing displayed in all four (4) columns, the active and next price are determined by the precedence of the columns in conjunction with the event start and stop dates. See the pricing precedence section below for more information.

INFORMATION: Various price events can be managed directly in the Price table, in the grid or via the eSuite Batch module. If you have any bulk price management requirements, ensure that you ask your reseller about implementing the eSuite Batch module.

Display the Price master table

Follow these steps:

1. In the launcher, click the down arrow next to Items to expand its menu and select Items.
   
2. Click Items from the start widget.
   
3. Enter the search criteria, selecting Show price.
   
4. Click on Execute.
5. In Items - General List, select a record.
   
6. Click Edit in the bottom menu to display the options.
   
7. Select Master tables, then Price master.
   
   
   The Price table is displayed.
   
   
   NOTE: You can also display the Price edit table by selecting Master tables>Price Master when right clicking on an item in the grid or from the Item views menu in the Context Tools. 

Add a price record

If you have multiple levels of pricing in your store, you can add a price level to your item allowing you to sell to different customers at different pricing based on the shopper levels. For example, if you want a shelf price for customers personally shopping in your store and another better price for the loyalty clients.

To add a price record:

1. From the Items grid, open the Price table on the item to which you want to add another price level. 
2. Select “+” in the toolbar to add another record.
   
3. Select the drop-down under Level and choose your additional price level. In this case, 5: Super saver.
   
4. Enter the price desired in the Regular price field.
   
5. To save, click the checkmark or press Enter on your keyboard to save pricing for level 5.
   
   NOTE: By maintaining costs and margin for items, the system can auto-generate pricing for items and levels. Your system can be configured one of two ways to do this calculation. See your reseller for more information.

Modifying an item price

1. Display the price table of the record whose pricing you want to modify. 
2. Choose the record for the levels you want to modify. 
3. Edit the price. 
4. Save the change.

Pricing precedence for multiple events

If Regular, TPR and Sale pricing columns contain prices, but none have the start and end dates specified, the Regular price takes precedence.

If a Store price is also entered (without any dates specified), the Store price takes precedence over the Regular price.

Both TPR and Sale prices require valid dates in the Start and End date fields for their prices to take effect. If no dates are specified for the Regular price, the eSuite software uses the date and time when the modifications were made as the active date for the change. 

The TPR price takes precedence over the Regular price when the current day is part of the TPR dates range. The Sale price also takes precedence over the Regular price when the current day is part of the Sale dates range. If the current day is part of both the TPR and Sale dates ranges, the Sale price takes precedence over the TPR price.

Finally, the Store price may also take precedence over the TPR and/or Sale prices if it is specified as such by checking off the column(s) it should override.

Profit margin calculation

If you are maintaining costs, the profit margin is displayed for each price, near the header for each column, profits in green and losses in red.

The profit margin is calculated according to one of the two options that were selected when the software was configured for your store. To illustrate the two options available, here are two examples with the same cost and profit margin %.

Margin on cost

• The margin on cost in this example is the result of 25% of $10.00.
• The margin is $2.50, and the retail price is $12.50.
• The formula to calculate the profit margin as a percentage of the cost is: Cost + (Cost * profit margin %).

Margin on retail

• The margin on retail in this example is the result of 25% of the retail price.
• The margin is $3.33 and the retail price is $13.33.
• The formula for calculating the profit margin as a percentage of the retail price is: Cost / (1 - profit margin %).

Margins for auto-price generation item-by-item can be set by populating the Retail Margin field found under the Margin tab.