| 37562 |
27 d 17 h |
amit |
/trunk/profitmandi-dao/src/main/resources/sql/ |
Add SQL to delist pre-2025 Samsung listings with no stock
Marks 738 catalog.tag_listing rows (tag_id 4) inactive with eol_date
2026-09-08. These are Samsung listings published before 2025-01-01 holding
no stock in any SmartDukaan warehouse and none at any active partner store.
Id list is frozen from the prod evaluation rather than re-derived, so the
same listings are delisted in every environment; stock tables in a copy
drift from prod. Script is idempotent and carries guards, verification and
a rollback block.
Applied to prod hadb1 and the local dev copy. |
|
/trunk/profitmandi-dao/src/main/resources/sql/delist_samsung_pre2025_no_stock.sql
|