JDBC Driver for eBay

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462