Nalpac as Source

Nalpac is a premier distributor of adult products and novelties, delivering quality merchandise and timely shipments. Integrated with Flxpoint, Nalpac streamlines inventory updates and order processing for effortless management. This guide offers a comprehensive overview to help you efficiently retrieve and map shipment data from Nalpac's API.

 

How to Connect

📋 Phase 1: Create Your Source in Flxpoint+
Open Sources
Log into Flxpoint and go to Sources.
Add a Source
Click Configure Single Source (or + Add Source) to start a new source.
Basic Details
Enter vendor name and fulfillment preferences, then click Save.
Open Integrations
Go to Integrations → Get Inventory (Primary). If you see “No integrations…”, click Start Creating Integrations.
🔐 Phase 2: Select & Set Up the Nalpac Integration+
Choose the Integration
From Custom or Standard Integrations, select Nalpac to open the connection form.
Create the Connection
In New Nalpac Connection (or Edit), provide:
  • Connection Name
  • Username
  • Password
If your Nalpac setup requires extra fields (e.g., endpoint or token), complete those as instructed.
Test & Save
Click Test Connection. When valid, click Save Connection.
⚙️ Phase 3: Configure Settings & Mapping+
Settings
On Configure Settings, choose whether to enable Archive/Un-Archive Inventory.
How it works: Items missing from Nalpac’s feed are archived in Flxpoint. If they return, they are automatically un-archived and updated.
Define a Mapping Template
Create or select a Nalpac Mapping Template for Get Inventory (Primary). Map:
  • SKU
  • Quantity
  • Price
  • Title/Description
Apply any needed transformations, then click Save & Complete.
✅ Phase 4: Activate & Verify+
Activation
Your Nalpac Get Inventory integration is now active. Flxpoint will fetch inventory on your schedule.
Verification
Monitor the initial run in Fulfillment Sources → Integrations. Confirm expected SKUs/quantities appear in your catalog.

 

 

Product Operations

The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates.

Get Inventory (Primary)

Supported | Nalpac — Get Inventory (Primary)

Introduction
Get Inventory (Primary) (GIP) imports Nalpac catalog data (products, variants, quantities, pricing) into Flxpoint. The job retrieves pages from GET /api/product (Nalpac v2) and saves results to your Global Inventory Pool.
Important: Discontinued items are now excluded using excludeDiscontinued=true. Items with a WholesalePrice of $0 are also excluded from import to prevent unusable records.

This job keeps your Nalpac catalog in sync with Flxpoint:

  • Imports products/variants, quantities, brand, categories, and primary images.
  • Applies exclusions for discontinued products and zero-cost items.
  • Updates your inventory records for downstream channels.

  • 1Authenticate — Use your Nalpac API key; ensure any IP allowlisting is configured if required.
  • 2Fetch Products — Calls GET /api/productV2?pageNumber=<n>&pageSize=<n>&modifiedAfter=<iso>&excludeDiscontinued=true.
  • 3Paginate — Flxpoint iterates pages (recommend ≤100–250 items per page depending on limits).
  • 4Apply Exclusions — Skip records where discontinued=true or WholesalePrice == 0.
  • 5Map Fields — Source fields are mapped to your template (see table below).
  • 6Save Inventory — Data is written to the Global Inventory Pool.
Example: If a SKU appears with WholesalePrice: 0, it will be skipped. If a SKU is marked discontinued=true, it will not be imported.

  • 1Connect Integration — Select Nalpac as your Source and enter API credentials.
  • 2Configure Settings
    • Page Size — 100 is safe; adjust if you encounter rate limits.
    • Archive/Un-Archive Inventory — Enable if this is your only job archiving for this source.
  • 3Create Mapping Template — Map SKU, Quantity, Brand, Categories, Price fields, etc.
  • 4Save & Schedule — Run manually or schedule (UTC).

Recommended minimum mappings for reliable imports:

