Excel Data Entry from Website.

We want only “Wigs” and “Costumes” from this wholesale page for our retail website: [url removed, login to view] Each category has multiple pages of products. Wigs with the same name such as Vegas Wig are the same product with different colors and only count as one product, and only one picture is needed.

[url removed, login to view]

ProductCode: All Products begin with FA_ and this brand has product numbers such as 24823, so that would be FA_24823 if it has a number like 21043-07 don’t include the “-07” just d FA_21043.

ProductName: Wig or Custome Name from site. Such as Smoky Eyes Wig, or Mod Flight Attendant.


Wigs: Start with product name, Smoky Eyes Wig, If wig has only one color say color shown as “Color” (see samples).

If a description is included use that too. Don’t include product#’s

Costumes: Star with product name, then get the description such as “ Includes Dress, Cap & Gloves

Sizes Available - S, M, L & XL”


Wigs: All wigs used 9,158, some wigs may also use the following numbers:

Long Showgirls (75)

Movies, TV, Cartoons, & Anime (77)

Early 1900's & Colonial (72)

Celebrities & Presidents (76)

Party Styles & Clowns (73)

Braids, Dreds, Asian & Indian (10)

Santa (78)

Separate each number by a comma, for example a celibrity wig would be 9,158,76


All costumes use 154, plus one of the numbers:

Women's Costumes (157)

Teen & Kids Costumes (156)

Men's Costumes (153)

So a women’s costume would be 154,157

Other columns are all the same as in samples..

[url removed, login to view]

This file is where you put the wig or costume colors and sizes.

Some wigs have multiple colors each with their own picture. There’s one called Vegas Wig shown twice for example, one says 21043-07 Natural Red, one says Black and 21043-01.. These should be just one productcode called FA_21043 like in samples.

Most costumes don’t have colors, but many have sizes such as S,M, L, XL or Standard and X-Large.

Optionsdesc: Put the color or size name here such as S, or X-Large

Below the sizes put “Select Size”

Below the colors put “Select Color”

OptionCatID: Put 5 next to sizes, put 64 next to colors.

Pricediff: Always “0” (zero)

Applytoproductcodes: Put the productcode from the other file for the wig you got the colors from, if you got the colors from “FA_24823”, put FA_24823.

Photos: Use productcode + “-2” at the end, like in last project, one picture from each product is enough. Saving them as gif is fine.

Taidot: Excel

Näytä lisää: www excel, wigs for kids, we excel, website for cartoons, website com for kids, tv eyes, red black data, photos to cartoons, gif sizes, get entry, fine products, entry com, data entry teen, cartoons from photos, black and, excel wig, party wigs xls, mod x, indian cartoons, data entry from website to excel, cartoons website, xl, Wigs, wig, Vegas

Tietoa työnantajasta:
( 120 arvostelua ) Ashland, United States

Projektin tunnus: #406482

Myönnetty käyttäjälle:


I will try to my best.

$195 USD 2 päivässä
(160 Arvostelua)