WARNING!!!! NEVER CLICK REBUILD.ALWAYS CLICK ADD AFTER UPLOADING A FILE TO YOUR STORE! Clicking REBUILD can delete items and sections of your store.

Here is the basic information that you will need to put your products into your store using a database upload. We have created a database upload template for you to use. You can download it here:

Database Upload Information

Path:
The path is the section that you want your item placed in. For instance, if you wanted a section called Shirts the path would be Shirts. If you wanted to have a sub category like men, the path would be Shirts:Men If you are creating a new store or new sections, you can use the name of the new section in the Path field. If the section where you want products to go to already exsists, use the ID of the page that you will be placing the items into.

ID:
This is the url of the actual page, the part that comes before .html
For example, the ID of this page http://www.mlwdesign.com/comparison-chart.html would be comparison-chart. When building a product database, the ID does not have to be filled in but it is beneficial to do so for search engine optimization. If you had a product called mans shirt the id would be mans-shirt as you are not allowed to have spaces in your url or other characters except for numbers and letters. If you do leave this field blank, Yahoo will come up with the id of the page and quite often they are abbreviated. For instance Gift Certificates is turned into gice.html. It would be best if the url ended with gift-certificates.html, these are actual keywords in the url.

Name:
This is a name of the product that you are selling.

Headline:
This is not a required field. However, if you have a longer name of the item you would want to use, you will use the headline field. For example: You have a Blue Hawaiian Mens Shirt and it is located in the Mens Shirts Category. On the section page you might want the product Name to say: Blue Hawaiian Shirt (since they are already in the Men Shirts Category) But the Headline you want to be more detailed and keyword rich for search engine optimization. So the headline would read: Blue Hawaiian Mens Shirt

Caption:
This is where you will put the item description. Also known as the sales pitch. Example: This Hawaiian shirt is made with etc etc etc etc

Options:
This is where you will put information on the different sizes or colors available.
Color Blue Red “Light Blue” Notice light blue is in quotes. This is so Yahoo knows it is one word and not two. If you did not have the quotes are light blue, it would think that light is one color option and blue is a second option.

Price:
Do not use $ sign.

Sale-price:
Do not put $ sign.

IMAGES:
In order to do a bulk image upload, all image names must match the ID of the product. So for mens-shirts the image name will be mens-shirts.jpg or mens-shirts.gif

Once all images are done this way, zip all of them together. Then click on Config in your store editor. Then click on Multiple Image Upload. Then click on browse to locate the zip file and upload. If you have a lot of products this will take some time for Yahoo to unzip your file and place all the images on the item pages matching them together.

More information on Database Uploads can be found at:

http://help.yahoo.com/l/us/yahoo/smallbusiness/store/edit/advanced/advanced-38.html

Please feel free to contact me should you have any questions.

For more information call Michal at 917-301-2584