My oh my, setting up six separate csv files with all this critical information cross linked with IDs like a database has to be one of the weakest and most error-prone setups ive come across in 30 years of IT.. I guess the product just isn’t finished and this was a quick hack to get going?

At least support upload from a multi-tabbed xls file and provide a template with macros to generate the IDs.