Working with SKUs

Purpose: A SKU (stock keeping unit) is used to further define an item. An item that is sold in multiple colors and sizes is often represented by a base item number, which is common to all of the colors and sizes, and a SKU, which specifically defines the color and or size. For example, the base item number for a dress might be 9201, and the SKUs associated with that item number might be RED SML, RED MED, RED LRG, BLUE SML, BLUE MED, and BLUE LRG.

All functions accessible at the base item level are accessible at the SKU level, including offers, warehouses, sets, and comments. Information entered at the SKU level overrides information defined at the base item level.

In this chapter:

Split SKU Elements

SKU Groups

SKU Sort Sequence Numbers

SKU Generator

Work with SKUs Screen

Split SKU Elements

The elements of the Split SKU are defined in the System Control table. There are three elements used in the Split SKU environment. Typically, these elements are used to represent size, color and width for items of apparel; however, you can define the elements to meet your particular requirements. Once you set up the elements in the System Control table, you will be prompted for this information throughout the system.

SKU Groups

A SKU Group can be assigned to an item in the Item table and is used to define the standard sizes or colors in which items are sold. You can use Working with SKU Groups (WISG) to create groups to facilitate data entry Using the SKU Generator (ESKG).

For example, a SKU group can be defined for a particular manufacturer's product line for dresses. You can define an Item SKU Group for dress size. For example, the Item SKU Group 001 could be set up for dresses and would list the sizes in which these dresses are available (4, 6, 8, 10, 12, 14, regular and petite).

SKU Sort Sequence Numbers

SKU sort sequence numbers are numbers used to determine the order in which SKUs sort.

You can use the sort sequence to display SKUs in a different order, such as by size, rather than alphanumerically by SKU code. See SKU Sort Sequence Numbers for an overview.

SKU Generator

The SKU Generator is used to create all the SKUs for an item automatically. Once you define the item and the SKU group, you can run the SKU generator to automatically build all the SKU records.

When generating SKUs for an item, you can accept the defaults as defined in the SKU Groups or you can add or subtract individual SKUs.

For more information about SKU elements, SKU groups and the SKU generator, see Setting up SKUs.

Note: Before you can work with SKUs, you must create the SKU information on the system. You can create SKUs by selecting Create at the Work with SKUs Screen.

Work with SKUs Screen

Purpose: Use this screen to create, change, delete and display related records for a base item.

How to display this screen: At the Work with Items Screen, select SKU for a SKUed item (the SKU field is selected).

Field

Description

Item

The item code and item description whose SKUs you are reviewing.

Item code: Alphanumeric, 12 positions; display-only.

Item description: Alphanumeric, 40 positions; display-only.

Colr (Color)

The color of the item/SKU.

Note: “Colr” represents SKU Element 1, which is user-defined at the System Control table. Color is used for sample purposes only.

Split SKU: alphanumeric, 4 positions; optional.

Size

The size of the item/SKU.

Note: “Size” represents SKU Element 2, which is user-defined at the System Control table. Size is used for sample purposes only.

Alphanumeric, 4 positions; optional.

Othr (Other)

The other characteristic of the item/SKU.

Note: “Othr” represents SKU Element 3, which is user-defined at the System Control table. Other is used for sample purposes only.

Alphanumeric, 4 positions; optional.

Description

The description of the SKU.

Alphanumeric, 40 positions; optional.

Color, Size, Width

The long SKU elements (L/S Color, L/S Size, L/S Width) used to further define the item, typically for reporting purposes.

Alphanumeric, three 4-position fields; optional.

Screen Option

Procedure

Create a SKU

Select Create to advance to the Create SKU 1 of 2 (With Overrides) Screen.

Change SKU information

Select Change for a SKU to advance to the Change SKU Screen. At this screen you can change any information except the SKU. See Create SKU 1 of 2 (With Overrides) Screen for field descriptions.

Delete SKU information

Select Delete for a SKU to delete it.

Note: If you delete a SKU, the following dependent tables are deleted:

• Item warehouse

• Kit/Kit details

• Lot

• Set/Set details

• SKU comments

• SKU offer

• Variable set/Variable set group/Variable set details

• Vendor item

• House list SKU

Display SKU information

Select Display for a SKU to advance to the Display SKU Screen. You cannot change any information on this screen. See Create SKU 1 of 2 (With Overrides) Screen for field descriptions.

Comments

Select Comments for a SKU to display the Work with Item/SKU Comments Screen.

Finished goods

Select Finished Goods for a SKU to display the Work with Finished Goods Screen.

External Image and Information Link

Select Image/Info Link for a SKU to advance to the Item Image/Info Link Screen.

Note: This option is available only if the Use External Item Image (L55) system control value is selected.

Offers

Select Offers for a SKU to advance to the Work with SKU Offers Screen.

Sets

Select Sets for a SKU to display the Work with Sets Screen.

UPC codes

Select UPC for a non-SKUed item to advance to the Work with UPC Codes Screen. You can work with UPC codes for a SKUed item by selecting SKU for the item and selecting the UPC option from the Work with SKUs Screen.

Work with user defined fields

Select User Fields for a customer to advance to the Work with User Fields Screen.

Variable Sets

Select Variable Sets for a SKU to display the Work with Variable Sets Screen.

Vendor Item

Select Vendor Item for a SKU to advance to the Work with Vendor Item Screen.

Warehouse

Select Warehouses for a SKU to display the Work with Item Warehouse Screen.

ME03_03 OROMS 17.0 2018 OTN