Maintaining Item/SKU/Offer (CPIM)
Purpose: Use Maintain Item/SKU/Offer to recalculate the projected units or update other information in the Item/Offer table.
In this topic:
• Maintain Item/SKU/Offer Screen
• Recalculate Projected Units Window
For more information: See Working with Existing Items (MITM) for a description of the fields on the Change Item, Change SKU, and Change SKU/Offer screens.
Also, see Introducing Forecasting.
Maintain Item/SKU/Offer Screen
Purpose: Use this screen to update item/offer information.
How to display this screen: Enter CPIM in the Fast path field or select Maintain Item/SKU/Offer from a menu.
Field |
Description |
Offer |
A code for the catalog, space, or television advertisement from which you accept orders. See Working with Offers (WOFR). Alphanumeric, 3 positions; required. |
Item |
A code for a unit of inventory that you sell. Alphanumeric, 12 positions. |
SKU |
A code for the unique characteristics of the item, such as its color, size, width, etc. Alphanumeric, three 4-position fields. |
Price |
The price of a single unit of the item, as advertised in the offer. Numeric, 7 positions with a 2-place decimal; optional. |
Prj unit (Projected units) |
The number of units of this item that you expect to sell in an offer. Used for forecasting and reporting purposes. Numeric, 7 positions; optional. |
Page# |
The primary page on which the item is advertised in the offer. Used for reporting purposes. Numeric, 5 positions; optional. |
Sq in (Square inches) |
The square inches that this item occupies on the page in an offer. Used to calculate the profitability of the item on the page. Numeric, 3 positions; optional. |
F/O (Feature/Option code) |
This code identifies whether the item in the offer is considered a feature or option in a depiction (a photograph or drawing of the item along with other items). If, for example, a dining room is depicted, the featured item might be the dining room table, and the options might include a place setting, crystal, and a centerpiece. Valid values are: Feature = Item is the featured item in the depiction Option = Item is an option within a depiction Optional. |
P/N (Pickup/New code) |
This code identifies whether the item is a carryover from a previous offer or is an item that you are just beginning to sell. Valid values are: Pickup = Item is a pickup item from a previous offer New = Item is new to this offer Optional. |
Tax inclusive price |
The price of a single unit of the item, as advertised in the offer, on orders which are subject to VAT. Included only if the Tax Included in Price (E70) system control value is selected. Numeric, 7 positions with a 2-place decimal; optional. |
Screen Option |
Procedure |
Update the base item |
Select Change Item for the item you want to update to advance to the Change Item Screen. See Performing Initial Item Entry (MITM). |
Update a SKU |
Select Change SKU for the SKU’d item you want to update to advance to the Change SKU (First Screen). See Performing Initial Item Entry (MITM). |
Update a SKU/Offer |
Select Change SKU offer for the SKU/Offer you want to update to advance to the Change SKU/Offer Screen. See Performing Initial Item Entry (MITM). |
Adjust the number of units you expect to sell from this offer |
Select Recalc proj. units to display the Recalculate Projected Units Window. |
Recalculate Projected Units Window
Procedure: Select Recalc proj. units on the Maintain Item/SKU/Offer Screen to display this window, where you can indicate:
• whether the number of sales is expected to increase (I) or decrease (D)
• the percentage of positive or negative change (this is a 5-position field with a 2-place decimal)
Result: Based on your entries, the system updates the value in the Projected units field for each item/offer. This is a convenient way to perform an automatic update without changing each manually.
