Custom Program scrape or API to Find, compare data (on WWW site) and write Specific product data to Excel file
$30-50 USD
Cancelled
Posted over 17 years ago
$30-50 USD
Paid on delivery
Hello and thank you for taking the time to review this interesting project.
Here are the specs:
Find, compare [login to view URL] data and write Specific product data to Excel file
The program you are making will take our excel file and look at our ASIN column.
It will search each ASINs on [login to view URL] and get the sale price for each seller
on that particular ASIN and write the price to a column in the file.
It will get each sellers name and their sale price for that ASIN item.
It will be writing these colums at the end of our input excel file for each ASIN.
Product name, seller name, their sale price, % Price Difference & Our New Sale Price
(see samples files attached)
Next, I need to take OUR sale price, compare it with the other sellers price for the
same ASIN. Write in the % DIFFERENCE Colum the % difference between our price and
theirs for that ASIN. If we are HIGHER then make that box RED of lower make GREEN.
Keep all lines in the order as we input it so we can cut an paste this data and
match it to another excel file which wont concern you at this point but may
in future jobs.
Then give us an imput box where we can specify a % lower in which you will
modify a new Column for us called OUR NEW SALE PRICE where all of our prices will be
lowerd by that % ammount for each ASIN universally.
Basically so you understand we want to match or beat their price. Mostly we will
beat their price.
Please only accept this job if you know you can get it done properly and by the dealine.
As always feel free to ask me as many questions as you need. I will reply promplty.
Thanks for your time,
JackG
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
windows,excel,acess whatever