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

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

Integrating with Home Depot

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

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

Mapping warehouses

You must also map your warehouse(s) in Sellercloud for Home Depot:

  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.

Related documentation

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.

Understanding Home Depot properties

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.

Understanding 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?

Related Articles