Database Upload, Excel, and CSV

I've seen this come up many times, especially with people new to Yahoo! Store. They try to use the database upload function to load products into the store, and get a bunch of error messages after the upload complaining about missing fields, invalid characters, etc. The problem most likely is that they are trying to upload the actual Excel (XLS) file, not a CSV file.

So before you try to upload your spreadsheet, first make a copy of it as a CSV file. This is one of the file type formats when you select File > Save As in Excel. Then, upload the CSV copy, not the original Excel file.

Here is some more info on the database upload feature for Yahoo! Store.

Comments

Catalog Request

You may have noticed that both the Catalog Request and Catalog Request Confirmation pages are now customizable through Checkout Manager. If you have already customized your Checkout Manager pages (or had someone customize them for you), and would like to have the same custom look applied to your Catalog Request and Catalog Request Confirmation forms, all you have to do is this: Go into Checkout Manager, click Page Configuration and then look at how your Shipping, Billing, Review, etc. pages are set up; in particular, check if you have the Top Navigation and Left Navigation enabled. Click over to the Catalog Request tab, and make sure you have the same settings next to Top Navigation and Left Navigation. Don't forget to hit Save or Save & Preview , otherwise your changes will be lost. Click over to the Catalog Request Confirmation tab and there too, make sure you have the same settings next to Top Navigation and Left Navigation (so if those are enabled on your other checkout p

CPR for a Yahoo Store on Google's Supplemental Index

Recently a client of mine came to me and said that most of his store pages disappeared from Google, and he did not do anything to make this happen. I was a bit skeptical, so I went to Google, did a search on his store, and sure enough, there were only two pages indexed, his home page and his site map (ind.html) page. The rest were in the supplemental results, which means that Google thought the rest of the pages were not much different than these two pages. When I looked at the supplemental results, the little excerpts under each link were exactly the same, and I also noticed that what Google showed under each result was actually text from the ALT tags of the header image. I looked at some of these pages in my client's store, and they were actually different. This was a bit puzzling, but then I thought perhaps Google saw that the header and left navigation was the same throughout the site (which is pretty normal), but that the text that made each page different was too far down ins

Auto-update Copyright Year

This is one of those minor, recurring questions I'm always asked (each year): to update the copyright year in sites. Whether this is the "right thing" to do or not I don't know, but here is how you can make it automatic: First, go to the Variables page (these instructions are for Yahoo! Stores), and do a search for the word "copyright" or the year that's currently displayed next to your copyright message. If you can't find it there, chances are you have a custom template and the copyright message might be coming from some place else. In that case, you'll have to track it down, but because custom templates can be set up in any which way, unfortunately you'll be on your own. Assuming you found it, replace the year with this JavaScript code: <script>document.write(new Date().getFullYear())</script> Hit Update and you should be all set!

Search This Blog