Subversion Repositories SmartDukaan

Last modification

• Rev 37562 2026-09-10 00:50:44
• 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.