Overview
HD Supply is a leading industrial distributor in North America, providing a wide range of products and value-added services to facility maintenance, repair, and operations (MRO) professionals. Serving sectors like hospitality, healthcare, multifamily housing, and government, they offer products from plumbing and electrical supplies to safety and janitorial equipment.
Integrating HD Supply into your Sellercloud account allows you to seamlessly import orders, upload tracking information and invoices, and ensure your listings are always up-to-date with the latest inventory data. This integration works through EDI documents, transmitting information between the two services via plugins and Scheduled Tasks. The document exchange goes through Rithum, previously known as CommerceHub.
If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.
Prerequisites
Before you can integrate HD Supply into Sellercloud, complete the following requirements.
Rithum Support
Before going live, you must follow a testing plan provided by Rithum, which involves sending a test transaction for each test order in the plan. Rithum provides two main documents—a Supplier Test Plan and a Supplier Guide. You must complete the entire test plan by following the outlined procedures.
Rithum will supply you with both the test and production credentials. Once you complete all test cases outlined in the test plan document, the platform will provide you with the production credentials and SFTP details. You must enter them into Sellercloud to set up the integration.
Sellercloud Support
Open a ticket with Sellercloud Support and request that the following plugins be installed on your server:
- HDSupply CommerceHub EDI 850 997 Order Import – Imports orders from HD Supply to Sellercloud in EDI 850 format and sends acknowledgment back in EDI 997 format.
- HDSupply CommerceHub EDI855 Order Export – Sends order acknowledgment to HD Supply in EDI 855 format.
- HDSupply CommerceHub EDI856 Tracking Export – Exports tracking information from Sellercloud to HD Supply in EDI 856 format.
- HDSupply CommerceHub Invoice EDI 810 Order Export – Exports invoices from Sellercloud to HD Supply in EDI 810 format.
- HDSupply CommerceHub EDI 846 Inventory Export – Exports inventory from Sellercloud to HD Supply in EDI 846 format.
- HDSupply Packing Slip – Generates a printable packing slip in a format that complies with HDSupply’s requirements.
Custom Company Settings
Create the following Custom Company Settings.
On your default company:
- STControlNumber
- GSControlNumber
- ISAControlNumber
On the company created for the integration:
- HDS_CustomerISAID – Your ISA ID. Enter a unique phone number that you don’t use for any other EDI integration.
- HDS_CustomerQualifier – Your Qualifier. Set to ZZ.
- HDS_ISAID – HD Supply’s ISA ID. Typically, it’s 8004313000CH. Rithum will confirm if this is the correct value.
- HDS_Qualifier – HD Supply’s Qualifier. Typically, it’s 12. Rithum will confirm if this is the correct value.
- HDS_VendorID – Your Internal Vendor Number.
- HDS_AcceptAllOrders – Set to True to accept all orders with the EDI 855, regardless of whether the acknowledgment code in the Custom Order Column HDS_ItemAckCode is IA, IR, or none. Defaults to False.
Custom Product Columns
Create the following Custom Product Columns:
- HDS_SKU – The product’s SKU at HD Supply. Set the Data Type to String.
- (Optional) HDS_Enabled – Enable only specific products for HD Supply. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.
- (Optional) HDS_SafetyQty – The default Safety Quantity, which is to be subtracted from the Available Quantity to prevent overselling on HD Supply. Set the Data Type to Integer.
Custom Order Columns
Create the following Custom Order Columns:
- HDS_VendorNumber – Automatically populated by the Order Import plugin. Set the Data Type to String.
- HDS_ItemAckCode – Populate manually. Enter an order acknowledgment code: IA to Accept or IR to Reject. Set the Data Type to String.
- HDS_ItemAckReason – Populate manually. Anytime you set the HDS_ItemAckCode column above to IR, use this column to enter the rejection reason. Set the Data Type to String.
Order Import
The HDSupply CommerceHub EDI 850 997 Order Import plugin imports order data from HD Supply to Sellercloud in EDI 850 format.
The plugin matches products by the HDS_SKU Custom Product Column first, and if there is no match, by their ProductID.
Automate Order Import
To create a Scheduled Task that imports orders:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Import Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- On the Scheduled Task page, click the Edit button at the top right corner.
- In the Details panel:
- Click Create Orders For Company and select the company designated for this integration.
- Click the Plugin menu and select HDSupply CommerceHub EDI 850 997 Order Import.
- In the Import Options panel, set Import From to FTP and fill out the FTP fields with the details provided by Rithum. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General panel, click the Enable button.
- Click Save.
Order Acknowledgment
The HDSupply CommerceHub EDI855 Order Export plugin sends order acknowledgment to HD Supply following the 855 EDI format and marks orders as Acknowledged after export.
The acknowledgment is sent per line item, and an order line item can only be fully accepted or rejected, even if it is split. It cannot be partially accepted or rejected. For example, if you have an order for SKU XYZ with a quantity of 10, you must either fully accept or reject the entire amount.
Before you move on, create a Saved Search for orders filtered by:
- Company – The company you created for the integration
- Order Status – InProcess Or Completed
- Payment Status – Charged
- Exported – Not Exported
- Order Ack (Accept) – No
Automate Order Acknowledgment
To create a Scheduled Task that sends order acknowledgment:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- On the Scheduled Task page, click the Edit button at the top right corner.
- In the Details panel:
- Click the User ID menu and select your email.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select HDSupply CommerceHub EDI855 Order Export.
- Check Mark Orders As Exported.
- Check This is Order Ack (Accept).
- In the Export Options panel, set Export To to FTP and fill out the FTP fields with the details provided by Rithum. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General panel, click the Enable toggle button.
- Click Save.
Tracking Export
The HDSupply CommerceHub EDI856 Tracking Export plugin exports tracking from Sellercloud to HD Supply following the 856 EDI format.
This plugin supports separate tracking numbers for Split Orders. Additionally, if you split an order due to a partial cancellation, it automatically skips any child orders with statuses Cancelled and Void and only sends tracking for the remaining shipped order to HD Supply.
Before you move on, create a Saved Search for orders filtered by:
- Company – The company you created for the integration
- Order Status – InProcess Or Completed
- Shipping Status – FullyShipped
- Payment Status – Charged
- Tracking Uploaded – No
Automate Tracking Export
To create a Scheduled Task that exports order tracking:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- On the Scheduled Task page, click the Edit button at the top right corner.
- In the Details panel:
- Click the User ID menu and select your email.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select HDSupply CommerceHub EDI856 Tracking Export.
- Check This Is Tracking Export.
- In the Export Options panel, set Export To to FTP and fill out the FTP fields with the details provided by Rithum. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General panel, click the Enable toggle button.
- Click Save.
Invoice Export
The HDSupply CommerceHub Invoice EDI 810 Order Export plugin exports invoices from Sellercloud to HD Supply in EDI 810 format.
Before you move on, create a Saved Search for orders filtered by:
- Company – The company you created for the integration
- Shipping Status – Fully Shipped
- Order Status – InProcess Or Completed
- Invoice Uploaded – No
- Tracking Uploaded – Yes
Automate Invoice Export
To create a Scheduled Task that exports invoices:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Orders.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- On the Scheduled Task page, click the Edit button at the top right corner.
- In the Details panel:
- Click the User ID menu and select your email.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select HDSupply CommerceHub Invoice EDI 810 Order Export.
- Check This Is Invoice Export.
- In the Export Options panel, set Export To to FTP and fill out the FTP fields with the details provided by Rithum. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General panel, click the Enable toggle button.
- Click Save.
Inventory Export
The HDSupply CommerceHub EDI 846 Inventory Export plugin exports inventory from Sellercloud to HD Supply in EDI 846 format.
The plugin will send Product UPCs to HD Supply if you have configured them; otherwise, it will skip them.
Optionally, you can enable only specific products for HD Supply by setting their HDS_Enabled Custom Product Column to True:
- For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the HDS_Enabled column, and Save.
- For multiple products in bulk: follow the steps to Bulk Update Products and use the HDS_Enabled column – set it to True for all products you want to enable.
Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.
Next, create a Saved Search for products filtered by HDS_Enabled – True. Optionally, you can add more filters to the search to narrow down the export further.
Automate Inventory Export
To create a Scheduled Task that exports inventory:
- Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the green + icon: Create New Scheduled Task.
- Complete as follows:
- Click Task Type and select Export Products.
- Set the Task Name.
- Select the Company.
- Select the Start Time.
- Click CREATE.
- On the Scheduled Task page, click the Edit button at the top right corner.
- In the Details panel:
- Click the User ID menu and select your email.
- Click the Saved Search menu and select the saved search you created earlier.
- Click the Export Via menu and select HDSupply CommerceHub EDI 846 Inventory Export.
- In the Export Options panel, set Export To to FTP and fill out the FTP fields with the details provided by Rithum. Make sure to check Use Passive and Use Secure FTP.
- In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
- In the General panel, click the Enable toggle button.
- Click Save.
Configure PDF Invoices
With the HDSupply Packing Slip plugin set up under your designated company, you can print PDF invoices with information about your HD Supply orders and the products they include through Sellercloud or Shipbridge.
To set up the invoice plugin:
- Go to the Company Settings of the company you created for the integration
- Click Toolbox and select Invoice Settings.
- Click Per Channel Preferences.
- For Website, select Plugin > HDSupply Packing Slip.
- Click Save.