Version: eXtendPS-SE 1.4.2 and above
Audience: Administrator
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.
To configure the service:
- Go to eXtendTech → eXtendPS-SE → Product Pricing Setup.
- Complete the fields of the General
Field Mappings section as follows:
- Product ID*
Select the field that contains the main item ID.
The recommended field for this is{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.
The recommended field for this is{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. - Fill the fields of the Part Field Mappings section as follows:
- Part ID*
Select the field that contains item's part ID.
The recommended field for this is{itemid}
- Description
Field on the part item that specifies the part's description.
The recommended field for this is{salesdescription}
- Default Part Field
Field on the part item that determines if a part is included in the “Basic Pricing Configuration” service price. - Specify the Pricing Field Mappings as follows:
Note: 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 requirement.There are three more fields related to the price level mapping listed below which are required to be completed: - 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. - Fill the fields of Currency Field Mappings subtab as follows:
In this mapping, you will have to map your NetSuite currencies to the PromoStandards API currencies. You can provide multiple currency mappings as per your requirements. - Complete the Decoration Charges Mappings subtabas follows:
- 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 subtabfields
- Location level fields
- Imprint
Location ID Field – Imprinting location ID.
- Imprint
Location Field*– Imprinting location name.
- Decorations
Included Field* - Number of decorations included in the price.
- Is
Default Location Field* - Determines if the mentioned imprinting location is 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 location-based on supplier experience.
- Decoration
level fields
- Decoration
Id Field - Decoration
ID.
- Decoration
Geometry Field* - Shows the shape of decoration.
- Decoration
Name Field – Name of
decoration.
- Decoration
UOM Field* - Unit of
measure of 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 subtab fields - 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
basis.
- Charge Per Color Field – Charge of decoration per color
basis.
- 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.
- Complete the Additional Configuration subtab as
follows:
- 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.