ODBC Driver for eBay

Build 20.0.7587

ShippingServices

Query Shipping Services supported by the specified eBay site.

Table Specific Information

Select

The following query retrieves all available Shipping Services. There are no supported filters for this view.

SELECT * FROM ShippingServices

Columns

Name Type Description
ShippingServiceId [KEY] Integer Numeric identifier. A value greater than 50000 represents an international shipping service.
CODService Boolean This flag is returned as true if the corresponding ShippingService value is a COD (Cash-On-Delivery) service.
CostGroupFlat Boolean If returned, this is the shipping service group to which the shipping service belongs.
Description String A user-friendly description of shipping service options.
DetailVersion String Returns the latest version number for this field.
DimensionsRequired Boolean Whether the shipping service option requires that package dimensions are provided by the seller.
ExpeditedService Boolean Indicates whether the shipping service is an expedited shipping service. Only returned for sites for which the Get It Fast feature is enabled and only if true.
InternationalService Boolean Indicates whether the shipping service is an international shipping service.
MappedToShippingServiceId Integer The Id of another shipping service that will be used when a shipping service is deprecated.
ShippingCategory String Indicates the shipping category. Shipping categories include the following: ECONOMY, STANDARD, EXPEDITED, ONE_DAY, PICKUP, OTHER, and NONE. International shipping services are generally grouped into the NONE category.
ShippingService String The name of the shipping service option. If the ValidForSellingFlow column is not true, this particular shipping service option is no longer valid and cannot be offered to buyers through a listing.
ShippingTimeMax Integer The maximum guaranteed number of days the shipping carrier will take to ship an item (not including the time it takes the seller to deliver the item to the shipping carrier). Always returned when ExpeditedService is true or if defined for a particular service.
ShippingTimeMin Integer The minimum guaranteed number of days the shipping carrier will take to ship an item (not including the time it takes the seller to deliver the item to the shipping carrier). Always returned when ExpeditedService is true or if defined for a particular service.
SurchargeApplicable Boolean True if a surcharge applies for any region that this service ships to.
UpdateTime Datetime Gives the time in GMT that the feature flags for the details were last updated.
ValidForSellingFlow Boolean If this field is returned as true, the shipping service option can be used. If this field is returned as false, the shipping service option is not currently supported.
WeightRequired Boolean If true, a seller who selects this package type for the listing and then offers this shipping service must specify WeightMajor and WeightMinor in the item definition. If not returned, WeightRequired is false.

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
DetailName String A designation of what kind of information you wish returned for the specified eBay site.

The allowed values are ShippingServiceDetails.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587