Capture information for store website sales flyers and enter into spreadsheet

  • Status: Closed
  • Hadiah: $10
  • Penyertaan diterima: 7
  • Pemenang: sharmaankit09

Ringkasan Peraduan

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: [url removed, login to view]
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: [url removed, login to view]
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.

Kemahiran Disyorkan

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • anandr58
    anandr58
    • 4 tahun yang lalu

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

    • 4 tahun yang lalu

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!