Version: eXtendPS-DE 1.3.2 and above
Audience: Administrator

Use Case

  • You have an item mapped to your vendor who supports PromoStandards Product Data versions 1.0.0 and 2.0.0.
  • To keep your item fields up-to-date, you can periodically update them using metadata from PromoStandards. For instance, you may need to inactivate a closeout item.

Overview

eXtendPS-DE enables you to update item data in real-time from the PromoStandards feed suppliers provide. This ensures that you can keep your NetSuite items synchronized with the data available in PromoStandards.

Prerequisites

To take advantage of this feature, you will need to ensure that your items are constituted using eXtendPS-DE, or that you have linked your items with the supplier's items. For more information on linking items, see Linking Existing NetSuite Items to PromoStandards via Map/Reduce Script.

Configuration Details

To update your linked NetSuite items from the PromoStandards feed, follow the steps below.

  1. Create new mapping records using a unique integration name (an integration name that is different from the one already being used with existing eXtendPS-DE mappings). Please see Creating eXtendTech Field Mapping Records for Item Constitution for more details on mapping record creation.

  2. Create a new saved search containing items which you want the mapping to be executed.

  3. The item data mappings from #1 and the items from #2 will be the records and fields which will be processed.

  4. Perform the update using a custom workflow.

    Note: If the volume of items is high, or you have many script and workflow customizations, skip to step #5.

    1. Create a copy of the bundled workflow eXtendPS-DE Custom Integration[B], and add any additional criteria as per your requirements.

    2. Specify the saved search created in step #2 as scheduled criteria for the workflow.

    3. In the custom workflow action eXtendPS-DE Custom Item Integration, specify values under the following parameter fields as per the details below:
      1. eXtendPS-DE Custom User Integration Name - Enter the integration name from step #1 in this field. This will be used for creating integration logs records which will be generated when your item record is updated from PromoStandards.

      2. eXtendPS-DE Custom Field Mapping Integration Name - Enter the integration name from step #1 in this field. Field mappings specified with this integration name will be executed to update the item records from PromoStandards.
    4. Upon execution of this workflow, all the items as per the saved search from #2 will be updated as per the mappings from #1.

  5. Update using Map/Reduce script (use this approach if workflow approach does not meet your requirements).
    1. Go to the eXtendPS-DE Custom Integration Map/Reduce script.

    2. Create a deployment of the script.

    3. Specify the script level parameters:
      1. eXtendPS-DE User Integration Name - Enter the integration name which will be used for creating script logs.

      2. eXtendPS-DE Field Mapping Integration Name - Enter the integration name from step #1 in this field. Field mappings specified with this integration name will be executed to update the item records from PromoStandards.

      3. eXtendPS-DE Custom Mapping Integration Search - Specify the saved search from step #2.

      4. eXtendPS-DE Custom Mapping Search Limit - Specify the mappings search limit. Specify -1 if you don't want to specify any limit.
    4. Schedule this deployment if you want it to be executed on scheduled basis as per your requirements.

    5. If you want to execute it in real-time, do not schedule the deployment and instead choose the Save & Execute option.

    6. Upon execution of this Map/Reduce script, all the items as per the saved search from #2 will be updated as per the mappings from #1.