Flxpoint Field Nalpac Source Why It’s Needed
SKU sku Unique identifier for product matching.
Title name Human-readable product title.
Quantity quantityOnHand Controls available stock in Flxpoint.
Brand manufacturer Consistent brand labeling.
Categories categoryLevel1..3 (if provided) Organizes your catalog for channels.
Image URL images[0].url Primary product image.
Weight / Dimensions weight, width, height, depth Shipping calculations and listings.
Cost WholesalePrice Nalpac’s API uses WholesalePrice as the cost field.
Records with WholesalePrice = 0 are excluded from import.
Internal cost tracking and margin calculations.
MSRP / Price msrp, price (if available) Pricing for channels and reporting.

  • Discontinued Exclusion — The job calls Nalpac with excludeDiscontinued=true to omit discontinued items.
  • Zero-Cost Exclusion — Items where WholesalePrice == 0 are not imported.
  • Customer Guidance — If valid items appear with WholesalePrice = 0, contact Nalpac to correct cost data. As a fallback, consider Do Not Import rules for specific SKUs.

  • Missing products? Confirm they aren’t discontinued and don’t have WholesalePrice = 0.
  • Zero quantities? Verify source quantities and mapping to Quantity.
  • Auth failures? Re-check API key and any IP allowlisting.
  • Rate limits/slow imports? Reduce page size and schedule off-peak hours.
  • Audit — Review job logs to confirm exclusions and page-by-page imports.

Schedule this job daily (or more frequently if needed) to keep your catalog up to date. All schedules run in UTC.

 
 

 

 

Order Operations

It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring an integration between order processing and shipment tracking.    

Send Fulfillment Requests

Supported | Nalpac — Send Fulfillment Requests (Primary)

Introduction
Send Fulfillment Requests (Primary) submits purchase orders (POs) to Nalpac using POST /api/order. After submission, Nalpac may acknowledge, reject, or partially accept the order if any lines are invalid.
Heads up: Ensure your carrier and method values match Nalpac’s configuration. Mismatches commonly trigger responses like "Carrier name could not be found" or "Shipping method not found".

  • Posts a PO payload to https://api.nalpac.com/api/order.
  • Validates order-level details and line items (SKU, quantity, etc.).
  • Checks for carrier and method mapping accuracy before finalizing.
  • Receives acknowledgements, partial acceptances, or rejections from Nalpac.
  • Logs all request/response details to Job History for auditing.

  • 1Prepare PO — Build the order JSON from your mapping template (order + lines).
  • 2Endpoint Check — Nalpac validates that the PO can be created/processed. If not recognized, an error is returned.
  • 3Carrier & Method Matching — Ensure your Carrier Name and Shipping Method map to Nalpac’s values; otherwise you’ll see carrier/method errors.
  • 4Post Order — Send POST to /api/order; capture the response including any line-level messages (e.g., “option ID could not be found”).
  • 5Auto Acknowledgements — Nalpac often returns PushItem-style confirmations indicating accepted/rejected lines.
  • 6Schedule — Run on-demand or on a cadence that fits your order-processing flow.
Example: An order may be partially accepted if one line contains an unrecognized SKU, while the remaining valid lines proceed.

Each Flxpoint field maps to a Nalpac API field using one of these modes:

  • Don’t Map — Ignore the field.
  • Set to Empty — Force a blank value.
  • Field — Copy from a Flxpoint field (e.g., Fulfillment Request NumberExternalOrderNumber).
  • Value — Provide a fixed value (e.g., “Dropship”).
  • Mapping Set — Use a predefined translation list (e.g., internal ship codes → Nalpac codes).
  • Rules — Conditional logic (e.g., “If Carrier = FedEx, Method = Ground”).
Key Fields to Map
1) Order-Level
Flxpoint Field Nalpac Field Notes
Fulfillment Request Number ExternalOrderNumber Unique PO identifier; if not recognized, Nalpac may reject.
Order Date OrderDate Optional but recommended.
PO Number PoNumber Map if you use a separate internal PO reference.
Packing Slip / Delivery Instructions DeliveryInstructions If unsupported by Nalpac, set to Don’t Map or Set to Empty.
Order Notes Note General text; often optional.
Signature Required SignatureRequired Use only if supported; otherwise Don’t Map.
2) Shipping & Carrier
Flxpoint Field Nalpac Field Notes
Carrier Name Name (Carrier) Must match Nalpac’s carrier Name.
Description DefaultMethodCode Method description maps to Nalpac’s default code.
Shipping Method Method/ShippingCode Exact match with values from /carrier is required.
Ship To Email Address Email Set if required for notifications.
Ship To Phone Number Phone Set if carrier requires a contact number.
3) Shipping Address
Flxpoint Field Nalpac Field Notes
Address1 / Address2 / Address3 AddressLine1/2/3 Map extra lines to Don’t Map if unused.
City City  
State State Use full name or 2-letter code per Nalpac’s format.
Zip Code PostalCode  
Country Country  
Name FullName Map if present; otherwise Don’t Map.
4) Line Items
Flxpoint Field Nalpac Field Notes
SKU Sku Unrecognized SKUs cause partial acceptance or line errors.
Quantity Quantity Units requested per SKU.
Cost Cost Map only if required by Nalpac; otherwise Don’t Map.
Title / UPC / MPN Title/Upc/Mpn Optional; can assist cross-referencing if supported.
PO Line Item # PoLineItem Optional reference for line numbering.

  • PO Recognition — If Nalpac flags the PO as invalid, confirm your ExternalOrderNumber mapping.
  • Carrier/Method Mismatch — Validate that Carrier Name and Shipping Method exist in Nalpac’s system (see /carrier).
  • SKU Validation — If lines are rejected, confirm SKUs against Nalpac’s catalog.
  • Template Accuracy — Re-check critical fields (ExternalOrderNumber, OrderDate, SKU) align with Nalpac’s API.
  • Response Logs — Use Job History to identify which fields/lines were rejected and why.

