Switchboard In A Box

Software Engineer · End-to-end ownership · Cross-functional lead

nopCommerce · Kingdom · Schneider API · Xero · eWay · ElasticSearch

Background

Switchboard is a wholesale electrical storefront whose catalog is dominated by Schneider Electric - more than 60,000 SKUs that change often. Buyers need accurate specs, prices, and availability. What began as a platform upgrade quickly became a full rebuild of catalog sync, legacy migration, pricing control, and accounting automation so the business could run the catalog without depending on engineers for every update.

Challenges

  • Schneider sync was rigid - fixed vendor dates, little progress visibility, and almost no admin control when a job stalled or failed.
  • Vendor feeds were incomplete - missing images, attributes, and related products - while duplicate categories made navigation messy.
  • Pricing across 60k+ SKUs was largely manual with no safe stage-and-review path before go-live.
  • Legacy products, carts, orders, and customers had to move without breaking relationships when IDs changed.
  • Xero invoicing and product sync needed automation without breaching daily API limits.

Solution

Product Sync command center

I built a single admin hub for catalog work - Schneider sync, Excel import, category fixes, price uploads, and retry of failed jobs - with live progress, counts, and cancel. Admins could see what was running instead of guessing whether a job was stuck.

Configurable Schneider sync engine

Replaced hardcoded vendor cutoffs with an admin-chosen start date, queue-based change detection, API fetch with PDS fallback, and the ability to pause, clear, or patch the queue. Teams could fix a bad SKU without replaying the whole catalog.

Bulk enrichment and category cleanup

Excel templates filled gaps the feed never provided - attributes, assets, related products - keyed by SKU, with import reports. Category trees (multi-level) could be imported and merged so near-duplicate names stopped fragmenting the menu.

Price import with staged markup

SKU-level price files land in a staging area for filter and review, then publish with supplier cost-code markup (and optional discount). Nothing hits the storefront until it has been checked.

Catalog health reporting

Live diagnostic reports - sellable products, missing images or prices, SKU mismatches, orphans, uncategorized items - exportable to Excel so issues are caught before customers see them.

Legacy remapping and Xero automation

SKU-based remapping carried categories, ~70M specification combinations, carts, and orders onto new product IDs; guest noise was filtered so real customers survived. Checkout creates Xero invoices within tier limits, with capped daily product sync so accounting stays reliable.

Results

  • Unified admin control of 60,000+ SKUs - sync, enrichment, pricing, categories, and recovery in one place.
  • Migrated legacy catalog and order history with SKU remapping, including tens of millions of specification records.
  • Automated invoicing and bounded Xero sync (thousands of product updates per day within account limits).
  • Reduced engineer dependency for day-to-day catalog operations and cut time-to-fix for bad data.

I owned delivery end to end and coordinated QA, UI engineering, and developers from requirements through production support.