D&H With Etilize as a Source

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.

In this guide you'll set up D&H with Etilize as a Source in Flxpoint — connect the integration, configure inventory and order operations, and map your data. To enable the Etilize content feed for your account, contact support@flxpoint.com.

How To Connect

  • Log into your Flxpoint account.
  • Navigate to the Connections tab.
  • Click on Fulfillment Sources.
  • Click on + Add Source, name it, and select the source type.
  • Click FLX Supplier Directory, then click Continue.
  • Select D&H Distributing US with Etilize or D&H Distributing Canada with Etilize based on your needs.
  • In the D&H Connection screen, select the appropriate Etilize Package from the dropdown:
    • Etilize SpexBasic
    • Etilize SpexFLX
    • Etilize SpexFLX with images Add-on
    The package you choose determines how the enriched Etilize content feed is delivered to Flxpoint. To enable the Etilize feed for your account, contact support@flxpoint.com.
  • Enter the Etilize Agreement Number provided by Etilize, and specify if you want to import thumbnails as the primary product image. If you do not have your credentials, contact support@flxpoint.com.
  • Click Save Connection 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 updates.

Get Inventory and Pricing & Quantity

Supported | D&H with Etilize — Get Inventory and Pricing & Quantity

Introduction
Get Inventory connects 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. After each run, products live in your catalog and can be mapped to downstream channels. Pricing & Quantity keeps costs and on-hand quantities current on a separate connection.
Note: Get Inventory is the full catalog import using your Etilize package. After each run, products are saved to your catalog for mapping to downstream channels.
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.
Heads-up on archived products: Most D&H with Etilize products can appear Archived when the SKU used to fetch inventory doesn't match the SKU used to build products. See the Mapping Template & Configuration dropdown below and the Products showing as Archived item in the Troubleshooting section for the full explanation and fix.
Pricing & Quantity

Pricing & Quantity automates cost and on-hand updates for the D&H with Etilize integration. A separate connection is required specifically for pricing and quantity operations — it cannot share the same connection used for sending orders.

  • Provide your D&H API credentials (the username and password assigned to you for this operation). You may optionally reuse the same connection settings as Send Orders, depending on your setup.
  • Select the warehouses to include in the inventory calculation. The system sums the quantities from the warehouses you choose — such as Harrisburg, California, Chicago, or Atlanta — to determine total available inventory.
  • Advanced settings let you enable the creation of product variants during the secondary inventory operation, which is useful if you handle products with variations.
Define a Mapping Template
  • Map fields from D&H's inventory feed to your platform using a customizable mapping template. This ensures your product data, quantities, and pricing flow correctly.
Automate the Process
  • Enable scheduling to automate inventory updates. You'll receive notifications when the process runs, ensuring you are always informed.
Mapping Template Basics

Map fields from D&H's inventory feed to your Flxpoint fields. At minimum, map your variant identifier (SKU), quantity, and pricing so the catalog imports cleanly. The Etilize package you selected determines how much enriched content is available to map.

Important — SKU field binding and archived products. Most D&H with Etilize products can appear Archived when the SKU used for the inventory feed — the feed that drives quantity and Archive/Un-Archive — doesn't match the SKU used to build the products. The inventory match expects the compact, no-dash D&H item number (itemId) rather than a dashed SKU. When products are built with a dashed SKU but inventory is fetched against the no-dash item number, the two never match, so the items aren't found in the feed and get archived.
Verify the SKU Field Binding

To verify and correct the SKU field binding used by the inventory feed:

  • 1Open your D&H source and edit the Get Inventory (Secondary) mapping template.
  • 2Find the field that the inventory match uses for the variant identifier. The variant SKU is mapped to D&H Item NO, and inventory is matched against the compact itemId (no-dash item number).
  • 3Confirm the SKU field supplies the no-dash item number (itemId) and not a dashed SKU. If a dashed value is bound, change the binding so the match value is the compact item number.
  • 4Save the template and re-run the inventory job. Items that previously had no inventory match should now be found and un-archived on the next run.
