Flagship 01 / WooCommerce data architecture
Governing location data and database growth inside a live retail system.
An Australian WooCommerce retailer needed a large location dataset to support delivery workflows and useful location content under an established live store.
Uncontrolled imports, generated content, cache behavior, and indexing could increase database weight or damage relationships that existing commerce functions depended on.
The system combined a custom post type, hierarchical suburb, region, state, and country relationships, dynamic location content, delivery pages, and substantial database growth. Production data could not be discarded for a clean rebuild.
Treat imports, relationships, content generation, indexing, and cleanup as one governed data lifecycle. Separate required records from disposable growth and protect a reversible boundary before changing the live database.
The required hierarchy and operational location workflow were retained. Database weight was materially reduced while the records needed by the live store remained protected.
