Add StockLocationExternalId column to the EcomStockLocation table #484
Description
Is your feature request related to a problem? Please describe.
Current data integration import jobs have no stable external reference for stock locations. This makes it hard to reliably map and sync stock locations between external systems and the EcomStockLocation table.
Describe the solution you'd like
Add a new nullable column StockLocationExternalId (nvarchar(255)) to the EcomStockLocation SQL table.
This field will store an external identifier used by integration and import jobs.
Describe alternatives you've considered
Using the internal stock location ID or name for mapping, but these values are not stable across systems and can change over time.
Additional context
The new field is intended only for integration purposes and should not affect existing logic unless explicitly used by import jobs.