The project consists of writing code to do the following:
* Monitor a dedicated email address on our mail server for incoming messages
* Each message will have a CSV file attached to it with an agreed format, containing an order. The data in the CSV file needs to be inserted in an order system that is written in PHP and MySQL.
* If an order contains more than one product, it will be emailed in multiple messages, one for each different product but each time with the same order number. This means that before inserting an order into the order system, the code has to check if means inserting a completely new order or adding an order line to an already existing order.
* Some of the order attributes such as SKU and shipping method need to be mapped to the corresponding values in the order system.