I need someone that can scrape Item IDs from [login to view URL] and then use [login to view URL] API to perform a query and spits back the info into Excel. I then need it to integrate with another program to see if the UPC is already a listing on Amazon.
Then we need to use the Walmart API to pull the data. Below is an Example:
Product Lookup API
Product Lookup API gives access to item price and availability in real-time. Item id needs to be specified for doing a lookup. Response type returned is full response.
Example Queries
Lookup for item id 12417832, XML Response
[login to view URL]{apiKey}&lsPublisherId={Your LinkShare Publisher Id}&format=xml
Lookup for item id 12417832, JSON Response
[login to view URL]{apiKey}&lsPublisherId={Your LinkShare Publisher Id}&format=json
Lookup by UPC "10001137891":
[login to view URL]{apiKey}&upc=10001137891
Lookup for mutiple item ids 12417832,19336123 (supports upto 20 items in one call):
[login to view URL],19336123&apiKey={apiKey}&lsPublisherId={Your LinkShare Publisher Id}
Formats
xml, json
Query Parameters
Param Name Description Required/Optional
apiKey Your API access key. Required
lsPublisherId Your LinkShare Publisher Id Optional
format Type of response required, allowed values [json, xml]. Default is json. Optional
ids Comma separated list of item ids Optional
upc upc of the item Optional
To play with the API, please checkout the I/O Docs.
Response
Lookup API returns the Full Response. Response types are covered in the Item Response Groups section.
Sample Response
{
itemId: 19336123,
parentItemId: 19336123,
name: "Intex Krystal Clear Saltwater System 15,000 Gallon",
msrp: 199,
salePrice: 139,
upc: "078257317042",
categoryPath: "Toys/Outdoor Play/Swimming Pools & Waterslides/Pool Supplies",
shortDescription: "You can enjoy a clean and comfortable pool using the Intex Krystal Clear saltwater pool filtration system. This easy to maintain saltwater filter is compact and efficient in generating clear pool water. The Intex filter replaces hazardous chlorine with inexpensive, natural salts as it cleans.",
I'm interested in two things.
1. The corresponding UPC. I can use this API to find out what the UPC is for each product and can then use this UPC as a method of quickly listing on [login to view URL]
2. in the event that the listing is not on Amazon.com. Then I would need the other information given such as Image URL, Description, etc.
I envision the program working like this.
1. we do a pull of model numbers for specified categories.
2. we run the API which pulls the information
3. separately a test is run to see if Amazon has this product listed. ( I already have a VBA file that can do this)
4. If yes, then just the UPC is displayed on one sheet
5. If no, the on a different sheet in excel all the information is pasted.
Please reply with API so I know you read this
I already have developed Key information.
Key Rate Limits
5 Calls per second
5,000 Calls per day
API. Hi, I can do web-based system that will allow you to upload IDs and spit out csv (readably by excel) with UPCs that are on amazon & Full info for IDs that are not. But I'll need you to raise budget for that.
Hi sir,
I am scraping expert, I have did too many similar projects, please check my feedback then you will know.
Can you tell me more details? then I will provide demo data for you.
Thanks,
Kimi
Dear Sir,
I'm very much delighted to let you know that i did data scraping
with PHP-cURL, Node.js, Selenium from many sites. I just scraped the data from web site
and then wrote the data in mysql database or excel or csv or xml file.
I worked on many similar projects, I have big experience in data mining projects.
I have written hundreds of web scrapers which scrape millions of pages each day.
I'm ready to fulfill your requirement.
I can finish this task in short time, with the best quality. I can assure 100% accuracy.
Please give me the opportunity to do the work.
With Kind Regards,
Debdulal Roy Proshanta
Hi,
I am a professional web data scraper specialized using Python program, PHP script, .Net program, Crawler and Bot. My tool can search data and get information from Aa to
Zz with an existing lists of english words. Below is the link for your reference as a sample related to my tool being developed. This demo will capture doctor's name,
address, zip, phone, ratings and reviews in 4 different sites. The final output will be save in *.XLSX format or as your quirement.I can start as early possible depending on your approval and acceptance. In relation to this application, I can rest assured I will
impart a high quality and reliable, efficient and accurate with the output. Give me a try and I will try to get the best results and finish the project far before
the deadline. Thanks,Ferdous
Hello. I am most experienced freelancer here in freelancer.com and expert in web scraping and data mining. I read your project description and i assure you that i can do this. This is exactly what i am offering here. Please send me website do you want to scrape and details about data you want to scrape. Looking forward for your response. Thanks
Hi,
I have more than 14 years of web scrapping using API and VBA/Excel exp and I am expert in this kind of work.
I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work.
Waiting for your positive response.
Thanks.
API.
Well I have worked similar things before but now with Walmart API but with other EStores API.
I am now very much experienced in scrapping/parsing/extracting data from html pages. In 2014, I worked on various project to get data from ECommerce sites, Education Sites, Sports Sites etc to get data and create database from that information.
Hi; I can help. I am an Excel / VBA coder pro with over ten years experience in developing automated, web data mining applications.
Of particular interest I have integrated Excel with many APIs, including Instagram API, , Zillow API, Crunchbase, BigCommerce, and others. I can provide reference projects on request.
API: I understand your requirements. This can be done within 2-3 days. But, I am not sure about the item details that you want if product is not listed on amazon. If it is not listed then where will we get the info like image URL etc. Rest of the days are just for unexpected delays
Hi.. Expert Web Scraper & Data Minor here. I have done too many similar project in past. Having best scraping tools and experience i assure you 100% accurate and good quality work.
Hi! My maximum project is similar to your project,please check my portfolio and my projects , Kindly give me chance for work really very interested for this project,
Waiting for your reply. Thanks
Simon.
Hi..
I have already developed some parts of this application
You can either input Walmart Id or ASIN and the matching will happen with the criteria of UPC.
Also.. the program can show whether you will make a profit (and how much) by selling walmart product in amazon.
If you have amazon professional plan, i can make the application automatically list into amazon for selected product
let me know.
I am a software engineer and I have much of experience for this project. my expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you wants high quality work then as soon as possible contact me. Please give me chance to prove myself.
Thats really detailed description. I can show sample result before offering the project . I am working on web technologies since year 1999 and have done web scraping applications too.