Find Jobs
Hire Freelancers

Daily Product QTY Web Scrapper

$30-250 USD

Closed
Posted about 10 years ago

$30-250 USD

Paid on delivery
This project is for the development of Visual Basic (2010 Express) application that can scrape the qty of products on a website each day for the purpose of tracking how many products are sold. The websites this will be used on use a common html template, which allows us to use search parameters to "drill down" to the product QTY field. See the attachment "example" for an example of the div used for the product QTY section of html. If all the whitespace and linebreaks were stripped, then you could create a filter that worked on every product URL by using the logic shown in attachment "logic" (Freelancer strips html tags if I wrote it here) With this in mind, I need some configuration settings: - Configure the search strings for finding product QTY - as shown in the logic example, but I need to be able to search for 3 strings (using the pointer of the last to begin the start point for the next search. If search string 1 or 2 are blank, then they are skipped) - I also need a checkbox setting on the above configuration for "QTY is After Search". This toggles if the QTY is found after the last (3rd) search string, or if it is found before it. For example: After46 46Before - Configure a list of products to track (product_sku, url, retail price, raw_price) The application needs to fetch data when manually initiated by a button and apply this logic: - If QTY decreased from one scrape to the next, then record the QTY of products sold - If the QTY remains the same from one scrape to the next then record 0 sold - If QTY has increased from one scrape to the next then disregard the result (data not valid as the product has been replenished and we can't determine the qty sold). The script needs to be able to recover from this though; and if on the third scrape the qty has decreased compared to the second scrape, then record the qty sold. There needs to be basic error logging. A log page needs to show after each scrape if any unusual issues occurred such as: - URL not found (for SKU abc) - Search string not found (for SKU abc) - No QTY value found (for SKU abc) There needs to be a command button to "Clear Data" to begin collecting fresh data. This only clears the QTY data, all product SKU / URL data is preserved. Last but not least, the application needs a button "Create Report" which outputs a CSV with the following info: Product SKU, QTY Sold, Price Per Unit, Total Sales, Raw Price Per Unit, Total Profit, Error Where QTY sold is the total qty sold over the sample range Where total profit = (Price Per Unit X QTY Sold) - (Raw Price Per Unit X QTY Sold) If an error occurred on a product, it needs to show the last error logged for that product on the "Error" column
Project ID: 5695329

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $172 USD for this job
User Avatar
Hello, I am oracle certified professional java programmer and have Bsc,IT, I can do this in C#, java or delphi easily in 24 hours, if you want in VB, I am ready to start please start chat to discuss thanks
$152 USD in 2 days
4.9 (12 reviews)
4.3
4.3
User Avatar
Hello Sir I am interested in your project and I can start immediately I am a professional web scraper and I have done many web scraping projects before, I can show you a sample before awarding the project Looking forward to hear from you Regards
$45 USD in 3 days
5.0 (18 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
$222 USD in 5 days
4.8 (3 reviews)
3.0
3.0
User Avatar
Hello digitaldiy, I am interested in your project and ready to do it. Waiting for your approval of my bid. Thank you.
$190 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Kotara, Australia
5.0
77
Payment method verified
Member since Apr 13, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.