Version: eXtendPS-SE 1.4.1 and above
Audience: Administrator

Use Cases

  • Avoid timeout errors when fetching all sellable products with the getProductSellable() function.
  • Reduce the response time when fetching the getProductSellable() function response.

Overview

To avoid timeout errors when fetching all sellable products using the getProductSellable() function, and to reduce response time, eXtendPS-SE allows you to cache the getProductSellable() response in your NetSuite account and use the cached data in the response.

Creating the getProductSellable() Cache Record

The Map/Reduce script eXtendPS-SE Cache Sellable Product Data can be scheduled to generate and update the eXtendPS-SE Product Data Sellable Cache custom record. This record stores the response of the getProductSellable() function. Follow the steps below to create the scheduled script deployment:

  1. Go to Customization → Scripting → Scripts and find the script named eXtendPS-SE Cache Sellable Product Data.


  2. There are two existing script deployments for Product Data 1.0.0 and Product Data 2.0.0 that you can use to generate the eXtendPS-SE Product Data Sellable Cache custom record in real-time using the Save and Execute option.


  3. To create a scheduled script deployment, click Deploy Script on the Map/Reduce script record.


  4. Provide the necessary information regarding the deployment, including log level, status, and scheduling details based on your specific requirements and save the script deployment.

    1. In the EXTENDPS-SE PRODUCT DATA SERVICE NAME script parameter, specify the version of the Product Data service to be cached.

      1. For Product Data 1.0.0, enter: product data 1.0.0
      2. For Product Data 2.0.0, enter: product data 2.0.0

  5. Once the script has been executed, an eXtendPS-SE Product Data Sellable Cache custom record will be created. The name of the record will be either product data 1.0.0 or product data 2.0.0 depending on the associated version.
    Image Placeholder

Enable the Product Sellable Cache

Once cache records have been generated/scheduled, next, you will enable the cache for use.
  1. Go to eXtendTech → eXtendPS-SE → Product Data Setup.
  2. Open the Product Sellable Service subtab.
  3. Enable the "Cache Sellable Response" checkbox.
    Image Placeholder