Product Data Transformation
Open a raw export, shape it with Filters, Merge, Columns, and Add Column, then send the result to Export, Columns CSV, or straight into Odoo - all in the same preview you opened the file in.
At a glance
Import formats
CSV, Excel, or database
Toolset
Filters, Merge, Columns, Add Column
Output
Export, Columns CSV, or Odoo Sync
What's in the toolbar
Every one of these sits directly above the data preview - no separate tool to open, no export/re-import step between them.
Filters
Narrow rows down before anything downstream sees them - by date, value, or any column condition.
Merge
Join a second table in against the one you're working on, matched on a shared field.
Columns
Rename, reorder, or hide fields directly in the data preview.
Add Column
Build a calculated field - Amount from Quantity × Price, for example - without leaving the table.
AI SQL Assistant
Ask for a query in plain language against whatever table is currently open.
Diagnostics
Check the full result for nulls and type issues before it goes anywhere else.
Beyond a single file
A transformation you build once doesn't have to stay tied to the file you built it on.
Template Manager
Save a sequence of Filters, Merge, and Add Column steps once. Apply the same template to a different file next time instead of rebuilding it.
Transform Queue
Files waiting on a transformation run sit here - useful once you're processing more than one file through the same template.
Transformed Files
Every completed output lands in one library, so a finished export doesn't just disappear back into My Files.
In the product, not on a slide
500
Rows in a single preview
5
Columns, diagnosed automatically
1 Click
From Add Column to Odoo Sync
100%
Reusable as a saved Template
Open a file, shape it, send it on
Filters, Merge, Add Column, and Odoo Sync in one preview - save it as a Template once you'd reuse it.
FAQ
What is Product Catalog Management?
Product Catalog Management helps you import, organize, transform, and maintain product data from multiple sources. It ensures your catalog stays accurate, consistent, and ready for export or synchronization with business systems.
How can I clean and transform product data?
Use built-in tools such as Filters, Merge, Columns, and Add Column to remove unnecessary data, combine datasets, create calculated fields, and standardize product information—all from a single workspace.
Can I automate recurring catalog updates?
Yes. Save your transformation steps as reusable templates and apply them to future product files. This reduces repetitive work and keeps every catalog update consistent.
How does the AI SQL Assistant help?
WThe AI SQL Assistant lets you analyze and query product data using natural language. It generates SQL queries, helps validate data, and makes it easier to find insights without writing SQL manually.
Can I export or sync transformed product data?
Yes. Once your catalog is ready, you can export the transformed data or synchronize it with supported business systems, helping maintain accurate product information across your workflows.