Supermarkets · Dubai, United Arab Emirates · Operations

Water on the shelves before the heat arrives

Khalid runs supply for a supermarket chain with forty stores across Dubai. Summer is his hardest season.

Listen to the story:

The challenge

When a heatwave hits, water, ice and cold drinks fly off the shelves in hours. Store managers phone in their orders too late, and the trucks are already out. Last August, nine stores ran out of water on the hottest weekend of the year.

How the flow works

With xMap Flows, Khalid built Shelf. Shelf is an AI employee: a flow of 7 blocks.

  1. Every day at five in the morning,

    Every day at 5 am (Schedule)

  2. Shelf reads the forty stores,

    Our 40 stores (My data)

  3. checks the forecast at each one five days ahead,

    Each store, 5 days ahead (Weather forecast)

  4. keeps the stores facing forty-five degrees or more,

    45°C or hotter (Filter)

  5. works out the extra water, ice and cold drinks each one needs,

    Extra water and ice (Calculated field)

  6. adds them to the restock sheet,

    Restock orders (Google Sheets)

  7. and tells every store manager in Teams.

    Store managers (Microsoft Teams)

What it solves

The result

On Sunday, Shelf sees forty-seven degrees coming on Thursday for the stores inland. Twenty-two stores get extra stock on Tuesday’s trucks, two days early. That Thursday, not one water shelf goes empty.

The heat still comes to Dubai. Khalid’s shelves are just ready first.

5 daysof warning
22stores restocked early
0empty water shelves

An illustrative scenario: the figures are modelled to show what the flow produces, not a customer's results.

The flow, block by block

  1. 1

    Every day at 5 am

    Schedule

    Starts the flow on a timetable.

  2. 2

    Our 40 stores

    My data

    Brings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.

  3. 3

    Each store, 5 days ahead

    Weather forecast

    The weather forecast (Open-Meteo, from national weather services) for up to 16 days: temperature, rain, wind and UV.

  4. 4

    45°C or hotter

    Filter

    Keeps only the items that match a rule.

  5. 5

    Extra water and ice

    Calculated field

    Adds fields worked out from the others: a number, a text or a yes/no.

  6. 6

    Restock orders

    Google Sheets

    Create, edit, and collaborate on spreadsheets online

  7. 7

    Store managers

    Microsoft Teams · Teams

    Runs an action in Microsoft Teams.

Templates to build it

Ready-made flows with the same blocks. Open one, change the city and the kind of place, and run it.

Industries

Learn how it works

More stories from Retail & consumer goods

All 137 stories →

Build this flow on your own city

Run a live search on the home page without an account, or let Ask xMap build the flow from one sentence.