D&H as a Source
July 17, 2026
Summary
D&H Distributing is a US and Canadian electronics distributor with two connection methods in Flxpoint. Get Inventory (Primary) connects automatically with no credentials to import the full catalog; GIS, Send Fulfillment Requests, Get Shipments, and Get Invoices all authenticate with your D&H account User Name and Password. Separate source configurations exist for D&H US and D&H Canada, and the FR Number sent to D&H is limited to 20 characters, so map Flxpoint's internal order number rather than the channel order number.
What this integration does
Get Inventory (Primary)
Imports D&H's full electronics catalog via FTP, using the FTP Username and Password configured for the connection.
Get Inventory (Secondary)
Refreshes cost and quantity per warehouse from D&H's API.
Send Fulfillment Requests
Sends orders to D&H's order API using your account login.
Get Shipments
Pulls D&H shipment status, tracking numbers, and serials into Flxpoint.
Get Invoices
Retrieves D&H invoice totals and item costs for reconciliation.
How to connect - credentials you need
D&H has two connection paths. Get Inventory (Primary) requires the FTP Username and Password provided by D&H — add a D&H source, start configuring Get Inventory (Primary), click + New Connection, enter the FTP credentials, then Test Connection → Save Connection. GIS, Send Fulfillment Requests, Get Shipments, and Get Invoices use a separate XML API Username and XML API Password — add those when configuring one of those operations.
FTP UsernameRequired
The FTP username provided by D&H. Used to configure the Get Inventory (Primary) connection — there is no generic or automatic GIP connection.
FTP PasswordRequired
The FTP password provided by D&H, paired with the FTP Username to configure the Get Inventory (Primary) connection.
XML API UsernameRequired
Your D&H XML API username. Used to authenticate GIS, Send Fulfillment Requests, Get Shipments, and Get Invoices — separate from the FTP credentials used for GIP.
XML API PasswordRequired
Your D&H XML API password, paired with the XML API Username for GIS, Send Fulfillment Requests, Get Shipments, and Get Invoices.
There is no generic or automatic D&H connection — Get Inventory (Primary) requires the FTP Username and Password above. Add the XML API Username and XML API Password above only when configuring GIS, Send Fulfillment Requests, Get Shipments, or Get Invoices. Set up separate D&H sources for US and Canada accounts. Schedule all D&H jobs every 2 hours to stay within D&H's rate limits. For operation-specific mapping guidance, contact
support@flxpoint.com.Important - read before configuring
FR Number is limited to 20 characters — use Flxpoint's internal order number
D&H enforces a 20-character limit on FR/PO numbers. Channel order numbers from platforms like Amazon often exceed this limit (e.g., 113-1582479-0930653-1). Always map the Flxpoint-generated internal order number to the FR Number field — not the channel reference number. Orders with numbers exceeding 20 characters will be rejected by D&H.
API rate limits require scheduling jobs every 2 hours — not every 15–30 minutes
D&H enforces API rate limits. Running inventory or order jobs more frequently than every 2 hours causes 429 TOO MANY REQUESTS errors. Schedule all D&H jobs to run every 2 hours to stay within rate limits. If you see 429 errors, wait for the cooldown period mentioned in the error before retrying.
GIP requires FTP credentials from D&H — the connection is not preconfigured
Get Inventory Primary connects to D&H's FTP feed using the FTP Username and Password provided by D&H — there is no generic or preconfigured connection. GIS, Send Fulfillment Requests, Get Shipments, and Get Invoices use a separate XML API Username and Password, since the GIP FTP connection cannot be reused for GIS.
GIS requires at least one warehouse selected — or quantities default to 0
Get Inventory Secondary processes quantities per warehouse using D&H's API (25 products per batch). If no warehouse is selected in the GIS integration settings, all quantities default to 0. Select at least one warehouse. For multiple warehouses, GIS automatically sums quantities across all selected locations. SKUs must be saved without prefixes for GIS quantity/pricing lookups to work correctly.
Operations - fields to know
| Field | Maps To — Notes |
|---|---|
| SKU | → Product / Variant → SKU. Required. Primary identifier for the catalog item. |
| UPC | → Identifiers → UPC. Universal product code for the item. |
| Title | → Product → Title. Product name from D&H's catalog. |
| Description | → Product → Description. |
| Manufacturer | → Product → Manufacturer / Brand. |
| Category | → Product → Category / Subcategory. D&H's category code is translated to a category name; unrecognized codes default to Miscellaneous. |
| Quantity | → Inventory → Quantity. Full-catalog stock quantity from the FTP feed. |
| Wholesale Price | → Pricing → Cost. Your D&H dealer price, saved as Cost. |
| Estimated Retail Price | → Pricing → MSRP. Falls back to Cost multiplied by 1.25 when D&H doesn't return a retail price. |
| MAP Price | → Pricing → MAP. Minimum advertised price from D&H, when provided. |
| Weight | → Shipping → Weight. Defaults to 1 lb when D&H returns none or zero. |
| Length / Width / Height | → Shipping → Dimensions. Package dimensions from D&H. |
| Handling Charge / Shipping Cost / ShipVia | → Shipping → Handling & shipping cost fields. D&H's per-item handling and shipping cost figures. |
| Rebate Flag / Rebate Amount | → Pricing → Rebate fields. Informational; flags items with an active manufacturer rebate. |
| California Proposition 65 Warning | → Product → Compliance attribute. Added only when D&H flags a Prop 65 warning for the item. |
| Field | Maps To — Notes |
|---|---|
| SKU | → Inventory Variant → SKU. Required. Must match the GIP SKU exactly (no prefixes). |
| Price | → Pricing → Cost. Updated dealer price returned by D&H's API. |
| Quantity | → Inventory → Quantity. Summed across all selected warehouses; defaults to 0 if none are selected. |
| Source Field | Maps To (D&H) — Notes |
|---|---|
| FR Number | → PO Number. Required. Limited to 20 characters — map Flxpoint's internal order number, not the channel order number. |
| Fulfillment Request line → SKU | → Order Item Part Number. Required. Sent to D&H per line item. |
| Fulfillment Request line → Quantity | → Order Item Quantity. Required. Units requested. |
| Shipping address | → Ship To. Required. End-customer name, address, city, state and zip sent to D&H. |
| Source Shipping Method | → Ship Carrier / Ship Service. The carrier and method sent to D&H for the order. |
| Field | Maps To — Notes |
|---|---|
| Ship Date | → Shipment → Shipped At. When D&H marks the order shipped. |
| Carrier / Service | → Shipment → Carrier / Ship Method. Carrier and method returned by D&H. |
| Track Number | → Shipment → Tracking Number. Required. Package tracking number. |
| Item Number | → Shipment Item → SKU. Required. Associates the shipped line to your catalog. |
| Ship Quantity | → Shipment Item → Quantity. Required. Units shipped for the line. |
| Serial Numbers | → Shipment Item → Custom Fields. Captured as Serial Number 1, Serial Number 2, etc. when D&H returns them. |
| PO Number | → Shipment references. Associates the shipment back to the originating Fulfillment Request. |
| Field | Maps To — Notes |
|---|---|
| Invoice Number | → Invoice → Invoice Number. |
| Invoice Subtotal / Tax / Freight / Handling / EHF / Total | → Invoice → Financial line totals. Used to reconcile what D&H actually billed for the order. |
| PO Number | → Invoice → Associated Purchase Order. |
| Item Number | → Invoice Item → SKU. Required. Associates the invoiced line to your catalog. |
| Price / Quantity | → Invoice Item → Cost / Quantity. |
Common issues
Send FR failing — "ERROR: This user cannot submit XML requests"
This error means XML request permissions are not active for your D&H account. Contact D&H support and ask them to enable XML API permissions for your account. Once enabled, verify credentials in the Flxpoint connection and retry the order. This is a D&H account-side setting — no Flxpoint configuration change will resolve it without D&H enabling the permission first.
429 TOO MANY REQUESTS — API rate limit errors
D&H enforces rate limits on their XML API. Running jobs every 15–30 minutes triggers these errors. Change all D&H scheduled jobs (GIS, Send FR, Get Shipments, Get Invoices) to run every 2 hours. If a 429 error appears, wait for the cooldown period specified in the error message before retrying. Do not retry immediately — repeated requests during the cooldown will extend the block period.
GIS showing 0 quantity for all products
Zero quantities from GIS are almost always caused by either (1) no warehouse selected in the GIS integration settings — open the integration and confirm at least one D&H warehouse is enabled, or (2) SKUs saved with a prefix in Flxpoint that doesn't match the raw D&H SKU. D&H's API matches on exact SKU — any prefix (e.g., "DH-") in the source inventory will prevent the quantity lookup from matching. Remove prefixes from source-level SKUs, or set them only at the Master SKU level.
Send FR order number rejected — exceeds character limit
D&H rejects PO numbers longer than 20 characters. If you are mapping a channel order number (such as an Amazon order ID like
113-1582479-0930653-1) to the FR Number field, the order will fail. Change the Send FR mapping to use Flxpoint's internal order number instead. The Flxpoint-generated order number is always within the 20-character limit. Review any existing failed FRs and resubmit using the corrected mapping.FAQs
What fields does GIP import from D&H's FTP feed?▸
GIP downloads D&H's FTP inventory feed and imports: SKU, UPC, Title, Description, Manufacturer (brand), Category, Quantity, Wholesale Price, Estimated Retail Price (MSRP), MAP Price, Weight, Dimensions (Length, Width, Height), Handling Charge, Shipping Cost, ShipVia, Rebate Flag and Amount, and California Proposition 65 warning fields. Images are not included in the FTP feed and require separate configuration.
What does GIS retrieve from D&H, and how does multi-warehouse quantity work?▸
Get Inventory Secondary calls the D&H XML API in batches of 25 products to retrieve updated cost and quantity per product. It supports delta updates (price and quantity only — not full catalog data). Separate configurations are available for D&H US and D&H Canada. For multiple warehouses, GIS automatically sums quantities across all warehouses you have selected in the integration settings. If no warehouse is selected, quantity defaults to 0. SKUs must match exactly — no prefixes.
How does Send Fulfillment Requests work with D&H?▸
Send FR connects to D&H's order API using your D&H login credentials via the
orderEntry request. On success, D&H returns an order number which Flxpoint stores as the auto-acknowledgement on the FR. Required mapping: FR Number → PO Number (20-char limit; use Flxpoint internal order number), SKU, shipping carrier/method. The error ERROR: This user cannot submit XML requests means XML permissions are not enabled on your D&H account — contact D&H support to activate them.What does Get Shipments return from D&H?▸
Get Shipments calls the D&H XML API with the
getdetails tag, fetching shipment details for each FR individually using the stored D&H order number. Returns carrier, method, and tracking number at the item level via the PACKAGE field, plus SKUs for item-level matching. Partial shipments and multiple tracking numbers per FR are supported. Custom Fields in the Get Shipments template can be used to capture additional details like serial numbers.What does Get Invoices return from D&H?▸
Get Invoices retrieves invoice data via the D&H XML API using the Fulfillment Request Number. The response includes: line item costs, taxes, freight charges, handling fees, and SKU (ITEMNO) for item association. Use this for financial reconciliation and to confirm what D&H actually billed for each order.