Job description
Hello,
I am looking for a person who can create an automaton to analyze data from XML and CSV files containing product inventory. The analysis would consist of:
1. downloading the file from the given link and saving it on the server automatically through CRON.
2.Opening the file and selecting the relevant data, i.e. EAN code and number of available pieces of the product.
3.Adding the above data to the database. 4.
4. the data is then published on the website.
It is enough for the page to contain some information - the EAN code of the product and stock changes, possibly some additional data, maybe a thumbnail photo. I am uploading a screenshot of something like this that I am currently running in Excel. I also need column sorting with the difference. Downloading data every 2-3 days. First column is the current stock, next column is the stock from 2-3 days ago and the difference between the two so it knows how many units have sold. The next column is the stock from 4-6 days ago and a column with the difference between the most recent stock and the one from 4-6 days ago.
To create at the moment 3 such connections, it is possible that there will be more.
