1. The database to automatically import the CSV from a supplier URL, which is semi colon separated, which currently imports nicely into access, as attached, but it should be imported into pre-defined tables using a MySQL relational database structure.
2. For the database to modify information in magento database using SOAP API, when product quantities and prices change.
3. Allow magento to update the relational database when stock is ordered through the website.
4. Finally allow to check the customers order and use information to dispatch products and print out an invoice.