WordPress → Shopify migration, 9,000+ products
White Bathroom
Migrated a 9,000+ product catalogue and restructured it so colour duplicates became variants of a single Shopify product.
- Context
- Client project
- Discipline
- Migrations · Apps & Functions
- Core tech
- Admin API · GraphQL · Bulk mutations · Custom app
What I worked on
- Data modelling, custom migration app and bulk import.
The challenge
The source data held one product per colour. In Shopify those had to collapse into a single product with colour options and variants, which meant transforming the catalogue before importing it.
Implementation
- 01Source products grouped by product name so same-name/different-colour records become one product with variants and options.
- 02Custom Shopify app created from the Shopify Partner Dashboard using the legacy app/token flow available at the time.
- 03Shopify Admin API bulk product mutations used to write the transformed catalogue.
Flow
- WordPress
- Group & transform
- Custom app
- Admin API bulk mutations
- Shopify catalog
Engineering details
- 9,000+ source products
- Name-based grouping into variants
- Bulk mutations, not one-by-one writes
Technology
- Admin API
- GraphQL
- Bulk mutations
- Custom app
- Data transformation