A Python script that checks a list of addresses for status codes and redirects, hop by hop

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

After moving a site, changing its addresses or switching to https, old links must lead to the right new pages, and checking hundreds of them in a browser is slow. This Python script reads your list of addresses (CSV, Excel or text) and checks each one: the status code (200, 301, 404, 500), the final address it ends at and, from Standard, every step of the redirect chain. If you add a column with the address each one should lead to, it marks every mismatch. Premium flags loops and chains longer than you allow. It reads only open pages, at a polite pace you set, and never logs in. You run it on your computer and fix the redirects in your site's settings yourself; it only reports what it sees.

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 pace and timeouts; the code is also shown on the order page.
• Status of each address200, 301, 302, 404, 500 and the rest
• Every redirect hopFrom Standard, the full chain to the final page
• Expected target checkMismatches marked when you give the address it should reach
• Polite paceA pause between requests you set
• Readable codeWith comments, easy to add a column later

How it works

1. 1
   TaskYou send a sample of your address list
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it on part of the list, then on all of it
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

A sample of your list: 10-20 addresses as CSV, Excel or text and, if you have it, the column with the address each one should lead to (a redirect map from your move). Roughly how many addresses there are in all and whether they are on your site or several sites. How fast it may go, which report you want (CSV or Excel) and your system: Windows, macOS or Linux.

We will ask you:

• What is the list for?
• Do you have the addresses they should lead to?
• Which report do you need?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us