Project Detail

Add 179 Products From Wholesale Website to Excel File  

Add 179 Products From Wholesale Website to Excel File is project number 481588
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: destiny2030

Budget: $30-250

Created: 08/03/2009 at 6:55 EDT

Bid Count: 4

Average Bid:
$ 68

08/08/2009 at 6:55 EDT

Project Creator: mlaridon
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (24 reviews)

Bid On This Project
 

Description

Bidder will gather 179 product details from wholesale website, and add them to excel file so I can upload them to our retail website. Bidder will also save pictures.


SL_Colors.xls:
I also attached SL_Colors.xls which has some colors as a sample. All colors should use OptionCatid
155 once with a “Select Color”, and OptionCatid 11 with a “None” as in sample. Also on wholesale site when you choose a color, it gives a number in the “In Stock” box if you choose a color and it says “0” don’t add that color because they don’t have any in stock. If “In Stock” is greater than “0” add the color.

Photos: Crop any photos so you don’t see the logos. Photos hould be cropped to remove logo. Name photos same as product code, if there is more than one photo add a “-2” or “-3” after it.

Sl_prod-volusion.xls

(I attached “screenshot.jpg” to try and make instructions more clear.
All products should begin with “SL_”.
ProductsDescription:
For any wigs should be “(Size) (Synthetic or Human Hair) wig by Sillouette. <br><a href=/v/vspfiles/charts/un.....html target=cc>Color Chart</a>”
Example: “Medium Human Hair Wig by Silhouette<br><a href=/v/vspfiles/charts/un.html target=cc>Color Chart</a>”
Or “Short Synthetic Wig by Silhouette<br><a href=/v/vspfiles/charts/un.html target=cc>Color Chart</a>”

For other products such as weaves, braids, and drawstrings you can us “(Synthetic or Human Hair) (product type) by Silhouette. <br><a href=/v/vspfiles/charts/un.html target=cc>Color Chart</a>”

Example “ Synthetic Weave by Silhouette. <br><a href=/v/vspfiles/charts/un.html target=cc>Color Chart</a>”
Or “Human Hair Drawstring by Silhouette. <br><a href=/v/vspfiles/charts/un.html target=cc>Color Chart</a>”

Productprice: Should subtract $1 from price then round up 99 cents.
Example: $15.00 = $14.99 or $152.50 = $151.99 or $75.75 = $74.99


CategoryIDs
A little confusing this time, just do your best, and ask me if it’s not clear.

Wigs: I think we have them all, but double check please:
Wigs that say “Synthetic”
Use CategoryID 159 (if Short) or 160 (if Medium) or 161 (if Long)

Wigs that say “Human Hair” or “Remy”
Use CategoryID 167 (if Short) or 166 (if Medium) or 165 (if Long)

Wigs that say “Lace Front” use 55 and one of the sizes above, depending on if they say human hair or synthetic.
Wigs that say “Mono or Monofilament” use 49 and one of the sizes above, depending on if they say human hair or synthetic.

Half Wigs:
No sizes for these.
Use 187 if they are “Synthetic”
Use 179 if they are “Human Hair”

Weave:
Use 189 if “Human Hair”
Use 188 if “Synthetic”

Braid:

Use 176 if “Human Hair” or 176,177 if they also say “Pony”
Use 182 if “Synthetic” or 182,184 if they also say “Pony”

Draw String:
Use 186 if “Synthetic”
Use 178 if “Human Hair”

Styling Video and Accessory
Just leave these CategoryIDs blank I will add them.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

105

1 day

08-03-2009 07:01 EDT

Ready for start work.

help

 

75

3 days

08-03-2009 07:35 EDT

This can be done using Excel VBA or VB.NET program. Please refer to PM.

help

 

40

2 days

08-03-2009 07:52 EDT

Hi, Please check your PM. Thanks Vishal

help

 

50

5 days

08-03-2009 07:29 EDT

Ready to start immediately,please check pm

help


    Bid on this Project