Schedule this job according to your order flow. Many teams run it frequently during business hours. All schedules run in UTC.

 
 

Get Shipments

Supported | Nalpac — Get Shipments (Primary)

Introduction
Get Shipments (Primary) retrieves shipment tracking details for a given Purchase Order / Fulfillment Request using GET /api/order?poNumber=<po-or-fr> (Nalpac v2). The response includes carrier, tracking number(s), shipped items, and quantities.
Note: Multiple shipments may be returned for the same order (partial shipments). Map carrier/method values consistently with your system to avoid mismatches.

  • Looks up shipment records by PO Number (or Fulfillment Request #).
  • Returns carrier info, tracking number(s), ship dates, and item-level quantities.
  • Handles partial shipments by associating items to their corresponding tracking number.
  • Writes shipment data back to your order in Flxpoint for downstream notifications.
  • Logs the raw response for auditing in Job History.

  • 1Identify Order — Use your PO Number or Fulfillment Request Number as poNumber.
  • 2Call Endpoint — Request GET https://api2.nalpac.com/api/order?poNumber=<value>.
  • 3Parse Response — Read shipment(s): carrier name/method, tracking, ship date, and item associations.
  • 4Map & Save — Apply your mapping template to store shipment headers and line-level quantities.
  • 5Repeat/ Schedule — Run on a cadence to capture late or partial shipments.
Example: Order PO-12345 returns two shipments: Shipment A (Tracking 1Z...) with SKUs A/B; Shipment B (Tracking 9400...) with SKU C.

Configure how Nalpac response fields map into your shipment model. Each field can be set to:

  • Don’t Map — Ignore the field.
  • Set to Empty — Force a blank value.
  • Field — Copy directly from the response.
  • Value — Use a fixed, custom value.
  • Mapping Set — Translate using a predefined lookup (e.g., carrier code mappings).
  • Rules — Conditional logic based on data (e.g., map USPS-like methods to “USPS Ground”).
1) Shipment-Level Fields
Your Field Nalpac Response Notes
Carrier carrier.name / carrierCode Identify the shipping partner. Normalize to your internal carrier list.
Shipping Method method / service Optional; map to your method codes if available.
Tracking Number trackingNumber Primary tracking identifier used for notifications.
Shipped At shipDate / shippedAt Timestamp when the parcel left the facility.
Notes note / comments Optional free-text information.
2) Shipment Item-Level Fields
Your Field Nalpac Response Notes
SKU items[].sku Identifies the product shipped on this tracking.
Quantity items[].quantity Units shipped for the SKU on this parcel.
Tip: Double-check Carrier, Tracking Number, SKU, and Shipped At mappings to avoid data mismatches, especially with partial shipments.

  • No shipments found? Verify the exact poNumber / FR # passed to the endpoint.
  • Carrier/method missing? Normalize response values to your internal carrier/method mapping sets.
  • Partial shipments not linking? Ensure line-item association is saved per tracking number, not per order.
  • Parsing issues? Inspect the Job History raw response to confirm field names and nesting.
  • Time zone/format problems? Confirm your parser handles ISO timestamps for Shipped At.

Schedule this job to run periodically (e.g., hourly or several times daily) to pick up new or late shipment events. All schedules run in UTC.