Skip to main content

Product Sync Service

Keeps the staging Shopify store in step with production, so QA and the staging storefront see real catalog data. It also runs a handful of catalog upkeep jobs against both stores.

What it does​

AreaWhat happens
Product syncCopies products, variants, media, metafields and inventory from production to staging
Collection syncCopies collections and their product membership to staging
Activation syncStages launch-day drops (active but unpublished in production) on staging ahead of launch
MerchandisingWrites SearchSpring's merchandised product order onto Shopify collections
Back-in-stock datesSets each product's back-in-stock date from catalog-api
QA auditChecks synced products against catalog rules and writes errors to a Google Sheet
WebhooksSyncs no-index products to staging on create/update and fills in gift card details on new orders

Not yet released​

  • Airtable write-back: on product create/update, writes Shopify product and variant IDs back to Airtable, matched by SKU. Built, but switched off in production.

How it runs​

  • An HTTP service on Cloud Run receives Shopify webhooks and exposes endpoints to trigger syncs on demand.
  • Cloud Run jobs run the scheduled syncs. Each job exits non-zero on failure so Cloud Run retries it.

There's no database. Each run compares production and staging directly to decide what's out of date.

API reference​

The service has no OpenAPI spec. Endpoints are listed in the README. Sync endpoints require an X-API-Key header; webhook endpoints verify Shopify's HMAC signature instead.