Develop an Excel Macro that creates a Shopify product import file from another Excel file

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

We are planning to import products into our new online shop based on Shopify platform. This project is about creating an Excel macro that converts a product file from a given format in Excel (Source file) to a Shopify format also in Excel (Output file). This includes a field-to-field mapping as well as some necessary format modifications to satisfy the output to be exactly the way Shopify requires for product import. Products must be sorted based on the product type in source file.

I have uploaded a sample for the source file and a sample for the Shopify output file. Please note that the source file is only a sample. The exact format for the source file can be specified between us once you take on the project. The titles in the source file are in Swedish. Once you take on the project, I can provide English translation for these titles.

• Important: You need to already have or willing to obtain strong knowledge in Shopify Product import file format to be able to perform this task. I can help explaining most of Shopify format details, but you might also need to do your own reading. I will explain all details about the format of the source file.

• Important: You need to have strong knowledge in Excel and writing codes for macro to be able to perform this task.

• It is also required to perform some modifications and clean-up work in the source file.

• Our product file (the Excel source file) has close to 200,000 lines.

• The macro must also allow to brows and select the source file. The output file must be saved with a new filename in the same folder as the source file.

• We will need to share screens in one or more online meetings to discuss details. The exact format for the source and output files can be specified in such meetings.

• Once you have produced the bug free macro, we must perform a real Shopify import test together in an online meeting by sharing our screens.

Excel Excel Macros Excel VBA Excel VB Capabilities

Project ID: #32532862

About the project

18 proposals Remote project Active 2 years ago

Awarded to:

(397 Reviews)
8.1

18 freelancers are bidding on average $161 for this job

arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and More

$120 USD in 1 day
(13 Reviews)
3.7
trhbehzade

Hi, I am an expert in Excel and VBA. I have done several projects in which I have done any task using programming in VBA. I can do it quickly and will provide you with quality and fast work. Can we discuss all your nee More

$100 USD in 7 days
(0 Reviews)
0.0
denalekskhua

Dear Hiring Manager, Greetings from Denys ,hope your day is going well and all is good with you. We would like to discuss the project in details before confirming the bid, so kindly let me know when you are available.

$140 USD in 7 days
(0 Reviews)
0.0
reddiboinamaria

I HAVE A WORK EXPERIANCE WITH EXCEL. AND I AM VERY INTRESTED TO WORK WITH YOU. AND I COMPLETED YOUR WORK WITH IN TIME TO FALLOW YOUR INSTRUCTIONS. PLEASE GIVE ME A CHANCE TO WORK WITH YOU.

$140 USD in 7 days
(0 Reviews)
0.0
rashidamjad

Hi there, How are you? I can work with your project skills Excel VB Capabilities, Excel Macros, Excel VBA and Excel. Upon reading your description file I am sure we can definitely pull it off once provided with detaile More

$250 USD in 8 days
(0 Reviews)
0.0
ritchelobligado8

I am a fast learner and I possess good communication skills. I have a proper training for some online skills and tools. I am familiar also with Microsoft Word, Google Drive and can easily adapt to new programs .

$140 USD in 7 days
(0 Reviews)
0.0
Ezlybilly

hello sir I read through the job details extremely carefully and I am sure that I can do the project very well. I can achieve the results that you are asking for, and I am very interested in this project. I will finish More

$140 USD in 7 days
(0 Reviews)
0.0
soorajpathak2152

I will done this on my time so please give me this and see my magic because i love&like my work and i know i will do that.

$120 USD in 7 days
(0 Reviews)
0.0