A Python script that walks through your site and writes a clean sitemap.xml of the pages that really work

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

A sitemap.xml tells search engines which pages your site has. Many shop builders and site platforms already make one, so check yours first; this script is for hand-made or older sites, or when the sitemap you have lists pages that no longer work. It starts at your home page, follows your own links at a polite pace and keeps only pages that open normally: no errors, no redirects, no copies with tracking tags and, from Standard, none marked noindex. It writes a sitemap.xml by the sitemaps.org rules, and Premium splits a large site into several files with an index. You upload the file to your site and add it in Google Search Console yourself. A sitemap helps pages get found; it does not promise indexing or positions.

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 sections and limits; the code is also shown on the order page.
• Only working pagesNo errors, redirects or duplicate addresses
• By the standardsitemap.xml as described on sitemaps.org
• Sections left outSearch, cart, filters or anything you name
• Polite paceA pause between pages so your site is not loaded
• Readable codeWith comments, easy to change a rule later

How it works

1. 1
   TaskYou give the site address and what to leave out
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it, look through the list of pages and upload the file
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

Your site's address, roughly how many pages it has, what it is built on (if you know) and whether it already has a sitemap. Sections and kinds of addresses to leave out, such as search results, filter pages, the cart or addresses with ?sort=. Whether the site has several languages or subdomains. Your system: Windows, macOS or Linux.

We will ask you:

• What is your site's address?
• Does it already have a sitemap?
• What should be left out?

Compare packages

Questions and answers

Did not find your answer? Ask us