Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-dao/src/main/resources/sql/delist_samsung_pre2025_no_stock.sql – Rev 37562
Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 37562 – 30 d 0 h
- Author: amit
- Log message:
- 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.
