Excel guru needed for long-term E-commerce and Shopify product formatting

Completado Publicado hace 3 años Pagado a la entrega
Completado

***UPDATE – Another account has stolen the information in this post and posted it as their own job. That is not my account!

***UPDATE – I am offering to pay for this test job, which will help me decide who to hire long-term. I now understand that there are projects on here that want free work done – this is not one of those jobs, but I need to know if you have the basic skills (formulas, VBScript) to perform 90% of our required tasks. You should never do anything for FREE!

I hope this post finds you healthy and safe. My client requires 1, maybe 2 Excel gurus for immediate short term to probable long term e-commerce work at least through the end of the year. Shopify experience preferred but not required. Must be able to think dynamically and have a great knowledge of Excel formulas and/or VB Script to automate the formatting of thousands of products on a regular basis. Additional knowledge of other e-commerce platform formatting a plus (Volusion, Big Commerce, Magento, Houzz etc.).

Very strong English communication skills required. English is not a required primary language. You MUST be proactive, anticipate, ask questions, initiate concerns and be open to instruction and critiques as we work together. I do not want to chase you for work, timely responses or to fix mistakes. Hard workers with good attitudes have nothing to fear. We can make this enjoyable and develop a friendship while getting a lot done.

Ideal candidate can be available to work sometime between 12PM and 12AM EST. You are not required to work all that time but we need some overlapping working hours sometime during the day. Daily communication is not required but daily availability is required. 30-40 hours available for the first few weeks at least, if not permanently for the right candidate who can work independently and in a timely manner. Familiarity with Slack and Trello required for communications and Assigned Tasks.

You MUST be able to work online on either Excel Online or Google Sheets, even if the majority of your work is done locally.

No one who doesn't read this entire post will be eligible for this job. Scripts and bots that auto-populate a proposal will be detected and ignored. To that, in your proposal please briefly talk about your faith, tell me your favorite color and one thing you enjoy outside of work.

I am hoping to build a long-term relationship with the right candidate as our e-commerce businesses are growing and we will be adding a 3rd Shopify store in 2021 (among other endeavors). This job is a small test job, and will determine who we work with long term:

Attached are two test spreadsheets - A NEW spreadsheet from a manufacturer and a CURRENT inventory from one of our stores. Your first task is to identify which products in our CURRENT inventory have been discontinued (SKU is absent from NEW). These are products we need to DELETE. Your next task will be to identify what products from NEW are missing from CURRENT. These are products we need to ADD. Your last task is to take a list of image URLs and assign each, by SKU, to their corresponding product (see third spreadsheet for example). These three tasks are critical for our business. I want to see some kind of formula (or VB script) in your work as proof of your skill. If you can quickly do this, then you have a good chance of being considered.

Feel free to ask questions in your proposal or message me. I will not award the job until every interested applicant gets their questions answered.

sincerely

Peter

Excel Shopify VBScript Slack Google Sheets

Nº del proyecto: #28242247

Sobre el proyecto

32 propuestas Proyecto remoto Activo hace 3 años

Adjudicado a:

Jabirdriss0

Hello sir, im a hard worker and desiplined, actif and kind i would like to work to you, i have the skilles and the knowledge you required on the description. Im free to start working at [login to view URL] favorite colore is re Más

$10 USD / hora
(1 comentario)
0.6
(158 comentarios)
5.9
(11 comentarios)
3.2
priyabathula

*Christian - Blue - Games* I have COMPLETED task1 and task2 mentioned in the description. Coding completed for task3 as well. But need CLARIFICATION regarding mapping of image URLs to SKU's present in which file(New/ Más

$10 USD / hora
(3 comentarios)
1.9

32 freelancers están ofertando un promedio de $12 / hora por este trabajo

mrbrave

Hi, I am Muslim, working as a Excel VBA developer for more then 10 years. My favorite color is Yellow and I love to play with my kids outside of working. We have almost 10 hours of difference in time zone, but I mostl Más

$15 USD / hora
(272 comentarios)
6.9
writingapp

Green. Game. Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 days

$15 USD / hora
(102 comentarios)
5.8
dhanrajkarthick

