CategoryFeatures
Query the settings supported by eBay Categories.
Table Specific Information
Select
The only columns supported for filtering are CategoryId, LevelLimit, AllFeaturesForCategory, and FeatureId. If no CategoryId is specified , all features for top level categories will be returned.
SELECT * FROM CategoryFeatures WHERE LevelLimit = '2' AND CategoryId = '277'
Columns
| Name | Type | Description |
| CategoryId | String | The unique identifier of the category that the setting belongs to. |
| BestOfferAutoAcceptEnabled | Boolean | Indicates whether the category supports the Best Offer Automatic Accept feature for fixed-price listings. |
| BestOfferAutoDeclineEnabled | Boolean | Indicates whether the category supports the Best Offer Auto Decline feature. |
| BestOfferCounterEnabled | Boolean | Indicates whether the category supports sellers offering a counter offer against the Best Offer from a buyer, or a buyer offering a counter offer against the counter offer of the seller. This field is only applicable to fixed-price listings. |
| BestOfferEnabled | Boolean | Indicates whether the category supports the Best Offer feature for fixed-price listings. |
| BrandMPNIdentifierEnabled | Boolean | Indicates whether the category supports the capability to identify a product using the brand/manufacturer part number combination. |
| ConditionEnabled | String | Indicates whether the category supports (or requires) conditions to be specified. |
| ConditionValuesAggregate | String | The valid condition Ids for this category. |
| EANEnabled | String | Indicates whether or not European Article Numbers (EANs) can be used to help create a listing. |
| FreeGalleryPlusEnabled | Boolean | Indicates whether the category supports free, automatic upgrades for Gallery Plus, which enhances pictures in search results. |
| FreePicturePackEnabled | Boolean | Indicates whether the category supports free, automatic upgrades for Picture Pack, a discount package that includes super-sizing of pictures. |
| GlobalShippingEnabled | Boolean | Specifies whether or not the corresponding category supports the Global Shipping Program (GSP). |
| Group1MaxFlatShippingCost | Double | Returns the applicable max. cap per shipping cost for shipping service group 1. |
| Group2MaxFlatShippingCost | Double | Returns the applicable max. cap per shipping cost for shipping service group 2. |
| Group3MaxFlatShippingCost | Double | Returns the applicable max. cap per shipping cost for shipping service group 3. |
| HandlingTimeEnabled | Boolean | If false, listings in this category require a handling time when flat or calculated shipping is specified. A handling time is not required for local pickup or for freight shipping. see DispatchTimeMax in AddItem. |
| HomePageFeaturedEnabled | Boolean | Indicates whether or not it is possible to enhance a listing by putting it into a rotation for display on a special area of the eBay home page. Support for this feature varies by site. Item or feedback restrictions may apply. |
| INEscrowWorkflowTimeline | String | Indicates the escrow workflow version that applies to the category on the India site: Default Workflow, Workflow A, or Workflow B. |
| ISBNEnabled | String | Indicates whether or not International Standard Book Numbers (ISBNs) can be used to help create a listing. |
| ItemCompatibilityEnabled | String | Indicates whether the category supports parts compatibility by application (ByApplication), by specification (BySpecification), or not at all (Disabled). |
| ItemSpecificsEnabled | String | Indicates whether the category supports custom Item Specifics. |
| ListingDurations | String | The listing types and listing durations in days that are supported for the category. |
| MaxFlatShippingCost | Double | The maximum cost the seller can charge for the first domestic flat rate shipping service. The total shipping cost is the base flat rate shipping cost plus the cost of insurance, if insurance is required. Mutually exclusive with GroupNMaxFlatShippingCost. |
| MaxGranularFitmentCount | Integer | Indicates the maximum fitment count. |
| MaxItemCompatibility | Integer | Specifies the maximum number of parts compatibilities. |
| MinimumReservePrice | Double | Indicates whether a Minimum Reserve Price is enabled for this category. On the Germany, Austria, Belgium French, and Belgium Dutch sites, Minimum Reserve Price is supported for the Art and Antiques, Watches and Jewelry, and Motorbikes categories. |
| MinItemCompatibility | Integer | This field specifies the minimum number of parts compatibilities for listing items. |
| NonSubscription | String | The value in this field indicates whether the category supports Motors Local Market listings if the seller does not have a vehicle subscription. |
| PaisaPayFullEscrowEnabled | Boolean | Indicates whether the category supports the PaisaPayEscrow payment method. This feature is only applicable to the India site. |
| PaymentMethods | String | Indicates the acceptable payment methods that can be used when adding, revising, or relisting an item in the corresponding category. |
| PaymentProfileCategoryGroup | String | Indicates the Business Policies category group that can be used for Payment profiles. Only returned when this value (or the setting of this category) overrides the value inherited from the parent category. |
| PayPalBuyerProtectionEnabled | Boolean | Whether then buyer protection is allowed for this category. |
| PayPalRequired | Boolean | Indicates whether the category requires PayPal as a payment method. |
| PickupDropOffEnabled | Boolean | A true value in this field indicates that items listed in the category can be enabled with the Click and Collect feature. With the Click and Collect feature, a buyer can purchase certain items on eBay and collect them at a local store. Buyers are notified by eBay once their items are available. |
| PremiumSubscription | String | The value in this field indicates whether the category supports Motors Local Market listings if the seller has a Premium vehicle subscription. |
| ProductCreationEnabled | String | Indicates whether a category supports (or requires) product creation in listings. Use this to determine whether it is mandatory to specify the product Id when adding, revising, or relisting. |
| ProPackEnabled | Boolean | Indicates whether the category supports the Pro Pack Bundle listing upgrade. |
| ReturnPolicyEnabled | Boolean | Only returned when this value (or the setting of this category) overrides the value inherited from the parent of the category. |
| ReturnPolicyProfileCategoryGroup | String | Indicates the Business Policies category group that can be used for Return Policy profiles. Only returned when this value (or the setting of this category) overrides the value inherited from the parent of the category. |
| RevisePriceAllowed | Boolean | Indicates if the category allows the seller to revise the price of a fixed-price listing. |
| ReviseQuantityAllowed | Boolean | Indicates if the category allows the seller to revise the quantity of a multiquantity, active listing. |
| SafePaymentRequired | Boolean | Indicates whether listings in this category need to have a safe payment method. |
| SellerContactDetailsEnabled | Boolean | Indicates whether this category supports seller-level contact information for Classified Ad listings. |
| SellerProvidedTitleSupported | Boolean | This boolean field indicates whether a category supports Seller Provided Titles in listings. |
| ShippingProfileCategoryGroup | String | Indicates the Business Policies category group that can be used for Shipping profiles. Only returned when this value (or the setting of this category) overrides the value inherited from the parent of the category. |
| ShippingTermsRequired | Boolean | Indicates whether the category requires sellers to specify shipping details at listing time. |
| SpecialitySubscription | String | The value in this field indicates whether the category supports Motors Local Market listings if the seller has a Specialty vehicle subscription. |
| ListingDurationsAggregate | String | Provides additional listings durations that are available to eBay Store owners. The extended listing durations provided here in this element should be merged in with the baseline listing durations provided in the ListingDurations column. Applies to fixed-price Listings. |
| TransactionConfirmationRequestEnabled | Boolean | Defines if transaction confirmation requests are enabled in a given category. |
| UPCEnabled | String | Indicates whether or not Universal Product Codes (UPCs) can be used to help create a listing. |
| UserConsentRequired | Boolean | Indicates whether a bidder must consent to the bid by confirming that he or she read and agrees to the terms in the privacy policy of eBay. |
| ValueCategory | Boolean | Some eBay sites may select a few categories and designate them as value categories. These are typically selected from categories where buyers can find great deals. This designation can change over time. |
| ValuePackEnabled | Boolean | Indicates whether the category supports the Value Pack bundle listing upgrade. |
| VariationsEnabled | Boolean | If true, you can create multiple-variation listings when you list a fixed-price item in this category. |
| VINSupported | Boolean | Indicates if the category supports the use of the VIN (Vehicle Identification Number) field to identify a motor vehicle and create a listing. VINs are supported on the US, Canada, Canada-French, and Australia sites. |
| VRMSupported | Boolean | Indicates if the category supports the use of the VRM (Vehicle Registration Mark) field to identify a motor vehicle and create a listing. VRMs are only supported on the UK site. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AllFeaturesForCategory | String | Use this switch to view all of the feature settings for a specific category. All feature settings are returned, regardless of the site default settings. This element works in conjunction with CategoryId--refer to the notes for that element for more details. If you also set FeatureId, eBay returns the status of the specified features only for the specified category. Default: false. |
| FeatureId | String | Use this field if you want to know if specific features are enabled at the site or root category level. Multiple FeatureId elements can be used in the request. |
| LevelLimit | String | A level of depth in the category hierarchy. Retrieves all category nodes with a CategoryLevel less than or equal to the LevelLimit value. The root category is 0.
The allowed values are 1. |
| ViewAllNodes | String | If set, eBay returns the site defaults along with all the categories that override the feature settings they inherit. That is, this column contains only the features that the category has overridden from its parent category. |
| DetailLevel | String | Detail levels are instructions that define subsets of data to return for particular tables. Possible values: ItemReturnAttributes, ItemReturnCategories, ItemReturnDescription, ReturnAll, ReturnHeaders, ReturnMessages, and ReturnSummary. |