Version: eXtendPS-SE 1.4.36 and above
Audience: Administrator

Overview

The Order Status Notification (OSN) Service allows distributors to receive shipment information for their orders. This configuration maps fields from NetSuite sales order to the corresponding fields in the PromoStandards Order Status Notification API response.

Configuration

Go to eXtendTech → eXtendPS-SE → Order Shipment Setup and configure the fields as described below.

Image Placeholder

WSDL Mappings Section

  1. Sales Order ID - Sales Order number field in NetSuite. The recommended field is {tranid}.
    • Field IDs can be specified as {fieldIdA},{fieldIdB},{fieldIdC}… to include the first non-null field
    • A record join of createdfrom will be auto-applied
  2. Purchase Order ID - Customer Purchase Order number field in NetSuite. The recommended field is {otherrefnum}.
    • Field IDs can be specified as {fieldIdA},{fieldIdB},{fieldIdC}… to include the first non-null field
    • A record join of createdfrom will be auto-applied
    • Version 1.3.8+ will return "Not Specified" when no value exists during searches by Sales Order or timestamp
  3. Shipment Date - Shipment date field in NetSuite. The recommended field is {shipdate}.
    • Field IDs can be specified as {fieldIdA},{fieldIdB},{fieldIdC}… to include the first non-null field
    • You can source values from joined fields by using format "recordReference.fieldName" (e.g., "createdfrom.datecreated")
  4. Supplier Part ID - Supplier part ID field in NetSuite. The recommended field is {vendorname}.
  5. Supplier Product ID - Supplier product ID field in NetSuite. The recommended field is {vendorname}.
  6. Distributor Part ID - Distributor part ID field in NetSuite. The recommended field is {itemid}.
  7. Distributor Product ID - Distributor product ID field in NetSuite. The recommended field is {itemid}.
  8. Ship Method - Ship method field in NetSuite. The recommended field is {shipmethod}.
  9. Shipping Carrier - Shipping carrier field in NetSuite. The recommended field is {shipcarrier}.

Additional Configuration Section

  1. Saved Search ID - The internal ID of the item fulfillment saved search used to query orders within NetSuite. Configure your saved search to display only item fulfillment records applicable to PromoStandards.
  2. Package for Each Tracking Number - When enabled, tracking details for item fulfillments will be sent separately based on unique tracking numbers. When disabled, they will be consolidated under a single package with tracking numbers separated by commas.
  3. Validate Response - When enabled, the system will validate the data type of fields before returning the response.
  4. ShipMethod-Account Number Map - Provide mappings for your Ship Methods based on their respective shipping account numbers and corresponding locations. This information will be included in the API response.
    • Note: If the Location field is left blank, the mapping will return the same account number for all locations associated with that Ship Method.

Click Submit to save your modifications.

Frequently Asked Questions (FAQs)

Q: What happens if a field mapping is incorrect?
A: If a field mapping is incorrect, the API response may return empty or incorrect values. Ensure all field mappings accurately reflect your NetSuite configuration.

Q: Can I map multiple NetSuite fields to a single PromoStandards field? A: Yes, you can specify multiple field IDs in the format {fieldIdA},{fieldIdB},{fieldIdC} to include the first non-null field in the response.