How to Automate Shopify Inventory Management

I build automate shopify inventory management alerts systems that give store owners track stock levels and predict reorder points. This automation runs in the background so you can focus on growth instead of operational tasks.

What You Need

• Python 3.9+ or Node.js 18+
• Shopify API credentials
• A notification channel (Slack, email, or SMS)

Step 1: Connect to the Shopify API

import requests
import os
from dotenv import load_dotenv

load_dotenv()

API_KEY = os.getenv("SHOPIFY_API_KEY")
SHOP_URL = os.getenv('SHOPIFY_STORE_URL')

headers = {
    'X-Shopify-Access-Token': API_KEY,
    "Content-Type": "application/json"
}

def fetch_data(endpoint, params=None):
    url = f'https://{SHOP_URL}/admin/api/2024-01/{endpoint}.json'
    response = requests.get(url, headers=headers, params=params or {})
    return response.json()

Step 2: Build the Processing Logic

from datetime import datetime
import json

def process_items(items):
    results = []
    for item in items:
        processed = {
            "id": item.get("id"),
            "name": item.get("name", item.get("title", "")),
            "status": item.get("status", ""),
            "amount": item.get("total_price", item.get("amount", 0)),
            "processed_at": datetime.now().isoformat()
        }
        results.append(processed)
    return results

Step 3: Set Up Notifications

def send_notification(message):
    slack_token = os.getenv("SLACK_BOT_TOKEN")
    channel = os.getenv("ECOM_CHANNEL")

    requests.post("https://slack.com/api/chat.postMessage",
        headers={"Authorization": f"Bearer {slack_token}"},
        json={"channel": channel, "text": message})

def notify_batch(processed_items):
    for item in processed_items:
        msg = f"*{item['name']}* | Status: {item['status']} | ${item['amount']}"
        send_notification(msg)
    print(f"Sent {len(processed_items)} notifications")

Step 4: Add Webhook Handler

from flask import Flask, request

app = Flask(__name__)

@app.route("/webhook/shopify", methods=["POST"])
def handle_webhook():
    data = request.json
    processed = process_items([data])
    notify_batch(processed)
    return "OK", 200

Step 5: Run on Schedule

import sqlite3

def log_run(action, count):
    conn = sqlite3.connect("ecom_automation.db")
    conn.execute("""CREATE TABLE IF NOT EXISTS runs (
        action TEXT, count INTEGER, ran_at TEXT
    )""")
    conn.execute("INSERT INTO runs VALUES (?, ?, ?)",
        (action, count, datetime.now().isoformat()))
    conn.commit()

def main():
    data = fetch_data("orders", {"status": "any", "limit": 50})
    items = data.get("orders", data.get("data", []))
    processed = process_items(items)
    notify_batch(processed)
    log_run("Shopify inventory management", len(processed))

main()

What to Build Next

Add a dashboard in Google Sheets that shows Shopify inventory management trends over time. Connect it to the webhook handler so data flows in real time, not just on schedule.

Related Reading

• Setting Up Automated Inventory Alerts - tracking stock levels and triggering reorders automatically
• Inventory and Operations Management with AI - tracking stock levels and triggering reorders automatically
• How to Build Automated Alerts That Actually Help - practical guidance for building AI-powered business systems