Template catalog
Loading templates
WorkflowCrate Assistant
Usually replies instantly
Sign in to chat with the assistant.
Pages through your entire Shopify order history into PostgreSQL, one page per run, tracking a cursor so it is resumable and never re-reads what it already loaded.
On every Shopify product change, upserts the product and a row per variant (with inventory quantity) into PostgreSQL.
Mirrors Shopify customers into PostgreSQL, normalising and de-duplicating on lowercased email so one person is one row.
Each night, compares recent PostgreSQL order rows against the live Shopify orders and writes a flag for every row that drifted, is missing, or is stale.
On every new Shopify order, upserts a normalised row into PostgreSQL and writes an ingest-log entry — idempotent, so webhook retries never double-insert.