🔧 barcodedb INTERNAL

Mission Control

2026-04-28T10:10:30.087578Z
Overview PQS Drill-down Legacy Dashboard

Feed Health

Status of each scheduled retailer feed. Flagged stale if no success in >36 h.
bestbuy ✓ OK
Last OK: 2026-04-28T05:24 (5h ago)
newegg ✓ OK
Last OK: 2026-04-28T02:20 (8h ago)
bh ✓ OK
Last OK: 2026-04-28T02:43 (8h ago)
walmart ✓ OK
Last OK: 2026-04-28T03:31 (7h ago)
lenovo ✓ OK
Last OK: 2026-04-28T03:53 (6h ago)

Pipeline Funnel

Data flow from ingestion to publication.
961,636
Products
→
999,646
Raw Specs
→
61,033
Normalized
→
56,692
Reconciled
→
56,692
PQS Scored
→
29,601
PQS ≥ 75
→
10,000
Publish Set
Retailer Offers
1,014,377
Price History Records
23,480,168

PQS Component Averages

Average points across all scored products. Total max = 100.
Component Max Avg Points %
Spec Completeness 30 15.2
51%
Retailer Depth 15 12.9
86%
Price History 15 14.8
99%
Freshness 10 4.6
46%
Internal Linking 10 9.6
96%
Template Quality 10 9.9
99%
Category Strength 10 9.9
99%
Overall PQS 100 76.7
77%

Feed Status

Per-retailer raw and normalized spec counts.
Retailer Raw Specs Normalized Norm Rate First Seen Last Seen
bestbuy 63,226 54,932 86.9% 2026-03-02T07:33 2026-04-28T05:24
bh 19,453 0 0.0% 2026-03-02T10:40 2026-04-28T02:43
lenovo_us 3,087 1,356 43.9% 2026-03-02T10:58 2026-04-28T03:53
newegg 32,159 4,745 14.8% 2026-03-02T10:42 2026-04-28T02:19
walmart 881,721 0 0.0% 2026-04-04T03:23 2026-04-28T03:31

Top Categories

Category Reconciled PQS ≥ 75 Publish Set Pass Rate
(none) 27,282 5,495 1 20.1%
audio 3,798 3,464 700 91.2%
range 3,437 3,430 800 99.8%
tablet 2,419 1,428 600 59.0%
laptop 2,331 2,102 1,200 90.2%
refrigerator 1,898 1,731 800 91.2%
range_hood 1,658 1,186 300 71.5%
smartwatch 1,251 145 0 11.6%
phone 1,179 1,002 800 85.0%
monitor 1,056 854 488 80.9%
washer 958 796 200 83.1%
car_dash_kit 786 785 200 99.9%
tv 737 670 400 90.9%
dishwasher 654 614 330 93.9%
microwave 639 585 400 91.5%
grill 582 578 0 99.3%
smart_camera 555 427 200 76.9%
car_installation_accessory 473 289 153 61.1%
gaming_controller 463 304 150 65.7%
ssd 433 333 163 76.9%
oven_single 425 425 300 100.0%
car_radio_harness 348 320 149 92.0%
camera 319 312 217 97.8%
freezer 311 202 100 65.0%
wine_cooler 307 0 0 0.0%
oven_double 289 289 200 100.0%
gaming_headset 287 260 150 90.6%
lens 282 279 239 98.9%
mini_fridge 278 278 100 100.0%
air_conditioner 272 259 100 95.2%

Data Quality

Spec coverage & constraint violations per category.

Ingest Runs

