| 37853 |
amit |
1 |
-- NOTE ONLY - no SQL to run. Changes made on hadb1 on 2026-10-05 outside any Claude session (no script or backup kept
|
|
|
2 |
-- by whoever ran them), recorded so the history is complete.
|
|
|
3 |
--
|
|
|
4 |
-- 1. Franchise store remap, afternoon of 2026-10-05:
|
|
|
5 |
-- fofo.fofo_store.warehouse_id 7720 -> 13368, 7573 -> 13370, 9514 -> 13372 (FRANCHISE stores; INTERNAL stores kept).
|
|
|
6 |
-- After: 13368 = 292 franchise stores (91 active), 13370 = 69 (18), 13372 = 403 (244).
|
|
|
7 |
--
|
|
|
8 |
-- 2. Pending orders (status 3) moved to HR, same afternoon, with reservations
|
|
|
9 |
-- (transaction.order.warehouse_id + fulfilmentWarehouseId, inventory.currentreservationsnapshot,
|
|
|
10 |
-- inventory.currentinventorysnapshot.reserved). Verified consistent: each moved order's reservation row is on its new
|
|
|
11 |
-- fulfilment warehouse. Of the 112 orders listed in transaction._wh_move_plan_20261005:
|
|
|
12 |
-- 7573 -> 13368: 29 7678 -> 13368: 2 7720 -> 13368: 2 9514 -> 13368: 22 9514 -> 13372: 57
|
|
|
13 |
-- Orders on internal movement POs were left on 7573/9514/10516 by choice (13 at the time).
|
|
|
14 |
-- transaction._bak_order_wh_move_20261005 / inventory._bak_crs_wh_move_20261005 / inventory._bak_cis_wh_move_20261005
|
|
|
15 |
-- are snapshots taken mid-move by a rolled-back attempt, not a clean "before".
|