Field

Description

From offer

The offer from which the information will be copied. This must be a valid offer in the Offer file. See Marketing Chapter 2: Working with Offers (WOFR).

Alphanumeric, 3 positions; required.

To offer

The offer to which the information will be copied. This must be a valid offer in the Offer file.

Alphanumeric, 3 positions; required.

Item class(es)

The item class(es) from which the information in the “from” offer will by copied. Each must be a valid item class in the Item Class file; see Chapter 5: Working with Item Classes (WICL).

You can maintain item/SKU offers by item class through Working with Offer Overrides by Item Class (WSOI).

Alphanumeric, ten 3-position fields; optional.

Update SKU and item offers

This value defines whether the system updates existing item/SKU information in the "to" offer with the copied information in the "from" offer.

Valid values are:

N (default) = Existing item/SKU information in the "to" offer will not update with the copied information in the "from" offer.

Y = Existing item/SKU information in the "to" offer will update with copied information in the "from" offer.

Example:

Item "Sunglasses" exists in offers 1 and 2.

In offer 1, the price of the sunglasses is $10.00 and in offer 2 the price of the sunglasses is $20.00.

If you are copying information from offer 2 to offer 1 and this field is set to Y, the price in offer 1 will update to $20.00.

If this field is set to N, the price will not update and only new information will copy to offer 1.

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

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.

Note: Each of the field descriptions below describes the information that will be copied from the "from" offer to the "to" offer if the field is set to Y.

Page number

The item/SKU page numbers in the "from" offer. Valid values are:

N = In the "to" offer, the item/SKU page numbers will not change.

Y (default) = Item/SKU page numbers in the “to” offer will default the Page number defined in the “from” offer.

Alphanumeric, 1 position; required.

Expected return

The percentage of returns you expect to receive for the item/offer. This field is used for forecasting projections and other reports (such as the Inventory Status & Projection Report (ISRP)).

Example:

3.5 = 3.50%

Valid values are:

N = In the "to" offer, the expected return percentage will not change.

Y (default) = Item/SKUs in the “to” offer will default the Expected return % defined in the “from” offer.

A (actual) = Use the actual return percentage from the “from” offer as the expected return percentage for the “to” offer. You will have the opportunity to adjust the return percentage higher or lower from the “to” offer’s actual return; see Entering Adjustment Percentages.

Alphanumeric, 1 position; required.

Cost

The cost to include the item/SKU in the offer. Cost is used in square inch analyses and offer page analyses. This value is used in calculations to determine item contribution and profitability.

Y (default) = The items will carry the same cost from the "from" offer to the "to" offer.

N = In the “to” offer, the Cost for the items will not be changed.

Alphanumeric, 1 position; required.

Freight

The freight amount to be charged for this item. The value in this field will be multiplied by the quantity ordered. This value is used only if Freight by item or Flat Rate by item has been chosen as the Freight method for the source code.

Valid values are:

N = In the "to" offer, the freight amount will not change.

Y (default) = Item/SKUs in the “to” offer will default the Freight defined in the “from” offer.

Alphanumeric, 1 position; required.

Square inches

The square inches (not the percentage) that the item occupies on the catalog page or in the offer. This value is used to calculate the profitability of the item on the page. Valid values are:

Y (default) = The items in the "to" offer will have the same square inches as the items in the "from" offer.

N = In the “to” offer, the Square inches for the item will not be changed.

Alphanumeric, 1 position; required.

Sale item

Indicates whether the item is on sale. This flag controls whether to generate a sale credit when the customer returns the item, based also on the payment method and the setting of the Generate Sale Credit for Orders with Sale Items (I64) system control value. Valid values are:

Y (default) = The items in the "to" offer will have the same Sale item setting as the items in the "from" offer.

N = In the “to” offer, the Sale item setting for the item will not be changed.

If the Exclude Sale Item When Prorating Discounts (I65) system control value is set to Y, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. Also, if both this system control value and the Apply Loyalty at the End of Order (J35) system control value are set to Y, then sale items do not receive a loyalty discount. See these system control values for more information.

Alphanumeric, 1 position; required.

S/H (Special handling)

This item is eligible for any type of special handling in this offer (such as, monogramming, hemming, etc.).

Y (default) = The items in the "to" offer will have the same special handling as the in "from" offer.

N = In the “to” offer, the Special handling field for the items will not be changed.

Alphanumeric, 1 position; required.

Coupon discount

This value represents the amount that is subtracted from the price when the item/SKU is ordered from this offer. Valid values are:

Y (default) = The items in the "to" offer will have the coupon discount amount as in the "from" offer.

N = In the “to” offer, the Coupon discount $ (Coupon discount dollars) for the items will not change.

Alphanumeric, 1 position; required.

S/H code (Special handling code)

A code that represents the type of special handling that is required for this item. If you enter a special handling code, during Order Entry a pop-up window appears. When this item is ordered, you can specify the quantity ordered, a special handling charge (if different), and special handling instructions. Valid values are:

Y (default) = The items in the "to" offer will have the same special handling codes as in the "from" offer.

N = In the “to” offer, the S/H code (Special handling code) for the items will not change.

Alphanumeric, 1 position; required.

Projected units

The number of units of this item that you expect to sell in the offer. You enter this forecasting value manually; the system does not update this field. This value is used for reporting purposes such as in the Inventory Status & Projection Report (ISRP). Valid values are:

Y (default) = The items in the "to" offer will have the same projected units as in the "from" offer.

N = In the “to” offer, the Projected units for the items will not change.

A (actual) = Use the actual unit quantity ordered from the “from” offer as the projected units for the “to” offer. You will have the opportunity to adjust the return percentage higher or lower from the “to” offer’s actual unit quantity ordered; see Entering Adjustment Percentages.

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.

