A Python script that turns your product file into a CSV for WooCommerce's built-in product importer

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

WooCommerce has its own product importer, but it expects its own columns: Type, SKU, Name, Regular price, Categories with > between levels, pictures as links, and for clothes or other options, a parent product plus one row per variation linked by Parent. This Python script turns your supplier's price list, an export from another shop or your own table into that file. It maps your columns, builds categories and, from Standard, variable products with attributes such as size and colour, and lists rows with no price, SKU or picture. Pictures must be at links your site can download. You run the importer in your WordPress admin yourself; we never log in to your site. Try a few products first and keep a backup of your shop.

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 the column map; the code is also shown on the order page.
• WooCommerce's columnsAs its built-in product importer expects them
• Variations linkedFrom Standard, parent products with sizes and colours
• Nested categoriesClothes > Women > Dresses, as WooCommerce reads them
• Problems listedRows with no price, SKU or picture are reported
• Readable codeWith comments, easy to add a column later

How it works

1. 1
   FilesYou send a sample of your product file and say what goes where
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou import a few products on a copy of your shop or a test site
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

20-30 rows of your product file, how options are written in it (a row per size, or sizes in one cell), your category tree, where the pictures are (links, or files already in your WordPress media library) and how prices should be set. An export of a few products from your WooCommerce shop helps the columns match exactly. Your system: Windows, macOS or Linux.

We will ask you:

• What file do you have now?
• Do your products have options?
• What is your category tree?
• Where are the pictures?

Compare packages

Questions and answers

Did not find your answer? Ask us