There is an Excelfile with nearly thousand different products with our prices and they should be compared to the prices from an website "wein dot cc". The cheapest price from the website should be added to this excel file so that you can compare between our offer and theirs, direct hyperlink embedded would be perfect. Its very important that the input is really the exact hit in the website database, the products are wines and a little difference can be very bad.
The excelfile should be sortable and an all over statistic would be nice to have (how often is our pricer cheaper, eg.)
this is what we have:
nr. type of wine our price
1 type 1 [url removed, login to view] Euro
2 type 2 [url removed, login to view] Euro
and so on
this is what we need:
nr. type of wine our price delta to cheapest competitor Comp1
1 type 1 [url removed, login to view] - 1 4
2 type 2 [url removed, login to view] - 0,5 2,5
and so on
I need to run/create this files on my own so i need something "run and forget" and get my results.
The type list should be changeable if our offers - types of wines - or just the input order changes.
Any other ideas are welcome.
I edited it a little bit and added an example excel file.
13 freelancers are bidding on average $128 for this job
Hello, I'll create and provide you a windows desktop app for xp/vista/7 to do that. Perhaps it will be fine? And please reupload the example file - it's not attached. :) Thanks in advance.