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 Connections tab, then select Fulfillment Sources.
Step 2: Under the Sources section, click on + Add Source to begin creating a new source for your D&H Distributing connection.
Step 3: In the Create Source popup, enter the source name as "D&H Distributing" and select the appropriate type from the dropdown. Click Save.
Step 4: After saving, you’ll see a message: "You have not created any integrations yet." Click Get Started to set up the integration.
Step 5: In the Setup Integrations popup, select Flx Supplier Directory (recommended) to proceed with the D&H Distributing integration.
Step 6: In the Let's Find Your Supplier popup, search for "D&H Distributing" in the Search Suppliers field. Select D&H Distributing from the list and click Select.
Step 7: In the Confirm Your Relationship With Supplier popup, check the box to confirm that you have a reseller account with D&H Distributing. Click Continue.
Step 8: In the Authenticate With Supplier popup, you’ll see a message: "This supplier doesn’t require any authentication details." Since D&H Distributing does not require authentication for the initial connection (e.g., Get Inventory), click Continue to proceed.
Note: While this step does not require credentials, operations like Pricing & Quantity, Send Orders, and Get Shipments will require a separate FTP connection with a DandH US API token. Be prepared to provide your User Name and Password in those sections.
Step 9: In the Master SKU section, set up your SKU mapping (Inventory SKU → Master SKU → Listing SKU). Optionally, set an SKU prefix (e.g., "ABC-") if needed. Click Save to complete the basic setup.
Step 10: To enable Pricing & Quantity, Send Orders, or Get Shipments, you’ll need to set up a separate FTP connection. For each operation:
Pricing & Quantity: Enable Automatically Pricing & Quantity and enter your DandH US API token credentials:
User Name and Password: Your FTP credentials for ftp.dandh.com (contact D&H Distributing if needed).
Warehouse Selection: Choose the D&H warehouses to source from (e.g., Harrisburg, California, Georgia). Quantities will be the sum of the selected warehouses.
Send Orders: Enable Automatically Send Orders and enter the same DandH US API token credentials (User Name and Password).
Get Shipments: Enable Automatically Get Shipments and enter the same DandH US API token credentials (User Name and Password).
Click Save to complete the setup for each operation.
×
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 and Pricing & Quantity
Supported | D&H Distributing - Get Inventory and Pricing & Quantity
Introduction to D&H Distributing Get Inventory and Pricing & Quantity Integration
This guide helps you set up the D&H Distributing Get Inventory and Pricing & Quantity integration. It syncs product data (e.g., attributes, SKUs) and updates stock levels and pricing, ensuring your catalog stays accurate. Let’s get started.
Purpose of This Integration
This integration imports and updates product data from D&H Distributing:
- Get Inventory: Imports product details like attributes (e.g., brand) and identifiers (e.g., SKU).
It keeps your inventory accurate, preventing overselling and ensuring correct pricing.
How the Integration Works
The integration has two parts with key differences:
1. Get Inventory: Uses the default connection (set up in "How to Connect") to retrieve product details like brand and SKU. No FTP credentials are required, as the connection is preconfigured.
2. Pricing & Quantity: Connects to ftp.dandh.com via FTP to download stock and pricing data, updating quantities (e.g., 17 units) and prices (e.g., wholesale price of $1184.58). 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. Syncing: Data is processed and synced to your system, either manually or on a schedule (e.g., every two hours to avoid rate limits).
Note: If the FTP connection fails for Pricing & Quantity, updates will not complete, and an error will appear in your logs.
Configuration Options
You can customize the integration with these settings:
- Enable/Disable Fields: Choose which fields to import in the mapping template (e.g., enable “Cost” or disable “MAP Price”).
- Warehouse Selection: Select specific D&H warehouses (e.g., Harrisburg, California, Georgia) to source inventory from.
- SKU Prefix: Add a prefix to SKUs (e.g., “ABC-”) to differentiate D&H inventory in your system.
- Scheduling: Run manually or schedule (e.g., every two hours to avoid rate limits like “429 TOO MANY REQUESTS”).
Setup Instructions
Follow these steps to configure the integration:
1. Access the Integration: Go to the D&H Distributing source and select "Get Inventory" and "Pricing & Quantity."
2. Configure FTP for Pricing & Quantity: Enable Automatically Pricing & Quantity and enter:
- User Name and Password: Your FTP credentials for ftp.dandh.com (contact D&H Distributing if needed).
- Warehouse Selection: Choose the D&H warehouses to source from (e.g., Harrisburg, California, Georgia). Quantities will be the sum of the selected warehouses.
3. Set SKU Prefix (Optional): Under Master SKU, add a prefix (e.g., “ABC-”) to D&H SKUs. This applies to all inventory after the next sync.
4. Create a Mapping Template: Define which fields to import (see below).
5. Run the Integration: Start manually or schedule it (e.g., every two hours).
Pricing Details
Pricing is sourced from the D&H feed file:
- Wholesale Price: The cost you pay (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.
Quantity Details
Stock quantities are sourced from the “quantity” field in the D&H feed file (e.g., 17 units for SKU “0005NXXX-SRC1225-1”). Quantities are the sum of the selected warehouses (e.g., Harrisburg, California).
Mapping Template Details
A mapping template controls how data is imported. In this version, you can only enable or disable fields.
Interface Overview
- The mapping screen is labeled “D&H → Flxpoint” with subsections for “Get Inventory” and “Get Pricing & Quantity.”
- Buttons: Cancel and Save Mapping.
- Columns: Left (D&H fields), Right (your system’s fields).
Mapping Options
- Enable: Import the field (e.g., enable “Cost”).
- Disable: Ignore the field (e.g., disable “MAP Price”).
Required fields like “SKU” cannot be disabled.
Available Source Fields
- Get Inventory: ALL ATTRIBUTES, ALL IMAGES, BRAND, CATEGORY, CUSTOM FIELD 1, DESCRIPTION, GTIN, HEIGHT, LENGTH, MASTER SKU, MPN, REFERENCE IDENTIFIER, TITLE, UPC, WEIGHT, WIDTH, PARENT SKU, SKU.
- Pricing & Quantity: COST, QUANTITY, SKU.
Complete Field Mappings
Get Inventory Mappings
These mappings cover product details like attributes and identifiers from D&H:
SKU: A unique identifier for each product variant.
- Example: “0005NXXX-SRC1225-1”
- Mapping: Maps to “SKU” from D&H feed.
- Reason: “SKU” is a unique identifier in D&H, making it ideal for your SKU. This field is required and cannot be disabled.
Brand: The brand name of the product.
- Example: “Eaton”
- Mapping: Maps to “BRAND” from D&H feed.
- Reason: Importing the brand helps categorize products and enhances customer trust.
All Attributes: A collection of all product attributes.
- Example: “Weight: 0.01, Ship Via: UP”
- Mapping: Maps to “ALL ATTRIBUTES” from D&H feed.
- Reason: Importing all attributes provides a comprehensive view of the product’s features.
Images: The images associated with the product.
- Example: Not directly provided in the feed; requires additional configuration.
- Mapping: Maps to “ALL IMAGES” from D&H feed.
- Reason: Images enhance the product listing and attract customers, but may need separate configuration.
Category: The category the product belongs to.
- Example: “Electronics”
- Mapping: Maps to “CATEGORY” from D&H feed.
- Reason: Categories help organize your inventory for better navigation.
Custom Field 1: A custom field for additional product details.
- Example: “Proposition 65 Warning: Yes”
- Mapping: Maps to “CUSTOM FIELD 1” from D&H feed.
- Reason: Custom fields allow you to include extra information relevant to your business.
Description: A detailed description of the product.
- Example: “Eaton Preventive Maintenance for In-Row DX Air Conditioning Units”
- Mapping: Maps to “DESCRIPTION” from D&H feed.
- Reason: A detailed description provides customers with more information about the product.
GTIN: The Global Trade Item Number for the product.
- Example: “123456789012”
- Mapping: Maps to “GTIN” from D&H feed.
- Reason: GTIN helps verify the product identity in your system.
Height: The height of the product.
- Example: Not provided in the sample feed; requires additional data.
- Mapping: Maps to “HEIGHT” from D&H feed.
- Reason: Height is useful for shipping and storage calculations.
Length: The length of the product.
- Example: Not provided in the sample feed; requires additional data.
- Mapping: Maps to “LENGTH” from D&H feed.
- Reason: Length is useful for shipping and storage calculations.
Master SKU: A unique identifier for the product, often used to group variants.
- Example: “0005NXXX-SRC1225-1”
- Mapping: Maps to “MASTER SKU” from D&H feed.
- Reason: Master SKU helps manage product variants in your system.
MPN: The Manufacturer Part Number for the product.
- Example: Not provided in the sample feed; requires additional data.
- Mapping: Maps to “MPN” from D&H feed.
- Reason: MPN helps identify the product’s manufacturer part number, useful for inventory tracking.
Reference Identifier: An optional identifier like UPC or MPN.
- Example: “123456789012”
- Mapping: Maps to “REFERENCE IDENTIFIER” from D&H feed.
- Reason: Reference identifiers help match source variants in your system.
Title: The name or title of the product.
- Example: “Eaton Preventive Maintenance for In-Row DX Air Conditioning Units”
- Mapping: Maps to “TITLE” from D&H feed.
- Reason: The product title is essential for identifying products in your catalog.
UPC: The Universal Product Code for the product.
- Example: “123456789012”
- Mapping: Maps to “UPC” from D&H feed.
- Reason: The UPC helps verify the product identity in your system.
Weight: The weight of the product.
- Example: “0.01”
- Mapping: Maps to “WEIGHT” from D&H feed.
- Reason: Weight is useful for shipping calculations.
Width: The width of the product.
- Example: Not provided in the sample feed; requires additional data.
- Mapping: Maps to “WIDTH” from D&H feed.
- Reason: Width is useful for shipping and storage calculations.
Parent SKU: A unique identifier for the parent product.
- Example: “0005NXXX-SRC1225-1”
- Mapping: Maps to “PARENT SKU” from D&H feed.
- Reason: Parent SKU helps group product variants in your system.
Pricing & Quantity Mappings
These mappings cover stock levels and pricing from D&H:
Quantity: The stock quantity available for the product.
- Example: “17” (e.g., SKU “0005NXXX-SRC1225-1”)
- Mapping: Maps to “QUANTITY” from D&H feed.
- Reason: “QUANTITY” provides the current stock quantity for the product.
Cost: The cost of the product for your business.
- Example: “$1184.58”
- Mapping: Maps to “COST” from D&H feed.
- Reason: “COST” provides the wholesale price of the product in your inventory.
SKU: A unique identifier for each product variant.
- Example: “0005NXXX-SRC1225-1”
- Mapping: Maps to “SKU” from D&H feed.
- Reason: “SKU” is a unique identifier in D&H, making it ideal for your SKU. This field is required and cannot be disabled.
Practice Mapping
Try enabling or disabling the “Cost” field:
Troubleshooting
If issues arise:
- Verify the FTP connection to ftp.dandh.com for Pricing & Quantity. Ensure your credentials are correct.
- 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 required fields like “SKU” are enabled in the mapping template.
- Note that issues with regional data (e.g., parsing 'US' values) have been resolved and should no longer occur.
- Contact Flxpoint support if needed.
Conclusion
With this integration set up, your system will sync product details, stock levels, and pricing from D&H Distributing, keeping your catalog accurate.
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 Orders
Send Orders
Yes, the Send Orders operation is supported!
The Send Orders operation automates order submissions to D&H. You must establish a separate connection for this operation.
Connection Requirements:
Enter your Username and Password to authenticate the connection.
You may use the same connection as Pricing & Quantity, but it’s optional.
Additional Notes:
No advanced settings are required for this operation.
Fulfillment Request Number Compliance: D&H enforces a strict 20-character limit for FR numbers. To prevent errors:
Always use the Flxpoint-generated internal order number, as it complies with the limit.
Avoid using long order numbers from channels like Amazon.
Example: Replace 113-1582479-0930653-1 with a shorter internal number like 113-1582479.
XML Request Permissions Error: If you encounter "ERROR: This user cannot submit XML requests", this usually indicates that XML permissions are not active in D&H’s system. Steps to resolve:
Confirm with D&H support that XML permissions are enabled.
Ensure your D&H account credentials in Flxpoint are correct.
Retry sending the request once permissions are confirmed.
Managing API Rate Limits: To avoid the error "429 TOO MANY REQUESTS: API limit exceeded":
Adjust job schedules to run every two hours instead of at shorter intervals.
Monitor API usage through logs and adjust schedules if limits are frequently hit.
Always adhere to the cooldown period specified in the error message before retrying requests.
Shipping Carrier Mapping: Properly configure the shipping carrier mapping to avoid errors:
Add the carrier name in the "Name" field of the mapping template.
REnsure that all carrier codes match D&H’s specified formats for seamless fulfillment processing.
Get Shipments
Send Orders
Yes, the Get Shipments operation is supported!
The Get Shipments operation automates shipments. You must establish a separate connection for this operation.
Connection Requirements:
Enter your Username and Password to authenticate the connection.
You may use the same connection as Pricing & Quantity, but it’s optional.
Additional Notes:
No advanced settings are required for this operation.