Sell on Home Depot Overview

Click here for information related to Sellercloud’s previous interface.

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 Home Depot
    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 Commerce Hub 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

Integrating 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’s setting page, click Toolbox > HomeDepot Settings > Home Depot General.
  2. Click Edit > Go to the Home Depot General Settings panel > Select HomeDepot Enabled.
  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 Home Depot
    4. Supplier/Warehouse ID— Serves the same purpose as the Remit ID
    5. HomeDepot Shipping Reference Number— This reference number is provided by CommerceHub for use by ShipBridgesellercloud home depot integrationNote: See these instructions to set co-op fees here for dropship.
  4. Next, enter the FTP credentials provided by Commerce Hub or the VAN credentials obtained from Sellercloud:sellercloud home depot ftp settings
  5. Finally, enable your desired automatic updates for import and export information. home depot enable automated feeds

Mapping warehouses

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

  1. Go to Company 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.

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 Home Depot Enabled and have the UPC set on the Product Summary page. To access,
  1. Go to the desired product > Toolbox > Home Depot.
  2. Then, simply fill out information for each panel. sellercloud home depot product 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?