The problem
A fashion brand selling through 10+ retail stores, e-commerce and wholesale could not reconcile Shopify with its Apparel Magic warehouse system, and monthly sales were off by 1–3%.
What I built
- 01Built an Azure warehouse unifying Shopify and Apparel Magic, with virtual-warehouse logic that stops inventory being counted twice.
- 02Traced the sales gap to gift-card refunds that Shopify's REST and GraphQL APIs classify differently, and rebuilt reconciliation on the GraphQL order-changes API.
- 03Found that incoming stock exists only in Shopify's GraphQL API and merged both endpoints without breaking incremental loads.
- 04Cut Azure Monitor from about $1,000 a month to $0.10 by replacing redundant rules with one essential failure alert.
- 05Added daily incremental loads, inventory snapshots and a dimensional model valuing stock at cost, retail and wholesale.
Screens

