Rev 37778 – fix(catalog): delist cron retires only models it darkened in the ...

amit — Thu, 24 Sep 2026 22:37:06 +0530

amit – 3 file(s) modified
fix(catalog): delist cron retires only models it darkened in the same run

Step 4 scanned every mobile model with no active listing and moved it to OTHER,
so new launches (categorised before listing) and hand-paused models were retired
the next morning, e.g. Nothing Phone 4 1026596-603 on 2026-09-15. Scope it to
models whose listing this run delisted (_delist_audit run_date = today).
Add fix_dark_model_retire_20260924.sql to restore the 16 models still stuck on OTHER.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/CatalogDelistServiceImpl.java
~ /trunk/profitmandi-dao/src/main/resources/sql/delist_inactive_listings_rolling_24m.sql
+ /trunk/profitmandi-dao/src/main/resources/sql/fix_dark_model_retire_20260924.sql

SmartDukaan – //trunk/profitmandi-dao/src/main/resources/sql/fix_dark_model_retire_20260924.sql

Rev 37778 – fix(catalog): delist cron retires only models it darkened in the ...