Cleaning Up 10,000+ Products for Seamless BigCommerce & MYOB Integration

The Challenge

A national wholesaler working across medical, mining, and air systems was preparing a full overhaul of their online product catalogue. But like many growing businesses, their product data was a mess:

• Scattered across multiple spreadsheets
• Inconsistent naming conventions
• Duplicates everywhere
• Key details missing or misaligned between systems

The team was burning hours trying to align product data between BigCommerce and MYOB, but manual fixes kept falling short.

If you've ever said, “We'd update our store… if only we had time to sort through 10,000 messy SKUs,” — you're not alone.

What I Did

• Standardised Raw Product Data
  Cleaned and formatted specifications, grouped filter types, mapped brands, and fixed inconsistent naming — creating a structured and usable master list.
• Consolidated Variants and Removed Duplicates
  Merged OEM and housing fields, preserved variant logic, and eliminated redundancies without breaking category or SKU structure.
• Built SEO‑Optimised Listings for BigCommerce
  Created import‑ready rows with product names, HTML descriptions, meta titles and descriptions, image URLs, and weight fields.
• Mapped Images for Automated Upload
  Generated a dynamic PythonGroups sheet linking each SKU to the correct brand and filter‑type folders for future bulk uploads.
• Formatted BigCommerce Import Files
  Structured image import rows to match BigCommerce's strict format rules, avoiding common upload errors and rework.
• Synced MYOB Pricing & Inventory
  Matched cleaned parts with MYOB inventory, flagged missing SKUs, and pushed pricing updates in bulk for fast reconciliation.

The Result

• ⏱️ Reduced manual data handling time by 90%
• 🧹 Delivered a clean, searchable product catalogue
• 📦 Enabled seamless imports into both BigCommerce and MYOB
• 🤖 Laid the foundation for full automation via Python and Excel

Why It Mattered

Messy product data is one of the biggest hidden blockers to growth. It clogs up your workflows, breaks automation, and creates friction for customers and staff alike. By turning a chaotic product list into a structured, SEO‑friendly, platform‑ready dataset, I helped this wholesaler take control — and set them up to scale confidently.

No more spreadsheet headaches. No more upload errors. Just clean data, ready to work.

✅ Key Takeaways

• 10,000+ SKUs cleaned, consolidated, and restructured
• Fully aligned product data across MYOB and BigCommerce
• SEO‑ready listings built with meta and image data
• Pricing synced and bulk updates automated
• Manual processing time slashed — future automation unlocked