Client Ẹwà London
Service Store Data Hygiene
Platform Shopify
Market UK · Luxury Skincare
Engagement 5 Days

A post-migration catalogue in crisis. Thirty days from a major launch.

When Ẹwà London replatformed from WooCommerce to Shopify ahead of their largest retail push to date, they inherited a catalogue that was technically live but operationally broken — 67 products, 7 vendor values, 3 misfiring Klaviyo flows, and a collection architecture that had never been rebuilt from scratch.

Products resolved 67 → 34 Duplicate clusters, junk records, and incomplete products removed
Klaviyo revenue recovered £3,800/mo 3 broken flows restored by resolving deleted product references
Issues cleared 6 of 6 All issue categories resolved before the 30-day launch window
Background

A brand that outgrew its infrastructure.

Ẹwà London launched as a market stall in Brixton in 2021, selling Afro-botanical skincare formulated around shea, baobab, and black seed oil. By 2023 they had a WooCommerce store, a growing wholesale account list, and a Klaviyo account set up by a freelancer who no longer worked with them.

When they migrated to Shopify in late 2024, the developer performing the migration imported the WooCommerce catalogue programmatically — every product, every category, every vendor field, including all the test entries, deprecated variants, and WooCommerce category structures that had accumulated over two years.

The result was a store that looked fine in the admin dashboard but was silently broken underneath: Klaviyo flows referencing product IDs that no longer existed, smart collections built on tag logic that never fully migrated, and three versions of the same hero product sitting live and active at the same time.

They came to us with 30 days to launch a major PR campaign and a Klaviyo account that had been sending broken abandoned cart emails for six weeks.

The Audit

What the catalogue actually looked like.

Before touching anything, we ran a full data hygiene audit — mapping every product, every vendor value, every collection rule, and every inventory anomaly. This is what we found.

Product catalogue state — at audit (67 records)
Incomplete / no data
Junk / test product
Duplicate record
Clean — survivor
11
Duplicate Clusters
23 total duplicate records across 11 product clusters. Most originated from the WooCommerce import creating separate records for size variants that should have been Shopify variants within a single product.
9
Junk / Test Products
Developer test entries from the migration, all in ACTIVE status and visible to customers. Two were appearing in Google Shopping feed. One was named "DO NOT PUBLISH — STAGING ONLY."
7
Vendor Values
A single brand, seven vendor strings: variations of the brand name across different capitalisations, the developer's handle, "WooCommerce Import," and two blank entries.
14
Collections to Retire
WooCommerce categories had been imported as Shopify smart collections. None had been rebuilt with Shopify-native rules. Four collections contained zero products. Three overlapped completely.
4
Inventory Anomalies
Two products at zero stock with "continue selling" enabled — accepting orders with nothing to fulfil. One product at 10,000 units (WooCommerce unlimited stock import artefact). One at -3.
3
Broken Klaviyo Flows
Abandoned cart, post-purchase upsell, and browse abandonment flows were all referencing Shopify product IDs from the WooCommerce migration that no longer existed. Emails were sending but product blocks were blank.

The Klaviyo issue was the most urgent finding. The abandoned cart flow had been active for six weeks. Every email had sent with a broken product block — no image, no title, no "Add to Cart" button. Customers were receiving cart reminder emails pointing at nothing. The flow was suppressing revenue, not recovering it.

Catalogue State

Before and after, in every dimension.

✕  Inherited State
  • Total products67
  • Unique vendor values7
  • ACTIVE junk / test products9
  • Duplicate clusters11
  • Products with no description31
  • Products with £0 price14
  • Collections14
  • Empty collections4
  • Inventory anomalies4
  • Broken Klaviyo product refs3 flows
  • Products in Google Shopping feed67 (incl. junk)
✓  Post-Cleanup
  • Total products34
  • Unique vendor values1
  • ACTIVE junk / test products0
  • Duplicate clusters0
  • Products with no description0 (all populated)
  • Products with £0 price0
  • Collections6
  • Empty collections0
  • Inventory anomalies0
  • Broken Klaviyo product refs0 — all flows updated
  • Products in Google Shopping feed34 (clean)
Revenue Impact

The number that mattered most to the client.

The data hygiene work itself was the foundation. But the immediate commercial consequence — the number the founder cared about — was what happened to Klaviyo performance once the broken product references were resolved.

Monthly Klaviyo Revenue Recovered £3,800

Estimated monthly flow revenue suppressed by broken product references, restored within 72 hours of cleanup completion. Based on Klaviyo flow analytics comparing the 30-day pre-cleanup period against the 30-day post-cleanup period.

£2,100 Abandoned Cart flow (primary — highest volume)
£940 Browse Abandonment flow (product block restored)
£760 Post-Purchase Upsell flow (cross-sell product fixed)

The broken flows had been active for six weeks before the audit. At £3,800 per month that represents approximately £5,700 in suppressed revenue during that window — revenue that was being lost silently, with no error message, no Shopify alert, and no visible indicator in the admin dashboard. The store looked fine. The catalogue looked fine. The money was just not arriving.

This is why data hygiene is not a cosmetic service. It is a revenue integrity audit.

How We Work

The process, from first access to final report.

01
Audit — map the full catalogue state
We produce a structured audit findings report before touching a single product. Every issue is categorised, every dependency checked. Nothing is deleted before we know whether it is referenced in a Klaviyo flow, a discount code, an active ad campaign, or an existing order.
02
Orchestrator review — you make the decisions
We present findings and recommended actions. The client (or agency) confirms which duplicate survives, what the canonical vendor name is, and whether to archive or delete. We execute the decisions — we do not make them unilaterally.
03
Execution — in a defined sequence
Vendor standardization first. Then duplicate resolution. Then junk deletion. Then inventory correction. Then incomplete records. Then collections last. This order exists because each step creates the clean foundation the next step depends on.
04
Klaviyo handoff — flow integrity check
Every product deletion triggers a Klaviyo check. Flows referencing deleted product IDs are updated immediately. In this engagement, three flows were restored within the same working session as the product cleanup.
05
Before/After Report — the client deliverable
A structured report documenting every change made, every decision taken, and every outstanding item that needs client input. Formatted for a non-technical stakeholder. Ends with a prioritised list of recommended next steps.
What You Receive

Three documents. One clean store.

01
Audit Findings Report
A structured breakdown of every issue found, organised by category. Includes dependency checks, risk ratings, and recommended actions. Produced before any execution begins.
02
Cleanup SOP
A step-by-step internal record of the execution sequence followed, including every decision made and why. Serves as your paper trail if a client ever questions a change.
03
Before / After Report
A client-facing document showing the catalogue in both states across every measured dimension. Formatted for a non-technical founder or brand director. Includes revenue impact where measurable.
Free First Audit

Give us your messiest client store.
We'll do this for free.

If you have a client account that looks anything like Ẹwà London did — post-migration chaos, duplicate products, broken Klaviyo flows, vendor inconsistency — send us the store URL. We will run the full audit, produce the findings report, and deliver a Before/After Report to your standard, white-labelled with your agency name.

No charge. No commitment. One store. You keep everything we produce.

If you like what you see, we'll talk about a white-label arrangement for your other clients.

Send Us the Store URL growthlabs.strategy@gmail.com · We'll confirm within 24 hours and begin within 48