Field

Description

Item

A user-defined code the represents a unit of inventory.

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

Alphanumeric, 12 positions; optional.

SKU

The unique characteristics of an item, such as color, style, or size.

Alphanumeric, 14 positions; optional

Ofr

The code for the catalog, space, or advertisement in which you sell merchandise. See Working with Offers (WOFR).

Alphanumeric, 3 positions; optional.

Description

The description of the item.

Alphanumeric, 40 positions; display-only

Field

Description

Item

The code and description of the item for which you are uploading item/SKU offer information.

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

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

SKU

The code and description for the SKU of the item for which you are uploading item/SKU offer information.

SKU code: Alphanumeric, three 4-position fields; display-only.

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

Offer

The code and description of the offer for which you are uploading item/SKU offer information. See Working with Offers (WOFR).

Offer code: Alphanumeric, 3 positions; display-only.

Offer description: Alphanumeric, 30 positions; display-only.

Action code

This code identifies whether the item/offer upload is a change to an existing item/offer in CWSerenade or a new item/offer in CWSerenade.

Valid values are:

A = This item/offer upload creates a new item/offer in CWSerenade.

C = This item/offer upload changes an existing item/offer in CWSerenade.

Alphanumeric, 1 position; required.

Effective date

The date the price becomes valid.

This date should be equal to or greater than the start date of the offer, and equal to or less than the stop date of the offer. If you leave this field blank, the effective date of the offer defaults.

Numeric, 6 positions (MMDDYY); optional.

Price

The price at which the item will be sold in this offer, if no discounts are applied, and the order date is equal to or greater than the effective date.

You can establish multiple effective dates and prices for the same item/offer.

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

Associate price

The price at which the item will be sold in this offer to associate customers. Associate price is used when the Associate field on the order is selected (yes) and the order date is equal to or greater than the effective date.

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

Page number

The primary page number on which the item appears in the offer. This assignment is used for reporting purposes, such as in the Offer Page Analysis Report (OPAR).

Numeric, 5 positions; optional.

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 table. See Working with Projection Curves (WCRV).

Numeric, 3 positions; optional.

Expected return %

The percentage of returns you expect to receive for the item/offer. Used for forecasting projections and other reports (such as the inventory status and projection report).

Example:

3.5 = 3.50%

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

Special handling

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

Selected = This item is eligible for special handling.

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

If this field is selected and there is a default special handling code defined (see below), OR if you specify special handling for an item in order entry, you advance to the Work with Special Handling Screen or the Work with Custom Special Handling Screen; however, if the special handling code’s:

• Suppress S/H window field is selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is selected: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by selecting Handling for the item.

See Special Handling Overview for more information.

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 indicates if you define a special handling price and the Special handling field is unselected:

Special handling price not allowed when not eligible.

The following message indicates 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 system validates that the additional charge code is defined as special handling, with a Type of standard or custom; the system handles each type in a different way. See Special Handling Overview for more information.

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; however, if the special handling code’s:

• Suppress S/H window field is selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

• Bypass S/H field is selected: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by selecting Handling for the item.

See Special Handling Overview for more information.

Alphanumeric, 2 positions; optional.

Gift wrap

Indicates whether gift wrapping is available for this item.

If you leave this field blank, the system defaults the Default “Gift Order” Flag (D14) system control value.

Selected = This item can be gift wrapped.

Unselected = In this offer, gift wrapping is not available for this item.

G/W price (Gift wrap price)

The price in this offer for gift wrapping the item. The G/W field must be selected to indicate that this item is eligible for gift wrap. The gift wrap price will be charged for each unit of this item that is gift wrapped.

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

Freight

The freight amount to be charged for this item. Multiplied by the quantity ordered. Used only if you selected By Item or Flat Rt/Item as the Freight method for the source code.

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

Hidden freight

Used only with item level freight methods, such as: Flat Rt/Item, Flat Rt/Qty, Flat Rt/Itm Src, 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 from the Division table. Hidden freight is also known as “theoretical” or “buried” freight.

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

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:

Selected = This is a sale item.

Unselected (default) = This is not a sale item.

If the Exclude Sale Item When Prorating Discounts (I65) system control value is selected, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. See the system control value for more information.

Volume discount

Indicates whether this item is eligible for an end-of-order discount that will be applied when you accept the order during Order Entry.

Selected = The item/SKU is eligible for the volume discount.

Unselected = The item/SKU is not eligible for the volume discount.

How Volume Discounting Works

If the Item Volume Discount is enabled, the system will:

• total the number of units ordered of volume-discountable items

• check the quantity break price table in the SKU/offer for the discount price for each discountable item

Example: the system calculates the volume discount for items A123 and C123, as if the customer purchased 12 units of each item.

Cost

The cost to include the item in the offer. Used in square inch analyses and offer page analyses, such as the Offer Page Analysis Report (OPAR), and used in calculations to determine item contribution and profitability.

Numeric, 11 positions with a 4-place decimal; optional.

Square inches

The square inches (not the percentage) that the item occupies on the catalog page or in the offer.

Used to calculate the profitability of the item on the page.

Numeric, 3 positions; optional.

Coupon discount $ (Coupon discount dollars)

Represents the amount that is subtracted from the price when the item/SKU is ordered from this offer.

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

Coupon expiration date

The date the coupon expires.

Numeric, 6 positions (MMDDYY format); optional.

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. Used for reporting purposes such as in the Inventory Status & Projection Report (ISRP).

Numeric, 7 positions; optional.

Feature/option

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.

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:

Feature = Item is the featured item in the depiction.

Option = Item is an optional item in the depiction.

Optional.

Pickup/new

Indicates whether the item has been carried over from a previous offer or is new to your product offerings.

Valid values are:

Pickup = Item is a pickup item, previously sold in another offer.

New = Item is a new addition in this offer.

Optional.

Warranty

Defines whether the item in this offer is a warranty item.

Valid values are:

Selected = The item in this offer is a warranty item. When an operator adds this item to an order in order entry or order maintenance, the system adds the item to the order at no charge.

Unselected = The item in this offer is not a warranty item.

If the Default Price Override Reason for Warranty Items (G01) system control value contains a price override reason code, the system defaults this code to the Price override code field, otherwise the operator must enter a code.

Required reason code

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. When you specify an add reason code for an item, there is a record of the add reason code stored in an order line history record, available for review at the Display Order Line History Screen.

Valid values are:

• selected = The item in this offer requires an add reason code when the item is added to an order in order entry or order maintenance. The Enter Add Reason Window opens when an operator adds this item to an order in order entry or order maintenance.

• unselected = The item is this offer does not require an add reason code when the item is added to an order in order entry or order maintenance.

Note: When the item is added automatically to an order through the order API, the add reason code is not required. For example, an item might be added to an order automatically if it is set up as a free gift by source code.