D&H Distributing provides connections for both U.S. and Canadian markets, supporting businesses with automated inventory updates and pricing synchronization. Through its integration with Etilize, a leading provider of product content and data, businesses can access enriched product information and specifications. This partnership ensures that businesses operating in the U.S. or Canada can efficiently leverage D&H’s product catalog for accurate inventory management and streamlined order automation.
For connecting to the Etilize feed. Contact support@flxpoint.com
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 with Etilize or D&H Distributing Canada with Etilize based on your needs.
-
Proceed to the Configure Settings step. Here, select the Etilize Package from the dropdown:
- SpexBasic
- SpexFLX
- SpexFLX with images Add-on
- For connecting to the Etilize feed. Contact support@flxpoint.com
-
Click Save and Proceed to finalize the configuration and proceed to mapping templates.
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)
Yes, Get Inventory (Primary) is supported!
The "Get Inventory (Primary)" integration allows you to connect to D&H's product inventory using Etilize, providing seamless access to product data and ensuring your business stays updated with the latest inventory information. Here’s everything you need to know to make the most of this feature:
Connect Your Integration:
- Simply choose the integration type (e.g., D&H US with Etilize), and you're set to go. No additional connection information is required for this integration.
Configure Your Settings:
-
Decide how inventory data is managed:
- Archive/Un-Archive Inventory: Automatically archive items not found in the source feed to keep your catalog clean and unarchive them if they return. (Tip: This setting is optional but can help with stock management.)
- Image Resolution: Choose your preferred image size (e.g., 650x650, 300x300) to display products on your platform optimally.
- Primary Product Image: Decide if you want to use Etilize's thumbnail image for your main product image—perfect if your sales platform doesn’t handle image optimization.
- Enter your Etilize Package details, including the package type and agreement number.
Define a Mapping Template:
- Map fields from D&H’s inventory to your platform using a customizable mapping template. This ensures your product data flows correctly.
Automate the Process:
- Enable scheduling to automate inventory updates. You’ll receive notifications when the process runs, ensuring you are always informed.
Technical Details Simplified:
Etilize offers three package options, and the choice determines how the inventory feed file is accessed via FTP. Here are the details:
Etilize SpexBasic:
- Host:
ftp.etilize.com - Username:
inventSrc - Password:
!nV3ntS0UrC3
Etilize SpexFLX:
- Host:
ftp.etilize.com - Username:
spexFlx - Password:
sp3xflX
Etilize SpexFLX with Images Add-on:
- Host:
ftp.etilize.com - Username:
SpexFLXimages - Password:
Sp3xFlXImag3s
Once connected, the system will download, parse, and save product data based on the chosen package, giving you access to up-to-date inventory and enriched product content.
Get Inventory (Secondary)
Yes, Get Inventory (Secondary) is supported!
The Get Inventory (Secondary) integration with D&H US/CA provides businesses with a reliable way to manage additional inventory sources. This integration is ideal for businesses requiring supplemental data or managing multiple warehouses. Here’s everything you need to know to set it up effectively.
Connect Your Integration:
- Connect D&H US API Token, if it is not already established. If needed, clients can modify this connection or set up a new one.
Configure Your Settings:
-
Tailor the integration to match your inventory management needs:
-
Archive/Un-Archive Inventory: Automatically archive SKUs not present in the source feed and unarchive them when they reappear. This is helpful for handling temporary out-of-stock items.
- Important: Avoid enabling this setting if it’s already active for another D&H inventory integration.
- Select Warehouse: Choose specific D&H warehouses (e.g., Harrisburg, California, Chicago, Atlanta) to pull inventory from. This is useful for businesses managing inventory across multiple locations.
- Allow Create Variant: Enable this option to create product variants during the inventory update process, ensuring accurate catalog management.
-
Archive/Un-Archive Inventory: Automatically archive SKUs not present in the source feed and unarchive them when they reappear. This is helpful for handling temporary out-of-stock items.
Define a Mapping Template:
- Use a mapping template to align inventory fields from D&H’s feed to your system. This ensures accurate data transfer, including SKUs, quantities, and product details.
Automate the Process:
- Schedule the process to automatically run inventory updates. Notifications will keep you informed whenever the process runs, helping you maintain real-time accuracy.
Key Features of Get Inventory (Secondary):
- Warehouse Selection: Pull inventory data from specific D&H warehouses.
- Efficient SKU Management: Archive or unarchive SKUs based on source feed data.
- Variant Support: Create product variants during inventory updates.
Supported Operations & Limitations
- Generic Pricing & Currency: Provides price updates in supported currencies.
- Quantity Updates: Real-time availability.
- Multiple Warehouses: Summarizes quantities across selected warehouses.
Limitations:
- Delta Feed vs. Full Feed: Only delta feeds (price & quantity).
- Weights & Dimensions: Not included.
- Custom Fields & Archive Support: Not available for this integration.
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
Yes, Send Fulfillment Requests is supported!
The Send Fulfillment Requests integration allows you to automate the submission of order fulfillment requests to D&H for both the U.S. and Canadian markets. This integration ensures a seamless flow of order information, reducing manual effort and optimizing order processing.
Connect Your Integration:
- Select D&H Distributing US/CA as the integration type.
- Enter the necessary credentials, including Connection Name, Username, and Password, to establish a secure connection. Use the Test Connection feature to verify the setup before saving.
Configure Your Settings:
-
Adjust the settings to fit your business needs:
- Hold for X Hours: Set a delay before orders are sent, allowing for final checks or edits.
- Send During Business Hours: Enable this option to restrict order submissions to D&H’s working hours, ensuring prompt handling.
- Auto Acknowledgements: This ensures that fulfillment requests are acknowledged automatically, helping you track submission status in real-time.
Define a Mapping Template:
- Use a customizable mapping template to match your system’s order fields (e.g., SKUs, quantities, and shipping details) to D&H’s requirements. This ensures the accurate transfer of data for every fulfillment request.
Automate the Process:
- Schedule the fulfillment request process for automated submissions. Notifications will be sent every time the process is run, keeping you informed.
Fulfillment Request Number Compliance: D&H enforces a strict 20-character limit for FR numbers. To prevent errors:
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:
Managing API Rate Limits: To avoid the error "429 TOO MANY REQUESTS: API limit exceeded":
Shipping Carrier Mapping: Properly configure the shipping carrier mapping to avoid errors:
Key Features of Send Fulfillment Requests:
- Automated Processing: Directly submit fulfillment requests to D&H.
- Real-Time Acknowledgements: Automatically receive confirmation for requests.
- Flexible Configuration: Customize submission settings like hold periods & templates.
- Business Hour Support: Align with D&H’s business hours for prompt processing.
Supported Operations & Limitations
- Fulfillment Request Numbers: Unique numbers for easier management.
- FR Item Association: Ensures proper SKU association in the request.
- Auto Acknowledgements: Improves order tracking.
- Shipping Selection: Choose the appropriate shipping method.
Limitations:
- Customer Association: Not supported.
- Custom Fields & Attachments: Not supported.
Get Shipments
Yes, Get Shipments is supported!
The Get Shipments integration enables businesses to seamlessly retrieve shipment data from D&H for both the U.S. and Canadian markets. This integration ensures timely and accurate shipment tracking, making it easier to keep customers informed and maintain operational efficiency.
Connect Your Integration:
- Connect using the D&H US API Token. If the connection is already established, you can use it as is, or you have the option to modify it or set up a new connection as needed.
Configure Your Settings:
- No additional configuration is required in Fixpoint for this integration, making setup straightforward and efficient.
Define a Mapping Template:
- Use the mapping template to align shipment data from D&H with your system. This ensures that all shipment details, such as tracking numbers, items, and statuses, are correctly captured and reflected in your platform.
Automate the Process:
- Enable scheduling to automate shipment updates. Notifications will keep you informed whenever the process runs, ensuring you never miss an update.
Key Features of Get Shipments:
- Accurate Shipment Tracking: Retrieve up-to-date shipment details.
- Partial Shipments: Supports tracking for multiple-part shipments.
- Custom Fields: Incorporate custom fields for detailed tracking.
- Carrier & Methods: Retrieves carrier info & shipping methods.
Supported Operations & Limitations
- Carrier & Methods: Includes shipping carriers and methods.
- Shipment Item Association: Associates items with respective shipments.
- Partial Shipments: Supports multiple tracking numbers for a single order.
- Custom Fields: Enables further customization in shipment data.
Limitations:
- Invoice Information: Not retrieved by this integration.
Get Invoices
Yes, Get Invoices is supported!
The Get Invoices integration enables businesses to retrieve detailed invoice data from D&H for both the U.S. and Canadian markets. This ensures accurate financial tracking, reconciliation, and streamlined billing processes.
Connect Your Integration:
- Use the D&H US API Token to connect. If the connection is already established, you can use it as is, or you can modify or set up a new connection as needed.
Configure Your Settings:
- No additional configurations are required for this integration in Fixpoint, making the setup quick and straightforward.
Define a Mapping Template:
- Use the mapping template to align invoice fields from D&H with your system. This ensures that key details like invoice formats, line item costs, and item associations are captured correctly.
Automate the Process:
- Enable scheduling to automate invoice retrieval. Notifications will keep you updated whenever the process runs, ensuring timely access to invoice data.
Key Features of Get Invoices:
Invoice Formats: Retrieves invoices in a supported format, easy to reconcile.
Line Item Costs: Captures detailed cost info for each line item.
Item Association: Associates invoice items with orders.
Supported Operations
Invoice Format: Standardized, supported format for processing.
Line Item Costs: Detailed breakdown (taxes, freight, handling).
Item Association: Links invoice items to corresponding orders.