Creation of a serial number control database

The creation of an application useful for checking and keeping an archive of the serial numbers of the products we sell.

The application should work like this:

- Archive product serial numbers by selecting and importing a CSV or XLS/XLSX file
- In the serial number archiving process, it will be necessary to be able to associate the serial number lot/batch with certain parameters, i.e. "Supplier", "Purchase order", "Purchase order date", "Purchase invoice", "Purchase Invoice date"
- Control and verification tool by selecting and importing a CSV or XLS/XLSX file, which allows you to import a list of serials and check if those serials are already contained in the archive/database
- Return of an output of the control tool, which identifies whether the serial numbers are already present and if so, which associates the above parameters with each serial number, and therefore from which "Supplier" they were purchased, with which "Purchase order " on what "Date" and what is the "Purchase Invoice" associated with that serial and on what "Date" was it received
- Possibility of associating other parameters to the serial numbers: "Sales order", "Sales order date", "Customer", "Sales invoice", "Sales invoice date"