Closed

Update Excel Files for Product SKU's to create new SKU's that include colours

Job Description:

We are updating our inventory management system, and need to create individual SKU's for each colour a product is available in. We currently use a generic SKU which gets edited to input the colour.

The SKU's are exported in a csv file, and edits are to be made in excel.

We are looking for a freelancer to use the csv file we provide with the product SKU's, and duplicate the SKU's for each individual product. There are 5 lists left to be done, each with 150-1000 original SKU's. Each orginal SKU could have 5-30 different colours that need to be created.

Example shown in attached image, as well as CSV file that would be used.

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

About the Client:
( 1 review ) Sherwood Park, Canada

Project ID: #35360294

105 freelancers are bidding on average $369 for this job

jeweljitu

Hi There, Good day. I am a highly trained Data Entry, Research, Web search, Web scrape, and Email Lead Generation Expert with excellent knowledge of Excel and all Social Networks. I want to prove my skills and ha More

$500 CAD in 7 days
(1414 Reviews)
9.0
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you More

$500 CAD in 7 days
(570 Reviews)
8.5
P0L

Hello, I am an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$400 CAD in 3 days
(510 Reviews)
8.0
saqibmunir55

Hi Sure, I read details and checked pdf and excel file attached, I can use original sku's and can add colour names at the end of column A, column B, And column I, and will add new sku for each colour available within More

$250 CAD in 1 day
(786 Reviews)
7.8
eltamarisa85

Hi. I can start now to use the csv file with the product SKU's and duplicate the SKU's for the individual product. I'm serious to work fast and accurate. I don't have any work for this time, so i can spend all my time More

$299 CAD in 3 days
(341 Reviews)
7.2
ksriniravi

Greetings! Please share the 5 lists with Original SKUs along with a table defining the list of colors applicable for each Original SKU. I can generate a new SKU for each of the Original SKU - Color combination exactly More

$250 CAD in 3 days
(260 Reviews)
7.2
daniyal3214

Hi, I will be glad to assist you with that. I am an experienced Data Analyst and Excel expert holding years of experience in Data Analysis, Data Visualization, Financial & Business Analysis. Lets discuss your project i More

$250 CAD in 1 day
(194 Reviews)
7.1
gangabass

I can process all products you have automatically using the script (no human errors etc) in less than a day for just $250 CAD. As a result of my work you'll receive Excel output + the script that you can use later for More

$250 CAD in 1 day
(246 Reviews)
7.0
pakee

Hey I have go through THE ATTACHED EXAMPLE and READY to CREATE SKU for 5-30 different colors of products. I can DO it PERFECTLY as i have already did the same task and know very WELL how to create SKU's for variables. More

$350 CAD in 5 days
(301 Reviews)
7.0
AccountantArman

SIR", I am EXCEL Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Acco More

$250 CAD in 1 day
(215 Reviews)
6.8
MohsanEijaz

I am confident in your project and I can finish it clearly on time. I am a well-experienced and skillful Excel/VBA, Google Sheet, Python as you can see in my past works on this site. I ensure the best quality of your p More

$250 CAD in 3 days
(99 Reviews)
6.8
belalihabibullah

Dear sir, I am glad to inform you that we have a strong 5+ years of quality experience in knowledge of Excel . I am interested in doing this job for you. I do have the necessary skill set & resources to complete this p More

$350 CAD in 3 days
(151 Reviews)
6.4
uhjk

Hello, I can do this using php. I will import your excel file to database and create variations. I can deliver you file in <24 hours.

$250 CAD in 1 day
(92 Reviews)
6.5
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m More

$250 CAD in 3 days
(126 Reviews)
6.6
PERPETUAL0

Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t More

$295 CAD in 2 days
(209 Reviews)
6.2
vsprybhanu

Hi, I can develop Excel VBA Macro to generate SKUs as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please More

$250 CAD in 3 days
(148 Reviews)
6.2
Guptapuru304

Hi, my name is Puru. I am from India. I read your `Update Excel Files for Product SKU's to create new SKU's that include colours` project description carefully before bidding. I got what you need and ready to go ahead More

$750 CAD in 3 days
(11 Reviews)
6.0
mhfsha

Hello sir/ madam I checked your project description. I can do update Excel files for products SKU editing task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss mo More

$250 CAD in 1 day
(156 Reviews)
5.6
yadavexpert53

Hello there, I can create individual SKU's for each colour a generic product. Previous I had done an automation for this type of work.I am an excel EXPERT level with top rating (I CAN DO IT RIGHT AWAY--Microsoft Excel More

$450 CAD in 1 day
(80 Reviews)
5.4
EmiliaSimon

Hello, I can help you to create individual SKUs, according to the available colours. I am a VBA Developer with extensive experience in task automation in Excel. I can quickly and easily deliver the results you need. P More

$250 CAD in 2 days
(21 Reviews)
4.7