Chapter 61: Updating SKU Offer Prices (MUSK)

Purpose: Use the Update SKU/Offer screen to create or update a SKU/offer price for specific SKUs of an item.

You might want to use this menu option instead of maintaining SKU/offer prices through Work with Item/SKUs, if your company contains items with many SKUs and you want to update multiple SKUs for multiple offers at one time.

The SKU/Offer price information you can update for a SKU’ed item is:

• effective date

• price quantity

• price of the SKU in the offer

• associate price of the SKU in the offer

• special handling flag

• special handling price

• special handling code

• tax inclusive price of the SKU in the offer

• tax inclusive associate price of the SKU in the offer

You can define SKU/offer prices for up to 10 offers at one time.

Number assignment: The SKU Quick Price Update Number number assignment allows more than one user to enter SKU/offer prices at one time. When a user creates a SKU/offer price, the system assigns the SKU/offer price the next number available for this number assignment. See Installation Chapter 23: Setting Up the Number Assignment File (WNUM).

If the item/offer exists: The system creates a SKU/offer using the item/offer information, except for the information you defined for the SKU/offer price.

If the item/offer does not exist: The system creates a SKU/offer using the following information:

• the value defined in the Gift Wrap Default (F07) system control value defaults to the Gift order field.

• the system defaults the Sale item field to N.

• the system defaults the Volume discount field to N.

• the system defaults the Column pricing field to N.

• the information you defined for the SKU/offer price

The system leaves any remaining fields blank.

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

In this chapter:

Update SKU/Offer Screen

Exclude SKU Offer Prices Screen

Update SKU/Offer Screen

Use this screen to create or update a SKU/offer price for specific SKUs of an item.

Defaulting active offers: If the Default Active Offers (J07) system control value is set to Y and you do not manually enter an offer in the Offer fields, the system defaults the 10 most recent active offers to the Offer field for the entered SKU’ed item: Offers have been defaulted - press Enter to update.

The offers default to the Offer fields in descending Start date sequence.

Note: The system does not default any offers until you enter a SKU’ed item, effective date, quantity, and price, and press Enter.

You must enter a SKU’ed item on the Update SKU/Offer Screen; however, you cannot enter a SKU code. Because of this, the system always defaults the 10 most recent item offers to the Offer fields.

• If the item is not assigned to 10 active item offers, the system defaults the available active offers assigned to the item. For example, if the item is assigned to 25 item offers, but only 8 item offers are active, the system defaults the 8 active item offers.

• If the item is assigned to more than 20 active item offers, the system evaluates the offer’s Start date to determine the 20 most recent active item offers to default.

• If active offers do not exist for the item, the Offer fields remain blank and you must manually enter offers in the Offer fields.

• If you update the Item and/or SKU field, the system will not update the defaulted offers.

• You can manually change a defaulted offer to another offer, even if the offer is a future offer or expired offer.

How to display this screen: Enter MUSK in the Fast path field at the top of any menu or select Update SKU Offer Prices from a menu.

INR1574 ENTER Update SKU/Offer 3/28/08 14:21:04

KAL Co.

Item: Description:

Effective Date: Quantity: Tax Inclusive Price:

Price: Associate Price: Tax Inclusive Assoc. Price:

Spec Hand (Y/N): N S/H Price: S/H Code:

Generate Item Out Triggers . . Y (Y/N)

COLOR

STYLE

SIZE

Offers

F3=Exit F12=Cancel

Note: The following message displays if you do not use split SKUs (the Split SKU Inventory system control value is set to N):

Menu option not valid in non-split SKU environment.

Field

Description

Item

A user defined code that represents an item. This is the item for which you wish to create or update SKU/offer prices.

An error message similar to the following displays if you enter a non-SKU’ed item in this field:

Invalid item - Item must be SKU’ed.

 

An error message similar to the following displays if you enter an item that is not associated with an item/offer:

Invalid item - Item/Offer must exist.

 

Item codes are defined in and validated against the Item file.

Alphanumeric, 12 positions; required.

Description

A description of the item.

This field updates when you enter an item code in the Item field.

Alphanumeric, 40 positions; display-only.

