Version: eXtendPS-DE 1.3.7 and above
Audience: Administrator

Use Case

  • Update purchase prices from PromoStandards automatically on a scheduled basis.

Update Purchase Price with Workflows

For automatic updates to your PromoStandards item purchase prices through workflows, refer to the Automated Pricing Update Using NetSuite Workflow article for configuration instructions.

Update Purchase Price with Map/Reduce Script

For automatic updates of your PromoStandards item purchase prices via a Map/Reduce script, refer to the following instructions.
  1. Go to the Map/Reduce script "eXtendPS-DE Custom Integration".
  2. If one does not already exist, create a new script deployment.
  3. In script parameters for the deployment, specify the following parameters:
    1. EXTENDPS-DE USER INTEGRATION NAME
      Specify refresh_item_price as the integration name.
    2. EXTENDPS-DE CUSTOM MAPPING INTEGRATION SEARCH
      Specify a saved search id for the PromoStandards items to be considered during the update.

      Note: If no saved search id is specified, the default saved search "eXtendPS-DE Custom Mapping Items[B]" will be used.
    3. Leave other fields empty.
      Image Placeholder
  4. Schedule the deployment as per your requirement.

Additional Notes

  • The lowest price using the "Customer" Price Type and "Blank" Configuration Type will be used when updating.
  • Configuration Type can be customized using the workflow parameters.
  • If the Purchase Price in PromoStandards is returned as zero, it will not be updated.
  • If you have a Fob Point specified during item constitution, it will use the specified fob point on the item during the pricing update, otherwise, it will use the first available fob point in the PromoStandards response.