Problem: Need to get all product data (tittle, Desc, Image URL, Product URL, SKU, etc.) from multiple eCommerce Stores (eg: Amazon, ebay) in a specific category (exp: LAPTOP) and save it into WordPress (MySql) Database.
I am building an eCommerce website in the WP that shows certain category Products from Multiple eCommerce stores.
Requirement Details.
1) Map CSS Selectors (Product fields) of an URL to my database fields (MySql Fields).
2) Connect to MySQL DB of WP
3) Enter required URLs to scrape (It will be a category). Each URL has to be crawled for multiple products.
4) Downloads the data (All the category product data) and Saves in required MySQL DB and Excel File
5) In case the Record already exists - Update the DB
6) In case the Record doesn't exist - Add the DB
7) In case the record is found in WordPress DB and not found in scraped data, delete the DB row.
I specialize in web scraping jobs like this one. You can see on my profile that I have completed many similar jobs.
Don't make the mistake of hiring an amateur, who doesn't have the skill set to properly complete this task and will only waste your time.
Hire me, a professional with a rock solid reputation and over 8 years of experience specifically in writing scraping code like this.
I know what I can and cannot do, and I won't waste your time by saying I can do something that I can't. because I exclusively write scraping code
I know what to expect and I will always live up to what I tell you, and will also deliver a higher quality final product than my competitors.
Hello..
I see your requirements and it is not big deal for me... I can scrape the category pages from amazon or ebay and create an excel file of data scrapped..
I want to ask you why you want to dump data in mysql db directly.. you can import the excel file also.. it would be more easy and secure..
but if you want to insert in db directly.. i have no issue.. i can do this..
I want to know more about this.. please explain..
"1) Map CSS Selectors (Product fields) of an URL to my database fields (MySql Fields)."
Thanks