DEV Community

Irene
Irene

Posted on

Open-source tool to import and clean supplier product catalogs (CSV/XLSX/JSON)

Hey everyone ๐Ÿ‘‹

Just wanted to share a small tool weโ€™ve open-sourced recently, maybe itโ€™ll be helpful to someone dealing with supplier product data.
It started as a utility script we used on several client projects at Setronica, and over time it turned into something more reusable.


What it does

The idea is simple: suppliers send you product catalogs in different formats, often with messy or inconsistent fields.

This tool helps you:

  • parse CSV, XLSX, or JSON feeds
  • map fields to a standard structure
  • apply transformations using YAML config
  • get a clean output for import (CSV/JSON)

It runs as a CLI, no UI, no integrations. Just the data logic.


Why we open-sourced it

Mostly because weโ€™ve seen this logic rebuilt over and over again - by us, by others, in custom pipelines. So we figured it might save someone time, or at least serve as a starting point.


Repo & examples

๐Ÿ“‚ https://github.com/setronica-dev/product-catalog-import-tool

There are some sample configs and files in the repo. Itโ€™s still early, not super polished, but it works and is easy to extend.


Open to feedback

If youโ€™ve built something similar, would love to hear how you approached it. Or if you spot issues or ideas โ€” open an issue, or just leave a comment. Thanks for reading ๐Ÿ™Œ

Top comments (0)