Completed

Data Entry Project

This data entry project entails adding 1 new variant to each of our products, as well as 1 new size for each product.

Our current product library consists of several images that come in 5 sizes: Small, Medium, Large, Giant and Collector. They all have white borders, referred to as "Border." Each piece is available in 4 different framing options: Black, White, Hickory or No Frame.

The purpose of this task is the following:

1. Add new variants for each product which will not have the white border - these are referred to as "Full Bleed"

2. Add a new size for each product called "Exhibition." This new Exhibition size will be available just like the others in both Border and Full Bleed variants.

The steps required to complete this task are as follows:

1. For each product, create additional rows to accommodate the new Full Bleed variants, as well as the 8 additional rows at the bottom to include the new "Exhibition" size (in both Border and Full Bleed variants). These rows are highlighted in the EXAMPLE PRODUCT tab of the spreadsheet.

2. Add "Full Bleed" as the Option 2 value (column L) in the new rows created for the new variant.

3. Add "-FB" to the end of the preceding SKU to create the SKU for the new Full Bleed variant (e.g., if the SKU for the Border variant in the preceding row is "JC01-S-B-SBL" then the SKU for the Full Bleed variant of that product in the new row you have created should be "JC01-S-B-SBL-FB").

4. Copy over data in remaining cells that is the same for the Full Bleed variants (you will see this data in the highlighted rows on the EXAMPLE PRODUCT tab)

5. Make sure "Image Position" column numbers are sequential

6. You can ignore the URL data in the columns highlighted in GREY.

7. Add the 8 additional rows at the bottom for each product to include the new Exhibition size in both Matted and Full Bleed variants, and include all information for all further cells in the new rows where applicable

See "REQUIREMENTS" tab on the Excel worksheet for a brief recap of the above instructions.

Please complete this exercise for the first ten (10) products on the "ALL PRODUCTS 6.29.22" tab so that we can confirm the work is correct before proceeding.

Only bids that contain the word PINEAPPLE to show you have read the entire description will be considered.

Skills: Data Entry, Excel, Data Processing

About the Client:
( 1 review ) Los Angeles, United States

Project ID: #34016633

Awarded to:

(28 Reviews)
5.0

66 freelancers are bidding on average $142 for this job

(446 Reviews)
8.1
(306 Reviews)
7.4
(187 Reviews)
7.0
hdlong66

PINEAPPLE Hello Chris, I can assist you to update your spreadsheet for about 296 products. I’m willing to give a sample for your review and comment. Please drop a PM if you’re interested. Best regards, Hoang

$100 USD in 3 days
(182 Reviews)
7.1
(56 Reviews)
6.6
(101 Reviews)
6.5
tmoi06

"PINEAPPLE" Hello Sir, I am 100% confident that I can execute the project with good quality. For better clarification, you can also have a look at several feedbacks that I have earned so far on Freelancer. Thanks A More

$100 USD in 4 days
(480 Reviews)
6.5
(92 Reviews)
6.2
nimiwebjuggler

Hi PINEAPPLE, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of mor More

$140 USD in 1 day
(98 Reviews)
6.0
sobhad20

PINEAPPLE Hi There, I can do this project right now with perfectly. Kindly ping me to start your work now. Regard’s Sobha

$100 USD in 1 day
(113 Reviews)
5.3
(69 Reviews)
5.5
(22 Reviews)
4.9
monicawriter99

Hey! I've carefully checked your requirements and really interested in this project Data Entry Project. I'm a full-time data and statistical analyst. I have worked with many clients across the world. I have rich experi More

$94 USD in 2 days
(17 Reviews)
4.9
Badhan685

Data Entry Project. (PINEAPPLE ) We have a team. We will provide 100% quality. We are ready to start the task. Please send me a message for discussion. Let's discuss the job. Thank

$30 USD in 1 day
(29 Reviews)
4.5
(12 Reviews)
4.4
ismail80196

PINEAPPLE Hi, I understand perfectly your requirements. I am ready to start right now. I have strong knowledge about it. I am ready to start work right now and can assure the best service from my end. Waiting for your More

$140 USD in 7 days
(15 Reviews)
4.1
Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta More

$50 USD in 1 day
(13 Reviews)
3.7
anenkovakateryna

Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!

$100 USD in 2 days
(2 Reviews)
3.6
Monicajain1993

Hey, I have gone through the requirements and the excel file as well. Your requirements are clear. I can do sample work. Please message me for taking it forward. Thanks

$140 USD in 7 days
(6 Reviews)
3.3
Tandra24

PINEAPPLE, Hello, I have downloaded the HoS - FB & EX Products [login to view URL] file, now working on it. The requirement is clear to me. I will complete the first 10 products and will send you. Kindly drop a message, so t More

$250 USD in 7 days
(15 Reviews)
3.6