Azelaic Acid (아젤라산) Naming Variants, Product Volume, and Price-per-ml Distribution in the Catalog (July 2026)

Conclusion: A single master ingredient record for Azelaic Acid (아젤라산) maps to 192 name-matched product rows (172 in the aggregate price-stats query), with catalog prices ranging from ₩12,880 to ₩267,090 (median ₩45,000, mean ₩55,547.54) and price-per-ml ranging from ₩271.9 to ₩8,820.

Method

All figures below come from three whitelisted queries run against the internal catalog database on 2026-07-07T08:04:44.413Z: (1) ingredients_master_lookup for slug azelaic-acid (N=1 row), (2) ingredient_keyword_search using name patterns "아젤라산", "아젤라익", "아젤라익애씨드", "azelaic" with limit 200 (N=192 rows returned), and (3) price_stats_by_filter using name patterns "아젤라산", "azelaic" with limit 40 (aggregate count=172; 40 rows sampled, sorted ascending by price). No other data sources were used.

Data

Table 1 — Ingredient Master Record

Table 2 — Row Counts by Query

Table 3 — Summary Statistics (ingredient_keyword_search, N=192)

Table 4 — Aggregate Price Statistics (price_stats_by_filter, N=172)

Table 5 — Price & Price-per-ml Extremes (individual rows)

Table 6 — Lowest-Price Sample (bottom 10 of 172, ascending)

Findings

• A single ingredient master record exists for Azelaic Acid (slug azelaic-acid, row_count 1), and its also_known_as field already lists "아젤라산" as a registered alias, yet name-pattern searches surface 192 product rows (ingredient_keyword_search) and a 172-row aggregate (price_stats_by_filter).
• Central price tendency sits near ₩45,000: median is ₩45,000 (ingredient_keyword_search) and ₩44,950 (price_stats_by_filter), while the mean is higher in both queries — ₩55,547.54 and ₩55,645 respectively — indicating the mean is pulled upward relative to the median.
• Prices span from a low of ₩12,880 (APLB Azelaic Acid Peptide Ampoule Serum, 40ml) to a high of ₩267,090 (Bareface Brightening Serum), the min_price/max_price extremes recorded in both queries.
• Price-per-ml spans from ₩271.9/ml (a 300ml lotion-format listing) to ₩8,820/ml (a 5ml booster-cream-format listing), showing that per-ml economics diverge sharply by product format at the two ends of the volume range.
• Data completeness varies by field across the 192-row keyword-search set: price_krw is present for 175 rows, parsed_volume_ml for 121 rows, and review_rating for only 10 rows.

Limitations

• The "제형 추정" (formulation-type) axis requested for this study — counts by serum, cream, toner, mask, or powder format — is not separately aggregated by either query template; this report does not present per-format counts.
• Per-spelling-variant counts (아젤라산 vs. 아젤라익 vs. 아젤라익애씨드 vs. azelaic individually) are not available; the data pack only provides combined totals across all patterns searched together (192 and 172).
• price_krw has a present_count of 175, parsed_volume_ml a present_count of 121, and review_rating a present_count of only 10 — all out of 192 total rows in the keyword-search query, so a substantial share of listings lack price, volume, or rating data.
• Multiple rows carry volume_parse_note flags such as "no_volume_token_found," "unit_mismatch_grams," and "ambiguous_multiple_ml_values," meaning volume (and therefore price-per-ml) could not be derived for those listings.
• The research question's cited figure of 188 product-name matches is not directly reproduced by either query in this data pack (192 rows in ingredient_keyword_search vs. 172 in the price_stats_by_filter aggregate); this discrepancy is not resolved here.
• The "0 curated entries" framing in the research question cannot be verified from this data pack: the only ingredient-level record retrieved (row_count 1) already lists "아젤라산" as a registered alias in also_known_as.

Related Links

• Ingredient guide: azelaic-acid
• Category page: brightening ingredients
• Pricing analysis: K-beauty serum price-per-ml benchmarks