Back to profileSolved··
AutomationData

Automate messy vendor and marketplace Excel files

Dynamic column detection and SKU normalization to automate Excel transformations without changing templates.

Share
EView emre's profile

Author

Emre

E-commerce Leader | Founder of SolvedOnce & CleverCSV

10
Challenges
10
Solved
0
Part of
Impact & Results

Flexible Excel transformer with column detection and SKU normalization.

The Story

How this challenge was approached and solved

Problem: Every marketplace/vendor Excel had different columns, casing, and formats; manual edits caused errors. Approach: Automation that detects columns, normalizes SKUs, and transforms files while keeping templates intact. Result: Prep time dropped and upload errors were reduced across marketplaces.

Focus Areas

AutomationData

Tools & Technologies

NodeExcel
Automate messy vendor and marketplace Excel files | Emre · SolvedOnce