Philippine Egg Price history

To track real-time retail prices of medium eggs in the Philippines, a data pipeline ingests daily listings from major online grocery retailers (e.g., SM Supermarket and Waltermart). Because stock-keeping units (SKUs) often bundle eggs in different counts (e.g., 6s, 10s, 12s, 30s), all prices are normalized to a per-piece basis. The pipeline extracts the piece count from the SKU string and computes daily average and median prices per egg, enabling apples-to-apples comparisons across brands, stores, and dates.

To ensure relevance and consistency, the dataset is filtered to SKUs explicitly labeled as eggs and medium size, and records are kept only when the piece count is valid. Each day’s snapshot aggregates prices across available markets and products, producing a time series of average price per piece and median price per piece for that date.

As with any retail scraping, day-to-day variation can occur due to SKU availability. If a specific SKU is unavailable on a given day, the system records the next available matching product. While this may introduce some variability, it reflects the actual consumer-facing prices at the time of access, yielding a responsive, near-real-time indicator of how egg prices move across platforms.