Hi @Ire
- You could create a spreadsheet tool to map categories at the click of a button. This is very easy and requires only a knowledge of spreadsheets. Whatever solution you create you’ll need to do a category mapping that will be less than perfect. A fully automated integration solves this problem no better than a spreadsheet tool.
Of course having to import products every day is an annoying task. But paying someone to do this task for 10 minutes each day would be cheaper than developing the integration. You could pay someone to do this task for years and not spend as much money. It is worth bearing that in mind 
- ‘Product code’ and ‘Quantity Ordered’ both exist in the Pack By Supplier report. Does this report meet your requirements?