Backend fix: A backend update now fetches inventory using the variant SKU instead of the parent SKU, so the inventory match lines up with how products are built. This reduces the number of products that fall out of sync and get archived.
Merging duplicated SKUs: If you already have duplicated SKUs from earlier mismatches, run the product re-builder using UPC to merge the duplicated SKUs in your channel listings. Matching on UPC consolidates the duplicates so inventory and pricing resolve to a single product.
Recommended Mapping (Inventory + Price)
Field D&H Field Notes
SKU (variant identifier) D&H Item NO Bind to the compact itemId (no dashes) so inventory matches.
Quantity On-hand Quantity Summed across selected warehouses.
Cost Dealer Price Account-specific pricing on the Pricing & Quantity connection.
UPC UPC Used by the product re-builder to merge duplicate SKUs.
Enriched Content Etilize fields Available based on your Etilize package.
Images Etilize image Choose resolution and whether to use the thumbnail as primary.
Quick Checks
  • The correct integration type (e.g., D&H US with Etilize) is selected.
  • Your Etilize Package type and Agreement Number are entered.
  • Archive/Un-Archive Inventory is enabled on only one D&H inventory integration — not on both Primary and Secondary at once.
  • The SKU field binding in your inventory template supplies the no-dash item number (itemId), so inventory matches the products you built.
Operation Details
Enriched Content (Etilize) SUPPORTED Product specifications and content from your Etilize package.
Images SUPPORTED Choose resolution and whether to use the Etilize thumbnail as primary.
Pricing & Quantity SUPPORTED Imported and kept current on each scheduled run (separate connection).
Quantity Logic SUM Sum of selected warehouses.
Archive / Un-Archive SUPPORTED Items absent from the feed are archived; re-activated when they return. Enable on one integration only.
Troubleshooting
  • Most products show as Archived: This is primarily caused by SKU mismatches in the source integration — the inventory match expects the compact no-dash item number (itemId), but products were built with a dashed SKU. Verify the SKU field binding (see Mapping Template & Configuration) and re-run.
  • Duplicated SKUs after correcting the binding: Run the product re-builder using UPC to merge the duplicated SKUs in your channel listings.
  • Catalog not importing: Confirm your Etilize Package and Agreement Number are correct. To enable or troubleshoot the Etilize feed for your account, contact support@flxpoint.com.
Tip: Run the full catalog import on a schedule, and pair it with the Pricing & Quantity job on a more frequent schedule to keep quantities and pricing fresh between full catalog runs.

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

Supported | D&H with Etilize — Send Orders

Introduction
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.
Shipping Carrier Mapping

Properly configure the shipping carrier mapping to avoid errors:

  • Add the carrier name in the "Name" field of the mapping template.
  • Ensure that all carrier codes match D&H's specified formats for seamless fulfillment processing.
Guidance: Use the Flxpoint-generated internal order number for the FR/PO reference so it stays within D&H's 20-character limit, and keep SKU and Quantity mapped for every line.
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.

Get Shipments

Supported | D&H with Etilize — Get Shipments

Introduction
The Get Shipments operation automates shipment retrieval from D&H, updating your orders with carrier, method, tracking, and shipped quantities. 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.
  • Enable scheduling so tracking imports automatically as orders ship.
Key Features
  • Carrier & Methods: Includes shipping carriers and methods.
  • Shipment Item Association: Associates items with respective shipments by SKU.
  • 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.
Quick Checks
  • The D&H connection is established and selected.
  • Tracking number and SKU fields are mapped in your shipment template.
  • A schedule is enabled so tracking imports as orders ship.
Troubleshooting
  • Tracking not importing: Confirm the connection is valid and the tracking/SKU fields are mapped. Orders that haven't shipped yet on D&H's side won't return tracking.

Troubleshooting

Troubleshooting

Common issues and solutions for the D&H with Etilize integration. Expand each item to learn more.

Still need help? If you're experiencing issues not covered here, contact our support team.

Contact Support