Subversion Repositories SmartDukaan

-- Haryana Gurugram is a NEW GST registration: seller 21 NSSPL-HR-GGN, GSTIN 06AACCN9802G2ZI (created 2026-10-01).

-- Three physical billing warehouses under it, replacing the Delhi-GSTIN ones:

--   7720 DL-NSSPL/Delhi-HR -> HR-NSSPL/GGN  (NSHRGGN)  internal store HRGN1710

--   7573 DL-NSSPL/Delhi    -> HR-NSSPL/DL   (NSHRDL)   internal store HRGN1713

--   9514 NSSPL-DL/Noida    -> HR-NSSPL/UPW  (NSHRUPW)  internal store HRGN1714

-- 7681 HR-NSSPL / seller 16 (06AACCN9802G1ZJ, Faridabad) stay untouched: their past invoices, CNs and returns

-- resolve sellerwarehouse by (7681, seller 16).

-- Region rows are OURS/BAD vendor 40 like 7573/7720/7681 - never GOOD/vendor 1 (Hotspot), which lookups mistake for a

-- supplier child. Per-supplier G/B/THIRD_PARTY children, internal suppliers, brand mapping, warehouse_provider, internal

-- store moves and the ProfitMandiConstants maps follow separately.

START TRANSACTION;

-- new GST address; city must be the last comma segment (WarehouseAddressMaster.getCustomAddress)

INSERT INTO transaction.warehouseaddressmaster (address, pin, state_id, created, contact_number, contact_person)

VALUES ('Ground Floor, Plot No. 466, Udyog Vihar Phase 5, Gurugram', '122016', 3, NOW(), '9718617332', 'Shivam Gupta');

SET @addr = LAST_INSERT_ID();

SET @loc = 'Ground Floor, Plot No. 466, Udyog Vihar Phase 5, Gurugram';

SET @gstin = '06AACCN9802G2ZI';

SET @seller = 21;

-- HR-NSSPL/GGN

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/GGN', @loc, 3, NOW(), NOW(), NULL, @gstin, '122016', 3, 40, 0, 'BAD', 'OURS', 0, 0, 0, 0, 3, 0);

SET @w = LAST_INSERT_ID();

UPDATE inventory.warehouse SET billingWarehouseId = @w, shippingWarehouseId = @w WHERE id = @w;

INSERT INTO transaction.sellerwarehouse (seller_id, warehouse_id, orderType, id, prefix, challan_id, cn_sequence,

  created_on, is_active, dn_sequence, refurb_sequence, fofo_dn_sequence)

VALUES (@seller, @w, 0, 0, 'NSHRGGN', 0, 0, NOW(), 1, 0, 0, 0);

INSERT INTO transaction.warehouseaddressmapping (warehouse_id, address_id, created, updated) VALUES (@w, @addr, NOW(), NULL);

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/GGN/Dummy/G', NULL, 3, NOW(), NOW(), NULL, NULL, '122016', 3, 40, 0, 'GOOD', 'OURS', @w, @w, 0, 0, 3, 0);

-- HR-NSSPL/DL

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/DL', @loc, 3, NOW(), NOW(), NULL, @gstin, '122016', 3, 40, 0, 'BAD', 'OURS', 0, 0, 0, 0, 3, 0);

SET @w = LAST_INSERT_ID();

UPDATE inventory.warehouse SET billingWarehouseId = @w, shippingWarehouseId = @w WHERE id = @w;

INSERT INTO transaction.sellerwarehouse (seller_id, warehouse_id, orderType, id, prefix, challan_id, cn_sequence,

  created_on, is_active, dn_sequence, refurb_sequence, fofo_dn_sequence)

VALUES (@seller, @w, 0, 0, 'NSHRDL', 0, 0, NOW(), 1, 0, 0, 0);

INSERT INTO transaction.warehouseaddressmapping (warehouse_id, address_id, created, updated) VALUES (@w, @addr, NOW(), NULL);

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/DL/Dummy/G', NULL, 3, NOW(), NOW(), NULL, NULL, '122016', 3, 40, 0, 'GOOD', 'OURS', @w, @w, 0, 0, 3, 0);

-- HR-NSSPL/UPW

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/UPW', @loc, 3, NOW(), NOW(), NULL, @gstin, '122016', 3, 40, 0, 'BAD', 'OURS', 0, 0, 0, 0, 3, 0);

SET @w = LAST_INSERT_ID();

UPDATE inventory.warehouse SET billingWarehouseId = @w, shippingWarehouseId = @w WHERE id = @w;

INSERT INTO transaction.sellerwarehouse (seller_id, warehouse_id, orderType, id, prefix, challan_id, cn_sequence,

  created_on, is_active, dn_sequence, refurb_sequence, fofo_dn_sequence)

VALUES (@seller, @w, 0, 0, 'NSHRUPW', 0, 0, NOW(), 1, 0, 0, 0);

INSERT INTO transaction.warehouseaddressmapping (warehouse_id, address_id, created, updated) VALUES (@w, @addr, NOW(), NULL);

INSERT INTO inventory.warehouse (displayName, location, status, addedOn, lastCheckedOn, tinNumber, gstin, pincode,

  logisticsLocation, vendor_id, billingType, inventoryType, warehouseType, shippingWarehouseId, billingWarehouseId,

  transferDelayInHours, isAvailabilityMonitored, state_id, source)

VALUES ('HR-NSSPL/UPW/Dummy/G', NULL, 3, NOW(), NOW(), NULL, NULL, '122016', 3, 40, 0, 'GOOD', 'OURS', @w, @w, 0, 0, 3, 0);

COMMIT;

-- verify

SELECT w.id, w.displayName, w.inventoryType, w.vendor_id, w.billingWarehouseId, w.state_id,

       sw.prefix, sw.seller_id, m.address_id, a.address, a.pin

  FROM inventory.warehouse w

  LEFT JOIN transaction.sellerwarehouse sw ON sw.warehouse_id = w.id

  LEFT JOIN transaction.warehouseaddressmapping m ON m.warehouse_id = w.id

  LEFT JOIN transaction.warehouseaddressmaster a ON a.id = m.address_id

 WHERE w.displayName IN ('HR-NSSPL/GGN', 'HR-NSSPL/DL', 'HR-NSSPL/UPW')

    OR w.displayName LIKE 'HR-NSSPL/%/Dummy/G'

 ORDER BY w.id;