Last 50 ingestion jobs.
ID Source Status Started Duration Total OK Errors Input Error Summary
256 ir_lenovo_us completed_with_errors 2026-04-28T03:53 0s 4,905 2,739 2,166 data/raw/ir/lenovo_us/20260428T035303Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
255 ir_walmart_electronics completed_with_errors 2026-04-28T03:16 15m 6s 463,013 461,736 1,277 data/raw/ir/walmart/20260428T031607Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
254 bh_feed completed_with_errors 2026-04-28T02:42 14s 13,712 13,296 416 data/raw/bh/20260428T024256Z_20260428T024256Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 9, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
253 newegg_feed completed_with_errors 2026-04-28T02:16 2m 55s 897,670 31,723 27,578 data/raw/newegg/20260428T021600Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 838369, "delimiter": "|", "match_only": true, "skip_rows": 0}
252 bestbuy_all ✓ ok 2026-04-28T01:23 4h 0m 56,400 56,400 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 564, "rows_invalid_gtin": 0, "gtin_reject_reasons": {}, "error_samples": []}
251 ir_lenovo_us completed_with_errors 2026-04-27T03:44 0s 4,904 2,740 2,164 data/raw/ir/lenovo_us/20260427T034418Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
250 ir_walmart_electronics completed_with_errors 2026-04-27T03:26 14m 51s 463,013 461,736 1,277 data/raw/ir/walmart/20260427T032604Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
249 bh_feed completed_with_errors 2026-04-27T02:43 14s 13,772 13,351 421 data/raw/bh/20260427T024315Z_20260427T024315Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 9, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
248 newegg_feed completed_with_errors 2026-04-27T02:16 3m 23s 892,890 31,735 27,586 data/raw/newegg/20260427T021527Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 833569, "delimiter": "|", "match_only": true, "skip_rows": 0}
247 bestbuy_all ✓ ok 2026-04-27T01:16 0s 0 0 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": null, "pages_done": 0, "pages_total": 565, "rows_invalid_gtin": 0, "gtin_reject_reasons": {}, "error_samples": []}
246 ir_lenovo_us completed_with_errors 2026-04-26T03:49 0s 4,901 2,740 2,161 data/raw/ir/lenovo_us/20260426T034937Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
245 ir_walmart_electronics completed_with_errors 2026-04-26T03:19 14m 44s 463,013 461,736 1,277 data/raw/ir/walmart/20260426T031940Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
244 bh_feed completed_with_errors 2026-04-26T02:38 15s 13,973 13,539 434 data/raw/bh/20260426T023838Z_20260426T023838Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 8, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
243 newegg_feed completed_with_errors 2026-04-26T02:16 3m 47s 893,742 31,768 27,549 data/raw/newegg/20260426T021540Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 834425, "delimiter": "|", "match_only": true, "skip_rows": 0}
242 bestbuy_all ✓ ok 2026-04-26T01:23 3h 59m 56,441 56,429 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 565, "pages_done": 565, "pages_total": 565, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
241 ir_lenovo_us completed_with_errors 2026-04-25T03:44 0s 4,899 2,740 2,159 data/raw/ir/lenovo_us/20260425T034441Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
240 ir_walmart_electronics completed_with_errors 2026-04-25T03:26 14m 14s 452,272 451,036 1,236 data/raw/ir/walmart/20260425T032652Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
239 bh_feed completed_with_errors 2026-04-25T02:35 14s 13,973 13,539 434 data/raw/bh/20260425T023539Z_20260425T023539Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 8, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
238 newegg_feed completed_with_errors 2026-04-25T02:16 1m 50s 888,726 31,790 27,549 data/raw/newegg/20260425T021600Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 829387, "delimiter": "|", "match_only": true, "skip_rows": 0}
237 bestbuy_all ✓ ok 2026-04-25T01:20 3h 59m 56,442 56,430 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 565, "pages_done": 565, "pages_total": 565, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
236 ir_lenovo_us completed_with_errors 2026-04-24T03:45 0s 4,900 2,744 2,156 data/raw/ir/lenovo_us/20260424T034517Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
235 ir_walmart_electronics completed_with_errors 2026-04-24T03:25 14m 38s 462,100 460,893 1,207 data/raw/ir/walmart/20260424T032531Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
234 bh_feed completed_with_errors 2026-04-24T02:39 14s 13,892 13,447 445 data/raw/bh/20260424T023925Z_20260424T023925Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 8, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
233 newegg_feed completed_with_errors 2026-04-24T02:23 3m 46s 890,406 31,484 27,626 data/raw/newegg/20260424T022232Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 831296, "delimiter": "|", "match_only": true, "skip_rows": 0}
232 bestbuy_all ✓ ok 2026-04-24T01:13 3h 59m 56,421 56,409 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 565, "pages_done": 565, "pages_total": 565, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
231 ir_lenovo_us completed_with_errors 2026-04-23T03:42 0s 4,902 2,746 2,156 data/raw/ir/lenovo_us/20260423T034213Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
230 ir_walmart_electronics completed_with_errors 2026-04-23T03:17 14m 47s 462,100 460,893 1,207 data/raw/ir/walmart/20260423T031727Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
229 bh_feed completed_with_errors 2026-04-23T02:33 14s 13,800 13,362 438 data/raw/bh/20260423T023305Z_20260423T023305Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 7, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
228 newegg_feed completed_with_errors 2026-04-23T02:13 3m 47s 890,994 31,767 27,336 data/raw/newegg/20260423T021225Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 831891, "delimiter": "|", "match_only": true, "skip_rows": 0}
227 bestbuy_all ✓ ok 2026-04-23T01:17 3h 59m 56,384 56,372 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 565, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
226 ir_lenovo_us completed_with_errors 2026-04-22T03:49 0s 4,896 2,741 2,155 data/raw/ir/lenovo_us/20260422T034957Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
225 ir_walmart_electronics completed_with_errors 2026-04-22T03:15 14m 17s 462,100 460,893 1,207 data/raw/ir/walmart/20260422T031503Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
224 bh_feed completed_with_errors 2026-04-22T02:41 14s 13,542 13,109 433 data/raw/bh/20260422T024117Z_20260422T024117Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 7, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
223 newegg_feed completed_with_errors 2026-04-22T02:14 2m 50s 891,737 31,261 27,315 data/raw/newegg/20260422T021315Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 833161, "delimiter": "|", "match_only": true, "skip_rows": 0}
222 bestbuy_all ✓ ok 2026-04-22T01:17 4h 0m 56,337 56,325 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 564, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
221 ir_lenovo_us completed_with_errors 2026-04-21T03:48 0s 4,890 2,740 2,150 data/raw/ir/lenovo_us/20260421T034847Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
220 ir_walmart_electronics completed_with_errors 2026-04-21T03:21 14m 13s 462,100 460,893 1,207 data/raw/ir/walmart/20260421T032058Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
219 bh_feed completed_with_errors 2026-04-21T02:41 14s 13,392 12,958 434 data/raw/bh/20260421T024154Z_20260421T024154Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 7, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
218 newegg_feed completed_with_errors 2026-04-21T02:11 3m 42s 889,022 31,203 27,333 data/raw/newegg/20260421T021054Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 830486, "delimiter": "|", "match_only": true, "skip_rows": 0}
217 bestbuy_all completed_with_errors 2026-04-21T01:20 3h 59m 56,347 56,306 29 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 564, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": [{"page": 293, "sku": "6580387", "raw_upc": "850029050759", "gtin14": "00850029050759", "error_type": "DeadlockDetected", "error": "deadlock detected\nDETAIL: Process 816652 waits for ShareLock on transaction 15599376; blocked by process 829291.\nProcess 829291 waits for ShareLock on transaction 15602530; blocked by process 816652.\nHINT: See server log for query details.\nCONTEXT: while inserting index tuple (20985,20) in relation \"products\""}, {"page": 293, "sku": "6580388", "raw_upc": "850029050803", "gtin14": "00850029050803", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580389", "raw_upc": "850029050650", "gtin14": "00850029050650", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580390", "raw_upc": "850029050674", "gtin14": "00850029050674", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580391", "raw_upc": "850029050735", "gtin14": "00850029050735", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580393", "raw_upc": "850029050810", "gtin14": "00850029050810", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580394", "raw_upc": "850029050728", "gtin14": "00850029050728", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580395", "raw_upc": "850029050773", "gtin14": "00850029050773", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580396", "raw_upc": "850029050858", "gtin14": "00850029050858", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580398", "raw_upc": "810119071248", "gtin14": "00810119071248", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580400", "raw_upc": "810119071545", "gtin14": "00810119071545", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580401", "raw_upc": "810119071262", "gtin14": "00810119071262", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580402", "raw_upc": "810119071255", "gtin14": "00810119071255", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580406", "raw_upc": "041093935916", "gtin14": "00041093935916", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580407", "raw_upc": "041093935602", "gtin14": "00041093935602", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580408", "raw_upc": "810119071835", "gtin14": "00810119071835", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580449", "raw_upc": "810143400014", "gtin14": "00810143400014", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580450", "raw_upc": "887276870250", "gtin14": "00887276870250", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580457", "raw_upc": "686136960229", "gtin14": "00686136960229", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}, {"page": 293, "sku": "6580458", "raw_upc": "686136913140", "gtin14": "00686136913140", "error_type": "InFailedSqlTransaction", "error": "current transaction is aborted, commands ignored until end of transaction block"}]}
216 ir_lenovo_us completed_with_errors 2026-04-20T03:54 0s 4,890 2,745 2,145 data/raw/ir/lenovo_us/20260420T035425Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
215 ir_walmart_electronics completed_with_errors 2026-04-20T03:23 14m 41s 462,100 460,893 1,207 data/raw/ir/walmart/20260420T032344Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
214 bh_feed completed_with_errors 2026-04-20T02:31 14s 13,513 13,074 439 data/raw/bh/20260420T023138Z_20260420T023138Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 7, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
213 newegg_feed completed_with_errors 2026-04-20T02:19 3m 43s 909,382 31,269 27,344 data/raw/newegg/20260420T021856Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 850769, "delimiter": "|", "match_only": true, "skip_rows": 0}
212 bestbuy_all ✓ ok 2026-04-20T01:23 4h 1m 56,341 56,329 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 564, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}
211 ir_lenovo_us completed_with_errors 2026-04-19T03:45 0s 4,892 2,747 2,145 data/raw/ir/lenovo_us/20260419T034509Z_LenovoImpactRadiusUSNEW_IR.txt;delimiter= ;has_header=True;retailer=lenovo_us {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "UPC", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
210 ir_walmart_electronics completed_with_errors 2026-04-19T03:22 14m 12s 462,100 460,893 1,207 data/raw/ir/walmart/20260419T032158Z_72-ELECTRONICS_IR.txt;delimiter= ;has_header=True;retailer=walmart {"rows_invalid_gtin": 0, "delimiter": "\t", "has_header": true, "skip_rows": 0, "upc_field": "EAN", "sku_field": "MPN", "price_field": "Current Price", "title_field": "Product Name"}
209 bh_feed completed_with_errors 2026-04-19T02:34 14s 13,700 13,259 441 data/raw/bh/20260419T023432Z_20260419T023432Z_shopiner20033/shopiner20033.csv;delimiter=,;has_header=True;retailer=bh {"rows_invalid_gtin": 7, "delimiter": ",", "has_header": true, "skip_rows": 0, "upc_field": "upc", "sku_field": "itemcode", "price_field": "price"}
208 newegg_feed completed_with_errors 2026-04-19T02:24 3m 41s 906,729 31,087 27,336 data/raw/newegg/20260419T022305Z_44583_3309007_mp.txt;delimiter=|;match_only=True;retailer=newegg {"rows_invalid_gtin": 0, "rows_skipped_no_match": 848306, "delimiter": "|", "match_only": true, "skip_rows": 0}
207 bestbuy_all ✓ ok 2026-04-19T01:18 4h 0m 56,393 56,381 0 {"allow_invalid_gtin":false,"allow_parallel":false,"base_retry_sleep":20.0,"commit_every_pages":1,"max_pages":0,"max_retries":8,"over_quota_sleep_seconds":3600.0,"page_size":100,"resume_from_last_run":true,"sleep":20.0,"sleep_jitter":10.0,"start_page":1,"stop_when_remaining":5,"wait_on_over_quota":true} {"last_page_processed": 564, "pages_done": 564, "pages_total": 566, "rows_invalid_gtin": 12, "gtin_reject_reasons": {"missing": 12}, "error_samples": []}