[SYS · 10] Standing system · filed

Quarry Sync

n8n bridge between quarry inventory (Excel/ERP/Sheets) and live Shopify. New block → published with photos.

Quarries and distributors manage inventory in Excel, Google Sheets, or legacy ERPs. The Quarry Sync monitors those sources and automatically creates or updates Shopify products — new blocks appear with their metadata and photos without manual data entry.

METRIC<1hvs 2–3 day manual entry
FLOW05stages · soup to nuts
STACK03technologies on the bench
STATELIVErunning in production
N°01Anatomy

The flow.

5 stages from first touch to closed loop. The system runs this path autonomously; the operator only sees the result at the end.

  1. Excel / ERP / Sheets
  2. n8n bridge
  3. product created
  4. photos attached
  5. live
ENTRYExcel / ERP / SheetsEXITliveMODEAUTONOMOUS

What the theme would not hold.

tone distributors receive new container inventory every 4–8 weeks. Manually creating 40–200 new Shopify products per container shipment — with photos, dimensions, and block metadata — is a 2–3 day task. The Quarry Sync collapses that to under an hour of QA.

N°03Technical surface

How it is actually built.

The stack is on the bench, the wiring is documented, and the instance you ship with is yours to extend after handover.

ON THE BENCH
  • 01n8n
  • 02Integration
  • 03Automation
3 layers · all yours after handover

n8n workflow with file/sheet watchers (Sheets API or SFTP polling) that parse incoming inventory manifests. Product creation and variant updates via Shopify Admin API. Image upload from quarry photo CDN via media attachment. Duplicate detection by block number prevents double-listing.

DELIVERED WITH

Full source · architecture diagram · workflow exports · runbooks · the keys to every credential the system uses.

N°04The compound

What this system compounds.

N°06Next step

Want this — or one shaped to your case?

Every engagement starts with a paid discovery. We map your case against the rack and tell you which systems fit, which get adapted, and what is genuinely new.