Azure middleware

An in-house middleware that delivers product stock. It is a transport, not a system of record: the stock numbers originate elsewhere and pass through it.

What it delivers

Product stock, as a CSV.

Cadence and window

Queued once a night, current state only. There is no maintained stock history. A new snapshot replaces the live table. The swap can leave one previous copy in _old, which is not a dated time series or a maintained backup.

Its cron line runs hourly. That is the worker picking up the nightly batch, not an hourly refresh.

A consumer wanting stock over time has to accumulate it themselves; CCC does not.

Quirks and limits

• CSV rather than a structured API, so a change in column order or formatting upstream is a silent risk rather than a typed error.
• Stock is a point-in-time figure that was already slightly out of date when it was read.

Where it lands

The product stock table, replaced on each run.

Related

• Stock
• Products

Evidence

Feed and transport from AGENTS.md, The application, and the job under app/jobs/azure/. The status derivation from middlewareazure->getstockstatus() and the guarded swap from app/jobs/azure/getproductstock.php. Basis: code-checked at 30f5313.

Where the middleware gets the stock figures, and how often it refreshes them, is a property of that service and is not described anywhere in this repository.