Automation Specialist (Shopify + Make.com + Monday.com)

We need an operator-grade workflow (not just a CRM) to run our supply-chain/back-office for a Shopify store. You will build robust ---------- scenarios and Monday boards to track and automate:

Unfulfilled Orders (must include null, unfulfilled, and partial statuses)

Quality Checks (pull reports/flags, route to Supply Chain Checker)

Address issues, failed deliveries, refunds/disputes ? routed to the correct team

Alerts (e.g., >48h unfulfilled), assignees, SLAs, and audit logs

Applications must start with the keyword ORANGE-PARTIAL-48H and include it in the email/subject line. Applications without this keyword will be ignored.

Key deliverables

Shopify ? ---------- (webhook-first)

Webhooks: orders/create, orders/updated, orders/fulfilled, orders/partially_fulfilled, fulfillments/create|update, refunds/create (+ disputes/returns if available).

Filters/routers that include partial fulfillments and exclude only fully fulfilled.

Mapping examples:

Order number ? Monday Order number

Created at ? Date

Payment method ? payment_gateway_names (fallback to processing_method)

Amount ? total_price (+ currency)

Line items (titles) ? joined text

---------- boards

Unfulfilled Orders: Order number (text), Date (date), Status (labels: Waiting Supplier / Delayed / Ready to Ship), Why not fulfilled? (long text), Payment method (text), Amount (numbers), Supplier Action (text/status), optional Link to order.

Quality Checks: fields for SKU/title, reason, assignee, due date, evidence files, decision (approve/reject), notes.

Automations:

create item on new unfulfilled/partial order

escalate to Delayed after 48h

move to Ready to Ship on key comment keyword (ship) and notify Fulfillment

Scenarios to implement

Unfulfilled pipeline: Shopify ? filter (? fulfilled) ? Monday.Create Item ? Slack/Email notify

Failed delivery: watch fulfillments status=failure ? Monday ticket ? notify CS

Wrong address: missing/incomplete shipping_address ? CS/Parcel Panel checker queue

Quality check auto-routing: daily sweep of items >5 days unfulfilled ? QC board, assign to Supply Chain Checker

Refunds ? Finance: watch refunds ? Finance board item with amount %, note, link

Admin API & security

Use Custom App with least-privilege scopes: read/write_orders, read/write_fulfillments, read/write_customers, read_products, read/write_inventory (if needed), read_analytics, read_reports, read_shipping, read/write_returns (if available), read_refunds + write_refunds (if required).

Token handling, environment variables, masked secrets inside Make.

Docs & handover

Diagram of flows, list of webhooks, field mapping table, error-handling/retry strategy, and a short Loom walkthrough.

Quick SOP for the team (how to add columns, labels, assignees, and edit filters).

Must-have skills

Expert in ---------- (routers, iterators/aggregators, array mapping, error handlers, retries)

Shopify Admin API + webhooks, JSON schemas

---------- API & board schema (columns, IDs, updates)

Practical ops mindset for supply-chain/back-office flows

Bonus: Slack webhooks, Airtable/n8n familiarity

What to include when applying

Subject line: AUTOMATE–PH–SHOPIFY/MONDAY

2–3 links or Looms of your Make scenarios (show filters/routers and error handling)

A short note on how you’d capture partial fulfillments without missing edge cases

Example JSON of Monday column values you’d post for an item (with labels)

Your fixed price for the whole scope + availability

One improvement you’d propose that we didn’t mention