Version: eXtendPS-SE 1.4.15 and
above
Audience: Administrator
Overview
The Product Pricing and Configuration
Service must be
configured before it can be made available
to Distributors. The
configuration maps fields from the
NetSuite item object to the corresponding
fields in the PromoStandards API
response.
Configuration
To configure the
service:
- Go to eXtendTech → eXtendPS-SE → Product Pricing Setup.
General
Field Mappings
- Product ID *
Specify the field that contains the main item ID.
Recommended field:{itemid}
- Location *
Enter the field on the item that shows the location to use for the product pricing.
See Configuring Multiple Locations and FOB Points for more information regarding this field's configuration.
Recommended field:{location}
- Validate
Response
This setting controls whether to validate a field's data type before returning the response.
See Perform Promostandards Services XML Response Validation for more information.
Part Field Mappings
- Part ID *
Specify the field that contains item's part ID.
Recommended field:{itemid}
- Description
Specify the field on the item part that specifies the part's description.
Recommended field:{salesdescription}
- Default Part
Field
Specify the field on the item part that determines if a part is included in the “Basic Pricing Configuration” service price. - Part GroupSpecify a numeric field on the item part that identifies the part group that it is a part of. This field is a numeric identifier grouping mutually exclusive parts together. If not specified, eXtendPS-SE will default to "1".
- Part Group RequiredSpecify a check box field on the item part that identifies if the part is required in the part group. If set to checked/true, a selection in the partGroup is required for ordering. If not specified, eXtendPS-SE will default to "true".
- Part Group Description
Specify a field on the item part that contains a description of the partGroup. Examples: “Main Product”, “Optional Lid”, “Straw”, etc. If not specified, eXtendPS-SE will default to the field mapped to Description above.
Pricing Field Mappings
There are two sublist in this
subtab: One for Quantity UOM
Mapping and one for Price Level Mapping.
Quantity UOM
Mapping
In
this mapping, select your
NetSuite unit value which
represents the PromoStandards
unit value. You can
provide multiple quantity UOM
mappings as
per your requirements.
Price
Level
Mapping
In
this mapping, select your
NetSuite price level which
represents the
PromoStandards price type.
You can provide multiple
price level mappings as
per
your requirements.
- Discount Code Field
This field will determine the offered industry discount code. The eXtendPS-SE Industry Discount Code{custitem_extend_promo_ind_code}
field is included in eXtendPS-SE if an existing field does not already exist. - Price Effective Date Field
This field will determine the price effective date of the product. If no value is populated, the last modified date will be considered as price effective date. The eXtendPS-SE Price Effective Date{custitem_extend_promo_api_price_effctv}
field is included in eXtendPS-SE if an existing field does not already exist. - Price Expiry Date Field
This field will determine the price expiry date of the product. If no value is populated, next year’s date after today will be considered as the price expiry date. The eXtendPS-SE Price Expiry Date{custitem_extend_promo_api_expry_effctv}
field is included in eXtendPS-SE if an existing field does not already exist. - Repeat Discount Code Field
This field will determine the offered repeat discount code. The eXtendPS-SE Repeat Industry discount code{custitem_extend_promo_repeat_dc}
field is included in eXtendPS-SE if an existing field does not already exist. - Repeat Price Field
Field on the item that contains the repeat price of the item. The eXtendPS-SE Repeat Price{custitem_extend_promo_repeat_price}
field is included in eXtendPS-SE if an existing field does not already exist. - Exclude Quantity
Header 0
Prices
This checkbox determines whether to return the quantity 0 pricing header in the response or not. - Show Qty0 Prices as 1
for
Main
Items
This checkbox determines whether to return the quantity 0 pricing header as quantity 1 in the response or not. - Sort Pricing Quantity
Header
Specify whether the quantity pricing is returned in ascending or descending order.
Currency Field Mappings
In this
mapping, you will map
your NetSuite currencies to
the PromoStandards API
currencies. You can provide
multiple
currency mappings as per
your requirements.
Decoration Field Mappings
- Saved Search ID for
Decoration*
A Decoration Upcharges saved search will filter all the upcharges and item decoration configuration details for the main item. You will have to create a saved search against your decoration configuration record to populate the required pricing and configuration details. - IMC Group for
Decoration
Imprinting group reference in the imprint configuration custom record. - IMC Group for
Item
Imprinting group reference on the item. - Main Item Reference
Field
Id
Main item reference field/column id in the saved search.
Imprint
and Decoration
Mappings
Location level
fields
- Imprint
Location ID
Field
Imprint location ID. - Imprint
Location
Field*
Imprint location name. - Decorations
Included
Field*
Number of decorations included in the price. - Is
Default
Location
Field*
Determines if the imprinting location is the default location or not. - Max
Decoration
Field*
Maximum number of decorations that can be imprinted. - Min
Decoration
Field*
Minimum number of decorations that are required. - Location Rank
Field
Field showing the value of popularity of the imprint location - based on supplier experience.
Decoration
level
fields
- Decoration
Id
Field
Decoration ID. - Decoration
Geometry
Field*
Shows the shape of the decoration. - Decoration
Name
Field
Name of the decoration. - Decoration
UOM
Field*
Unit of measure for the decoration area. - Allow
Sub for
Default
Location
Field*
Determines that buyer can substitute a decoration location without changing the price or not. - Allow
Sub for
Default Method
Field*
Determines that buyer can substitute a decoration method without changing the price or not. - Item
Quantity Less
Than Minimum
Field
Absolute minimum quantity that can be ordered without a Less Than Minimum (LTM) charge. - Decoration
Height
Field
Height of decoration to be imprinted. - Decoration
Width
Field
Width of decoration to be imprinted. - Decoration
Diameter
Field
Diameter of decoration to be imprinted. - Decoration
Units Included
Number of decoration units included. - Decoration
Units Included
UOM
Field
Unit of measure for included decoration units. - Max Decoration
Units
Field
Maximum number of decoration units that can be done on the product for decoration/location combination. - Lead
Time
Field
Required lead time for the given decoration work. - Rush
Lead Time
Field
Required lead time for the given decoration work in case of rush service. - Default
Decoration
Field
Determines whether the given decoration is default decoration for a location.
Product Data 2.0
Fields
- Maximum Imprint
Colors
Maximum number of imprint colors available based on decoration location and type. - Includes
Price
Checkbox field on the imprint configuration record which determines whether prices of the decoration(s) are included in the item price or not.
Decoration
Charges
Mappings
To create
decoration charge
mappings, select
the charge type and
specify the item field
reference against
it.
Decoration
Charges
Mappings
- Decoration
Charge
Description
Field*
Decoration charge description on IMC record. - Decoration
Charge
Name
Field*
Decoration charge name on IMC record. - Decoration
Charge Id
Field*
Decoration charge ID on IMC record. - Charge
Per
Location
Field
Charge of decoration per location. - Charge
Per Color
Field
Charge of decoration per color. - Is
Charge
Applied If
Ordered
Less Than
Minimum
Field*
Charge applied if order is less than minimum. - Exclude
Quantity
Header 0
Prices
This checkbox determines whether to exclude quantity 0 price of charge items from the service response or not. - Show Qty0
Prices as 1
for Charge
Items
This checkbox determines whether to return quantity 0 pricing header as quantity 1 in the response or not. - YMINQTY FOR CHARGE
PRICES
Field containing minimum y-value quantity for the price. - Charge Type → Item
Field
ID Reference
Mapping
Decoration Charge type with Item field containing that charge type price mapping.
Additional
Configuration
- Additional Item Search
Column
Additional item search columns required for functional mappings.
Note: Add additional item search columns in a comma-separated format. - Product Search
Filters
This field works in conjunction with the Product ID field's value. The field specified will be used for filtering the items for creating a pricing and configuration response. The field specified in the Product ID field will be used for displaying the item name in the response.
If this field is left empty, then the field specified under Product ID field will be used for both filtering and showing the item name in the response. See How to remove parent name from part name in PromoStandards responses? for more information on this field. - Part Search
Filters
This field works in conjunction with the Part ID field's value. The field specified will be used for filtering the items for creating a pricing and configuration response. The field specified in Part ID field will be used for displaying the item name in the response.
If this field is left empty, then the field specified under Part ID field will be used for both filtering and showing the item name in the response. See How to remove parent name from part name in PromoStandards responses? for more information on this field. - Part Max Search
Limit
Specify the maximum number of parts which will be sent in the response. - Item Pricing Max Search Limit
Specify the maximum number of item pricing details which will be sent in the response.Note: If you are using quantity pricing and there are five quantity pricing columns, if you specify the maximum part search limit as 2 then your item pricing max search limit must be 2x5 i.e. 10 to show all pricings in the response. - Charge Item Pricing Max Search Limit
Specify the maximum number of charge item pricing details to be sent in the response.Note: If there are three charge items present on your item record, and all of them are using quantity pricing with 5 columns and you specified maximum part search limit as 2, you must specify this value as 3x5x2 (i.e. 30). - Exclude Item
Types
Select any item types to exclude from the product pricing response. - Group Non-Matrix
Parent
Enable this checkbox if you have non-matrix items with a parent. When checked, upon searching for a pricing and configuration response using a non-matrix parent item, it will provide the pricing and configuration details for all child items linked with the parent item. - Always Group Matrix
Parent
IMCs
Enable this checkbox if you want to return IMC records present on the matrix parent item's IMC group in the response. By enabling this feature, the IMCs in the IMC group applied on the child item will be returned along with the IMCs of the IMC group applied on the parent item in the response when a child item is searched for a decorated pricing response. If this feature is not enabled, only a child item's IMC group's IMCs will be returned in the response when child item is searched for decorated pricing response.