Capture information for store website sales flyers and enter into spreadsheet

  • Status: Closed
  • Præmie: $10
  • Modtagne indlæg: 7
  • Vinder: sharmaankit09

Konkurrencebeskrivelse

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.

Anbefalede færdigheder

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig præciseringstavle

  • anandr58
    anandr58
    • 3 år siden

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

    • 3 år siden

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Vælg det bedste indlæg

    Vælg det bedste indlæg Download filerne - Nemt!

Opret en konkurrence nu eller slut dig til os i dag!