A Python script that makes a QR code for every row of your list, named and ready to print

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

Table cards for a restaurant, labels for stock or equipment, tickets, product tags, codes for every page of a catalogue: when you need hundreds of QR codes, making them one by one on a website takes forever. This Python script reads your list (CSV or Excel) and makes a QR code for every row: a link, a text, a contact card or Wi-Fi details, saved as PNG for screens or SVG for print, named after a column such as the table number or SKU. From Standard it adds a caption and checks that each code reads back; Premium lays them out on a PDF sheet of labels. These are static codes: the link sits inside the code, so it cannot be changed after printing and scans are not counted. Test-scan a few before printing many.

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 size, colours and captions; the code is also shown on the order page.
• A code per rowLinks, texts, contact cards or Wi-Fi details
• For screen or printPNG in the size you set, or SVG that scales
• Named your wayFiles named after a column of your list
• Read-back checkFrom Standard, each code is decoded to make sure it matches
• Readable codeWith comments, easy to change the look later

How it works

1. 1
   ListYou send a sample of the list and how the codes will be used
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou make codes for a few rows and scan them with your phone
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

10-20 rows of your list as CSV or Excel, which column goes into the code and which gives the file name or caption, and where the codes will be used: screen, sticker, card or sign, with the printed size if you know it. Colours if not black on white, your logo as PNG or SVG for Premium, and the label sheet layout (paper size, codes per row and column). Your system: Windows, macOS or Linux.

We will ask you:

• What are the codes for?
• What goes into each code?
• Screen or print, and what size?

Compare packages

Questions and answers

Did not find your answer? Ask us