You have chosen to sponsor your bid up to a maximum amount of .
Need data input from 8 PDF files into a single EXCEL sheet.
Will not pay more than $30 for this job so please don't bid above that.
Job needs to be completed within 2 days.
Spreadsheet has many columns but only 6 columns need to be filled out.
Column names to be filled out are ItemSKU, ItemDesc, ItemPrice, FModel, FColor, FBrand
8 PDF's have 29 pages in total.
First 7 PDF's need the following data filled out. (OPAL documents)
ItemSKU(Excel) = Reference(PDF)
ItemDesc(Excel) = Description(PDF)
ItemPrice(Excel) = Gross Unit Price (PDF)
FModel(Excel) = First 7 characters of Reference field (PDF)
FColor(Excel) = Last 3 characters of Reference field (PDF) along with colour listed in Description field (PDF)
FBrand(Excel) = brand name can be found in the Description field (PDF)
For the other pdf the format is slightly different (allison)
Item codes/brand names key
BB = Benetton
BN = Benetton
BE = Benetton
MO = Moschino
RH = Zero RH+
SY = Sisley
fields need to be entered into the spreadsheet in the following format:
ItemSKU(Excel) = ITEM CODE(PDF)
ItemDesc(Excel) = Please fill in item code brand name at the beginning, from the key above, and then add the DESCRIPTION(PDF)
eg. if item code is BB17801 and description field is PLASTIC OPTICAL FRAMES, please fill in spreadsheet with Benetton PLASTIC OPTICAL FRAMES
ItemPrice(Excel) = PRICE - DISC.(PDF)
FModel(Excel) = first 5 characters of ITEM CODE(PDF) eg. if item code is BB17801, FModel will be BB178
FColor(Excel) = last 2 characters of ITEM CODE(PDF) eg. if item code is BB17801, FColor will be 01
FBrand(Excel) = item code brand name, so again using the key above if the item code is BB178, FBrand will be Benetton
Please bid only if you understand the requirements and are sure you can complete the project within the specified time frame (2 days).
Once winning bidder has been chosen documents will be sent.
If completed work is found to be incorrect it will need to be revised and re-completed by winning bidder until satisfactory.