The objective of this job is to put together a list of wines and cellar door prices for US based wineries.
The successful bidder will be provided with an Excel list of the US wineries we are interested in. The list has ~6250 wineries, and we have already identified the winery website URL (if available). The average number of wines per winery is around 8-12.
The task is as follows:
1. Go to the winery website
2. Find out the various wines that each winery is producing and the variety, region and price
3. Write those wine names into the Excel sheet provided, together with the vintage, variety, region and price information
If the winery doesn't have a website, then the successful bidder should consult other websites such as wine retailers, who offer wines from that winery for sale.
A master list of varieties and blends will be provided. In blended wines, varieties are to be separated by commas (i.e. "Chardonnay, Pinot Noir")
"NV" (Non-vintage) is to be entered as the vintage for wines without a specific vintage year. Wines with the same name but different vintages are to be entered as a separate line item for each vintage (e.g. Winery ABC Chardonnay 2005 & Winery ABC Chardonnay 2006 etc).
For the region information, the Excel sheet will come with drop-down menus, from which the successful bidder will select the regional information. If our list doesn't have the region, a new region can be entered. Region information comes in four levels (Country, Region, Subregion, Appellation) and should be entered on the most detailed level available for the wine.
After the first 30 wineries the successful bidder will send the spreadsheet to us so we can review it and check that the data is correctly entered.
Some basic understanding of the wine industry and terminology are useful, but not essential. We will provide very clear and precise instructions as to the syntax of the wine name entry to the successful bidder, and ongoing coaching during this project. The Excel sheet is not to be varied in any way (i.e. no new column or lines to be created).
The resulting spreadsheet should be proofread to avoid spelling errors.
The timing is for this flexible, with completion anticipated within 4-6 weeks of contract award.
Any questions, please let us know. We look forward to receiving your bids!
36 freelanceria on tarjonnut keskimäärin 901 $ tähän työhön
Hi, Can do it to your satisfaction within 7 days. The latency is due to time taken for hitting the long list of urls. Will update you with sample output soon. Thanks.
I am highly experienced in web data extraction but new to GAF. I would like the opportunity to provide you this service. Please review my PM with more details about how I plan to perform this project. Thanks.
This is my first bid and project, however, I am VERY internet savvy and I believe that I can supply you with exactly what you are looking for. Thank you for your consideration!