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

A bulk inventory processing application — built to validate, stream, and sync massive CSV datasets into Shopify via GraphQL.

FixitCSV — Inventory Bulk Editor

Problem

FixitMedia merchants needed to update inventory levels for thousands of SKUs on a monthly basis. The challenge: manual entry in the Shopify admin was severely error-prone, and massive CSV uploads frequently crashed browsers or timed out API limits.

Architecture & Solution

// System Pipeline

The app is a Remix/Vite stack using TypeScript. It features a streaming CSV parser that feeds a validation pipeline. Validated records enter a transaction queue and are executed against the Shopify GraphQL Admin API via batch mutations, supporting complete rollback on partial failures.

Implementation Decisions

  1. Streaming CSV ingestion — Processing files via streams prevents Out-Of-Memory (OOM) crashes on multi-megabyte inventory sheets.
  2. GraphQL batch mutations — Bundling updates reduces API roundtrips from O(n) to O(1), bypassing standard REST rate limits.
  3. Transaction-scoped rollbacks — Ensuring data consistency by rolling back entire batches if a critical validation error occurs mid-sync.