Effective date

The date the price or quantity break discount becomes valid. This date should be on or after the effective date of the offer.

If there are multiple effective dates for the same SKU/offer, the system uses the price associated with the effective date closest to, but not greater than, the order date.

Example: If there are effective dates of Feb. 20 and Mar. 31 and the customer placed an order on April 1, the customer receives the price associated with the effective date of March 31.

Numeric, 6 positions (MMDDYY format); optional.

Quantity

The amount of the item/SKU that the customer must order to receive the discounted (quantity break) price.

Numeric, 7 positions; required.

Tax inclusive price

The price at which the item will be sold in the specified offer(s) on orders subject to tax-inclusive pricing and VAT.

This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y. If so, the following message displays if you do not define a price in this field:

Tax Inclusive Price is required entry.

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

Price

The price at which the item will be sold in the specified offer(s) when the quantity and effective date are met.

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

Associate price

The price at which the item will be sold in the specified offer(s) to associate customers. 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.

Tax inclusive associated price

The price at which the item will be sold in the specified offer(s) to associate customers on orders subject to tax-inclusive pricing and VAT.

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

Spec. hand. (Special handling)

This value indicates whether this item is eligible for any type of special handling in this offer, such as monogramming or hemming.

Valid values are:

Y = This item is eligible for special handling. When you add this item to an order, the system advances you to another screen where you can define special handling instructions.

N (default) = This item is not eligible for special handling.

Alphanumeric, 1 position; required.

S/H price (Special handling price)

The price to charge the customer for special handling. You can specify in the Evaluate Special Handling Charges by Order Line (D67) system control value whether to add the price just once for each order line, or multiply the special handling price by the item quantity for the line.

An error message similar to the following displays if you define a special handling price and the Special handling field is set to N:

Special handling price not allowed when not eligible.

The following message displays if you enter a special handling price and you defined a custom special handling code in the Special handling code field:

Special handling charge not allowed with custom format code.

 

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

S/H code (Special handling code)

The additional charge code associated with the type of special handling you are offering for the item. The special handling can be either standard or custom; the system handles each type in a different way. See Customer Service Chapter 3: Establishing Additional Charge Codes (WADC) and Chapter 9: Establishing Custom Special Handling Formats (WSHF).

If you enter a special handling code here, you will advance to the Work with Special Handling Screen or Work with Custom Special Handling Screen automatically in order entry.

Alphanumeric, 2 positions; optional.

Generate item out triggers

Indicates whether to create an outbound interface transaction trigger for each 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 SKU’s. 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 SKU.

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

This field defaults to the 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.

SKU element 1

The name of SKU element 1, based on the value defined in the Split SKU Element Column 1 Heading (A34) system control value.

You can define up to 30 SKU element 1 codes for which you wish to create or update SKU/offer prices.

You can leave the SKU element 1 fields blank if you wish to update all of the SKU element 1 codes for the item.

Alphanumeric, thirty 4-position fields; optional.

SKU element 2

The name of SKU element 2, based on the value defined in the Split SKU Element 2 Column Heading system control value.

You can define up to 30 SKU element 2 codes for which you wish to create or update SKU/offer prices.

You can leave the SKU element 2 fields blank if you wish to update all of the SKU element 2 codes for the item.

Alphanumeric, thirty 4-position fields; optional.

SKU element 3

The name of SKU element 3, based on the value defined in the Split SKU Element 3 Column Heading system control value.

You can define up to 30 SKU element 3 codes for which you wish to create or update SKU/offer prices.

You can leave the SKU element 3 fields blank if you wish to update all of the SKU element 3 codes for the item.

Alphanumeric, thirty 4-position fields; optional.

Offers

The offers you wish to update with this SKU/offer price information. See Marketing Chapter 2: Working with Offers (WOFR).

You can create or update SKU/offer prices for up to 10 different offers at one time.

If the Default Active Offers (J07) system control value is set to Y and you do not manually enter an offer in the Offer fields, the system defaults the 10 most recent active offers to the Offer fields for the entered item. The offers default to the Offer fields in descending Start date sequence.

