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:
- Go to Settings > Companies > Manage Companies > Open a company.
- From the Toolbox, go to Channels > HomeDepot Settings > Home Depot General.
- Press Edit.
- From the Home Depot General Settings panel, check HomeDepot Enabled.
- Complete the Home Depot credentials and settings. Refer to the table below.
- Note: See these instructions to set co-op fees here for dropship.
- Next, enter the FTP credentials provided by CommerceHub or the VAN credentials obtained from Sellercloud.
- Finally, enable your desired automatic updates for import and export information.
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:
-
- Go to Settings > Companies > Select company > Toolbox > Channel Warehouse Mapping to use the Channel Warehouse Mapping tool.
- Click Edit and choose Home Depot from the Select Channel dropdown field. The Local Warehouse column shows all warehouses in Sellercloud.
- Select the warehouses for Home Depot.
- Save.
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.
Related Documentation
See these related documents from Home Depot:
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.
| 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. |
| 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:
- In the Company > Toolbox > Home Depot Settings > General Settings.
- Select the Home Depot Enabled setting.
- Complete the Home Depot credentials and settings:
- Customer ISA Qualifier— Use the value ZZ
- Customer ISA ID— Usually is the client’s phone number
- HomeDepot ISA Qualifier, HomeDepot ISA ID, and HomeDepot Seller ID— All three are provided by CommerceHub
- Remit ID— 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
Note: See these instructions to set co-op fees here for dropship.
- Either enter the FTP credentials provided by CommerceHub or the VAN credentials obtained from Sellercloud:
- Enable the various automated feeds for Sellercloud to import and export information:
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:
- Go to Settings > Company > Toolbox > Channel Warehouse Mapping to use the Channel Warehouse Mapping tool.
- Choose Home Depot from the Select Channel dropdown field. The Local Warehouse column shows all warehouses in Sellercloud.
- Select the warehouses for Home Depot.
- Save.
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.
Related documentation
See these related documents from Home Depot:
Home Depot Properties Explained
- 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
