A Python script that resizes and compresses a whole folder of photos for your site, shop or email

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

Photos straight from a camera or phone are often 5-10 MB each: too heavy for a product page, a site gallery or an email. This Python script goes through a folder and saves a smaller copy of every picture: fitted to the width or height you set without stretching, compressed to the quality you choose, as JPEG or PNG. From Standard it can make several sizes at once and remove the hidden details photos carry, such as the camera and the place they were taken. Your originals stay untouched, and the results go to a separate folder. Send us the sizes you need and two or three sample photos. You run the script yourself on your computer. It resizes and compresses; it does not retouch, cut out backgrounds or fix colours.

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 your sizes and quality; the code is also shown on the order page.
• No stretchingProportions kept; crop or padding only if you ask
• Quality you chooseLighter files with the sharpness you are happy with
• Originals keptCopies go to a separate folder
• Hidden details removedFrom Standard, camera and location data stripped if you want
• Readable codeWith comments, easy to change a size later

How it works

1. 1
   SizesYou give the sizes and send a few sample photos
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it on a folder and look at the copies
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The sizes you need in pixels (for example 1600 px wide for the site and 400x400 for thumbnails) or the sizes your shop platform asks for, whether to crop or add padding when the shape differs, the file format and any weight limit, such as under 300 KB. Two or three of your photos as samples, roughly how many photos there are and whether they sit in subfolders. Your system: Windows, macOS or Linux.

We will ask you:

• Where will the photos go?
• Which sizes do you need?
• Any weight or format limits?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us