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.

Taidot: Tiedonsyöttö, Excel, Tietojenkäsittely

Tietoa asiakkaasta:
( 1 arvostelu ) Los Angeles, United States

Projektin tunnus: #34016633

Myönnetty käyttäjälle:

(28 Arvostelua)

66 freelanceria on tarjonnut keskimäärin $142 tähän työhön

(446 arvostelua)
(306 arvostelua)
(187 arvostelua)

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 3 päivässä
(182 arvostelua)
(56 arvostelua)
(101 arvostelua)

"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 Lisää

$100 USD 4 päivässä
(480 arvostelua)
(92 arvostelua)

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 Lisää

$140 USD 1 päivässä
(98 arvostelua)

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 1 päivässä
(113 arvostelua)
(69 arvostelua)
(22 arvostelua)

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 Lisää

$94 USD 2 päivässä
(17 arvostelua)

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 1 päivässä
(29 arvostelua)
(12 arvostelua)

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 Lisää

$140 USD 7 päivässä
(15 arvostelua)

"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 Lisää

$50 USD 1 päivässä
(13 arvostelua)

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 2 päivässä
(2 arvostelua)

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 7 päivässä
(6 arvostelua)

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 Lisää

$250 USD 7 päivässä
(15 arvostelua)