A Python script that turns your supplier's or old shop's product file into a CSV ready to import into Shopify

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

Shopify imports products from a CSV file, but only in its own layout: one Handle for a product and all its variants, option names and values in set columns, pictures as public links. This Python script turns the file you have, a supplier's price list, an export from your old shop or your own Excel, into that layout. It maps your columns to Shopify's, turns sizes and colours into variants from Standard, cleans prices and stock and adds tags. It follows Shopify's current product CSV template, which you can download from your admin. Pictures must be at links Shopify can open. You import the file in Shopify yourself; we never log in to your store. Try a few products first: what you get is only as complete as your data.

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.
• Shopify's layoutBy Shopify's current product CSV template
• Variants groupedFrom Standard, sizes and colours under one product
• Clean prices and stockNumbers Shopify accepts, without currency signs or spaces
• 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 into Shopify and check them
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

20-30 rows of the file you have (supplier price list, old shop export or your own table), how variants are written in it (a row per size, or sizes in one cell), where the pictures are (links, or files you will upload to Shopify first) and how prices should be set. If you have one, an export of a few products from your Shopify store, so the columns match exactly. Your system: Windows, macOS or Linux.

We will ask you:

• What file do you have now?
• How are variants written in it?
• Where are the pictures?
• How should prices be set?

Compare packages

Questions and answers

Did not find your answer? Ask us