Maping categories for import of products

[rivernue]

I’m looking for a solution that help with import of products.

Most CSV files we get is easy to manage, just add some columns that is required - no issues.
But, what every single one of them have in common is the Category maping.
We recive CSV files with 2000, 5000 and 10’000 products - but categories are wrong since these CSV files comes from other systems (ERP, webshops, marketplaces, etc.) which doesn’t follow our category tree (obviously.).

How can we map there categories easier in the CSV file before import (or other solution?)?
I did one with 2000 products, manually, and it took me 5-6 hours.

[retailfactory]

Please have a look at our addon

Addon: Fast Products Import And Stocks Update From Excel, Xml With Mv Support

Dear Friends, we would like to present our addon "Fast and simple import from XLS, XLSX, XML, CSV files" The module helps to automatize work with XLS, XLSX, XML providers price lists, all Excel formats. What issues can this module solve? Complete automatization of work with providers’ price lists and store’s stock. You do not need to check it every time whether the item is on the price’s list, convert prices into one format and upload each separately. You can manage the prices o…

You can map categories in your store with categories in the file

[rivernue]

Yes, but manually setting 2000+ categories by hand is draining work, how to do it simpler?