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. |