# Seed / Import Data

Place historical CSV or JSON price datasets here for bulk import.

## CSV format

```csv
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

```json
[
  {
    "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:

```bash
psql $DATABASE_URL -c "\copy price_snapshots FROM 'seed/prices.csv' CSV HEADER"
```