Version: eXtendPS-DE all versions
Audience: Administrator, User

The getProductSellable() function in Product Data versions 1.0.0 and 2.0.0 is currently not supported in eXtendPS-DE. This is because the payload size and processing requirements often exceed NetSuite governance limits.

To use this workaround, you will need:

• Access to PromoStandards Web Service Validator or SoapUI
  
• Vendor PromoStandards endpoint credentials (username and password)
  

Workaround Steps

You can query the getProductSellable() function directly using the PromoStandards Web Service Validator, SoapUI, or other SOAP-based API testing tools:

1. Navigate to the PromoStandards Web Service Validator
   
2. Select "Product Data" for Web Service, choose Version "1.0.0" or "2.0.0" based on vendor support, and select Operation "getProductSellable"
   
3. Enter the vendor's endpoint
   
4. Complete the Request Body with these required fields:
   

• wsVersion: 1.0.0 or 2.0.0 depending on the endpoint version
  
• id: vendor username
  
• password: vendor password
  
• localizationCountry: US
  
• localizationLanguage: en
  
• productId: can be removed
  
• partId: can be removed
  
• lineName: can be removed
  
• isSellable: true
  

Here is a sample request format:

<GetProductSellableRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/">
   <wsVersion xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">2.0.0</wsVersion>
   <id xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">username</id>
   <password xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">password</password>
   <localizationCountry xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">US</localizationCountry>
   <localizationLanguage xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">en</localizationLanguage>
   <isSellable xmlns="http://www.promostandards.org/WSDL/ProductDataService/2.0.0/SharedObjects/">true</isSellable>
</GetProductSellableRequest>

Click "Validate" to send the request. The Response Body will contain the sellable productId and partId from the vendor endpoint.

Q: Will this feature be supported in eXtendPS-DE in the future?
A: We are evaluating workarounds for NetSuite governance limits and considering the getProductSellable() request as a potential enhancement for future releases.