KS_PRICE_ADJS

Ordinal

Data Description

Y

XREF lookup

Y

This is an identifying code for the overall Matrix. It is used in conjunction with the "Combine with Group Code" field when multiple discounts can be taken or when one matrix group requires the presence of another. If your ERP system does not have this concept which would be used here, you should choose a matrix group code that may reflect the type of matrix. For example, a matrix based on specific customer part price group may be called "CUST-PPG".

This field updates the order of precedence for the types being used. It is only updated if a new adjustment type is created automatically (above). The precedence is a numeric order, which is used to apply the applicable discount/markups. Note: The storefront looks for applicable discount/markups by type precedence until one is found. Aggregate discounts/markups are not supported.

The date this price adjustment was or will be in effect

Even if there is no ending date to this discount/markup, a future date should be sent (e.g. 01-01-3000)

The price UOM should be populated only when the price or discount applies to this UOM only (may be a contract price)

"Y" || "N"

Set to 'Y' if this is a contract price which is taken regardless if there is better price available

If this price matrix can be combined with other matrices, a group code can be supplied in this field which indicates that this matrix can be combined with any other applicable matrix which shares the same group code.

If the markup or discount is based on a specific price sheet instead of using the price sheet directly associated to the customer, an override price sheet can be specified in this field. Example: USA, STOREnn, BRANCHnn

If the markup or discount is based on a different basis within the price sheet instead of using the basis associated to the customer, an override price basis can be specified in this field. Example: LIST, WHOLESALE, MSRP, COST

If this matrix has either a maximum number of units or dollars that can be taken by any given customer over the period the matrix is effective, a quantity can be entered in this field. Whether the quantity entered represents a maximum number of units or maximum dollar amount is based on field "Disc Basis".

"Y" || "N"

Future Field Not used currently

Future Field Not used currently

A=Amount
U=Units
M=Measure (UOM)

Determines if volume discounting is based on (A)mount of the order, or (U)nits ordered

Y

This minimum quantity or amount that must be purchased on a given order to qualify for the price

The maximum quantity or amount that can be purchased to receive this price before moving to the next volume price level. Typically, the last volume range max value is set to an extreme level that is not typically purchased (e.g. 999,999). The price calculation does not assume the last range is infinite so if this is not done the customer may revert to a higher price.

This field is the formula to use for marking up or discounting the price. The formula is applied to the base price list and basis. The following expressions are supported:

$$nn.nn - Fixed price of nn.nn

G%nn.nn - Gross Margin of nn.nn%

+$nn.nn - Add amount of nn.nn

-$nn.nn - Subtract amount of nn.nn

+%nn.nn - Add a percentage markup of nn.nn%

-%nn.nn - Subtract a percentage discount of nn.nn%

/$nn.nn - Divide by amount of nn.nn

*$nn.nn - Multiple by amount of nn.nn

Note: Multiple expressions can be specified in the formula using a pipe (|) delimiter.

The Group Code(s) used by this Matrix are declared in this field. When determining the price of items in the store, the Group Code names are matched against the Group Code(s) related to either the Customer or the Item being purchased to determine eligibility. Coordination of the Group Code names must be a consideration between the Matrix Group Codes sent in the KS_CUSTOMERS export and the KS_MFG_ITEMS export. If a group code name of "CUST_ID" is sent as part of the KS_CUSTOMERS export and the group code used for a given matrix is called "CUST_NO" they will not match.

This is the FROM value for the associated Group Code. When comparing the value of a matching Group Code value for a Customer or Item, it is checking that the value falls between the range of values (FROM & TO) for the Matrix. Typically, the FROM value and TO Value are the same for exact matches (EQUAL) but if there is a range of values, an ASCII Sort order is assumed so it is necessary to manipulate the FROM/TO values in order for accurate comparison.

This is the TO value for the associated Group Code. It is used in conjunction with the FROM Value above to handle ranges. For example, if a Matrix is only allowed for a specific zip code range, a Group Code of "ZIP" may have a From value of "92000" and a TO value of "92999". A Customer that has a group of "ZIP" with a value of "92123" would qualify. East Coast zip codes which begin with "0" should not be suppressed in order for range comparisons to work. If an exact match on value is needed (i.e. no range) then this value can be the same as the From value or left blank.

Y

"Y" || "N"

An entry of "Y" in this field indicates that the price matrix will define the discount levels but each Item related to this price matrix will define the actual quantity break levels for which to receive the discounts. Refer to KS_MFG_ITEMS specification with respect to "Min/Max Break Quantity".

Y

"Y" || "N"

A Y in this field indicates that the override basis code for this matrix should be determined based on the Item's category. The pricing system will use the local override basis code for the matrix and replace it with the basis code from the item_category. See KS_CATEGORY export specification.

Y

"STD" || "SRP"||"CPN"

Identifies the type of price adjustment. The value 'STD' is the default and indicates that this is a standard matrix that is considered for an individual product. The type of 'SRP' indicates a special matrix for sum & reprice which happens at checkout by aggregating products of the same sum and reprice group together before determining volume discount breaks. The type 'CPN' indicates a coupon which will not display while browsing but will be applied at checkout time. This type matrix is typically defined internal to KommerceServer rather than from the back office. If the back office supports this type of matrix, you should refer to the Coupon Required and Coupon Key companion fields in this export.