An error message similar to the following displays if you enter the same offer in more than one field: More than one offer A01 has been entered.

An error message similar to the following displays if you do not define at least one offer: At least one (1) Offer must be entered.

Alphanumeric, 3 positions; required.

Step-by-step instructions:

1. Complete each necessary field.

2. If you did not define specific SKU codes you wish to update, the system displays the following message: Press Enter to update ALL SKUs for Item.

3. Press Enter to update the SKU/offer price information, or press F3 or F12 to cancel.

4. If you pressed Enter, you advance to the Exclude SKU Offer Prices Screen, where you can exclude specific SKUs from being updated with this SKU/offer price.

Exclude SKU Offer Prices Screen

Purpose: Use this screen to exclude a specific SKU from being updated with the SKU/offer price you defined.

The system displays all of the valid SKU combinations for the item, based on the SKU codes you entered on the Update SKU/Offer Screen. For example, if you sell mittens in small, medium, and large and in many colors, but only defined the SKU small on the Update SKU/Offer screen, the system would show mittens only in size small in all of the available colors.

How to display this screen: Complete the Update SKU/Offer Screen.

INR1573 CHANGE Update SKU/Offer Exclusions 9/29/99 10:36:43

KAL Co.

Item . : MITTENS Quantity . . : 2

Description HOMEMADE MITTENS Price . . . : 12.00

Assoc. Price : 9.00

Offers: A01 B01

COLO STYL SIZE Exclude?

BLCK LRGE

BLCK MEDM

BLCK SMLL

BRN LRGE

BRN MEDM

BRN SMLL

GREY LRGE

GREY MEDM

GREY SMLL +

F3=Exit F9=Process F12=Cancel

Field

Description

Item

A user defined code that represents an item. This is the item for which you wish to create or update SKU/offer prices.

Item codes are defined in and validated against the Item file.

Alphanumeric, 12 positions; display-only.

Quantity

The amount of the item/SKU that the customer must order to receive the discounted (quantity break) price.

Numeric, 7 positions; display-only.

Description

A description of the item.

Alphanumeric, 40 positions; display-only.

Price

The price at which the item will be sold when the quantity and effective date are met.

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

Associate price

The price at which the item will be sold to associate customers.

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

Offers

The offers you selected on the Update SKU/Offer Screen. These are the offers for which you wish to create or update SKU/offer prices.

Alphanumeric, 3 positions; display-only.

SKU elements

The name of SKU elements 1, 2 and 3, based on the value defined in the Split SKU Element Column 1 Heading (A34) system control value.

The system displays the valid SKU combinations that are eligible for a SKU/offer price update, based on the SKU codes you defined on the Update SKU/Offer screen.

Alphanumeric, thirty 4-position fields; optional.

Exclude?

This field indicates whether you wish to exclude the valid SKU combination from creating a SKU/offer price.

Valid values are:

Y = Exclude this SKU combination from creating a SKU/offer price.

N or blank = Do not exclude this SKU combination from creating a SKU/offer price.

Alphanumeric, 1 position; optional.

Step-by-step instructions:

1. Enter Y next to the SKU combinations you wish to exclude from creating a SKU/offer price; otherwise, leave the field blank or enter N if you want to create a SKU/offer price for the SKU.

2. Press F9 to create the SKU/offer prices, or press F3 or F12 to cancel.

3. You return to the Update SKU/Offer screen, which displays a message similar to the following: Job 250029/KLETENDRE/SKU_PRCUPD submitted to job queue QBATCH in library.

Note: If you submit the job multiple times but change the setting of the Generate item out triggers flag before the previously submitted job is complete, the system displays an error message: Item out trigger gen opt set differently for submitted job - try again later. Once the submitted job has finished, you can resubmit it with the different item trigger setting.

You can view the SKU/Offer prices you created on the Work with SKU Prices screen in Work with Item/SKUs. See Chapter 27: Assigning Items/SKUs to Offers.

Note: If the effective date of the SKU/offer price you created matches the effective date of an existing SKU/offer price, the system replaces the existing SKU/offer price with the new SKU/offer price.

ME06_12 CWDirect 18.0 August 2015 OTN