Order to automate the import of customer order data into an Excel database

I will outsource the task of automating the import of customer order data into an existing Excel database and assigning the appropriate data for new items from orders based on the existing database.

Details:

1. downloading the data from a csv file that will be updated once a day and uploaded to an FTP server from the client.

2. Putting the data into an Excel "Database" file by searching for a unique commodity code and assigning individual values to it from the following columns: order number, quantity ordered, date, place of delivery and price.

(3) The rest of the information assigned in the database for new items and the individual commodity code (ITEMID) should be invariable such as packing patterns, pallet dimension, number of pieces per pallet, labels, etc. and taken from this database.

4) Each new order should add itself as a new line in the file, without deleting previously added orders with the same item.

and more