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?

[takestock]

I have had a similar issue, While you might have 100000 products it is unlikely that you will have every product in a different category.
You may have 100 or 200 to map.
In that case It would be quite simple to open the CSV in excel and write some formulas that will find unique categories in one sheet and list them in another. you can then map them in the second sheet to category list from your store and have the formula fill in the new values in a category field in the first sheet.
Hope that makes sense, I have unique template excel sheets I send to vendors depending on what platform they currently have product on, They simply cut and paste the exported CSV from their platform into my sheet and it maps everything for import into CS Cart.