CSV of online orders downloaded from an e-commerce website needs to be pre-processed and imported regularly into a database. Database records of online orders need to be browsable, and be laid out to match existing layout on e-commerce site. Two specific report types need to be run.
The pre-processing needs to break-up one well defined nested field in the source data and map it to database fields.
Functional spec and more details to be supplied in due course
Looking at FileMaker Pro or Microsoft Access as possible options