Skip to main content

Adding custom Yahoo Store fields - Catalog Manager vs. Store Editor

In a non-legacy Yahoo Store, there are two ways to add custom fields: through Catalog Manager under "Manage my Tables" and through the Store Editor, under "Types" (the Store Editor's "Types" are essentially the same as Catalog Manager's "Tables".) Whether you add custom fields from Catalog Manager or from the Store Editor does make a difference as each has its advantages as well as disadvantages.

Catalog Manager

To me the main advantages of using Catalog Manager to add custom fields are:

1) You can add multiple fields quicker
2) You can later change the field's name and even type
3) You can delete the field if you no longer need it.
4) All the fields that are available in Catalog Manager are included in the data.csv file if you download your catalog.
5) All the fields that are available in Catalog Manager are also included in the catalog.xml datafeed file, which is used by the comparison shopping engines, for example. (See the Search Engines settings in your Store Manager page.)

However, Catalog Manager has its limitations when it comes to custom fields.

1) There are certain field types that are considered to be "editor only". These are references, symbol, color, ids, font, objects, references, and orderable. Because these field types are editor only, any field with these field types is invisible to Catalog Manager, which means you cannot add a custom field using any of these fields types, nor can you access any field (from Catalog Manager) that has one of these types. Furthermore, since these types are not seen by Catalog Manager, if you download your catalog, none of these types of fields are in the downloaded CSV file.

2) There is a limit as to how many custom fields you can add, depending on what Merchant Solutions package you have subscribed to. In Merchant Starter, you can have a total of 50 fields in Catalog Manager. In Merchant Standard, you can have 80, and in Merchant Professional, 100.

Store Editor

Everything I listed as an advantage of Catalog Manager is a shortcoming of the Editor, and everything that's a limitation in Catalog Manager is an advantage of the Editor.

1) If you find yourself the need to add editor-only fields, your only option is the Store Editor's "Types".
2) Fields that you add in the Store Editor, unless you check the box that you want the field to be available in Catalog Manager, are not counted toward the maximum allowed custom fields limit.
3) You can exceed the maximum number of fields even if you check the box that you want your field to be available in Catalog Manager, however, if you do this, you will not be able to make changes to the existing fields in Catalog Manager until you delete the excess fields.

Which method you use is up to you and the particular task you are trying to solve with your custom field. If you are adding a field that you are sure you won't ever need to change or delete, you won't need it to be included in the downloaded data.csv file in Catalog Manager, or the catalog.xml datafeed file, use the Store Editor. If the field you are adding is an editor-only field, you have no choice but to use the Store Editor to add it. If on the other hand, you may at some point want to delete the field, or the field needs to be included in the download or in the catalog.xml file, use Catalog Manager to add it.

Comments

Unknown said…
I can add a field to my default-table, but how do I get the custom field to display on the items page?
You need to modify your templates to do this, but how or where you display your custom fields depends on your circumstances and your templates so I can't tell you where to put it or what templates to change to make it happen.

Popular posts from this blog

Pre-Season Checkup

With the holiday shopping season fast approaching it's a good idea to do a general checkup on your store to be sure it's ready for prime time. Below are a few things you would want to check, along with a few add-ons that are not too major in scope, but which are often neglected and give you an edge over your competition. Can you Search and Order? Every time we do anything major in a store we test two things: whether searching and adding to cart/ordering works. You can have nice, flashy pictures, cool animation effects, a very quick loading site, anything, but if the store search is broken or you can't add to the cart or can't check out then an ecommerce site is worth nothing. Can you Order? Chances are if your checkout was completely broken you'd know about it by now, but it doesn't have to be totally broken in order to scare away potential customers. So go ahead, go to your site and first do a search and make sure it works. Then, add one or more products

How to create clean and efficient CSS

In a typical workday, I deal with dozens of yahoo stores and very often I have to tweak, fix, or change CSS used by these stores. While some stores have very clean and easy to follow style sheets or CSS definitions, the vast majority of stores I've seen seem to include complete hack jobs, style sheets put together completely haphazardly, or as an afterthought. While working in such a store, the idea came to me to turn my gripes into a post. So the following is my list of dos and don'ts of good CSS or style design. 1. Externalize your style sheets. This means to save your style sheets into one or more css files, and link to them using the <link rel="stylesheet" type="text/css" href="/lib/yourstoreid/yourstyle.css"> notation, or in Editor V3.0, you can use the LINK operator. 2. Combine your style sheets into as few files as possible. Nothing worse than trying to wade through 6, 8, 10 or more different style sheets to find the color of a

What is product-url anyway?

I keep having to field questions about the product-url field, and since it came up yesterday, I figured I'd try to clear up all the confusion about it. So the name product-url suggests that whatever you type in there will become the URL of that product. Unfortunately, this is not the case, or rather, not in the intuitive way. The URL you enter there will be used as the URL for that product in Yahoo Shopping, on the built-in search results page, and on the shopping cart page, however, the URL you type in there DOES NOT actually change the physical URL of the page. What is the URL of a page in a Yahoo Store? In any Yahoo Store built in the store editor, the URL of a page is the store's domain name and the page ID + .html. For example, in my store at www.ytimes.info, I have a page whose id is rtml101, thehrefore, the URL of that page is http://www.ytimes.info/rtml101.html . Why would you want to change the URL? For SEO reasons, it is believed to be better to have a URL tha