Chapter 63: Maintaining Item/SKU/Offer (CPIM)

Purpose: Use Maintain Item/SKU/Offer to recalculate the projected units or update other information in the Item/Offer file.

In this chapter:

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 for more information on how you can use the fields at this screen for forecasting purposes.

Other ways to update item and SKU prices and offers: See Options for Updating Item or SKU Offer or Price for a listing.

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.

CPR0043 DISPLAY Maintain Item/Sku/Offer 3/27/08 16:48:16

EZK Mail Order

Offer Generate Item Out triggers Y (Y/N)

Opt Item CLR SIZE WDTH Price Prj Unit Page# Sq in F/O P/N

BU001

Type options, press Enter.

5=Change item 6=Change SKU 7=Change SKU offer

BU001 CHOC LRGE 10.00 32

CHOCOLATE EASTER BUNNY Tax inclusive price 12.00

BU001 CHOC MEDM 8.00 32

CHOCOLATE EASTER BUNNY Tax inclusive price 10.00

BU001 CHOC SMLL 6.00 32

CHOCOLATE EASTER BUNNY Tax inclusive price 8.00

BU001 WHIT LRGE 10.00 32

CHOCOLATE EASTER BUNNY Tax inclusive price 12.00

BU001 WHIT MEDM 8.00 32

CHOCOLATE EASTER BUNNY Tax inclusive price 10.00 +

F3=Exit F7=Recalculate projected units F12=Cancel

Field

Description

Offer

A code for the catalog, space, or television advertisement from which you accept orders. See Marketing Chapter 2: Working with Offers (WOFR).

Alphanumeric, 3 positions; required.

Generate item out triggers

Indicates whether to create an outbound interface transaction trigger for each item and SKU whose information is updated when you complete this screen. The system creates a trigger with a file type of SKU, indicating to generate an outbound item XML message for the item. See Generic Item Download API for more information on the outbound XML message. Valid values are:

Y = Create a trigger to create an outbound item XML message (CWItemOut) for each updated item and SKU. The system does not create triggers for SKUs that are not included in the listed offer(s).

N = Do not create the triggers for the outbound item XML message.

This field defaults to its previous setting from the last time you used this menu option. If there is no stored setting, the default is Y. See Working with Default Options (WDFT) for information on how the system stores defaults.

Note: This field is displayed only if the Create Generic Item Download Trigger Records (I15) system control value is set to Y.

Alphanumeric, 1 position; 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, one, 14-position field (full SKU) or three 4-position fields (split SKU).

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. This value is used for forecasting and reporting purposes.

Numeric, 7 positions; optional.

Page#

The primary page on which the item is advertised in the offer. This value is 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. This value is 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:

F = Item is the featured item in the depiction

O = Item is an option within a depiction

Alphanumeric, 1 position; 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:

P = Item is a pickup item from a previous offer

N = Item is new to this offer

Alphanumeric, 1 position; 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. This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y.

Numeric, 7 positions with a 2-place decimal; optional.

Screen Option

Procedure

Update the base item

Enter 5 next to the item you want to update to advance to the Change Item Screen. See Chapter 24: Performing Initial Item Entry (MITM).

Update a SKU

Enter 6 next to the SKU’d item you want to update to advance to the Change SKU (First Screen). See Chapter 24: Performing Initial Item Entry (MITM).

Update a SKU/Offer

Enter 7 next to the SKU/Offer you want to update to advance to the Change SKU/Offer Screen. See Chapter 24: Performing Initial Item Entry (MITM).

Adjust the number of units you expect to sell from this offer

Press F7 to display the Recalculate Projected Units Window.

Recalculate Projected Units Window

Procedure: Press F7 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.

Recalculate Proj Units

Offer . . . . . . : W97 WINTER 1997

Increase/decrease . (I,D)

Percent . . . . . .

F9=Accept F12=Cancel

ME06_14 CWDirect 18.0 August 2015 OTN