Y (default) = The items in the "to" offer will have the same special handling price as in the "from" offer.

N = In the “to” offer, the S/H price (Special handling price) field for the items will not be changed.

Alphanumeric, 1 position; required.

Curve code

A code that represents the item's expected selling pattern in this offer. This code is used by the forecasting system for inventory projection and analysis reporting. Validated against the Projection Curve file. See Marketing Chapter 26: Working with Projection Curves (WCRV). Valid values are:

Y (default) = The items in the "to" offer will have the same curve code as in the "from" offer.

N = In the “to” offer, the Curve code for the items will not be changed.

Alphanumeric, 1 position; required.

G/W (Gift wrapping)

A value that indicates whether items can be gift wrapped.

Y (default) = The items in the "to" offer will have the gift wrap flag set the same way as in the "from" offer.

N = In the “to” offer, the Gift wrap flag for the items will not be changed.

Alphanumeric, 1 position; required.

Hidden freight

This value is used only with item level freight methods, such as: Flat rate by item, flat rate by item quantity, flat rate by item source, and by item.

Hidden freight represents the portion of the item's catalog price that is used for freight. You might define a hidden freight value when the freight charge to ship the item is very high. The hidden freight charge is included in the price of the item so the actual freight charge is not visible to the customer.

The hidden freight amount is subtracted from the catalog price of the item when gross profit is calculated and sales are posted. The amount of freight is posted to a separate G/L number, which is defined in the Division file. Hidden freight is also known as "theoretical" or "buried" freight. Valid values are:

Y (default) = The items in the "to" offer will have the same hidden freight amount as in the "from" offer.

N = In the “to” offer, the Hidden freight amount for the items will not be changed.

Alphanumeric, 1 position; required.

G/W price (Gift wrapping price)

The price in this offer that will be charged to gift wrap this item. The G/W field must contain a Y to indicate that this item is gift wrap-eligible. The gift wrap price will be charged for each unit of this item that is gift wrapped. The system will multiply this charge by the order quantity for the item.

Y (default) = The items in the "to" offer will have the same gift wrapping price as in the "from" offer.

N = In the “to” offer, the G/W price (Gift wrap price) for the items will not be changed.

Alphanumeric, 1 position; required.

Volume discount

This value indicates whether this item is eligible for an end-of-order discount that will be applied when you accept the order during Order Entry. See Item Volume Discounting. Valid values are:

Y (default) = The items in the "to" offer will have the same volume discount setting as in the "from" offer.

N = In the “to” offer, the Volume discount field for the items will not be changed.

Alphanumeric, 1 position; required.

SKU price

The price at which the item/SKU will be sold in this offer. Valid values are:

Y (default) = The items in the "to" offer will have the same SKU price as in the "from" offer.

N = In the “to” offer, the Price field for the items will not be changed.

If the Tax Included in Price (E70) system control value is set to Y, the message *Includes Tax price* displays next to this field. This message indicates that both the offer price and the tax-inclusive price will be copied if you set the SKU price flag to Y.

Alternate currency price: If the Use Alternate Currency Pricing (H89) system control value is set to Y the system calculates an alternate currency price using the conversion rate defined for the offer and the local price defined for the item. If a conversion rate is not defined for the “to” offer, indicating the “to” offer is in the local currency, the system does not calculate an alternate currency price. See Customer Service Chapter 12: Using Alternate Currency Pricing for an overview and required set up.

Alphanumeric, 1 position; required.

Associate price

The price at which the item will be sold in this offer to associate customers. A customer pays the associate price when the Associate flag on an order is set to Y. Valid values are:

Y (default) = The items in the "to" offer will have the same associate price as in the "from" offer.

N = In the “to” offer, the Associate price field for the items will not be changed.

If the Tax Included in Price (E70) field in the System Control file is set to Y, the message *Includes Tax Price* displays next to this field. This message indicates that both the offer associate price and the tax-inclusive associate price will be copied if you set the Associate price flag to Y.

Alphanumeric, 1 position; required.

Coupon effective date

The date the coupon becomes effective. Valid values are:

Y (default) = The items in the "to" offer will have the same coupon effective date as in the "from" offer.

N = In the “to” offer, the Coupon effective date for the items will not be changed.

Alphanumeric, 1 position; required.

Warranty

This field defines whether the item in this offer is a warranty item.

Valid values are:

Y (default) = The items in the "to" offer will have the same warranty setting as in the "from" offer.

N = In the “to” offer, the Warranty field for the items will not be changed.

Alphanumeric, 1 position; optional.

Feature/option

This value indicates whether the item is considered a featured or optional item in a depiction. A depiction is a photograph or drawing of several items within an offer. The featured item is the focus of the depiction; whereas, the optional items are less prominently displayed. For example, if a dining room is depicted, the dining room set may be the featured item and the individual place settings, crystal, and centerpiece may be the optional items. Valid values are:

Y (default) = The items in the "to" offer will have the same feature/option setting as in the "from" offer.

N = In the “to” offer, the Feature/option field for the items will not be changed.

Alphanumeric, 1 position; required.

Required reason

This field defines whether an Order addition reason code is required when the item in this offer is added to an order in order entry or order maintenance. Valid values are:

Y (default) = The items in the "to" offer will have the same required reason setting as in the "from" offer.

N = In the “to” offer, the Required reason code for the items will not be changed.

Alphanumeric, 1 position; optional.

Pickup/new

This value indicates whether the item has been carried over from a previous offer or is new to your product offerings. Valid values are:

Y (default) = The items in the "to" offer will have the same pickup/new setting as in the "from" offer.

N = In the “to” offer, the Pickup/new field for the items will not be changed.

Alphanumeric, 1 position; optional.