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
Step 1: Log into your Flxpoint account and navigate to the Sources tab.
Step 2: Click on + Add Source (or Configure Single Source) to begin creating a new source for D&H Distributing.
Step 3: Provide basic source details (e.g., vendor name "D&H Distributing"), then click Save or Next to continue.
Step 4: Follow the Source Wizard prompts. You may see:
Vendor Setup: Indicate if this source is a vendor (e.g., D&H Distributing) or an internal warehouse. If vendor, choose whether to enable a Vendor Portal or use integrations.
Assign Vendor: Assign an existing vendor record or create a new one for D&H Distributing.
Configure Vendor Portal: If you enable a portal, specify which vendor users can access your inventory/fulfillment requests.
Order Fulfillment: Enable/disable this source for fulfilling sales orders, set up auto-processing, and define your inventory commit strategy.
Shipping Cost Estimations: Choose to use Rate Shopping or Estimates via Rules.
Real-Time Estimates: Optionally integrate with a rate-shopping provider (e.g., ShipEngine).
Order Routing Groups: Add this source to any relevant routing group to prioritize order fulfillment.
Shipping Methods: Define your shipping method name, default carrier code, and whether to use rate-shopped codes.
Source Location: Enter the “Ship From” address (street, city, state, country).
Integration Setup: Once these steps are completed, click Done to finalize your source.
Step 5: Under Integrations, select the process you want to configure (Get Inventory [Primary], Get Inventory [Secondary], Send Fulfillment Requests, Get Shipments, or Get Invoices). If you see "No integrations have been configured for this process yet", click Start Creating Integrations.
Step 6: Configure the connection based on the process:
For Get Inventory [Primary]: No credentials are required. You can skip entering FTP details and proceed directly to the next step.
For Get Inventory [Secondary], Send Fulfillment Requests, Get Shipments, or Get Invoices: In the New D&H Distributing US Connection form, enter your FTP credentials:
Connection Name – a unique name (e.g., "D&H US FTP").
User Name and Password – your FTP login credentials provided by D&H Distributing (e.g., host: ftp.dandh.com).
Click Test Connection to ensure your credentials are valid.
Step 7: If credentials were required (for Get Inventory [Secondary], Send Fulfillment Requests, Get Shipments, or Get Invoices), click Save Connection to store these details in Flxpoint. For Get Inventory [Primary], you can skip this step.
Step 8: On the Configure Settings screen:
For Get Inventory [Primary]: No additional connection settings are needed since credentials are not required. Specify any file/folder paths for the D&H Distributing inventory feed (if applicable), decide whether to archive older data, and configure any shipping or advanced settings as needed.
For Get Inventory [Secondary], Send Fulfillment Requests, Get Shipments, or Get Invoices: Specify the file/folder paths for the respective process (e.g., inventory feed, fulfillment requests, shipment data, or invoice data), decide whether to archive older data, and configure any shipping or advanced settings as needed.
Click Save and Proceed to continue.
Step 9: Next, select or create your Mapping Template under Define a Mapping Template. Map the vendor’s fields (SKU, quantity, etc.) to the corresponding Flxpoint fields. Click Save and Complete when finished.
Step 10: Your D&H Distributing integration for the selected process is now active. Flxpoint will begin processing data according to your scheduled settings.
×
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 | D&H Distributing - Get Inventory (Primary)
Introduction to D&H Distributing Inventory Integration
This guide walks you through the D&H Distributing Get Inventory (Primary) integration, designed to keep your product catalog up to date with the latest data from D&H. Whether you’re just starting out or managing a large inventory, this section will help you sync essential product information—like stock levels, pricing, and descriptions—from D&H Distributing into your system. The goal is to ensure your inventory is accurate, so you can focus on growing your business. Let’s dive into how this integration works and how to set it up on the FLX Pro platform.
Purpose of This Integration
The D&H Distributing Get Inventory (Primary) integration connects your system to D&H to automatically update your product catalog. It retrieves key information, including:
- Product details (such as titles, descriptions, and categories).
- Stock quantities (how many items are in stock).
- Pricing (wholesale prices, estimated retail prices, and more).
This ensures your store reflects the most current data from D&H Distributing, helping you avoid overselling or showing outdated information.
How the Integration Works
The integration follows a simple process to bring D&H data into your system:
1. Accessing Files: It connects to D&H’s FTP server at ftp.dandh.com. For Get Inventory (Primary), no login credentials are required, as the connection is preconfigured. The integration downloads the inventory feed file, which contains product data for both US and Canadian markets.
2. Syncing Data: The integration processes the feed file and updates your product catalog with the latest information, such as stock levels, pricing, and product details. This is available with support for custom feed headers, ensuring compatibility with D&H’s feed format, including proper handling of regional data like 'US' values.
3. Keeping It Updated: You can run the integration manually or set it to run automatically on a schedule (e.g., every two hours, as recommended to manage API rate limits).
Note: If the feed file is missing or contains errors (e.g., incorrect formatting), the integration may fail, and an error message will appear in your logs.
Configuration Options
You can customize how the integration behaves to fit your needs:
- Handling Missing Products: If a product is no longer in the D&H feed, you can choose to archive it (remove it from your active catalog) or set its quantity to 0 (mark it as out of stock). This is controlled by the “Archive/Un-Archive Inventory” setting.
- Scheduling: Decide whether to run the integration manually or on a schedule. To avoid rate limit errors (e.g., “429 TOO MANY REQUESTS”), schedule jobs to run every two hours instead of every 15-30 minutes.
- Image Sizes: You can specify the preferred size for the main product image (e.g., 300px). Thumbnails can also be configured for smaller images.
Setup Instructions
Follow these steps to set up the integration on the FLX Pro platform:
1. Add the Integration: In your system, add the D&H Distributing integration. For Get Inventory (Primary), no FTP credentials are required, as the connection is preconfigured.
2. Configure Settings: Adjust settings like how to handle missing products, scheduling frequency, and image sizes. For example, you can set the integration to run every two hours to avoid rate limit issues.
3. Create a Mapping Template: Set up a mapping template to match D&H data to your inventory fields. This step is explained in detail below.
4. Run the Integration: Start the integration manually or let it run automatically based on your schedule.
Pricing Details
Pricing information is sourced from the D&H feed file and includes:
- Wholesale Price: The cost you pay for the product (e.g., $1184.58 for an air conditioning unit).
- Estimated Retail Price: A suggested selling price (e.g., $1920).
- Additional Fees: Includes handling charges, shipping costs, and rebates, if applicable.
You can also apply custom pricing logic in your mapping template (e.g., setting a markup percentage).
Quantity Details
Stock quantities are sourced from the D&H feed file under the “quantity” field. For example, if the file lists 17 units of a product, your system will show 17 units in stock. You can configure the integration to archive products with zero quantity or keep them active with a quantity of 0.
Mapping Template Details
A mapping template tells the integration how to match data from D&H to your system. For example, it decides whether the “title” from D&H should become the “Title” in your inventory. This section explains how to create and use a mapping template, with detailed options for every field.
Interface Overview
- The mapping screen is labeled “Get Source Products” at the top. You can name your template (e.g., “D&H US Mapping”).
- There are three buttons: Delete (remove the template), Duplicate (make a copy), and Save (save your changes).
- The screen is divided into two columns:
- Left Column (From Value): Shows the data fields from D&H (e.g., “title,” “wholesalePrice”).
- Right Column (To Inventory Parent Field): Shows the fields in your system (e.g., “Title,” “Price”).
Mapping Options
For each field, you can choose how to handle the data. Here are the available options, with explanations:
- Don’t Map: Ignore the field. The data won’t be used in your system. Use this if the information isn’t relevant (e.g., ignoring “rebateFlag” if you don’t need it).
- Set To Empty: Clear the field in your system. This removes any existing data for that field (e.g., setting “Weight” to empty means no weight will be shown).
- Direct Copy / Field: Copy the data exactly as it is from D&H. For example, copying “title” to “Title” means a product named “Eaton Preventive Maintenance” in the file will be named the same in your system.
- Value: Set a specific value of your choice. For example, you can set “Weight Unit” to “pound” for all products, regardless of what the file says.
- Mapping Set: Transform the data using a predefined rule (e.g., changing “US” to “United States”). This is useful for advanced users who need to modify data.
- Rules: Apply conditional logic (e.g., “If the category is ‘Electronics,’ set the category to ‘Tech’”). This is also for advanced users and can be skipped if you’re new.
Available Source Fields
The following fields are available from the D&H feed file for mapping:
Complete Field Mappings
Below is a detailed list of every field you can map to in your system, with explanations, examples, and suggested mappings:
Parent SKU: A unique identifier for each main product, used to group variations.
- Example: “0005NXXX-SRC1225-1”
- Suggested Mapping: Map to “sku” from the D&H feed using “Direct Copy.”
- Reason: “sku” is a unique code for each product in D&H, making it ideal for your Parent SKU.
All Attributes: Extra details about the product, such as weight or shipping method, copied together.
- Example: Weight: “0.01,” Ship Via: “UP”
- Suggested Mapping: Use “Direct Copy” to include all attributes (e.g., weight, shipVia, rebateAmount).
- Reason: This option saves time by copying all extra details at once.
All Images: The product’s images, which customers will see in your store.
- Example: Not directly provided in the feed; requires additional configuration.
- Suggested Mapping: Use “Don’t Map” unless you have a separate image source.
- Reason: The D&H feed doesn’t include image links, but you can configure image retrieval separately.
Brand: The brand or manufacturer of the product.
- Example: “Eaton”
- Suggested Mapping: Map to “manufacturer” from the D&H feed using “Direct Copy.”
- Reason: “manufacturer” provides the brand name, which matches this field.
Category 1: The primary category of the product.
- Example: “Electronics”
- Suggested Mapping: Map to “category” from the D&H feed using “Direct Copy.”
- Reason: “category” provides the main product category, which is ideal for your primary category.
Reference Identifier: An optional value (like UPC or MPN) used to match source variants.
- Example: “123456789012”
- Suggested Mapping: Map to “upc” from the D&H feed using “Direct Copy.”
- Reason: “upc” is a standard identifier that matches this field.
Title: The name of the product as it will appear in your store.
- Example: “Eaton Preventive Maintenance for In-Row DX Air Conditioning Units”
- Suggested Mapping: Map to “title” from the D&H feed using “Direct Copy.”
- Reason: “title” is the official product name provided by D&H, making it the best choice for your product title.
UPC: A Universal Product Code, often used for barcodes to identify products.
- Example: “123456789012”
- Suggested Mapping: Map to “upc” from the D&H feed using “Direct Copy.”
- Reason: “upc” contains the UPC code, which matches this field.
Weight: The weight of the product (a numerical value).
- Example: “0.01”
- Suggested Mapping: Map to “weight” from the D&H feed using “Direct Copy.”
- Reason: This provides the exact weight, which is important for shipping calculations.
Width: The width of the product (a numerical value).
- Example: Not provided in the sample feed; requires additional data.
- Suggested Mapping: Map to “width” from the D&H feed using “Direct Copy” if available.
- Reason: This provides the exact width, which is useful for shipping and storage.
Custom Fields (100): Additional fields you can create for specific data (up to 100 fields).
- Example: “Proposition 65 Warning: Yes”
- Suggested Mapping: Map to fields like “cAProposition65WarningType” using “Direct Copy.”
- Reason: This allows you to include any extra information important to your business.
Custom Aggregate Fields (10): Fields that combine multiple pieces of data (up to 10 fields).
- Example: “Electronics-US” (combining Category and Region)
- Suggested Mapping: Use “Don’t Map” unless you need to combine data.
- Reason: This is an advanced feature and can be skipped unless you have a specific need.
Practice Mapping
To understand how mapping works, try mapping the “Title” field for your system:
Troubleshooting
If the integration encounters an issue, here are some steps to resolve it:
- Check for rate limit errors (e.g., “429 TOO MANY REQUESTS”). If this occurs, wait for the cooldown period and adjust your schedule to run every two hours.
- Ensure your mapping template is correctly set up (e.g., “title” is mapped to “Title”). You can try adjusting the mapping template if data isn’t syncing as expected.
- If the issue persists, try deleting the source and re-running the integration to reset the process.
- Note that issues with regional data (e.g., parsing 'US' values) have been resolved and should no longer occur.
If the issue persists, contact your system administrator or support team for assistance.
Conclusion
Once your mapping template is set up and the integration is running, your system will be updated with the latest product data from D&H Distributing. This includes product details, stock levels, and pricing, ensuring your catalog is accurate and ready for your customers. You’re now equipped to manage your inventory effectively on the FLX Pro platform!
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.
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
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.
Fulfillment Request Number Compliance: D&H imposes a 20-character limit for FR numbers. To avoid request failures:
Use the Flxpoint-generated internal order number, which complies with the 20-character limit.
Avoid using channel order numbers (ChannelRef#) from platforms like Amazon, as they often exceed 20 characters.
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:
Confirm with D&H support that XML permissions are enabled.
Verify that the account credentials are correctly entered in Flxpoint.
Retry the submission after resolving any account issues with D&H.
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:
Schedule jobs to run every two hours instead of every 15-30 minutes.
Use the logs to monitor API usage and adjust schedules accordingly.
If the error persists, wait for the cooldown period mentioned in the error message before retrying.
Shipping Carrier Mapping: nsure proper mapping of shipping carriers to avoid fulfillment request failures:
Include the correct carrier name in the "Name" field of the mapping template.
Review the shipping method codes to ensure they align with D&H’s requirements.
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
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.
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
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.
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.