Jonathan
486749a890
Full-stack Dutch supermarket price tracker with FastAPI backend, PostgreSQL/SQLAlchemy, Albert Heijn scraper, and Next.js frontend. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Seed / Import Data
Place historical CSV or JSON price datasets here for bulk import.
CSV format
store_slug,external_id,ean,name,brand,category,url,price,unit_price,unit_description,was_price,is_on_sale,timestamp
albert-heijn,12345,8710400123456,AH Halfvolle melk,AH,Melk,https://www.ah.nl/...,129,108,per liter,,false,2024-01-15T10:00:00
price,unit_price,was_price— euro cents (integer)timestamp— ISO 8601, UTC
JSON format
[
{
"store_slug": "albert-heijn",
"external_id": "12345",
"ean": "8710400123456",
"name": "AH Halfvolle melk",
"brand": "AH",
"category": "Melk",
"url": "https://www.ah.nl/producten/product/wi12345/ah-halfvolle-melk",
"price": 129,
"unit_price": 108,
"unit_description": "per liter",
"was_price": null,
"is_on_sale": false,
"timestamp": "2024-01-15T10:00:00"
}
]
Import
A import-seed CLI command is planned. For now import via psql:
psql $DATABASE_URL -c "\copy price_snapshots FROM 'seed/prices.csv' CSV HEADER"