Chapter 60: Maintaining SKU Cross Reference/JCP Codes (MSKR)

Purpose: Use Maintain SKU Cross Reference to create and work with JC Penney SKU cross reference codes for each item or SKU sold in an offer. You can use JC Penney SKU cross reference codes as a way to create a cross reference between a CWDirect item and SKU code and another system's item and SKU code.

Important: The cross references discussed here are different from the cross references you set up through the Cross Reference # option (option 32) in item maintenance, through the item upload, or automatically at item creation. The cross references you set up through the Maintain SKU Cross Reference menu option are stored in the SKU Cross Reference/JCP file and are related to the JC Penney integration. See Work with SKU Cross Reference Type Screen for more information on the other type of SKU cross references.

JC Penney cross reference codes in OEOM: Creating JC Penney cross reference codes for each item and SKU sold in an offer allows an operator to enter the cross reference code in the Item field when entering a line in order entry or order maintenance. When the operator adds the line to the order, the system searches the SKU Cross Reference/JCP file for the item or SKU that is associated with the cross reference code. When the system finds the item that is related to the cross reference code the operator entered, the system defaults the CWDirect item and SKU to the order.

Example:

CWDirect item/SKU: KAL555 GREY WMNS SMLL

SKU cross reference code: 525KL

When the operator enters 525KL in the Item field in order entry or order maintenance, the system defaults the CWDirect item KAL555 in the Item field and the CWDirect SKU GREY WMNS SMLL in the SKU field.

If the operator enters a SKU cross reference code that is not associated with a CWDirect item or SKU or if the operator enters a valid SKU cross reference code but also enters a SKU code, an error message similar to the following displays when the operator attempts to add the line to the order:

Base item (525KL) is missing or invalid.

Which offer is used for the order detail line?

When an operator enters a JC Penney SKU cross reference code in the Item field in order entry or order maintenance, the system uses the offer on the order detail line to determine the price of the item, not the offer where the SKU cross reference code was defined. If a price has not been defined for the item in the offer on the order detail line, the error message Price (.00) cannot be zero for item displays and the operator must manually enter a price.

What if more than one item and SKU is defined with the same JC Penney cross reference number?

The system searches offers alphanumerically for an item and SKU that contain the cross reference number, selecting the first item and SKU it finds.

Example:

Offer	Item	SKU	Reference Number
A01	A123	BLUE	321RG
A01	A123	RED	321RG
B01	B123	BLUE	321RG
B01	B123	RED	321RG
In order entry and order maintenance, the system defaults the CWDirect item A123 and the CWDirect SKU BLUE, when an operator enters the reference number 321RG in the Item field.

In this situation, when an operator enters the cross reference number 321RG in the Item field, the system searches offers in alphanumeric order for a CWDirect item and SKU. Then, within the first offer where the system finds a match, the system selects the first CWDirect item and SKU it finds containing the cross reference number. For example, if a CWDirect item and SKU in offer A01 was not associated with the cross reference number 321RG, the system would then search offer B01 for a CWDirect item and SKU that was associated with the cross reference number.

In this chapter:

• Work with SKU Cross Reference Screen (Selecting an Offer)

• Maintain SKU Cross Reference Screen

• Create SKU Cross Reference Codes

• Change SKU Cross Reference Codes

Work with SKU Cross Reference Screen (Selecting an Offer)

Purpose: Use this screen to identify the offer for which you wish to define a cross reference between item and SKU codes in CWDirect and another system.

How to display this screen: Enter MSKR in the Fast path field at the top of any menu or select Maintain SKU Cross Reference from a menu.

PTR0030 ENTER Work with SKU Cross Reference 1/22/99 12:11:18 KAL Co. Offer Number . F3=Exit F12=Cancel

Field

Description

Offer

A unique code for the catalog, space, or advertisement for which you wish to define a cross reference between a CWDirect item and SKU and another system's item and SKU. Enter a valid offer code to advance to the Maintain SKU Cross Reference Screen. This screen displays every existing item and SKU in the Item and SKU files, regardless of whether the item or SKU is associated with the offer. Alphanumeric, 3 positions; required.

Maintain SKU Cross Reference Screen

Purpose: Use this screen to create, change, and delete JC Penney SKU cross reference codes for CWDirect items and SKUs. SKU cross reference codes represent the code for an item and SKU as represented in another system.

How to display this screen: Enter an offer code on the Work with SKU Cross Reference Screen (Selecting an Offer).

PTR0031 DISPLAY Maintain SKU Cross Reference 1/22/99 12:25:52 KAL Co. Offer . : A01 OFFER A01 - SPECIAL EDITION Item/Desc COLO STYL SIZE Sku Description Sku cross ref ABC A01-ABC CLOTH SUITCASE WITH WHEELS AN3856 A01-AN3856 BEHIND THE DOOR SHOE ORGANIZER APP89S A01-APP89S LAUNDRY BASKET APRIC76S A01-APRIC76S WOODEN CLOTHES HANGERS AVERA45 A01-AVERA45 SMALL SHOWER CADDY AVERA55 A01-AVERA55 LARGE SHOWER CADDY + F3=Exit F12=Cancel

Field	Description
Offer	The code and description of the catalog, space, or advertisement for which you wish to create SKU cross reference numbers. The system displays all existing CWDirect items and SKUs, regardless of whether the item or SKU is associated with this offer. Offer code: Alphanumeric, 3 positions; display-only. Offer description: Alphanumeric, 30 positions; display-only.
Item/desc (Item number/Item description)	The item code for which you wish to create a SKU cross reference number. The description of the item displays below the item code. Item number: Alphanumeric, 12 positions; optional. Item description: Alphanumeric, 40 positions; optional.
Colo, styl, size	The first, second, and third SKU elements defined for an item in your company. Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); optional.
SKU description	The SKU description. Alphanumeric, 40 positions; optional.
SKU cross reference	A code for an item and SKU as represented on another system. Alphanumeric, 12 positions; optional.

Create SKU Cross Reference Codes

To create: Scan for the item and SKU for which you wish to create a SKU cross reference code, using the scan fields at the top of the screen. Enter a cross reference code in the SKU cross reference field next to the item and SKU you wish to update.

The system positions the cursor to the first scan field so that you can scan for the next item and SKU you wish to update.

Change SKU Cross Reference Codes

To change: Scan for the item and SKU for which you wish to change the SKU cross reference code, using the scan fields at the top of the screen. Enter the change you wish to make to the existing cross reference code in the SKU cross reference field next to the item and SKU you wish to update.

The system positions the cursor to the first scan field so that you can scan for the next item and SKU you wish to update.