I've got a bunch of CSV files containing data scraped from a variety of reviews sites, and I'm trying to build a site on Wordpress that aggregates reviews from many sites.
Have found plenty of guides about HOW to scrape web data, but very little about how to actually utilize it.
I'm trying to aggregate mattress reviews from 20-30+ sites. This involves creates pages for each mattress model on my [login to view URL] site. I want 5 mini-reviews displayed per page. So a model with 30 reviews would need 6 pages.
See picture "aggregated reviews example", this is roughly how I want the aggregated reviews to look. Each review will list overall rating out of 10, company/product logo, summary paragraph (probably chosen manually) website author, date, and a link to the full review. Assume this is all data I will provide to you.
In a nutshell, I need help taking the scraped data in all these CSVs and adding it to my [login to view URL] page, with minimal manual work required on either end.
I would prefer instruction on how to do this myself, or recommendations for plugins/applications/etc that can help, but if it's exceedingly complex we can discuss an arrangement where you can do it.
-Need to be able to standardize reviews on different scales (out of 5, out of 10, out of 100, letter grades, etc) into a universal out-of-ten rating.
-Need my site to be able to scan for dead links regularly, and automatically remove them from my aggregated reviews.