Overview

General Information

Things to Note

Contacts

Inventory Requirements

Inventory Process

Documents

Schedules

Order Flow

Helpful Links

 

________________________________________________________________________________________________________________

 

General Information

  • Connection Method: CommerceHub (EDI > sFTP) (cost-friendly option)
  • Partner Portal: CommerceHub
  • Order Types: Dropship

Things to Note

  • Home Depot does not accept acknowledgments unless they are cancellations acks

Contacts

Inventory Requirements

Inventory is sent to Home Depot as an 846 file

Supplier uploads a Matching File and a Standard Feed with the following fields:

  • Supplier SKU (Column A)
  • Merchant SKU (Column B)- this is Home Depot's SKU
  • UPC (Column C) - if available
  • Quantity (Column E)
  • Warehouse (Columns O) - this must match the warehouse code the customer set up in their CommerceHub Setup Step 1 :Provide some details about your company)
  • Warehouse Quantity (Column S) - must match column C if there is only 1
    warehouse
  • Vendor Number (Column AM) *assigned to you by Home Depot

 

Inventory Process

Daily Feed: Supplier uploads a new Standard Feed feed daily into Logibroker reflecting updated quantities *if no quantities changed from the previous day, you don't need to upload a new file

Adding an item: If the supplier is adding a new item to their assortment, they will add it in their inventory feed and upload it into Logicbroker as a Matching File and also as a Standard Feed

Discontinuing an item: Disc: set status (Column AL) to DISC

Schedules

 

Documents

Supported Documents

  • Purchase Order
  • Acknowledgment *only cancellations are accepted
  • Shipment
  • Invoice
  • Inventory

Callouts

  • Auto-Acks are not accepted

Packing Slip

  • Sample: see attached
  • Need to make a change?
    1. Reach out to the retailer with desired changes
    2. Obtain approval from the retailer
    3. Provide Logicbroker with proof of approval and list of changes
    4. Logicbroker will make requested changes
  • Logicbroker: download individual slips or download them in bulk, see here
  • ShipStation: Logicbroker will send the packing slip PDF link in the notes section of the order:

    mceclip1.png

 

Schedules

Orders

  • CommerceHub > Logicbroker: schedule - every 10-15 minutes - orders in Commecrehub should appear in Logicbroker within 10-15 minutes 
  • *Logicbroker > ShipStation: schedule: 4 times per hour - orders in Logicbroker should appear in ShipStation within 20 minutes

Acknowledgments

  • Logicbroker > CommerceHub: schedule - 33 minutes past the hour - acknowledgments in Logicbroker should appear in CommerceHub hourly at 33-40 minutes past the hour

  • *ShipStation > Logicbroker: schedule: once an hour - cancellations in ShipStation will appear as acknowledgments in Logicbroker within 1 hour

Shipments

  • Logicbroker > CommerceHub: schedule - 4 times an hour - shipments in Logicbroker should appear in CommerceHub within 15-20 minutes

  • *ShipStation > Logicbroker: schedule: once an hour - shipments and fulfillments in ShipStation will appear in Logicbroker within 1 hour

Invoices

  • Auto-invoices: automatic - once shipments/fulfillments are pulled from ShipStation or created in the portal, Logicbroker will create an invoice within a few minutes *only applicable if you are signed up for auto-invoicing

  • Logicbroker > CommerceHub: schedule: daily at 2:30am EST - invoices in Logicbroker will be sent to CommerceHub at 2:30am EST

Inventory

  • Delta Feed: In the portal, go to Settings > Scheduled Jobs > Search for the EDI Inventory Exporter Job that runs once an hour and see the time there *note this is in UTC time

  • Full Feed: In the portal, go to Settings > Scheduled Jobs > Search for the EDI Inventory Exporter Job that runs once a day and see the time there *note this is in UTC time

*Schedules cannot be changed as they may affect other integrations

 

Order Flow

  • CommerceHub sends orders (850s) to LB
  • LB sends orders to Supplier through LB or to the supplier's system
  • Supplier ships or cancels orders in Logicbroker or in their external system
  • LB pulls shipments/cancellations if the supplier is using an external system
  • If auto-invoicing is on: LB will generate an invoice and send it to CommerceHub
  • LB sends shipments or cancellations to CommerceHub
  • Orders show as ‘Complete’ in LB and in CommerceHub

 

Helpful Links

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request