Black - Reading Books Hi there, I am a Microsoft Certified Professional in Excel and VBA as an Expert. Kindly go through my profile. Awaiting for your interview. Regards, Karthick G.

$15 USD / hora
(39 comentarios)
5.1
ryonkol

Hello, I am an experienced developer for last 8 years.I can deliver you the best out come you are really looking for.I can provide you a demo before the project is awarded to me and will look up to your remarkable opin Más

$13 USD / hora
(3 comentarios)
2.4
rukshanlancer

Hi Mate, I am checking your description carefully. I am familiar to Excel, Slack, Google Sheets, Shopify and VBScript. I have developed a lot of websites with Shopify. If you are looking for a hardworking, talented p Más

$15 USD / hora
(1 comentario)
1.8
tgltech

Hi, I have reviewed attachments & understood them thoroughly. I have gone through your requirements " Excel guru needed for long-term E-commerce and Shopify product formatting " and can absolutely assist you in achie Más

$12 USD / hora
(2 comentarios)
0.6
MahfujurNime

Dear Hiring Manager, Hope you are doing well. I read your description. I will be able to fulfill your requirements. I am a social media expert. I have enough experience on it. If you are interested in me, feel free Más

$8 USD / hora
(0 comentarios)
0.0
Agustina1501

Hello! I do an excellent job, I am very responsible, my work is organized, ordered, punctual and without errors.

$10 USD / hora
(0 comentarios)
0.0
sajjadzeroland

Hello, This is professional here to work with you i have a quality of skill i have a experience of many years please chat for more details. Thankx. Sajjad.

$7 USD / hora
(1 comentario)
0.0
Radakoovic

Regards from Serbia! First of all, to see that this is not generic proposal. My favourite collor is blue, dark blue! My biggest faith is faith in progress, and besides work I am crypto lover. I have good Shopify expe Más

$15 USD / hora
(0 comentarios)
0.0
nadasaber1

Hi, I am Nada . I am available for 24/7.i am dealing well with excel and google sheets. My favorite color is blue . I enjoy reading outside work. please communicate with me to send you what is required for the attached Más

$10 USD / hora
(0 comentarios)
0.0
AmrTalab

you can give me a sample to make sure that I am qualified to do this job. I am Amr talab from Egypt. I am excellent with excel and have the ability to work online . I can work under stress with good accuracy. hope yo Más

$5 USD / hora
(0 comentarios)
0.0
jmil91

Peter Finding the Discontinued and New items just requires a VLOOKUP between the NEW and CURRENT (if it errors...it's missing). The third just involves pasting the .txt file data into excel using the delimiter tool. Más

$10 USD / hora
(0 comentarios)
0.0
IsabelEnri

One of my main job in my current work is to keep an updated excel file of all the deals we have. This made me familiar and efficient in using excel files.

$10 USD / hora
(0 comentarios)
0.0
sunnygupt17

Hello, I will complete the desired task in the minimum budget along with 100% accuracy . Request you to connect with me for a superior quality of work. I have prior experience in this field . Also I can do this work i Más

$5 USD / hora
(0 comentarios)
0.0
claricejinod

Hi there! I'm Clarice, a professional data entry and I am a very high integrity person, self-motivated, diligent, and punctual. With 3 years experience in data entry, these are my services and tools that I can offer Más

$10 USD / hora
(0 comentarios)
0.0
sallydralews

Hi, Let me introduce me as a hardworking data entry professional willing to go that extra mile to achive the targets set forth. I have excellent English skills and proficiency in E-commerce site navigation. I hope wo Más

$10 USD / hora
(0 comentarios)
0.0
syrapaul7114

Hello, I have strong skills and experience in Excel. I understand the requirements and I can assure you of completion with high-quality of work if you put trust in me for this project of yours. Looking forward to hav Más

$8 USD / hora
(0 comentarios)
0.0
Samrohit9976

Hi, my name is Mohammad Salman . I am excel expert and speedy Data Entry Operator My working experience covers a variety of work, especially data entry, Excel, Word, PowerPoint, bookkeeping, Accounting, and much more Más

$8 USD / hora
(0 comentarios)
0.0
ainnooraini21

Hi Sir, I am writing in response to your advertisement for a data administrator. After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’ve held Más

$10 USD / hora
(0 comentarios)
0.0