Building a structured directory for a fragmented traditional industry turns out to be mostly a data-hygiene and localization problem rather than a UI problem. While putting together Fireworks Index—an independent bilingual (English and Chinese) reference mapping 4,714 fireworks manufacturers across 31 countries—several architectural choices made a big difference in keeping records accurate and maintainable.
1. Separating Entity Identity from Localized Display Fields
Many regional manufacturers operate under a local legal name (for example in Chinese, Spanish, or Italian) alongside an informal English export name that varies across trade lists. Storing a canonical immutable entity ID with a separate localized metadata table prevented duplicate rows when merging data from multilingual registries.
- Canonical fields:
entity_id,country_iso,region_slug,locality,coordinates,active_status - Localized fields (
en,zh):display_name,summary,product_categories,slug
2. Attaching Provenance to Every Record
Directories lose trust quickly when listings look copied from anonymous aggregators or mixed with paid placements. Treating source_citation as a first-class schema field—linking each record back to public registries, official company sites, or industry associations—made auditing updates straightforward and kept the catalog independent.
3. Geographic Clustering Over Flat Tables
A flat alphabetical list of nearly 5,000 companies is hard for readers to browse. Grouping records hierarchically by country and production town (such as Liuyang in Hunan, Sivakasi in Tamil Nadu, and regional hubs in Europe and the Americas) turned the dataset into an explorable map and allowed fast static pre-rendering per country and locality page.
4. Keeping Reference Guides Alongside Structured Data
Raw manufacturer rows rarely answer a newcomer's practical questions on their own. Pairing structured directory pages with bilingual reference guides covering product classifications, brands, and wholesale sourcing gave each taxonomy term concrete context and clean internal linking.
You can explore the live bilingual directory and country breakdowns at Fireworks Index.
