Correct incorrect addresses on spreadsheet, gather missing store id's, find missing phone numbers
$30-250 USD
Płatność przy odbiorze
Hello,
We have 16,166 records. Here is a sample record:
ID StoreName Alias City Address State Zip Code Lat Long StoreID Phone Number Address Address Original
Aldi aldi Bessemer 710 Academy Drive AL 35020 33.3598 -86.9981 NULL NULL 710 Academy Drive 710 Academy Drive Bessemer
1.) There are some errors in the 2nd to last column, which is address. The last column contains the Address Original. When we split the address from city and zip code, there were some errors. We need the errors fixed.
Here is an example of an error:
Aldi aldi Harrison 1105 Hwy 65 North AR 72601 36.2759 -93.1555 NULL NULL 1105 Hwy 65 North 1105 Hwy 65 North Harrison
"1105 Hwy 65 North" this should be "1105 Hwy 65" and city should be "West Harrison"
There are probably between 200 and 400 errors (just a rough guess).
You will need to go record by record and correct any mistakes.
2.) We are missing store ID's for 7,100 stores. We need to gather these store id's. You will need to visit the stores web sites, search the address or zip code and record the store id. Sometimes store id is list in the URL.
I.e. http://xxxxxx/[login to view URL]
3.) We are missing phone numbers for about 5,500 stores. We need to gather this information as well.
Thank you.
Numer ID Projektu: #4000034
O projekcie
Przyznany użytkownikowi:
I have excellent feedback from previous similar project. I work fast and accurately. I will check all list one by one manually.
49 freelancerów złożyło ofertę za $134 w tym projekcie
Hello omegasea21, Professional and skilled research team here. Complete proposal attached on PM. Please have a look. Regards - vSolCORP
Your tasks is simple. I am experienced and I can really do great! Please let me do . Thanks.
Lets Start & get it done perfectly...Check your ++++++++++++++++++++INBOX++++++++++++++++++for details
>>>>>>>>>>>>QUALITY HERE<<<<<<<<<<<<<<< +++++++++++++++please see my PMB++++++++++++++++++++
Hi Sir, How are you? We are a team of girls and we are eager to work in this project. Regards Sonia
Hello! After carefully reading your project description I feel that I am the right candidate for the job. Please check private message inbox for details.
Hi omegasea21, I know what to do. Please provide me the 16,166 records and I'll go record by record and fixed the errors. Thanks
Dear Sir, We are ready to start and fulfill your requirement. Please check your inbox for details. Regards Rajaa