We need an application (vb, c++, and MySQL or whatver else you want, as long as its fast and most efficient) which will extract/parse product info from websites (5 different websites to start but more will come as we expand), store it in a local database (probably MySQL since the website have from 5,000 to 50,000+ products and from the info we gather, MS Access might not be fast enough to handle so much data) and then will give us the ability to work with this data, edit, move, etc, and most importantly will let us export data into a spreadsheet from the db based on the columns/fields we choose fit. Will also need to have the ability to add attributes to the products that aren't in the data you extract/parse (such as different category names, etc, based on our export needs).
It should be easy to use since we will be using it weekly to update product info such as new products/availability/qty/price/etc.
All websites are drop-shipping websites so the FULL product info needs to be extracted (partial list):
- Title
- SKU
- Description (features, specifications, etc)
- Price
- Weight
- Shipping fee
- Estimated Shipping Time
- Item stock availability (Needs to show if the product is discontinued (each website has it's own way of showing this))
- We will also need the ability to download images for every product (thumbnails and images) so we need the ability to download images, and all the file name data will also need to be attached to each product.
- Basically ALL information related to each product
All info needs to be organized and contain clean appropriate info. You will need to make sure every column entry is contained within that column once exported into spreadsheet/csv. We had this project up before and first person selected could not contain description data within one column, kept breaking the formation and made info unusable. Another person was not able to complete the tast beacuse of lack of know-how. Please make sure you can do the job. We were told that due to the nature of this project, the way data is harvested and how much data there is, we will need to new new DOT NET and MySQL and have this written in the newest C++ 2010 or VB 2010. We are ok with any languange/method you prefer and are open for suggestions.
Since these websites are updated often, the application/script will need to be able to just update the new products and also be able to update the price/qty/availability ONLY! This way we do not have to parse the whole site to update the newest products and price/qty updates.
The results I need:
- Working Application + sourcecode (well documented for future updates)
- Instructions on using the application
The way we originally planned this would work is it will give us an interface which will have buttons for each website, and with each we will have option to parse full, update, new products only. Once all the data is obtained and stored, we need another export button, which will let us pick which info goes in which column and then will let us export these into an excel/csv sheet for further work.
Website names are available upon request.
SERIOUS AND PROFESSIONAL EXPERT PROGRAMMERS ONLY!
Hello Sir,
I have Described the things in PMB. So I kindly request you to go through my PMB Please.
Thanks and Regards,
Kinjan Shah
CEO,
iMaze Technology
Hi, i am experienced programmer. i have reviewed your project requirement carefully. Its all about web automation and extraction from running website. I work mainly on web automation. I have made 100s of software using web automation. Would you like to have a look at my past work? then please go through your pmb.
Thanks!
Respected Sir,
Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply.
Kindest regards.
Farrukh Rehman.