Home Depot Account Integration


Overview

Home Depot is the largest home improvement supply store in the U.S., with stores across 50 states, plus Canada and Mexico. They offer suppliers a great opportunity to sell home and garden improvement products in their dropship program.


Integrate with Home Depot

Home Depot is an EDI-based integration that requires documents to be transferred through CommerceHub, a third-party platform. Your account at CommerceHub lets Sellercloud integrate with Home Depot to allow inventory and order management from your Sellercloud portal.

There are 2 methods to integrate with Home Depot via CommerceHub:

  • Through SFTP obtained from CommerceHub
  • Through VAN obtained from Sellercloud

After you obtain your test credentials, a testing process will confirm that all documents being sent are correct. Note that testing for cancellations cannot be done through Sellercloud and must be done directly on order stream.

To proceed:

  1. Go to Settings > Companies > Manage Companies > Open a company.
  2. From the Toolbox, go to Channels > HomeDepot Settings > Home Depot General.
  3. Press Edit.
  4. From the Home Depot General Settings panel, check HomeDepot Enabled.
  5. Complete the Home Depot credentials and settings. Refer to the table below.
    1. Note: See these instructions to set co-op fees here for dropship.
  6. Next, enter the FTP credentials provided by CommerceHub or the VAN credentials obtained from Sellercloud.FTP Settings
  7. Finally, enable your desired automatic updates for import and export information.Automatic Settings

Map Warehouses

(Optional) If you have multiple warehouses set up in CommerceHub, you can map your warehouse(s) in Sellercloud to their corresponding locations. To do that:

    1. Go to Settings > Companies > Select company > Toolbox > Channel Warehouse Mapping to use the Channel Warehouse Mapping tool.
    2. Click Edit and choose Home Depot from the Select Channel dropdown field. The Local Warehouse column shows all warehouses in Sellercloud.
    3. Select the warehouses for Home Depot.
    4. Save.


Map LTL Carrier Codes

If you are using Less than a Truckload (LTL) carriers for Home Depot Orders, the correct SCAC codes need to be mapped in Sellercloud. Reach out to Home Depot support to acquire the list of carriers and corresponding codes. Once you have those, contact Sellercloud Support and provide the information. A representative will add the mapping in the backend for your server.


Configure PDF invoices

If you would like to print PDF invoices for your Home Depot orders through either Sellercloud or Shipbridge, you will need to have the Home Depot Invoice PDF plugin set up under your designated Home Depot company.

To do that, navigate to Settings > select your Home Depot Company > Toolbox > Invoice settings > Per channel preferences > choose your Home Depot PDF invoice plugin > Save.

Contact Sellercloud Support to ensure that the latest Home Depot PDF invoice plugin is installed for your account.

See these related documents from Home Depot:

Testing is required before going live with Home Depot! During this process, you can direct any questions you have to our Support team by email or ticket or enroll in Premium Support with a dedicated representative to walk you through the entire process.

Home Depot Settings Explained

You can find the settings below from Settings > Companies > Manage Companies > Open a company > Toolbox > Channels > HomeDepot Settings > Home Depot General.

Home Depot General Settings Panel
Options Descriptions
Customer ISA Qualifier Use the value ZZ.
Customer ISA ID Usually is the client’s phone number.
HomeDepot ISA Qualifier

HomeDepot ISA ID

HomeDepot Seller ID

 

All three are provided by CommerceHub.
Supplier/Warehouse ID Serves the same purpose as the Remit ID.
HomeDepot Shipping Reference Number This reference number is provided by CommerceHub for use by Shipbridge.
Order Handling Fee Allows you to set an exact handling fee or to set it as a percentage.
Order Handling Fee Is Per Item Check the box if you want the handling fee to be per item.
Order Defective Allowance Sets an allowance for defective items.
Login Email Enter the login email.
Login Password Enter the login password.
Safety Qty Sets a safety quantity.
Default Qty Only applies to Replenishable products. For these products, the Default quantity is the number that will always be sent to the channel in inventory updates regardless of the actual available inventory.
Enable Inventory Upload Select this to update inventory on Home Depot.
Enable Invoice Upload Invoices Home Deport for each shipped order.
Allows the orders to be downloaded from Home Deport to your Sellercloud account. Select this when ready to ship Home Deport orders.
Enable Order Functional Acknowledgement Informs Home Deport that the order file has been received.
Enable Order Acknowledgement Informs Home Deport that the order will be shipped.
Enable Order Fullfillment Upload
Enable for the tracking and Ship Date to be automatically sent to update the order status on Home Deport.
Requires Third Party Shipping Enable if you want your order to ship through a third party’s account.
FTP Settings Panel
Options Descriptions
Server Information provided by  CommerceHub.
Username
Password
Port
Use Passive FTP data transfer mode when the FTP client initiates both connections to the server solving the problem of firewalls filtering the data port connection from the server.
Use Secure FTP (SSH) Use SSH protocol as the binding agent to transfer files securely.
Delete FTP Files After Processing If left unchecked, incoming files will not be removed from the FTP and may cause a timeout during retrieval. It may be smart to check this option only after you test the order download.
Folder For Orders Folders paths for storing different file types.
Folder For Inventory
Folder For Tracking
Folder For Order Ack
Folder For Order Ack (Funational)
Folder For Invoices

