D&H as Source with Etilize
Summary
D&H with Etilize layers Etilize's enriched product content — detailed specifications, marketing copy, and images — on top of D&H's inventory and order operations. Available as D&H Distributing US with Etilize and D&H Distributing Canada with Etilize. Get Inventory (Primary) pulls the Etilize-enriched catalog using your Etilize Package and Agreement Number; Get Inventory (Secondary), Send Fulfillment Requests, Get Shipments, and Get Invoices use the same D&H account credentials as the standalone D&H as a Source integration. For setup or mapping guidance, contact support@flxpoint.com.
D&H with Etilize needs two separate setups on the same source. For Get Inventory (Primary), add a D&H Distributing US With Etilize or D&H Distributing Canada With Etilize source — no connection form is required, go straight to Configure Settings and enter the values below. For Get Inventory (Secondary), Send FR, Get Shipments, and Get Invoices, use the same D&H account connection as your standard D&H as a Source integration: enter your Username and Password, then Test Connection → Save Connection.
support@flxpoint.com.Most archived products = SKU mismatch between GIP and GIS — fix in GIS mapping template
The most common issue in D&H with Etilize is products appearing Archived unexpectedly. This happens when GIP builds products using a dashed SKU but GIS matches inventory against the compact no-dash item number (itemId). Since the values don't match, items aren't found in the inventory feed and get archived. Fix: open the GIS mapping template, find the variant identifier field (D&H Item NO), confirm it uses itemId (no dashes), save, and re-run GIS. Archived items should un-archive on the next run.
Enable Archive/Un-Archive on only one D&H inventory integration — not both GIP and GIS
Flxpoint already enforces this limitation — the Archive/Un-Archive setting can be enabled on either GIP or GIS, but not on both at the same time. Enabling it on one location automatically blocks it on the other, so there is no way to activate it in both places even if you try.
Etilize Package and Agreement Number are required — contact support to enable the feed
In the GIP Configure Settings step, select your Etilize Package: SpexBasic (basic product info), SpexFLX (extended specs), or SpexFLX with images Add-on. Enter your Etilize Agreement Number. You can also choose whether to use Etilize's thumbnail as the primary product image. If the Etilize feed is not yet enabled for your account, email support@flxpoint.com to request activation. GIP will fail to import enriched content without a valid package + agreement number.
Order operations are identical to standard D&H — same 20-char FR limit and rate limit rules apply
Send FR, Get Shipments, and Get Invoices for D&H with Etilize are functionally identical to the standard D&H integration. The same rules apply: 20-character FR number limit (use Flxpoint internal order number, not Amazon channel refs), 2-hour scheduling to avoid 429 rate limits, and XML permissions must be enabled on your D&H account. See the D&H as Source article for full order operation details.
| Field | Maps To — Notes |
|---|---|
| sku | → Supplier SKU → Product / Variant → SKU. Required. Primary identifier for the catalog item. |
| etilizeProductId | → Identifiers → External Product ID. Etilize's internal product reference used to group SKUs and variants. |
| upc | → Identifiers → UPC. Universal Product Code, when supplied in the feed. |
| ean | → Identifiers → EAN. European Article Number, when supplied in the feed. |
| mpn | → Identifiers → Manufacturer Part Number (MPN). |
| title | → Product → Title. |
| marketing / fbbs (feature bullets) | → Recommended Description → Product → Description. Combines Etilize's marketing copy with the bullet-point feature list when both are present; falls back to the standard description if no marketing copy exists. |
| shortDescription | → Product → Short Description. |
| manufacturer / brand | → Product → Manufacturer / Brand. |
| mainCategory / subCategory | → Primary / Secondary Category → Product → Category / Subcategory. Etilize's category taxonomy for the item. |
| weight (+ weightUnit) | → Variant → Weight. Unit (lb or oz) is carried over from the feed. |
| height / length / width | → Variant → Dimensions. Recorded in inches. |
| attributes | → All Attributes → Product → Attributes (Direct Copy). Etilize's enriched spec attributes — richer on SpexFLX than on SpexBasic. |
| imageUrls | → All Images → Product / Variant → Images (Direct Copy). Etilize product images — only populated when your Etilize Package and resolution settings include images (SpexFLX with images Add-on). |
| Field | Maps To — Notes |
|---|---|
| sku | → Inventory Variant → SKU. Required. Must match exactly — no prefixes. |
| price | → Pricing → Cost. Updated dealer cost. |
| quantity | → Inventory → Quantity. Summed across all selected D&H warehouses; defaults to 0 if no warehouse is selected. |
| Source Field | Maps To (D&H) — Notes |
|---|---|
| Fulfillment Request line → SKU | → PARTNUM. Required. Item number sent to D&H per line. |
| Fulfillment Request line → Quantity | → QTY. Required. Units requested for the line. |
| FR Number | → PONUM. Required. Limited to 20 characters — map the Flxpoint internal order number, not a channel order number. |
| Shipping address | → SHIPTONAME / SHIPTOADDRESS / SHIPTOCITY / SHIPTOSTATE / SHIPTOZIP. Required. End-customer shipping address. |
| Source Shipping Method | → SHIPCARRIER / SHIPSERVICE. The shipping carrier and method sent to D&H for the order. |
| Field | Maps To — Notes |
|---|---|
| carrier | → Shipment → Carrier. Carrier name returned by D&H. |
| service | → Shipment → Ship Method. Shipping service/method returned by D&H. |
| trackNum | → Shipment → Tracking Number. Required. Package tracking number. |
| dateShipped | → Shipment → Shipped At. Date D&H marked the shipment shipped. |
| itemNo / shipItemNo | → Shipment Item → SKU. Required. Associates the shipped line to your catalog item. |
| quantity | → Shipment Item → Quantity. Required. Units shipped for the line. |
| serialNo / customFields | → Shipment Item → Custom Fields. Serial numbers, captured as numbered Custom Fields (e.g. Serial Number 1, Serial Number 2) when D&H returns them. |
| Field | Maps To — Notes |
|---|---|
| invoiceNumber | → Invoice → Invoice Number. |
| poNum | → Invoice → Purchase Order Reference. Associates the invoice back to the Fulfillment Request/PO. |
| invoiceSubTotal | → Invoice → Subtotal. |
| invoiceFreight | → Invoice → Freight Charge. |
| invoiceHandling | → Invoice → Handling Fee. |
| invoiceTax | → Invoice → Tax. |
| invoiceEhf | → Invoice → Environmental Handling Fee (EHF). Populated on D&H Canada invoices where an EHF/eco fee applies. |
| invoiceTotal | → Invoice → Total. |
| ITEMNO / PRICE / QUANTITY | → Invoice Item → SKU / Unit Price / Quantity. Required (ITEMNO). Line-item detail used for item-level reconciliation. |
itemId used for inventory matching in GIS. When items aren't found in the inventory feed, Archive/Un-Archive archives them. Fix: edit the GIS mapping template → find the D&H Item NO binding → change it to use the compact itemId (no dashes) → save → re-run GIS. If items still don't un-archive after this fix, also confirm Archive/Un-Archive is not enabled on both GIP and GIS simultaneously.