First, I make sure I can EXPORT my data!
Then I go to PROMOTE> Click
I log into the MANAGER at http://store.yahoo.com.
Click DONE.
NOTE: Please remember that anyone who knows your Yahoo account name can now download your entire site. Just something to think about. Take a look at this big ole file. It's HUGE. It's everything in your store: Items, sections, content, etc...
Click Enter your account name (or whatever you want the CSV called and URL Pick your DELIMITER, (I use COMMAS).
Pick which pages you want - Just Products or ALL. I choose all files because I want to see any files that are EXILED that I might have forgotten about…
I also DON'T STRIP html from description and caption because most often I am exporting my store's contents to REUPLOAD THEM after cleaning up the mess.
Click on PROCESS FILE. Think happy thoughts for both Dan the Sausageman who sponsors this page, as well as Matt who wrote the program. Saves me HOURS. Thanks, Dan. Thanks, Matt.
I create a NEW FOLDER on my desktop for the file and SAVE the MY-ACCOUNT-NAME.CSV file into this folder. When you open the file you see you have the FIELD NAMES:
Id, Code, Description, Url, Thumb, Picture, Weight, Orderable, Taxable, BasePrice, LocalizedBasePrice, PathId, PathUrl, Availability, & Caption. Id Code is the same unless you changed it. I delete this.
Description is the Yahoo! Store Url is the location of the published page. (See the ID.html at the end?)
Thumb is the url of the thumbnail on the Yahoo! Image Server.
Picture is the url of the thumbnail on the Yahoo! Image Server.
Weight is Orderable is whether or not it has an order button.
Taxable is the uploadable field BasePrice PathId PathUrl
Go get the XML file by going to http://207.21.197.239/ystore/ystoreexport.htm
I use Microsoft EXCEL. I got to FILE > OPEN and make sure to select the second dropdown menu of ALL FILES.
Availability is AVAILABILITY if you want to upload a unique availability.
Caption is the First thing to remember is that you lose To get SALE-PRICE, you can get the Product Summary File and match the IDs. Sort the EXCEL file by ORDERABLE and then by CODE. Then sort the Product Summary File by CODE and paste side by side in a SPREADSHEET.
Now you have PRICE AND SALE-PRICE. Now that you have all of the fields you want to export, start making your changes. Add new products. Move items into new sections. Change prices.
In the EXCEL spreadsheet Insert a new column. COPY and PASTE I then save this file as a CSV with a name like 300am.csv so I know when it was current and I place it in my UPLOAD directory.
EDIT>ADVANCED>INDEX>DATABASE UPLOAD
I now use Data Format:CSV. I believe Yahoo! discontinued Bar-Delimited (a.k.a. PIPES) in NOV 2000 much to my dismay, and that is when I learned about ITEMS WITH NO CODE. BEFORE YOU UPLOAD YOUR CSV FILE WARNING: REBUILD
Goto EDIT>ADVANCED>CONTROL> Experimental>Product Summary File
To get the options is a bit more tricky. Use EDIT ALL from the INDEX page. View Source which in EXPLORER opens the NOTEPAD. You actually have to PARSE out the HTML, but the ID is matched up in the same TAGS as the OPTIONS info.
REBUILD deletes all product images and section icons and replaces the data with just the information from your database.
Yahoo! Says: "Warning: Rebuilding your site will delete all existing items and add only the items you have uploaded. Are you sure you want to Rebuild your site? "
ADD simply adds new items and overwrites items with the same IDs.
It's the safest of DATABASE UPLOADS. The worst thing that can happen is that your overwrite good products with the new products.
Example: If you have a picture for item ID 1234 and you ADD a new product with 1234 to the site it will have the OLD photo as the ITEM IMAGE.
REVERT takes you back one generation if you REBUILT or ADDed, but only once. It's kind of like UNDO, but you only get ONE.
Databases uploads can save you hours upon hours of editing your Yahoo! Store. You can also build consistent looking pages that load faster and present more information. Even better, you can tweak your pages to be more search engine friendly to get your more traffic, more sales, and more money!
Be careful!
rob@ystore.com