Project Overview

This is a public Shopify app that connects a third-party commerce platform to Shopify for bi-directional product and inventory sync, order details forwarding, and coupon code usage tracking across multiple stores. What makes this project distinctive is the development approach: every layer — from architecture through deployment — was built using vibe coding with AI pair programming (GitHub Copilot + Claude Sonnet 4.6 as the primary model).

Core App Features

• Bi-directional sync: Products, inventory, and orders flow between the third-party platform and Shopify in both directions.
• Idempotent webhook deduplication: Shopify fires multiple product update webhook triggers per change. Built deduplication logic that prevents redundant processing and ensures data consistency across all integrated stores.
• Queue-based architecture with Prisma ORM: Prisma-backed queuing system with per-page query batching and sequential processing via AWS ECS workers, preventing rate limit violations on both Shopify and external APIs.
• Adaptive rate limiting: Engineered retry/backoff strategies and adaptive throttling (plimit) to sync 10,000+ products without exceeding API thresholds on either system.
• Shopify Bulk Operations API: Used GraphQL bulk queries and mutations for large-scale initial product data ingestion across stores.
• Coupon code usage tracking: Tracks discount code redemption across stores and syncs usage data back to the external platform.

7 Purpose-Built AI Agents (VS Code)

Beyond the app itself, I designed and deployed 7 custom AI agents in VS Code to accelerate every phase of development:

1. Ticket Scoping Agent — Parses ticket descriptions and user stories; outputs effort estimates and implementation plans.
2. Post-Dev Review Agent — Reviews completed changes for missing coverage, security vulnerabilities, code duplication, and SonarQube-class issues with remediation steps.
3. Commit Message Generator — Reads unstaged local diff and generates structured commit messages in a custom heading + body format.
4. PR Description Generator — Compares branch commits against base and generates complete pull request descriptions.
5. Copilot Review Distributor — Fetches all GitHub Copilot reviewer comments from a PR and classifies them as SAFE (false positives conflicting with framework standards) vs UNSAFE (genuine issues requiring action).
6. Gap Analysis Agent — Accepts a User Story and dev tickets, cross-references against the existing codebase, and surfaces implementation gaps before development begins.
7. Security Audit Agent — Performs file-by-file audit across the entire codebase, surfacing security vulnerabilities, coding pattern inconsistencies, code duplication, and optimisation opportunities.

MCP Integrations

• shopify-dev MCP: Integrated for live Shopify API context, ensuring agents always reference current API behaviour without hallucination.
• claude-mem MCP (custom VS Code extension): The claude-mem MCP was unavailable natively in VS Code. Forked the repository, refactored the architecture to comply with the VS Code MCP extension protocol, and installed it as a custom local extension — enabling persistent cross-session memory for all agents.

Instruction & Skill Files

Authored and continuously maintained .instructions.md and SKILL.md files to keep agents aligned with project conventions, stack constraints, and coding patterns. Updated on every newly discovered gotcha to prevent recurring mistakes across sessions.