Maintain

USDA sync

This never overwrites what you already edited. Photos, names, nutrition, tags, and cuisines on existing rows stay as they are.

Sync only adds foods that are not already in the catalog:

USDA rows whose FDC id is not in the database
skipped if a cook-facing name already exists (same unique-name rule as admin create)
curated extras (matooke, witlof, …) whose names are still missing

First run or a forced re-download can take several minutes (USDA CSV archives). Leave this page open; status updates below.

Last run

Status: ok · started 2026-08-20T12:58:13.084320+00:00 · finished 2026-08-20T12:58:22.147570+00:00

Catalog before: 5731
Catalog after: 5756
New USDA rows: 25
New extras: 0
Existing USDA ids left unchanged: 4398
Skipped duplicate names: 500

Starting USDA sync (add new ingredients only)…
Downloading USDA datasets (if needed)...
Catalog already has 5731 ingredients (4398 USDA ids).
Selecting cooking ingredients...
  sr_legacy: 7793 rows
  foundation: 74175 rows
  kept 525 USDA rows not already in the catalog (cap 25000)
  reading nutrients in sr_legacy (410 foods)...
  reading nutrients in foundation (115 foods)...
Inserting USDA ingredients (new FDC ids only)...
  skipped 500 USDA rows whose display names were already in the catalog
Inserting world-cuisine extras (new names only)...
Seed complete: 5756 ingredients (+25 USDA, +0 extras, 4398 existing USDA ids left unchanged).