Flxpoint Knowledge

Contact us

D&H as Source

Table of Contents

How To Connect Product Operations Order Operations

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.

Note: Both the U.S. and Canadian connections can integrate with Etilize, offering enriched product data such as detailed descriptions, images, and attributes. This enhancement is ideal for businesses looking to optimize their listings and create a more competitive product catalog.
 

How To Connect

  • Navigate to Sources from the left-hand menu (building icon).
  • Click the + button in the top-left of the screen and follow the prompts.
  • Select D&H Distributing US or D&H Distributing Canada based on your needs.
  • Fill out the required connection details:
    • Connection Name (e.g., "D&H US").
    • Host: `ftp.dandh.com`.
    • Port: `21`.
    • Username and Password: Provided by D&H.
  • Test the connection using Test Connection, then click Save Connection to complete the setup.
D&H Setup




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)

Supported
Operations Details

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.

 
 

Get Inventory (Secondary)

Supported
Operations Details

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.
Troubleshooting Tips:
  • 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.
 
 

 

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
Operations Details

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 orderEntry is 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.

 
 

Get Shipments

Supported
Operations Details

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 getdetails is 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 PACKAGE field.

This feature ensures you receive accurate and detailed shipment information, enabling better tracking and management of your orders.

 
 

Get Invoices

Supported
Operations Details

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.

 
 

 

Related Articles

BigCommerce

How To Connect OAuth2 Method Follow the in app prompts to connect your Bigcommerc...

Amazon as a Channel

Amazon serves as a robust channel integration in Flxpoint, enabling smooth produc...

Turn 14 Distribution as source

Overview   Turn 14 Distribution as a source can be completely managed using Flxpo...