Freelance
$75
TBD
Feb 28, 2016
Good Evening, I'm looking for someone to visit a US website and complete data entry for products.
The desired output is an excel document t that includes Product Type, Brand, Product Name (with hyperlink to the product on target.com), Price, Size (in ounces) and a calculation of Price per ounce.
I'd like this completed for premium skincare on target.com (link: http://www.target.com/c/premium-skin-care-beauty/-/N-55aja#?lnk=lnav_ shop categories_8&intc=3153113|null)
the second step is to select type, starting with Facial moisturizer. Complete the spreadsheet for all products that show up as facial moisturizers (all pages on the site, not just the first page) . Once done, go back to type and this time select facial cleanser and complete the columns for all products that show up in that category.
I'd like this process completed for the following categories:
-Facial Moisturizer (62)
Facial Cleanser (24)
Eye Cream (14)
Serum (12)
Facial Mask Treatment (7)
Acne Treatment (6)
Moisturizing Lotion (5)
Facial Toner (4)
Lip Balm (4)
skin brighteners and dark spot treatments (4)
Face Mister Spray (3)
Facial Exfoliant (3)
Facial Cleansing Wipes (1)
Once complete, I'd like to see a category summary tab in the document shows the following for each type from the lists above:
Type
# of items
average price
average ounces
average price / ounce
I'd also like to see a second summary tab that shows:
Brand - in the first colum
Types- list the types across the row
place an X in the box if that brand has a product in the category.
I'm seeking a very fast completion on this project. Please review the requirements and tell me how long this will take to complete.