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
- Changes are only allowed to columns AC:AH in PRODUCTS worksheet.
15 freelancers are bidding on average £18 for this job
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
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.
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.