muaazl/product-matcher ? reverse-engineered prompt

Reverse engineered prompt

Build me a Python tool that can clean up and match product SKU names in bulk.

I have an Excel file with a master Dictionary sheet and a Brands sheet, and I’ll drop one or more CSV files into a folder with outlet product lists. The script should read the first column from each CSV, compare each item against the master data, and find the best match using a mix of meaning, keywords, and brand awareness. If something doesn’t match well enough, it should mark it clearly instead of forcing a bad result.

I want it to process all the CSVs in one go, then write the results back into the same Excel file as separate result sheets, while keeping the original sheets untouched. It should handle missing or messy data without crashing, and it should be easy to tweak the matching strictness near the top of the script. If you need to look up current docs online for any library details, go ahead.