# `List at` source audit

Generated 2026-09-23T01:07:59.600461+00:00 by `audit_list_at_sources.py`. Read-only: no database
writes, no xAI calls, no cache writes.

Command: `audit_list_at_sources.py --asin 9652204986`

Keepa tokens consumed: **6**

The AI reasonableness check was stubbed to `True` for every row, so
`recomputed List_at` is the ARITHMETIC the pricing code produces. The
`AI check in play` column says which rows reach that check in production.

## Summary

```
LIST AT SOURCE AUDIT  2026-09-23 01:07:59Z  |  1 rows, 6 Keepa tokens
  sample: 1 named ASIN(s) (limit 50); processed 1, failed 0
(a) WHAT SET List at   [median/sparse 1 | mode-distinct 0 | unclassified 0]
  mode, backed by ONE SHARED price point ......... 0   <- the hypothesis
    reconstruction == production 0 | ceiling did not overwrite it 0
  de-duplicating CHANGES List at on ............. 0 row(s)
(b) List at vs LOWEST NEW OFFER IN ITS PEAK WINDOW(S)   csv[1], item price
  rows with a New price in a peak window ........ 1 of 1
  List at ABOVE that floor ...................... 0
  comparison only: List at above TODAY's New ... 0  (buy side, not a bound)
(c) AMAZON CEILING   min(current, 180d, 365d) x 0.90
  clipped a peak-season List at on .............. 0 row(s)
    on TODAY's Amazon price, outside the peak month  0
    on a trailing average that blends the seasons .. 0
(d) THIN PEAK SEASON  unpriced if distinct points < min  [sparse]  of 1 priced (0 already not)
  min 2:  peak month only   0 [0]  |  peak month +/-1   0 [0]
  min 3:  peak month only   1 [0]  |  peak month +/-1   0 [0]
  min 4:  peak month only   1 [0]  |  peak month +/-1   0 [0]
```

## Every row

| ASIN | stored List_at | recomputed List_at | how | recon==prod | peak | sane sales | fed List_at | mode count | distinct points | shared dups | dup set price | sales after dedup | List_at after dedup | peak after dedup | dedup changed | peak-window New floor | median window floor | windows (yyyy-mm:floor) | windows | New points in windows | floor carried forward | List_at - peak-window New | today's New (item) | today's New (landed) | live offer item | live offer ship | ship estimated | live offer FBA | live New offers | above today's New | ceiling clipped | ceiling basis | Amazon price used | ceiling value | ceiling = today's price | measured outside peak month | ceiling blends seasons | ceiling mirror == prod | pre-ceiling branch value | peak-window New cap | season centre | centre mirrored (sparse) | sparse rescue | points in peak month | points in peak +/-1 | stored 1yr_Avg | stored Price_Now | stored sale count | version | offer drops | price source | AI check in play | error |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 9652204986 |  | 24.82 | median | True | Dec | 21 | 6 | 0 | 6 | 0 | False | 18 | 24.82 | Dec | False | 225.31 | 589.32 | 2025-11:225.31; 2025-12:589.32; 2026-01:589.32 | 3 | 36 | True |  |  | 28.94 | 24.95 | 3.99 | False | False | 2 | False | False |  |  |  | False |  | False |  | 24.82 | not needed | 12 | False | False | 2 | 6 | 148.60380952381 | 48.87 | 21 | 3 | 25 | Inferred Sales | True |  |

## Raw

```json
[
  {
    "ASIN": "9652204986",
    "list_at": null,
    "avg_1yr": "148.60380952381",
    "price_now": 48.87,
    "stored_sale_count": 21,
    "pricing_version": 3,
    "title": "Dictionary of Basic Biblical Hebrew",
    "error": null,
    "sane_sale_count": 21,
    "total_offer_drops": 25,
    "peak_season": "Dec",
    "price_source": "Inferred Sales",
    "xai_check_in_play": true,
    "recomputed_list_at": 24.82,
    "season_centre_month": 12,
    "season_centre_mirrored": false,
    "is_sparse": false,
    "season_points_month": 2,
    "season_points_window": 6,
    "classification": "median",
    "branch_list_at": 24.82,
    "branch_matches_production": true,
    "contributing_sales": 6,
    "mode_count": 0,
    "distinct_source_points": 6,
    "shared_point_sales": 0,
    "dedup_list_at": 24.82,
    "dedup_changes_list_at": false,
    "dedup_sale_count": 18,
    "dedup_peak_season": "Dec",
    "peak_new_floor": 225.31,
    "peak_new_median_window": 589.32,
    "peak_windows": "2025-11:225.31; 2025-12:589.32; 2026-01:589.32",
    "peak_window_count": 3,
    "peak_new_points": 36,
    "peak_new_carried_forward": true,
    "overstatement": null,
    "new_offer_count": 2,
    "current_new_item": null,
    "new_landed": 28.94,
    "new_item": 24.95,
    "new_shipping": 3.99,
    "new_shipping_estimated": false,
    "new_is_fba": false,
    "above_current_new": false,
    "peak_new_cap": "not needed",
    "ceiling_basis": null,
    "ceiling_amazon_price": null,
    "ceiling_price": null,
    "ceiling_engaged": false,
    "ceiling_on_todays_price": false,
    "ceiling_outside_peak_month": null,
    "ceiling_blends_seasons": false,
    "ceiling_matches_production": null,
    "duplicate_set_the_price": false,
    "reconstruction_matches_production": true
  }
]
```