WebSVN RSS feed – SmartDukaanWed, 07 Oct 2026 16:58:00 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdelist_samsung_pre2025_no_stock.sql&max=40& Thu, 10 Sep 2026 00:50:44 +0530amit<div><strong>amit – 1 file(s) modified</strong><br/>Add SQL to delist pre-2025 Samsung listings with no stock<br /> <br /> Marks 738 catalog.tag_listing rows (tag_id 4) inactive with eol_date<br /> 2026-09-08. These are Samsung listings published before 2025-01-01 holding<br /> no stock in any SmartDukaan warehouse and none at any active partner store.<br /> <br /> Id list is frozen from the prod evaluation rather than re-derived, so the<br /> same listings are delisted in every environment; stock tables in a copy<br /> drift from prod. Script is idempotent and carries guards, verification and<br /> a rollback block.<br /> <br /> Applied to prod hadb1 and the local dev copy.</div>+ /trunk/profitmandi-dao/src/main/resources/sql/delist_samsung_pre2025_no_stock.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdelist_samsung_pre2025_no_stock.sql&rev=37562https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdelist_samsung_pre2025_no_stock.sql&rev=37562