No batch loadedStart at step 1.

Choose the batch

A batch is one collection in one colour, for example Manhattan in Warm Terracotta. Only items with a UPC that aren't on Home Depot yet are listed. Pick one from Ready to run; anything greyed out isn't set up yet; that's a settings job, not something to work around.

Which batches can run now

Goes through every batch in Ready to run: finds its Shopify pages (searching the whole store if a page has moved) and runs the step 2 photo check on each. Takes a few minutes; the result is kept in this browser until you check again.

Check the photos

Every size needs real photos of this colour on Shopify before we create anything on Home Depot. Each picture is judged from its pixels, not its file name: a dimension drawing or a countertop slab is never used, the lifestyle picture is the first real room shot, and a slab in the front or top-view slot holds the size. Hover a thumbnail to see what it was taken for.

Check the UPCs aren't already used

The same UPC can't be listed twice. Load Home Depot's Existing Items export and the site compares every UPC in this batch against it. Ask the site owner for the file if you don't have it.

Then, on Home Depot

  1. Search for Items β†’ set Search By to UPC (it starts on OMSID and finds nothing) β†’ paste the UPC list. You should get no results. If any UPC is found, stop and report it.

Build the create sheets

One sheet per size. Each size goes under its parent ("Super SKU") on Home Depot. Known parents are filled in; leave a box empty to skip that size.

No parents yet? Create them first

A size with no parent can't have items. On Home Depot: Onboard New Items β†’ Create New Super SKU β†’ download that Quicksheet raw, load it here, upload the filled sheet back, then paste the new IDs into Settings.

One parent serves every colour of the same finish line, so building them batch by batch creates duplicates on Home Depot. The second button builds each missing parent once, across every batch that is otherwise set up.

Then, on Home Depot

  1. Upload each sheet. Choose the final Upload; skip Validate.
  2. Search the UPCs again (Search By = UPC, it resets to OMSID): every item should now have an OMSID. "Succeeded" alone doesn't prove it.
  3. Select all the new items β†’ Download QuickSheet (the enrich template).
  4. Export the sibling items: step 4 lists exactly which ones, ready to copy. Search By = MFG Model # β†’ Export β†’ All Maintenance Attributes.

Add the Home Depot files

The enrich template and the sibling export from Home Depot. They stay on this computer; nothing is uploaded anywhere.

Fastest: send them straight from Home Depot

No downloading and no picking files. Once: drag the Send to site button to your bookmarks bar. Then for every batch:

  1. Click Open Home Depot queue below. It opens the Upload/Download Queue in a tab linked to this one. A queue tab opened any other way can't send here.
  2. On that tab, click Send to site in your bookmarks bar. Every finished Quicksheet and export gets an orange button: β†’ Template, β†’ Sibling or β†’ Supply.
  3. Click the button on the right row. The file lands here and is checked: a template must hold this batch's items, a sibling export must be the All Maintenance Attributes one.

⬇ Send to site

Build photos and spec sheets

Photos come straight from Shopify. Spec sheets use the sibling weights and the collection facts from Settings.

Photos

Spec sheets (PDF)

Colour swatch

Step 6 holds every item whose colour has no swatch on Home Depot. Make one here from a Shopify photo: pick a photo, then click a plain spot on the cabinet front.

The asset-ID button (drag once, use forever)

Drag this button to your bookmarks bar. On Home Depot's Images & Digital Assets screen, search your assets and click it: it reads every page and saves guids.json for step 6.

⬆ Capture asset IDs

Then, on Home Depot

  1. Images & Digital Assets β†’ upload the photo ZIP as JPEG Image and the spec ZIP as PDF Document.
  2. Capture the asset IDs: on that screen, Search by Asset β†’ Name and paste the asset names from the list below, no more than 100 at a time β€” Home Depot silently drops anything past 100. Go to the first page of results, then click the Capture asset IDs button you dragged to your bookmarks bar. It walks every page and saves guids.json. More than 100 assets: search in two halves and send both files; step 6 accepts several.

Build the enrich sheets

Copies each item's details from its live sibling, then applies the colour, prices, pallet, photos, the colour swatch and the installation, countertop and measurement PDFs every live item carries, and the rules. Anything incomplete is held back and listed, never half-filled.

Then, on Home Depot

  1. Upload each enrich sheet.
  2. Check the items leave the Enrich tab. If any still show Onboarding after a few hours, open it and click Save & Submit.

Finish: Supply Chain and CommerceHub

After enrich, Home Depot parks every item in Supply Chain Enrich and will not let it through until one more field is answered. This fills it and gives you one sheet to upload; a complete upload submits the items by itself.

Or send it from Home Depot: then Send to site β†’ the β†’ Supply button on its row (see step 4).

On Home Depot: search this batch's items β†’ Supply Chain Enrich tab β†’ Select All β†’ Generate Quicksheet. Pull it after the enrich sheets have landed, not before, so the packaging columns carry the enriched values. Don't open it in Excel.

  1. Upload it through Upload Quicksheets, final Upload.
  2. Check the items have left the Supply Chain Enrich tab and show THD Internal Review. No SUBMIT is needed; only open an item if it is still on that tab an hour later.

CommerceHub

Every item also needs a CommerceHub inventory record, or it lands in "Inventory Hold" after review. Search the SKU prefix in CommerceHub first and only add what's missing. The list below is one card per item, in the order of CommerceHub's Add Inventory SKU form: click a value to copy it, then tick the card when the record is saved. Ticks are kept with the batch, so you can stop and come back.

Settings

Set up a collection so anyone can run it, and keep the product facts that go on spec sheets. Changes are kept in this browser and take effect immediately β€” no new upload of the site is needed.

Set up a collection to run

Fill this in for a collection that shows as "not set up yet" in step 1. The code is the start of its SKUs, for example MNH_TK_GLD.

Product facts for spec sheets

An empty box means "not confirmed yet", and spec sheets for that collection are refused until it's filled.

Where these settings are kept

Starting the engine…