Inventory Linking
Create inventory rows for all pharmacies that don't have any yet
What this does
Finds every pharmacy in the database that has no inventory rows yet (e.g. newly imported NPI pharmacies) and creates a row for every product with a randomised stock level. Safe to re-run — existing rows are never overwritten.
Run this after the NPI pharmacy import completes to give every pharmacy real stock data.