Projects→FixitCSV — Inventory Bulk Editor
STATUS
● Production
CLIENT
FixitMedia
YEAR
2025–2026
ROLE
Builder & Architect
STACK
RemixTypeScriptViteShopify APICSV Processing
EVIDENCE LINKS
Note: Where client systems are private, screenshots are anonymized and architecture is shown without protected data.

FixitCSV — Inventory Bulk Editor

Shopify app for bulk inventory uploads via CSV. Multi-file import with validation, error reporting, and transaction rollback.

FixitCSV — Inventory Bulk Editor

Problem

FixitMedia merchants needed to update inventory for 1000+ SKUs monthly. Manual Shopify admin entry was error-prone and time-consuming.

Architecture & Solution

// System Pipeline

CSV upload → validation pipeline → transaction queue → Shopify GraphQL batch write → reconciliation report. Supports rollback on partial failure.

Implementation Decisions

  1. Streaming CSV parser prevents OOM on large files
  2. GraphQL batch writes reduce API call count from O(n) to O(1)
  3. Transaction-scoped rollback ensures data consistency