Catalog to Spreadsheet Data Entry

Admin Support Data Entry Posted 2 years ago


Less than 30 hrs/week
Less than 1 week

Intermediate Level

I am looking for a mix of experience and value


Task:  To create a spreadsheet of all products in a catalog by page number.

Material Provided:
- Master spreadsheet with highlighted columns and item numbers already filled in.  This is to be used as a guide to help you identify multiple price items and group codes as described below.

- PDF of catalog pages

The columns to be filled in are highlighted in yellow.  They are columns B, C, K, S, T, U, V, W, X, Y, Z and AS—a total of 12 columns.
Using the data already filled in as a guide, step through each page of the pdf and:
• Enter each item shown on each page in column B (ITEMNO).  
• Enter each price in column C (NEW MASTER PRICE)
• Enter the page number in column K (PAGE_NO)
• If the item identifies a special price by ordering multiples of the item, enter the first break quantity in column S (MP_QTY_1) and the price for that break in column T (MP_PRICE_1).
o Each quantity break after the first break is entered in ascending column orders as highlighted on the sheet.  The last break qty is always 9999999 (seven 9’s) with the last break price being the lowest price shown in the catalog.
o Note that all multiple priced items from the most recent catalog are already in the file—you must verify price/multiple quantity breaks/multiple quantity price and page number.
• Be alert to verify column AS (MP_GROUP_CODE).  In most cases—and there are only a few—this will already be filled in.  
If you sort the spreadsheet for any reason, be sure to sort the entire sheet.
Do not be concerned with the same product on multiple pages—we will de-dupe the file when it is returned.

Catalog contains 80 pages with a total SKU count of approx. 1800.

  • Other Skills:

Activity on this Job

Last Viewed by Client: 2 years ago

Hired: 1

About the Client

(5.00) 2 reviews

United States
Pottstown 06:30 PM

7 Jobs Posted
58% Hire Rate, 1 Open Job

$2,486 Total Spent
4 Hires, 1 Active

$4.44/hr Avg Hourly Rate Paid
14 Hours

Member Since Jan 15, 2013