Maintaining SKU Cross Reference Codes (MSKR)
Purpose: Use Maintain SKU Cross Reference to create and work with SKU cross reference codes for each item or SKU sold in an offer. You can use SKU cross reference codes as a way to create a cross reference between a Order Management System item and SKU code and the item and SKU in another system, such as ChannelAdvisor.
About the ChannelAdvisor integration: See ChannelAdvisor Integration Overview and ChannelAdvisor Setup for more information.
Cross reference codes in OEOM: Creating 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 table 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 Order Management System item and SKU to the order.
Example:
Order Management System 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 Order Management System item KAL555 in the Item field and the Order Management System SKU GREY WMNS SMLL in the SKU field.
If the operator enters a SKU cross reference code that is not associated with a Order Management System item or SKU or if the operator enters a valid SKU cross reference code but also enters a SKU code, an error message such as the following indicates if the operator attempts to add the line to the order:
Base item (525KL) is missing or invalid.
Restrictions on using SKU cross references to identify items/SKUs:
• Interactive order entry: Since the Item field is 12 positions, the SKU cross reference code cannot exceed 12 positions in order to identify the item/SKU in interactive order entry.
• Order API: The generic order interface does not support using SKU cross reference codes to identify items. See Resolving the Item and SKU in the Order API for a discussion.
The ChannelAdvisor integration supports using a SKU cross reference of up to 40 positions. See ChannelAdvisor Integration Overview for background.
Which offer is used for the order detail line?
When an operator enters a 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 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 Order Management System item A123 and the Order Management System 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 Order Management System item and SKU. Then, within the first offer where the system finds a match, the system selects the first Order Management System item and SKU it finds containing the cross reference number. For example, if a Order Management System item and SKU in offer A01 was not associated with the cross reference number 321RG, the system would then search offer B01 for a Order Management System 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 Order Management System 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.
Field |
Description |
Offer |
A unique code for the catalog, space, or advertisement for which you wish to define a cross reference between a Order Management System item and SKU and another system's item and SKU. Enter a valid offer code to advance to the Maintain SKU Cross Reference Screen. ChannelAdvisor: To work with cross-references for the ChannelAdvisor integration, enter the offer code specified in the ChannelAdvisor SKU X-Ref Offer (L92) system control value. Alphanumeric, 3 positions; required. |
Maintain SKU Cross Reference Screen
Purpose: Use this screen to create, change, and delete SKU cross reference codes for Order Management System 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).
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 Order Management System 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 is listed below the item code. Item number: Alphanumeric, 12 positions; optional. Item description: Alphanumeric, 120 positions; optional. |
Colo, styl, size |
The first, second, and third SKU elements defined for an item in your company.nAlphanumeric, three 4-position fields; 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. Note: To use a SKU cross reference in order entry, you cannot have the code exceed 12 positions. Alphanumeric, 40 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.
