Capture information for store website sales flyers and enter into spreadsheet

  • Tila: Closed
  • Palkinto: $10
  • Vastaanotetut työt: 7
  • Voittaja: sharmaankit09

Kilpailun tehtävänanto

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.

Suositellut taidot

Kilpailun parhaat työt

Näytä lisää töitä

Julkinen selvennystaulu

  • anandr58
    anandr58
    • 3 vuotta sitten

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

    • 3 vuotta sitten

Kuinka päästä alkuun kilpailuiden kanssa

  • Julkaise kilpailusi

    Julkaise kilpailusi Nopeaa ja helppoa

  • Vastaanota tonnikaupalla osallistumisia

    Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa

  • Palkitse paras hakemus

    Palkitse paras hakemus Lataa tiedostot - helppoa!

Ilmoita kilpailu nyt tai liity tänään!