I need you to develop some software for me. I would like this software to be developed for Mac . Hi
I need two jobs to build a database for price comparison tool from my suppliers to help my buyer
I need to automate scraping data from excel spreadsheets , csv, text from emails , for price comparison from various suppliers of products. Our suppliers provide their pricing in different formats, different currencies , from different geographic regions of the world ( effects cost due to shipping and logistics costs ) some suppliers update prices daily and their stock and product availability changes other suppliers update prices yearly but their product range can expand and decrease
Key identifying field will be a upc or ean barcode number that we will insist on from each supplier before submitting prices, we have a database of barcodes and product descriptions
The product price will be in different currencies , mainly £ GBP, USD $, € Euro
We need to be able to identify the different suppliers and different currency so the comparison reports can be implemented for the second part of th project. Please note some suppliers can submit pricing in different currencies
All the pricing gets submitted to one email address currently , to automate or help the solution we can forward the pricing on the specifically set up emails for each supplier to help identify .
Some suppliers we would like to track the pricing to see if the price increases or decreases, a bit like tracking share prices , again some suppliers we would like to track the stock movements I.e if the stock qty has moved, we can’t and don’t want to do for every supplier but we want it for certain suppliers. We want to implement with a Mac friendly database so can access on phones and the company computers
2nd part is about building reports on the database and specific website scrapes .
Please quote a price for this work