A Python script that checks that your site answers and emails you from your own mailbox when it goes down

Example result

python merge_sales.py --month 2026-10

2026-11-02 09:14:03 INFO  Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO  shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO  shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN  shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO  Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
    """Reads one shop's file and gives it the report's column names."""
    table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
    renamed = {}
    for name, variants in columns.items():
        found = next((c for c in table.columns if c.strip() in variants), None)
        if found is None:
            raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
        renamed[found] = name
    table = table.rename(columns=renamed)[list(columns)]
    table["shop"] = path.stem
    return table

About this service

If your shop or booking site goes down at night, you may only learn about it from a customer in the morning. This Python script opens the pages you list every few minutes and sends you an email when one stops answering, returns an error or, from Standard, loads without a word that must be there, such as your Add to cart button. It tries again before raising an alarm, so a single slow answer does not wake you, and writes again when the site is back. Emails go from your own mail account; you put its sending password into the settings yourself. Run it on a computer or server that stays on and is not the one your site lives on, or it falls silent with the site. It tells you about a problem; it does not fix it.

What is included

• What you getA ZIP archive with the Python script, a README with step-by-step instructions and, from Standard, a settings file with addresses and mail settings; the code is also shown on the order page.
• Down and back upOne email when it fails, one when it is back
• No false alarmsRetries before writing to you
• Page content checkFrom Standard, a word that must be on the page
• From your mailboxYour own mail account, password kept out of the code
• Readable codeWith comments, easy to add a page later

How it works

1. 1
   TaskYou list the pages to watch and where alerts should go
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it with a page that does not exist to see an alert arrive
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The addresses to watch (home page, cart, booking page), how often to check them and, from Standard, a word or phrase each page must show. Where alerts should go and which mail account sends them (your provider's name is enough for us to describe its sending settings; the password you enter yourself). Where the script will run: a computer that stays on, or a server, with its system (Windows, macOS or Linux).

We will ask you:

• Which pages should it watch?
• How often, and what counts as down?
• Where should alerts go?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us