Shopify to Notion Inventory Sync: Build an Advanced Stock Tracker with Make.com

Introduction

If your ecommerce operation still relies on manual stock checks and separate spreadsheets, you know the pain. Stock changes from Shopify orders, refunds, and vendor shipments rarely stay in sync with your Notion inventory page. That misalignment leads to oversells, unexpected stockouts, and frantic last‑minute reconciliations. A Shopify to Notion inventory sync fixes this by automatically updating Notion whenever Shopify stock moves, with optional alerts for thresholds and drift.

By the end of this guide you will have a working Make.com scenario that reads Shopify inventory events, updates Notion records, and optionally adjusts reserved or location fields. This is the kind of reliability that reduces stock errors and frees time for higher‑value tasks.

What You’ll Need

• Shopify store with access to inventory and webhooks
• Notion workspace with a database to track SKUs, stock levels, and locations
• Make.com account with connections to Shopify, Notion, and optionally Slack for alerts
• A Notion database with fields like SKU, Product Name, Stock, Reserved, Location, Last Updated, and a view for inventory status
• A clear mapping of Shopify inventory fields to Notion properties (SKU → SKU, inventory quantity → Stock, etc.)

Note: A paid Make.com plan is recommended if you expect frequent inventory updates or many products.

How It Works (The Logic)

Trigger: a Shopify inventory event (stock quantity changes or a new variant). Action: look up the corresponding Notion page by SKU, update the stock field, and optionally adjust reserved or location fields. Optional: route alerts to Slack when stock drops below a threshold or when a drift is detected between Shopify and Notion after a batch update.

This pattern keeps your Notion inventory in near real time and reduces the risk of oversells across channels. It also gives you a unified place to review stock health without switching systems.

Step-by-Step Setup

1. Create a Notion inventory database

• Ensure you have a table with columns for SKU, Product Name, Stock, Reserved, Location, Last Updated, and a formula or checkbox for In Stock/Low Stock.
• Create a view that filters items below a threshold you care about, such as Stock < 10.

2. Prepare Shopify inventory triggers

• In Shopify, confirm you can access inventory events either via webhooks or the Admin API.
• If using webhooks, select inventory_quantity_changed or inventory_level_updated as the trigger. Note which products and variants you want to monitor.

3. Set up a new scenario in Make.com

• Create a new Scenario named Shopify to Notion Inventory Sync.
• Add a Shopify module configured to listen for inventory events. Use a webhook or the appropriate trigger depending on your integration approach.

4. Map Shopify fields to Notion properties

• Pull SKU from Shopify line item or variant data and use it to search Notion for the corresponding record.
• Map fields as follows:
  • Shopify SKU → Notion SKU
  • Shopify inventory_quantity → Notion Stock
  • Product title → Notion Product Name
  • Location (if tracked) → Notion Location
  • Last updated timestamp → Notion Last Updated
• If Notion record not found, optionally create a new Notion page with the mapped fields.

5. Update Notion record via Notion module

• Use the Notion "Update Database Page" action (or the equivalent in your Notion module) to set the Stock property to the Shopify quantity.
• Update Last Updated with the current timestamp from Make.com.
• If you track Reserved quantities, adjust that field if Shopify provides reserved stock data.

6. Add a drift check (optional but recommended)

• After updating Notion, add a Get Row or Search operation to re-fetch the Notion row and compare Stock values.
• If there is a drift beyond a small delta, trigger a follow-up workflow to reconcile with the supplier or customer service notes.

7. Optional Slack alert for low stock

• Add a Slack module to post a message in a dedicated inventory channel when Stock falls below a defined threshold.
• Message example: “Low stock: SKU {{sku}} - {{product_name}} has {{stock}} units left. Last updated {{last_updated}}.”

8. Handle bulk updates gracefully

• If Shopify sends batch updates, use an array aggregator to process multiple SKUs in a single run, reducing API calls.
• Ensure you de-duplicate updates to the same Notion row within the same execution.

9. Testing and validation

• Simulate a stock increase and a stock decrease to verify Notion updates correctly.
• Test the drift detection by changing stock in Notion directly and triggering a Shopify update, then confirm reconciliation behavior.

10. Turn on and monitor

• Activate the scenario and monitor the first 50–100 updates for accuracy.
• Check for Notion permission issues or rate limits from Shopify and Make.com.

Real-World Business Scenario

A mid‑sized D2C brand uses Shopify to Notion inventory sync to keep its Notion product catalog as the single source of truth for stock levels. Every time Shopify stock changes, Notion updates instantly, and the team receives a Slack alert when stock dips under 20 units. This eliminates oversells and reduces stock reconciliation time from hours to minutes each day.

In our experience, this pattern reduces stockRelated miscommunication across ecommerce, operations, and customer support, making it easier to forecast replenishment and align teams. If you want this level of automation across Shopify, Notion, and Slack, Olmec Dynamics builds tailored automations for real businesses. Learn more about our work at Olmec Dynamics.

Common Variations

• Extend to multiple warehouses: map Notion locations to multiple Shopify fulfillment centers and alert when a specific location runs low.
• Add a monthly stock reconciliation report: push a summary from Notion to Google Sheets or a PDF and share with stakeholders.
• Create a separate Notion page for each supplier in case you manage stock by supplier and want a dedicated overview.

Keeping inventory flow tidy

This Shopify to Notion inventory sync gives you a robust, auditable stock workflow without manual exports. If you want this level of automation across Shopify, Notion, and the rest of your stack, Olmec Dynamics builds these systems for real businesses. You can see what we do at Olmec Dynamics.