Create Color Sample Swatches for our Website

We want to add color samples to our products, so customers can see a little square of color when they order a wig.

To do this we need to name the color sample pictures correctly, and upload them.

I attached the excel spreadsheet with colors, and for the bidder will send a rar file with two folders with color samples for two of our brands. I’ll also provide links to our color chart pages in case you need to verify what color goes to what file. In the excel spreadsheet, we have all colors for productcodes beginning with H1_ (Harlem 125 brand), and for Productcodes beginning with CR_ (Carefree brand).

To create color swatches we have to create 3 pictures for each color for each product.

The columns you well need to use are A (ID), C(optiondesc), and H(applytoproductcodes)

The color names are in the C(optiondesc), column in spreadsheet. The productcodes are in the H(applytoproductcodes). The color samples are in the two folders in the Rar file. The cr_files folder has color samples for Carefree products beginning with “CR_”, the h1_files are samples for the Harlem products, productcodes starting with “H1_”.

The Carefree(“CR_”) color samples need to be cropped and made into separate color photos for each color. Such as [url removed, login to view] and 1B.jpg. The Harlem(“H1_”) already have separate photos for each color.

To create the color swatches you need to use the information in excel. So for each productcode in the H(applytoproductcodes) column (multiple productcodes are separated by commas), we need to create 3 photos named like this.

In row 2 of [url removed, login to view] color name (optiondesc) is “1”, so you would need to crop the 1 color sample from (CR_files), and can name it 1.jpg.

Then for each productcode that has that color create a 3 copies:

[url removed, login to view] (full size)

[url removed, login to view] (full size)

[url removed, login to view] (50x50 pixels)

30729 is the number the A(ID) column, CR_12BobDS is the first product code in H2 cell.

The pictures for the next productcode in H2 cell would be;

[url removed, login to view] (full size)

[url removed, login to view] (full size)

[url removed, login to view] (50x50 pixels)

If there is not a color sample for a color, just skip it, not all colors have color samples.

I am thinking the quickest way to do this would be to use Excel to create a .bat file that copied renamed all the color samples for you. Do you know how to make Windows .bat files? They use command line commands like copy and rename, so I think you could add commands to each row in excel, then paste the whole thing in an .bat and run it to have it copy and rename all the color photos. Or maybe you know a better way.

Also don’t create photos for any row that has “11” in the B(optioncatid) column. Those don’t need swatches.

While you’re add it please add descriptions to the colors for “H1_” productcodes. Our color chart for H1_ has names for each color, So color every color 1 in the C(optiondesc) column can be replaced with “1- Black” which is on that color chart page. “2’ can be replaced with “2 – Very Dark Brown”, ect.

You can also check that page to double check what the color file is named. They should match colors in optiondesc column, but have “/” replaced with “_’, but there might be a few inconsistences.

The CR_ color chart has the colors all joined in 4 big photos, you’ll have to crop each color and save it as separate file. Like [url removed, login to view], [url removed, login to view], [url removed, login to view], ect.

The little swatches ending in “-S” like “[url removed, login to view]” should all be shrunk to 50x50 pixels. The other two versions can stay original size.

Skills: Data Entry, Excel, Photo Editing

See more: color swatches excel, color swatches jpg files, we need brand name, want to create a chart, how to make copy of website, how to make a chart, how to create pages, excel command line, double data entry excel, create products, create on page for products, create a chart, command line excel, colors for website, black names, excel color samples, swatches photos rar, color chart, upload color samples website, swatches excel

About the Employer:
( 120 reviews ) Ashland, United States

Project ID: #909159

Awarded to:


Ready to finish.

$50 USD in 1 day
(99 Reviews)

11 freelancers are bidding on average $87 for this job



$30 USD in 1 day
(238 Reviews)

Interested, please check PM. Thanks

$50 USD in 7 days
(22 Reviews)

Please view the PMB

$160 USD in 7 days
(13 Reviews)

Ready to work on this project immediately. Please see PM.

$70 USD in 1 day
(3 Reviews)

good day! i am internet marketer graduate.. pls chck pm for info's and examples.. TY

$30 USD in 1 day
(0 Reviews)

Hi, I saw the job opening and I find it interesting. I worked as an executive assistant in one of Lace Wig Store online. I have knowledge on SEO job and been a Data Entry Specialist for a year. I have experience worki More

$250 USD in 30 days
(0 Reviews)

Thank you very much for your opportunity.I'll promised to you do my duty very best.

$150 USD in 5 days
(0 Reviews)

Please check the PMB.

$85 USD in 4 days
(1 Review)

Hi I am interested in this project please give me your project details .my services are so fast and i deliver your work as soon as possible Thanks......

$30 USD in 2 days
(0 Reviews)

Hello Sir, I can do this job for you. Please check PM. Thank you

$50 USD in 1 day
(0 Reviews)