Version: eXtendPS-DE 1.3.6 and above
Audience: Administrator
eXtendPS-DE provides the ability to link your existing NetSuite items with PromoStandards. A Map/Reduce script is included to execute the linking process. More information about this script is provided below:
eXtendPS-DE Link Items Map Reduce Script
Parameters
1. eXtendPS-DE Items Saved Search
This saved search id will be used as input for the linking process as to which items are going to be targeted for linking.
This saved search id will be used as input for the linking process as to which items are going to be targeted for linking.
Note: this saved search should not contain parent items.
2. eXtendPS-DE Item Link Mail Receiver
A summary email will be sent to the specified email address after the linking process is complete.
A summary email will be sent to the specified email address after the linking process is complete.
3. eXtendPS-DE Items Link Field Map
A map in JSON format for fields and other information to be used by the Map/Reduce script during the linking process.
A map in JSON format for fields and other information to be used by the Map/Reduce script during the linking process.
productId:
Specifies the field id for the productId (e.g. parent.vendorcode)
color:
Specifies the color field id
size:
Specifies the size field id
promoPartId:
Specifies the part id
field in the child item (e.g. vendorcode)
matchPartId:
If true, then NetSuite
Items are matched by their respective promoPartId whose value is given by the field specified in promoPartId. promoPartId must not be empty.
inputLength:
Used to specify the number of
records to be considered for linking.
Matching
Rules
Matching NetSuite items to PromoStandards is done using two rules:
1. Matching by the item’s color and size.
2. Matching by the item’s part id.
When matching an item by its color and size, the item linking field map uses the following fields: productid, inputLength, color, and size.
When patching an item by its part id, the
item linking field map uses the following fields: productid, inputLength, promopartid, color, and size.
Note: If your NetSuite account has the multiple vendors feature enabled and there are multiple vendors defined for an item, the preferred vendor will be used when linking the item to PromoStandards.
Link with Specific Vendor for Product Data 2.0 and Product Pricing and Configuration
To link an item with a specific PromoStandards vendor so that you can refresh your linked item with vendor-specific Product Data 2.0 and Product Pricing and Configuration information, the field values below will need to be populated on your existing item records to be used in the PromoStandards refresh process:
eXtendPS-DE Vendor
eXtendPS-DE vendor for the item.
eXtendPS-DE Product Id
The vendor's Product Id for the product.
eXtendPS-DE Product Part Id
The vendor's Part Id for the product.
eXtendPS-DE Product FOB value
The vendor's FOB value.
eXtendPS-DE Product FOB ID
The vendor's FOB Id.