Excel Formula for Product Variants

£10-20 GBP

Completed

Posted

over 3 years ago

£10-20 GBP

Paid on delivery

The spreadsheet is for bulk importing products to Shopify through the Excelify app. The PRODUCTS worksheet contains the data that will be uploaded. We need a formula for the variants in PRODUCTS AC:AH, which are pulled via VLOOKUP referencing the EAN in column C. The current formula provided in the workbook results in an upload error. The criteria are: - If a variant is "N/A", then Option Name and Option Value should be empty - There will be an upload error on Shopify if Variant 2 is populated, but Option1 is empty. Likewise for Option 3, if Option 1 and 2 are empty and so on. i.e. the lowest Option number must always be 1. The formula should ensure the Options are created from 1 upwards. - The formula should pull the relevant header from EPOS Brand List Worksheet to populate the Option Name column i.e. Size, Colour, Material Addtional: - Changes are only allowed to columns AC:AH in PRODUCTS worksheet.

Excel

Project ID: 27495947

About the project

15 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@AnowarRatul

£0 GBP in 1 day

5.0

(183 reviews)

6.0

15 freelancers are bidding on average £18 GBP for this job

@leelakalidas32

Hello sir Good evening how are you? i am expert in shopify products listing via csv bulk , if you need help then i can arrange your csv file so you can upload it directly to your store. contact me if you okay with my offer thanks.

£20 GBP in 1 day

4.9

(586 reviews)

7.6

@Mokshith30

Hi I am VBA Developer Experianced In Web Scrapping & VBA Macros I can finish this task in a day only please share the details thanks

£20 GBP in 1 day

4.9

(41 reviews)

4.6

@nelumindralal

Hello, I went thru the file and description Here is my feedback The criteria are: - If a variant is "N/A", then Option Name and Option Value should be empty--> 'EPOS Brand K value also N/A, its a value, not a non value So it will appear in the product sheet anyway - There will be an upload error on Shopify if Variant 2 is populated, but Option1 is empty. Likewise for Option 3, if Option 1 and 2 are empty and so on. i.e. the lowest Option number must always be 1. The formula should ensure the Options are created from 1 upwards. --> I dont understand this, can u explain more? - The formula should pull the relevant header from EPOS Brand List Worksheet to populate the Option Name column i.e. Size, Colour, Material --> seems its pulling with the Vlookup Addtional: - Changes are only allowed to columns AC:AH in PRODUCTS worksheet. --> OK

£30 GBP in 1 day

5.0

(29 reviews)

4.8

@haleem0786

i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks Abdul Haleem

£20 GBP in 1 day

4.9

(28 reviews)

4.2

@Mohilm007

------------------I CAN DO IT RIGHT AWAY------------------ Hi, I am the professional and skilled worker in this field since last 6 years. I can help you with your project of data entry in excel, VBA, excel macros, VB, excel dashboard, pivot tables, charts, v look up, word, database and Microsoft office, Accounting, Book Keeping at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let’s discuss more in chat box

£15 GBP in 1 day

4.9

(4 reviews)

3.3

@chetandc

Hello, Thanks for Reviewing my Bid. I have understood your "Excel Formula for Product Variants" project. & I can fulfill your requirements. I have years of data entry, data formatting, processing, Ecommerce product listings (Amazon, eBay, Wallmart, Shopify, Wix, WordPress, Magento, etc. experience. I can also edit product images if required and I am well aware of how a Brand works in the Market and what are the needs for it. I'm interested in your project, Message me so we can discuss details further. Regards. Chetan C.

£20 GBP in 2 days

5.0

(18 reviews)

2.8

@himanshuprajapa6

Hi I'm Himanshu Prajapati, I'm new in freelancer.com. But still I have worked in other private companies. So I'm more experienced in Excel, word, pdf to word conversion and Data Entry work. I have just seen that you need someone who is proficient in Data Entry. I'm qualified for this job. I can assure that my work will satisfy you. Please give me a chance.

£15 GBP in 7 days

0.0

(0 reviews)

0.0

@Zeeshaan6061

Hi, Lets Get Started With This right Now……This is pretty straightforward task……and I can do this as u want it done…..will fix it asap :) I have done many projects similar to this…all with 5* feedbacks, hope will get a chance to work with u too. Message me to discuss and finish it asap…….thanks Microsoft Excel is one of the most popular, powerful and easiest programs for managing information. ... Freelancer.com offers you a lot of Excel projects with clients who want help with Excel macros, Excel data entry, PDF to Excel conversion, Excel database, Excel V.B and Excel formulas.

£10 GBP in 7 days

0.0

(0 reviews)

0.0

@Lockest

Hello. I'm an engineering student and I've worked as an administrative assistant for two years now. I'm confident I can develop the formula you need, and I'd compromise to fix it if any issue would arise in the following months with it. Let me know if you are interested in my offer and we shall discuss further any specific details you might have missed.

£15 GBP in 5 days

0.0

(0 reviews)

0.0

@Subathrasiva

hi.... right time to work with you....I know Excel sheet for the work.... eager to work with you. tq ...I am waiting

£34 GBP in 6 days

0.0

(0 reviews)

0.0

@mpanigrahi2892

I can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail.

£10 GBP in 3 days

0.0

(0 reviews)

0.0

@Nazeer0010

Hi, To be frank I did not get the requirement, I'm really good in playing with excel formulas. If you can give me little more brief I'll give you the output in same day. Thanks, talk to you soon.

£10 GBP in 1 day