3 Pricing Codes and Descriptions

The following Merchandising codes are used to manage some of the dropdowns and options in Pricing. The details on how each are used is described below. Some of these codes allow new values to be added, while others only allow you to configure certain options off or update descriptions and translations. To configure any of these options, you'll need to use the Merchandising Codes and Descriptions spreadsheet download and upload functionality. This includes updating the terminology used for these codes, marking those that you are not using, as well as updating or adding any translations. You can find details on how to access and use the spreadsheet upload for Codes and Descriptions in the Merchandising Implementation Guide.

Clearance Codes

Code Type	Code Type Description	Notes	Add New Allowed?
CLCT	Pricing Application - Clearance Change Types	Used to determine the valid discount types for clearance markdowns - Percent Off, Amount Off, Fixed Price or Reset. This code type provides the options available to a user in the dropdowns when creating markdowns in the Pricing UI or the spreadsheet upload. You could indicate one or more codes as not used to hide the values in your implementation. Note: one of the values for this code type is Exclude. That is used only systematically when an item/location needs to be excluded from a price event due to conflicts. This will not normally be visible as a change type to users, but it is visible when using the spreadsheet upload method. If a user chooses that value for upload, an error will be raised.	No
CLIV	Pricing Application - Clearance Item Levels	Used to determine the valid item levels for creating clearance markdowns - Item, Parent/Diff, Upload List, Item List, or Item Parent. This code provides the options available to a user in the dropdowns when creating markdowns in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation. Note: code type 4 - Item Parent is used for backend processing only and is not displayed in the UI.	No
CLLI	Pricing Application - Clearance Location Levels - Induction	Used to provide a user-friendly description of the location type for users to select when downloading and uploading clearances using a spreadsheet, as well as through the web service or batched upload - Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide a value in your implementation.	No
CLLL	Pricing Application - Clearance Location Levels	Used to provide options for location type when creating clearance events in the Pricing screens. Valid values are Zone, Store, Warehouse, or Location List. You could indicate one or more codes as not used to hide the values in your implementation.	No
CLSI	Pricing Application - Clearance Statuses - Induction	Used to provide a user-friendly description of the status for a clearance markdown for users to select when downloading and uploading clearances using a spreadsheet, as well as through the web service or batched upload. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could result in errors when downloading existing clearance events.	No
CLST	Pricing Application - Clearance Statuses	Indicates the valid values for status for clearance markdowns. Used for display in the clearance UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors.	No
CMRC	Pricing Application - Clearance Reasons	Indicates the valid reason codes for a clearance markdown. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric.	Yes
MKDN	Pricing Application - Clearance Markdowns	Indicates the valid markdown numbers for a clearance markdown (e.g. First, Second, Final, and so on). This code is expected to be updated for your implementation to add new codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric.	Yes

Price Change Codes

Code Type	Code Type Description	Notes	Add New Allowed?
PCCT	Pricing Application - Price Change Change Types	Used to determine the valid change types for regular price changes - Change by Percent, Change by Amount, Fixed Price, Reset POS, or Multi-Unit Fixed Price. This code provides the options available to a user in the dropdowns when creating price changes in the Pricing UI or the spreadsheet upload. You could indicate one or more codes as not used to hide the values in your implementation. Note: one of the values for this code type is Exclude. That is used only systematically when an item/location needs to be excluded from a price event due to conflicts. This will not normally be visible as a change type to users, but it is visible when using the spreadsheet upload method. If a user chooses that value for upload, an error will be raised.	No
PCIL	Pricing Application - Price Change Item Levels	Used to determine the valid item levels for creating regular price changes - Item, Parent/Diff, Upload List, Item List, and Item Parent. This code provides the options available to a user in the dropdowns when creating price changes in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation. Note: code type 4 - Item Parent is used for backend processing only and is not displayed in the UI.	No
PCIM	Pricing Application - Price Change Impacts to Multi Unit Retail	Used to indicate the impact of a price change on the multi-unit retail of an item. The value selected on a price change help determine the workflow for the pricing analyst, as well as the intended behavior if no multi-unit pricing information is added for a price change. Valid values are Add or Update, Remove, or No Change.	No
PCLI	Pricing Application - Price Change Location Levels - Induction	Used to provide a user-friendly description of the location type for users to select when downloading and uploading price changes using a spreadsheet, as well as through the web service or batched upload - Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide the values in your implementation.	No
PCLL	Pricing Application - Price Change Location Levels	Used to provide options for location type when creating price changes in the Pricing screens. Valid values are Zone, Store, or Warehouse. You could indicate one or more codes as not used to hide the values in your implementation.	No
PCRC	Pricing Application - Price Change Reasons	Indicates the valid reason codes for a regular price change. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric.	Yes
PCSI	Pricing Application - Price Change Statuses - Induction	Used to provide a user-friendly description of the status for a regular price change for users to select when downloading and uploading price changes using a spreadsheet, as well as through the web service or batched upload. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could result in errors when downloading existing price events.	No
PCSS	Pricing Application - Price Change Statuses	Indicates the valid values for status for price changes. Used for display in the price change UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors.	No

Promotional Offer Codes

