Version: eXtendPS-SE 1.4.1 and above
Audience: Administrator

Overview

The getProductSellable() call from Product Data 1.0.0/2.0.0 retrieves your entire product catalog with a single call, allowing distributors to access your complete product catalog. However, in some NetSuite accounts, the search may time out if the number of products or items is too high for your NetSuite service tier. It's advisable to test this service before going live.

You can retrieve full responses or limited responses. For instance, you can choose to retrieve only 10,000 items instead of returning all products and parts.

Configuration

To configure the Product Data service's getProductSellable response, go to the Product Data Setup page at eXtendTech → eXtendPS-SE → Product Data Setup and open the "Product Sellable Service" subtab.
Image Placeholder

Field Descriptions

  1. Product is Sellable - Field ID in NetSuite that indicates if the product is sellable.
  2. Part is Sellable - Field ID in NetSuite that indicates if the product part is sellable.
  3. Product Search Limit - The maximum number of products to show in the product sellable service response.
  4. Kit Part Search Limit - The maximum number of kit/package part items to show in the product sellable service response.
  5. Other Part Search Limit - The maximum number of other part items to show in the product sellable service response.
  6. Cache Sellable Response - Enable this preference to send the getProductSellable response from the eXtendPS-SE Product Data Sellable Cache record. See Sending Product Data Service Responses from Cache for more information.
  7. Cache Sellable Page Size - The page size that will be used while fetching the items to be cached.
  8. Cache Sellable Max Item Search Limit - The maximum number of items which will be cached and to return in the product sellable service response.

Frequently Asked Questions (FAQs)

Q: How do I specify the Product Is Sellable and Part Is Sellable fields?
A: These fields can be specified using hardcoded values or multiple-field values. You can set the value with a hardcoded value such as "text:true" to indicate that all products being returned are sellable. The value can also be specified in the format fieldID1,fieldID2,fieldID3 to return the first non-null field in the response.

Q: Are Functional Mappings supported for fields in the Product Sellable Service?
A: No, Functional Mappings aren't supported for fields in the Product Sellable service.

Q: What are the search limit fields used for?
A: The Product Search Limit, Kit Part Search Limit, and Other Part Search Limit fields are available to optimize the performance of the searches.