Overview

Home Depot is the largest home improvement supply store in the U.S., with stores across 50 states, plus Canada and Mexico. They offer suppliers a great opportunity to sell home and garden improvement products in their dropship program.


Integrate with Home Depot

Home Depot is an EDI-based integration that requires documents to be transferred through CommerceHub, a third-party platform. Your account at CommerceHub lets Sellercloud integrate with Home Depot to allow inventory and order management from your Sellercloud portal.

There are 2 methods to integrate with Home Depot via CommerceHub:

  • Through SFTP obtained from CommerceHub
  • Through VAN obtained from Sellercloud

After you obtain your test credentials, a testing process will confirm that all documents being sent are correct. Note that testing for cancellations cannot be done through Sellercloud and must be done directly on order stream.

To proceed:

  1. In the Company > Toolbox > Home Depot Settings > General Settings.
  2. Select the Home Depot Enabled setting.
  3. Complete the Home Depot credentials and settings:
    1. Customer ISA Qualifier— Use the value ZZ
    2. Customer ISA ID—  Usually is the client’s phone number
    3. HomeDepot ISA Qualifier, HomeDepot ISA ID, and HomeDepot Seller ID— All three are provided by CommerceHub
    4. Remit ID— Provided by CommerceHub
    5. Supplier/Warehouse ID— Serves the same purpose as the Remit ID
    6. HomeDepot Shipping Reference Number— This reference number is provided by CommerceHub for use by ShipBridgesellercloud home depot integration fill credentialsNote: See these instructions to set co-op fees here for dropship.
  4. Either enter the FTP credentials provided by CommerceHub or the VAN credentials obtained from Sellercloud:sellercloud home depot integration ftp credentials
  5. Enable the various automated feeds for Sellercloud to import and export information:sellercloud home depot enable channel controls

Map Warehouses

If you have multiple warehouses set up in CommerceHub, you can map your warehouse(s) in Sellercloud to their corresponding locations. To do that:

  1. Go to Settings > Company > Toolbox > Channel Warehouse Mapping to use the Channel Warehouse Mapping tool.
  2. Choose Home Depot from the Select Channel dropdown field. The Local Warehouse column shows all warehouses in Sellercloud.
  3. Select the warehouses for Home Depot.
  4. Save.

Map LTL Carrier Codes

If you are using Less than a Truckload (LTL) carriers for Home Depot Orders, the correct SCAC codes need to be mapped in Sellercloud. Reach out to Home Depot support to acquire the list of carriers and corresponding codes. Once you have those, contact Sellercloud Support and provide the information. A representative will add the mapping in the backend for your server.


Configure PDF invoices

If you would like to print PDF invoices for your Home Depot orders through either Sellercloud or Shipbridge, you will need to have the Home Depot Invoice PDF plugin set up under your designated Home Depot company.

To do that, navigate to Settings > select your Home Depot Company > Toolbox > Invoice settings > Per channel preferences > choose your Home Depot PDF invoice plugin > Save.

Contact Sellercloud Support to ensure that the latest Home Depot PDF invoice plugin is installed for your account.

Related documentation

See these related documents from Home Depot:

Supplier Test Plan

Supplier Guide

Testing is required before going live with Home Depot! During this process, you can direct any questions you have to our Support team by email or ticket or enroll in Premium Support with a dedicated representative to walk you through the entire process.

Home Depot Properties Explained

To include products in the inventory feed, they must be HomeDepot Enabled and have the UPC set on the Product Summary page.
Product's Home Depot properties

Home Depot Enabled— Only enabled products will have the aggregate quantity pushed to the channel.

Merchant SKU— Enter the merchant SKU here. Note! If the SKU entered in Home Depot Merchant SKU field does not match your SKU in Home Depot, the item will not be updated and another product will be created in Home Depot with only a SKU and Product Name.

HomeDepot Title— Specific title for the Home Depot listing. If blank, we will use the Product Name.

Listing ID— Links to the listing on Home Depot.

Price— Specific price for this channel.

Discontinued

Safety Quantity— Can be set on the product, or click the Use Default box to use the default setting set on the company settings for Home Depot.

Enable Default Qty (in case of Replenishable)— Default Quantity only applies to Replenishable products. For these products, the Default Quantity is the number that will always be sent to the channel in inventory updates regardless of the actual available inventory.

Default Qty— Can be set on the product or click the Use Default box to use the default setting set on the company settings for Home Depot. Only applies to Replenishable products.

Inventory Shows the inventory available for this channel. This number will be sent in the feed.


Understand Backorders

Home Depot backorders are handled in a few different ways by Sellercloud:

If the OnOrder quantity of the product is > 0, and the expected delivery date is set to a date in the future, then Sellercloud will send the quantity on the order and the set expected delivery date automatically

If there is an OnOrder quantity, but no expected delivery date set, Sellercloud will send both fields. However, the expected delivery date will be sent as one month in advance

If the OnOrder has no quantity and no expected delivery date, Sellercloud will send the quantity as one and the expected delivery date as 1 month in advance


Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support