Code Type	Code Type Description	Notes	Add New Allowed?
IBOT	Pricing Application - Promotion Item Buy/Get Offer Templates	Used to determine the valid offer templates for promotional item-level offers of type Buy/Get: Buy X, Get Discount Buy X, Get Discount Spend X, Get Discount Buy X, Get Y for Discount Spend X, Get Y for Discount Buy X of Single Item for Discount Buy X and Y, Get Discount Buy X and Y, Get Z for Discount These codes provide the options available to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
IGOT	Pricing Application - Promotion Item Gift with Purchase Offer Templates	Used to determine the valid offer templates for promotional item-level offers of type Gift with Purchase: Buy X, Get Gift with Purchase Spend X, Get Gift with Purchase These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
IOTP	Pricing Application - Promotion Item Offer Types	Used to determine the valid offer types for promotional item-level offers when creating offers in the Pricing UI: Simple Discount Buy/Get Gift with Purchase You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
ISOT	Pricing Application - Promotion Item Simple Offer Templates	Used to determine the valid offer types of promotional item-level offers of type Simple Discount: Get Y for Discount These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. There is one code for this type - Get Y for Discount. You could indicate this code as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
OFCT	Pricing Application - Promotion Offer Change Types	Indicates the valid discount types for promotional offers - Percent Off, Amount Off, or Fixed Price. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions. This code is only used in the system options screen to determine the default values.	No
OFDR	Pricing Application - Promotion Offer Distribution Rules	Indicates how the selling solution should apply the discount on a customer's purchase for certain item-level offer types - Buy Items, Get Items, or Both Buy and Get Items. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions. Note: Xstore does not support using this indicator from Pricing. Therefore, when implementing with Xstore all but the "Get Items" option should be turned off.	nO
OFII	Pricing Application - Promotion Offer Item Levels - Induction	Indicates the valid item levels for inclusion or exclusion that can be used when uploading promotional offers from an external source or from a spreadsheet. These item levels are used for both the conditions and rewards part of the offer, where applicable. If any of these levels cannot be used for your implementation because your POS or OMS cannot interpret the data, then you can choose to mark those levels as not used. For example, if your POS doesn't have information on the valid suppliers for an item, you may need to hide the Supplier Site/Brand option. Valid values are Department (1), Class (2), Subclass (3), Parent/Diff (5), Item (6), All Departments (8), and Supplier Site/Brand (11).	No
OFIL	Pricing Application - Promotion Offer Item Levels	Indicates the valid item levels for inclusion and exclusion on promotional offers. This list is used for both the buy conditions and the get conditions as part of the offer creation. If any of these levels cannot be used for your implementation because your POS or OMS cannot interpret the data, then you can choose to mark those levels as not used. For example, if your POS doesn't have information on the valid suppliers for an item, you may need to hide the Supplier Site/Brand option. Valid values are Department (1), Class (2), Subclass (3), Item Parent (4), Parent/Diff (5), Item (6), Item List (7), All Departments (8), Upload List (10), and Supplier Site/Brand (11). Note that Item Parent is used only in backend processing.	No
OFLI	Pricing Application - Promotion Offer Location Levels - Induction	Indicates the valid location types that can be used when uploading promotions from an external source or from a spreadsheet. Valid values are Store (0) or Zone (1).	No
OFLV	Pricing Application - Promotion Offer Levels	Indicates the valid levels that offers can be created - Item or Transaction. Note: this code is used primarily for the labels on the screen, so setting the used flag to No doesn't impact how it is displayed.	No
OFRC	Pricing Application - Promotion Offer Cancel Reasons	Indicates the valid reason codes for an offer cancellation. This code is expected to be updated for your implementation to add new reason codes that are applicable for your business. The default codes provided as part of the initial installation can also be renamed to better suit your business. All new codes added must be numeric.	Yes
OFTI	Pricing Application - All Promotion Offer Templates - Induction	Lists all the valid offer templates supported by pricing for display in the spreadsheet download/upload function.	No
OPRO	Pricing Application - Promotion Offer Price Restriction Operators	Indicates the valid operators that can be used when defining a price restriction as part of the item qualifier criteria on an offer. Valid values are Less than, Greater than, or Between. You could indicate one or more codes as not used to hide the values in your implementation if price restrictions are not fully supported by your selling solutions.	No
PRAT	Pricing Application - Promotion Offer Applies To Values	Contains the options for which types of items an offer applies to: Regular, Clearance, or Regular and Clearance.	No
PRST	Pricing Application - Promotion Offer Statuses	Indicates the valid values for status used for promotional offers. Used for display in the promotion UIs. You could indicate one or more codes as not used to hide a value, but it is not recommended as it could lead to errors.	No
TBOT	Pricing Application - Promotion Transaction Buy/Get Offer Templates	Used to determine the valid offer templates for promotional transaction-level offers of type Buy/Get: Buy X, Get Discount Spend X, Get Discount These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
TOTP	Pricing Application - Promotion Transaction Offer Types	Used to determine the valid offer types for promotional transaction-level offers - Simple Discount or Buy/Get. These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No
TSOT	Pricing Application - Promotion Transaction Simple Offer Templates	Used to determine the valid offer templates for promotional transaction-level offers of type Simple Discount Get Discount These codes provide the available options to a user in the dropdowns when creating promotional offers in the Pricing UI. You could indicate one or more codes as not used to hide the values in your implementation if not supported by your selling solutions or not a desirable offer type.	No

Other Pricing Codes

Code Type	Code Type Description	Notes	Add New Allowed?
CLCA	Pricing Application - Clearance Cadence	Indicates the options for adding markdowns to a clearance group - either as a single markdown (S) or using a template (T).	No
MKUT	Pricing Application - Markup Types	Indicates the options for markup type used by Pricing. Valid values are Cost (0) and Retail (1).	No
RPMT	Pricing Application - Template Types	Indicates the valid template types for configuring spreadsheets to use for download and upload of Price Changes and Clearances. It is not recommended that these be updated.	No
RTCA	Pricing Application - Template Categories	Indicates the valid template categories for configuring spreadsheets to use for download and upload of Price Changes and Clearances. It is not recommended that these be updated.	No
YIND	Pricing Application - Yes or No Indicator	Used to decode values of Yes or No for more user-friendly display in spreadsheets or UIs, as these are held as numeric values in the database.	No