I will automate supplier CSV and excel catalogs with python scripts
About this Gig
Turn repetitive supplier file work into a repeatable Python workflow.
I will build a script that cleans, merges or converts your CSV and Excel catalog files using rules agreed before the order.
What I can automate:
- Merge supplier files and remove exact duplicates
- Match records by SKU or product code
- Normalize prices, titles and variant data
- Flag missing values and conflicting records
- Map columns to your required catalog format
- Prepare Shopify product CSV files when included in scope
You receive Python source code, processed output, a validation report and clear run instructions. Scripts are tested against your supplied files and agreed acceptance rules.
Please send a sample file, your desired output and the rules you currently follow. I will confirm the scope and package before you order.
This gig covers file automation, not manual product entry. APIs, scraping, hosting, scheduled deployment, product research, live store imports and existing-store updates require a separate agreement. No sales or ranking results are promised.
Technology:
Excel
•
Python
My Portfolio
FAQ
What makes this different from product uploading?
You receive a reusable Python script for a defined file workflow. I do not manually enter your products or upload them to a live store under these packages.
Can you handle any supplier format?
I review your sample first and agree on column mapping and cleaning rules. The package covers the approved layouts. A new layout or business rule after approval is additional scope.
Will the script run on my computer?
Yes, when your computer meets the agreed Python and library requirements. I include setup commands and run instructions. A desktop app, installer or hosted dashboard is separate work.
Can you work with CSV and Excel?
Yes, CSV and XLSX. Password-protected files, macros, complex formulas and legacy XLS need review before ordering.
How do you deal with duplicates?
Exact duplicates can be removed. Conflicting records are flagged unless you provide a clear rule identifying the authoritative source. I do not guess missing prices or product details.
Can you prepare Shopify files?
Yes, when Shopify output is part of the agreed scope. The default deliverable is a locally validated file. Store import testing, updates to existing variants and inventory locations require a separate agreement.
Are scripts automatically scheduled?
The standard delivery runs when you launch it. Scheduling, cloud hosting and production monitoring are separate scope. I can discuss them after reviewing your environment.
What is included in revisions?
Corrections to the original files, rules and acceptance criteria. Additional file layouts, features or outputs require a new quote.

