Looking for a PHP developer to build a simple interal tool to scrape reviews from [url removed, login to view] and present them to the user. The following brief is for the first version of the tool, with the scope expanding over time:
The user will first be asked to input the product code, known as the ASIN (example: B003BEDQL2).
The tool will then scrape, and store (MYSQL), all the reviews for that product. This could be the entry point:
[url removed, login to view]
Data points to record:
- Title (and link to review page)
- Body copy
- Review score (1-5 stores)
- Date of review
- Author name (and link to profile page)
- Number of comments (with link to comment page)
- If photos/video content (yes/no)
- If verified (yes/no)
- "Child" product being reviewed, also called "format"
The tool will need to scrape all the review pages until the very first review. This process make take some time to process. Therefore, I recommend it is completed asynchronously. Upon submission, the request could be entered into a queue. The user is returned to a page with a random value appended into the URL string. The user can bookmark and return to that page later (similar concept used here: [url removed, login to view]). On the server, we can create a cronjob to execute every 5 minutes to process new requests.
When complete, the user can see the data in a list format. Can copy similar Amazon format: [url removed, login to view]
Reviews are sorted by date, with most recent at the top.
There should be some input options at the top (with a Submit button to refresh) to filter results:
- Hide/Show Verified reviews (toggle)
- Hide/show each star (checkbox for each)
- Filter to select from specific child variation (or "All")
There should also be a summary at the top of the page:
- Total number of review (together with total verified and total unverified)
- Total number of votes per star rating (again with same breakdown of verified and unverified). Mockup: [url removed, login to view]
You will be more likely to be hired if you can demonstrate your skills be showing that you understand the requirements and have already planned out the task. Codebase must be developed using PHP/MYSQL, using Git for version control, and the FlatUI themed Bootstrap library ([url removed, login to view]) where a UI is required. Do not bid if you do agree to this.
Please include the password "maple syrup" in your bid. Proposals without the password will be ignored!
This should be a painless and fun project for someone who knows what they're doing. The above task is a fixed price project, but this will develop into a larger project over time.
You will see that I have a long standing reputation on [url removed, login to view] (since 2005) and that freelancers have had a successful working relationship with me.
To set expectations; this is a relatively simple task that doesn't require creative design skills and can lead to much more work. I expect the cost to be <$100. Additional milestones can be offered if the scope expands.