Project Overview
A full ERP ↔ Shopify automation to synchronize inventory, pricing, and product data in real time.
Built with Apps Script + Admin API — 100% code-controlled, no third-party middleware.
The Challenge
Manual updates across thousands of SKUs were slow and error-prone.
The brand needed a seamless pipeline between Google Sheets, ERP (Kingdee), and Shopify Admin API.
The Approach
We designed a custom automation layer that reads, transforms, and updates data on schedule.
Process
- Sheet Parsing Layer — Auto-maps SKU and variant IDs.
- API Sync Engine — Two-way data flow between ERP and Shopify.
- Logging System — Pushes sync status directly into Sheets dashboard.
Key Features
- Full SKU-level sync
- Scheduled & manual triggers
- Error handling + auto rollback
Results & Impact
-6+ hours manual work saved weekly
Zero data mismatch between ERP and Shopify after 3 months of operation.
Technical Stack
Google Apps Script
Shopify Admin API
JSON Mapping / Scheduler
Insight
Efficiency doesn't need to be complex — just consistent, automated, and transparent.