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β
| Area | What happens |
|---|---|
| Product sync | Copies products, variants, media, metafields and inventory from production to staging |
| Collection sync | Copies collections and their product membership to staging |
| Activation sync | Stages launch-day drops (active but unpublished in production) on staging ahead of launch |
| Merchandising | Writes SearchSpring's merchandised product order onto Shopify collections |
| Back-in-stock dates | Sets each product's back-in-stock date from catalog-api |
| QA audit | Checks synced products against catalog rules and writes errors to a Google Sheet |
| Webhooks | Syncs 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.