Nalpac as a Source
Summary
Nalpac is a pre-built adult products and novelties distributor integration in Flxpoint. The connection uses a single connection type — Nalpac API authenticated with a Username and Password. The integration runs Get Inventory (Primary), Send Fulfillment Requests, and Get Shipments. For operation-level mapping guidance contact support@flxpoint.com.
Nalpac supports one connection type — direct API authentication with your Nalpac account Username and Password. Add a Nalpac source, start configuring an operation, and when Flxpoint prompts you click + New Connection, enter the values, then Test Connection → Save Connection.
GIP excludes discontinued items and zero-cost SKUs automatically
GIP calls Nalpac's API with excludeDiscontinued=true — discontinued products are never imported. Additionally, any item where WholesalePrice == 0 is excluded. If valid SKUs appear missing after GIP, check first whether the product is marked discontinued or has a zero WholesalePrice in Nalpac's system. Contact Nalpac to correct cost data if legitimate products are being excluded.
Send FR carrier and shipping method must match Nalpac's configuration exactly
The most common order rejection cause is a carrier name or shipping method mismatch — Nalpac returns errors like "Carrier name could not be found" or "Shipping method not found." Map your Carrier Name and Shipping Method to Nalpac's exact accepted values (confirm them with your Nalpac representative). Use a Mapping Set to translate internal codes to Nalpac's values.
Send FR supports partial acceptance — some lines may be rejected while others proceed
Nalpac may return a partial acceptance response for a single order: valid line items proceed while invalid lines (unrecognized SKU, zero quantity, etc.) are rejected. The job logs all request/response details to Job History. After submitting an order, review the job log to identify any rejected lines and their specific error messages before resubmitting.
Get Shipments: lookback by PO number, supports multiple tracking per order (comma-separated)
Get Shipments looks up shipments by the PO/FR Number. Multiple shipments may be returned for the same order (partial shipments). If Nalpac returns multiple tracking numbers, they are stored and displayed together. Schedule Get Shipments hourly or several times daily to capture new and partial shipment events. Archive on GIP only.
| Field | Maps To — Notes |
|---|---|
| Sku | → Product / Variant → SKU. Required. Primary identifier for the catalog item. |
| Name | → Product → Title. |
| Description | → Product → Description. Returned pre-stripped of HTML (Flxpoint requests stripDescriptionHTML=true). |
| WholesalePrice | → Pricing → Cost. Your Nalpac dealer price, saved as Cost. |
| Msrp / MinimumAdvertisedPrice | → Pricing → MSRP / MAP. |
| QuantityOnHand / AvailableQuantity | → Inventory → Quantity. Available units. |
| Weight / Height / Length / Width | → Shipping → Dimensions & Weight. |
| Manufacturer / ManufacturerNumber / Upc | → Identifiers → Brand / MPN / UPC. |
| Categories | → Product → Category / Subcategory. Nalpac's Parent > Child category string is split into two levels. |
| Attributes | → Product → Attributes. Each Nalpac attribute name/value pair is copied as a product attribute. |
| Image (matched by SKU from Nalpac's image feed) | → Product / Variant → Images. |
| Discontinued / Sellable | → Variant → Custom Fields (discontinued, sellable, stored as Y/N). Note: Flxpoint also requests Sellable=true and excludeDiscontinued=true server-side, so discontinued/non-sellable items are normally filtered out before they reach Flxpoint at all. |
| Source Field | Maps To (Nalpac) — Notes |
|---|---|
| Fulfillment Request Number | → ExternalOrderNumber. Required. Also used to check for an existing order before sending, to prevent duplicates. |
| PO Number | → PoNumber. Used together with the FR date to validate against an existing Nalpac order. |
| Order Date | → OrderDate. Sent as yyyy-MM-dd'T'HH:mm:ss.SSSXXX; falls back to the current date/time if the source date can't be formatted. |
| Carrier Name | → resolved against Nalpac's carrier list to determine the Nalpac Shipping Option. Required — must match a Nalpac carrier name (case-insensitive) or the order fails before it's sent. |
| Shipping Method | → resolved against the matched carrier's ShippingOptions[].Description to determine the Nalpac Shipping Option ID. Required — must match exactly (case-insensitive). |
| Shipping address (Name, Address1–3, City, State, Zip, Country) | → ShippingAddress. Required. |
| Ship-to phone / email | → ShipToPhoneNumber / ShipToEmailAddress. Optional. |
| Delivery instructions | → DeliveryInstructions. Optional. |
| Fulfillment Request line → SKU / Quantity / Unit of Measure | → CreateOrderRequestLines[].Sku / Quantity / UnitOfMeasure. Sku and Quantity required per line. |
| Field | Maps To — Notes |
|---|---|
| Package → TrackingNumber | → Shipment → Tracking Number. Required — only packages with a tracking number are imported. |
| Package → ShipDate | → Shipment → Shipped At. |
| Order-level Carrier | → Shipment → Carrier. |
| Order-level OrderNumber / PoNumber | → cross-referenced back to the originating Purchase Order / Fulfillment Request in Flxpoint. |
| Package → Items[].Sku | → Shipment Item → SKU. Required. |
| Package → Items[].Quantity | → Shipment Item → Quantity. Required. |
| OrderNotes (if present) | → Shipment → Note. |