Capture information for store website sales flyers and enter into spreadsheet

  • Tình trạng: Closed
  • Giải thưởng: $10
  • Các bài thi đã nhận: 7
  • Người chiến thắng: sharmaankit09

Tóm tắt cuộc thi

Data Entry Gig

Details: I would like data captured in an excel spreadsheet from specific store flyers for the 94550 zip code. Instructions are below.

These are the stores:
Walmart
Walgreens

These are the instructions (they also attached since some formatting was lost):

Walmart
1. Please note, you must complete the following steps within the same US Business day because store flyers will change.
2. Go to website: www.walmart.com
3. Click the Weekly Ad menu, then click the Weekly Ad button
4. In the ‘Enter a new location’ field, type 94550 and click the Go button
5. Locate the ‘Livermore’ location and click the Browse Ads orange button. It is important you click the correct store button.
6. Click the Back on Track flyer, make sure you select the correct one, should be 10 pages long
7. Open an Excel spreadsheet and save it as ‘Walmart’.
8. Add the following Top Row names to the excel spreadsheet (see example in Step 9):
Sale Start Date:
Sale End Date:
Zip Code for flyer:
Name of Store:
9. Below the row names, add the following column names (see example in Step 9):
Manufacturer Name
Product Name
Size
Deal (If available)
Sales Price (if available)
10. Go through store flyer and add information to spreadsheet, here is an example.

Data Entry Gig - Walgreens

Walgreens
1. Please note, you must complete the following steps within the same US Business day because store flyers will change.
2. Go to website: www.walgreens.com
3. Click the Weekly Ads and Coupons link
4. Click View Weekly Ad button
5. Click Change Store
6. In the Find Another Location field, type 94550 and click the Go button
7. Next to Livermore location, click the View Weekly Ad button
8. Open an Excel spreadsheet and save it as ‘Walgreens’.
9. Add the following Top Row names to the excel spreadsheet (see example in Step 11):
Sale Start Date:
Sale End Date:
Zip Code for flyer:
Name of Store:
10. Below the row names, add the following column names (see example in Step 11):
Manufacturer Name
Product Name
Size
Deal (If available)
Sales Price (if available)
11. Go through store flyer and add information to spreadsheet, here is an example.

Example 1:

Store Flyer (Walgreens)



Sale Start Date: 1/19/14
Sale End Date: 1/25/14
Zip Code for Flyer: 94550
Name of Store: Walgreens
Manufacturer Name: Product Name: Size: Deal: Sales Price:
Nature’s Bounty Vitamins and Supplements Buy 1 Get 1 Free with Card
Osteo Bi-Flex Vitamins and Supplements Buy 1 Get 1 Free with Card
General Mills Cereal Cinnamon Toast Crunch 10.7 to 13 oz 1.99
General Mills Cereal Golden Grahams 10.7 to 13 oz 1.99
General Mills Cereal Cookie Crisp 10.7 to 13 oz 1.99
General Mills Cereal Lucky Charms 10.7 to 13 oz 1.99
Pepsi Pepsi 12 pack 2000 points on purchase of 4 = $2 reward 4 packs for $12
Dr. Pepper Dr. Pepper 12 pack 2000 points on purchase of 4 = $2 reward 4 packs for $12
Wonderful Pistachios Pistachios 16 oz 50 cent coupon from Sunday paper 5.99
Maxwell House Coffee Original or Master Blend 30.6 oz 1000 points = $1 5.99
Maxwell House Coffee French Roast 29.3 oz 1000 points = $1 5.99
12. Save File.










Example 1:
Store Flyer (Walmart)









Sale Start Date: 1/22/14
Sale End Date: 1/28/14
Zip Code for Flyer: 94550
Name of Store: Walmart
Manufacturer Name: Product Name: Size: Deal: Sales Price:
Kellog’s Kellog’s Special K Protein Cereal 12.5 oz 2.98
Weightwatchers Smart Ones Entrée 8 – 9 oz 1.78
Fiber One Fiber One Protein Cereal 14 oz 2.50
Skinny Cow Chocolate Truffle Bars or Vanilla Sandwiches 6ct or 15.4 – 24 oz 3.98



11. Save File.

Các kĩ năng yêu cầu

Bảng thông báo công khai

  • anandr58
    anandr58
    • cách đây 10 năm

    we need to put all ads in excel given in Livermore?

    • cách đây 10 năm

Làm thế nào để bắt đầu với cuộc thi

  • Đăng cuộc thi của bạn

    Đăng cuộc thi của bạn Nhanh chóng và dễ dàng

  • Nhận được vô số bài dự thi

    Nhận được vô số Bài dự thi Từ khắp nơi trên thế giới

  • Trao giải cho bài thi xuất sắc nhất

    Trao giải cho bài thi xuất sắc nhất Download File - Đơn giản!

Đăng cuộc thi ngay hoặc tham gia với chúng tôi ngay hôm nay!