Projects
Multi-Site Shopify Migration - Fuel Cell Store
Sep 2026 - PresentMoving the company's three sites to separate Shopify stores. HTEC Education (OpenCart 3) and Fuel Cells Etc (WordPress) are live. Fuel Cell Store, the largest with 2,000+ SKUs on OpenCart 3.0.3.8, comes last.
Owning the data migration: mapping two OpenCart databases and a WordPress site onto Shopify's data model, then moving products, customers, and order history.
Using AI-assisted reverse engineering to work out what each undocumented custom module does, then deciding for each one whether to replace it with an app, a native Shopify feature, or a custom build.
Running each cutover with no downtime: rebuilding the theme, redirecting legacy URLs to keep search rankings, and moving DNS to a new provider with mail records carried over. Next, moving GA4 and Google Ads conversion tracking to Shopify.
Visit the HTEC Education store Visit the Fuel Cells Etc siteWarehouse & Inventory Subsystem (WMS) - Fuel Cell Store
Oct 2024 - PresentBuilt the warehouse and shop-floor half of the internal operations platform, alongside the ERP: stock, receiving and purchase orders, builds and bills of materials, waste, and physical counts across 2,000+ SKUs.
Moved shop-floor work to scanning: operator badges, work orders, SKUs, and material lots are all identified by QR code, through either a hardware barcode gun or the browser camera.
Added a discrepancy lock: when a physical count does not match the database, the SKU is blocked from pulling until the variance is resolved, so a quantity already known to be wrong stops moving.
Rebuilt the lot-tracked materials subsystem from the ground up on its own database, retiring an unreliable legacy version without putting live inventory at risk.
Built directly on the ERP's SQL Server schema, so stock updates reach the ERP immediately and cannot drift out of step with orders. Stock lookups and inventory reports return in under a second.
Read case studyOpenCart Upgrade - Fuel Cell Store
Mar 2024 - Sep 2024Independently ran the company's e-commerce migration from OpenCart 1.5.6.4 to 3.0.3.8, covering 2,000+ SKUs and 70,000+ historical orders, reconciled table by table, with no business interruption.
Wrote SQL migration scripts for data cleaning, field mapping, and relationship rebuilding across major version differences.
Rebuilt the storefront templates by hand across the template engine change, working out what each customization depended on in the old engine before reimplementing it. Improved mobile responsiveness in the process.
Rewrote the store's custom features on 3.0 instead of porting the old code, preserving existing behavior such as standard checkout, the quote-only flow, and per-combination variant pricing and stock, while fixing legacy bugs and adding new functionality.
Read case study Visit the live storeInternal Operations Platform (ERP / WMS / MES) - Fuel Cell Store
Aug 2023 - PresentDesigned and built the company's internal operations platform as sole developer, replacing a slow, partial VB.NET WinForms desktop system with one web platform covering orders, inventory, materials, production work orders, and shipments.
Modeled the business in a 50+ table SQL Server schema shared directly with the warehouse subsystem, used by 20 to 30 internal users at the same time; its audit table has passed 1,000,000 rows.
Built 40+ reports that query live operational data and return in under a second, with no separate analytics stack to build or keep in sync.
Prevented conflicting edits with work-order locking shared with the warehouse subsystem, and added a unified audit trail recording who changed what across every module.
Set up scheduled backups and a recovery process that restores the system in minutes.
Read case study