We need an Excel product upload file to be completed – 131 items, most with parent/child. Attention to detail is very important. Emphasis must be placed on entering the correct style keywords and image URLs in correct order. Accuracy is more important than quick completion. Extra images need to be collected for us (see ‘Image URLs'.)
Payment to be made by Paypal after we have checked file for errors.
Please refer to attached sample file for file format. The first three items have been completed. Any questions, please ask before bidding.
Thanks to all!
Entries need to be made to the following columns:
New rows must be created for child items. The child SKUs will be the same as the parent SKUs but suffixed with the letter B, C, T, (Black, Café, Tan) or other letter to denote the item color.
Enter item SKU into search field of manufacturer website then cut and paste item description into file. At end of each description, cut and past the dimensions (adding " to denote inches) and manufacturer name. For example: Measures 6" x 9" 14". By Johnson.
Select the correct value from the following: Bag, Accessory, HomeAccessory, NonApparelMisc.
Color: Cut and paste from manufacturer website. For example: Azure Blue.
Most are ‘Leather'. Some are ‘Canvas', ‘Leather'.
Select the correct values in order of relevance from the following: womens, unisex-adult, mens. For example, a rolling luggage item will be unisex-adult unless specifically designed for a woman.
Select as many correct relevant entries as possible from the Merchant Classification Guide list and enter in order of relevance. We will provide the list.
Parent-child, parent-sku, relationship-type:
Many items are available in several colors. Child items must be created from the parent items. The fields ‘color', material-fabric, ‘parent-sku', ‘relationship-type' and imageURL are blank for parent rows.
Most image URLs may be found on our server. For each product, please check manufacturer's website for any additional images and enter their names into the URL field of the file.
Any images not listed at the above location, please right click, save to a file and send to us.
Image URLs must be correctly entered corresponding to the color of the related item. For example, a tan colored item will have the tan picture #1, #2 etc... When a product has a group shot, this must be entered in all the last image fields for the related product.