Creating NetSuite Custom Fields for eBay Categories
eBay requires a main Category field, and optionally also allows a Store Category to be set. The values for both must be posted to eBay as numeric Category IDs. Unless you have only one or two categories, these must be read from a field in NetSuite.
Category Field Setup
There is a standard eBay category rule in FarApp that is designed to read from NetSuite fields set up to the following standard, which we’ve found to be the best practice for eBay category selection. Please create the necessary custom field(s) in NetSuite to accommodate the categories you need.
Create a Select Value custom item field in NetSuite. You should name it something like “eBay Category” and give it a meaningful ID (e.g., ebay_category). Create a list for this field. There are over 25,000 eBay categories, but most sellers only use a dozen or fewer categories. In the list, you should put both the Category Name (so you will recognize it when making a selection) and the Category ID (an integer number that FarApp needs to post to eBay), separated by a colon. An example of one such list is:
Western Style Handbags : 954402010
Fashion Handbags : 879483010
Betty Boop Bags & Wallets : 879486010
Wallets/Frame Wallets : 879487010
Evening Bag/Purse/Clutch : 880369010
The same format can be used for Store Category fields (just be sure to note that store categories, and their IDs, are different than the eBay categories; the field format should be the same, but the field values are not).
You can find eBay category IDs through three methods:
I Sold What? has a current list of eBay categories. To find a leaf category, you’ll need to expand a particular category until you can’t expand it anymore and the category ID has “(leaf)” to its right.
If you go to ebay.com you can browse for a particular category and the category ID shows in the URL. So for example, if you browse for “Cell Phone Accessories”, this is the URL: http://www.ebay.com/sch/Cell-Phone-Accessories-/9394/i.html
So the category ID is 9394. However, this isn’t a leaf category so you’re not allowed to list items here. You have to select one of the children categories until there are no more children categories. So if you select “Chargers & Cradles” on the left, you’ll see that there are no more children categories so this is a leaf category and the URL is now: http://www.ebay.com/sch/Chargers-Cradles-/123417/i.html
So the leaf category ID you would use to list in this category would be 123417.
- FarApp has a list of available eBay categories (though it is not totally current). To view the list, log in to FarApp, select Manage Account, and then select eBay Dashboard. Select the eBay Categories tab, and you’ll see the available categories. You can use the Find button to search for categories of interest. Note that some categories are not “Listable.” This means that you cannot use those category IDs to post to eBay – they are parent categories, and only children categories are valid.
You can find your eBay store category IDs using this method:
- Log into eBay and click the Manage My Shop link from within My eBay (on the left). You can then click Shop Categories, where you will see a list of your Shop Categories. If you scroll down and click All Categories at the bottom right, it will show you a list of all of your categories and sub-categories, and their associated category number. Remember you can only list in LEAF categories ( category that has no child categories).