D&H Distributing provides connections for both U.S. and Canadian markets, supporting businesses with automated inventory updates and pricing synchronization. Whether operating in the U.S. or Canada, these connections ensure efficient access to D&H’s product catalog and order automation.
How To Connect
-
Log into your Flxpoint account.
-
Navigate to the Sources tab from the left-hand menu.
-
Click on + Add Source and follow the prompts.
-
Click on Start Creating Integrations and select your desired source from the available list.
-
Select D&H Distributing US or D&H Distributing Canada based on your needs.
-
In the D&H Connection screen, enter a Connection name, Host, Port, Username and Password. Click Save Connection to finalize the connection.
-
Click Save Connection to finish.
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 update.
Get Inventory (Primary)
Integration with D&H Supplier
Yes, we support integration with D&H Supplier for both Canada and the US.
This integration allows you to retrieve the following product information: quantity, SKU, manufacturer details, UPC, category, wholesale price, shipping costs, and product dimensions. This ensures accurate and timely updates to your product catalog, helping you manage inventory seamlessly.
Additionally, we use smart logic to handle specific scenarios:
- If a category is marked as "ZZ OLD ITEM - NOT ASSIGNED", the product is archived.
- If a product's weight is missing, it is automatically set to 1.
- For products costing less than $250, dropship fees are applied at $5.
- If MSRP is blank, it’s calculated using a formula to ensure accurate pricing.
Supported Features
Custom Fields
Client Pricing (& Currency)
Quantity
Images
Categories
Archive Support
Not Supported Features
Variations / Options
Multiple Warehouses
Weights & Dimensions
Delta Feed
Get Inventory (Secondary)
Get Inventory (Secondary)
Yes, we support "Get Inventory" for streamlined inventory management.
Here’s how it works:
- We retrieve product pricing and quantities directly from the D&H endpoint (
https://www.dandh.com/dXML/xmlDispatch), ensuring accurate and real-time updates. - Each request processes a batch of 25 products, returning their costs and quantities.
- Separate configurations are available for D&H US and D&H Canada to ensure compatibility with your operations.
- If a warehouse is not selected in the integration settings, the system defaults the quantity to 0.
- For multiple warehouses, the system automatically sums quantities for all selected warehouses.
- If quantity or pricing isn’t updating for all products, ensure that your SKUs are saved without prefixes.
- SKUs in the inventory source must match the SKU configuration in your source settings.
Supported Features
Generic Pricing (& Currency)
Quantity
Delta Feed (Price and Quantity Updates)
Archive Support (SKU Archiving)
Not Supported Features
Custom Fields (Variants Only)
Client Pricing (& Currency)
Multiple Warehouses (Beyond Summing Quantities)
Weights & Dimensions (& Units)
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
Send Fulfillment Requests
Yes, we support sending fulfillment requests to D&H with ease.
Here’s how it works:
- The system connects to the endpoint
https://www.dandh.com/dXML/xmlDispatch, using your login credentials for authentication. - The tag
orderEntryis used to submit your order data securely. - Once the request is successful, you’ll receive an order number, which is stored and associated with the corresponding fulfillment request.
This integration ensures your fulfillment process is efficient and streamlined, reducing the risk of errors or delays in your order processing.
Fulfillment Request Number Compliance: D&H imposes a 20-character limit for FR numbers. To avoid request failures:
Example: If the ChannelRef# is 113-1582479-0930653-1, replace it with the internal order number provided by Flxpoint.
XML Request Permissions Error: The error message "ERROR: This user cannot submit XML requests" indicates that XML permissions are not active for the user’s D&H account. To resolve this:
Managing API Rate Limits: D&H enforces rate limits for API requests, resulting in errors like "429 TOO MANY REQUESTS: API limit exceeded". To manage these limits:
Shipping Carrier Mapping: nsure proper mapping of shipping carriers to avoid fulfillment request failures:
Supported Features
Fulfillment Request Number: Fully mappable field for headers like FR# or similar.
FR Item Association: SKU is included in the fulfillment request.
Auto Acknowledgements: Order numbers are provided automatically upon successful requests.
Shipping Selection: Shipping methods such as UPS and FedEx can be configured in the mapping template.
Not Supported Features
Customer Association
Custom Fields
Attachments
Get Shipments
Get Shipments
Yes, we support retrieving shipment information from D&H.
Here’s how it works:
- The system connects to the endpoint
https://www.dandh.com/dXML/xmlDispatch, using your login credentials for authentication. - The tag
getdetailsis used to request shipment details for each Fulfillment Request (FR). - Shipment details are retrieved individually for each FR and mapped using the saved order number during FR processing.
- Item-level shipment details, such as SKU, carrier, method, and tracking, are available under the
PACKAGEfield.
This feature ensures you receive accurate and detailed shipment information, enabling better tracking and management of your orders.
Supported Features
Carrier & Methods: Available at the item level in the PACKAGE field.
Shipment Item Association: Item SKUs are included in the response and used for shipment mapping.
Partial Shipments: Supports partial shipments and multiple tracking numbers for a single FR.
Custom Fields: Option available in the mapping template to save additional details like serial numbers.
Not Supported Features
Invoice Information
Get Invoices
Get Invoices
Yes, we support retrieving invoice details from D&H.
Here’s how it works:
- The system connects to the endpoint
https://www.dandh.com/dXML/xmlDispatch, using your login credentials for authentication. - We use the provided Fulfillment Request Number (FR#) to fetch detailed invoice information.
- The retrieved data includes line item costs, taxes, freight, and handling charges.
This feature ensures accurate and organized invoice data retrieval for seamless order reconciliation and financial tracking.
Supported Features
Invoice Format: Fully supported and customizable for mapping templates.
Line Item Costs: Includes taxes, freight, and handling fees for each item.
Item Association: Associates SKUs (ITEMNO) for streamlined mapping.
Not Supported Features
Limitations: Limited to the provided FR# data scope.