ReturnPolicies
Retrieves all the return policies configured for the marketplace you specify using the MarketplaceId query parameter.
Select
MarketplaceId is required filter in the Select query. You can follow the query below to obtain the required values through SQL:
SELECT * FROM ReturnPolicies WHERE MarketplaceId='EBAY_US'
Some of the fields are named with the suffix Aggr. These fields display the content of the JSON tag with the same name that is returned from the API endpoint.
Columns
| Name | Type | Description |
| ReturnPolicyId [KEY] | String | A unique eBay-assigned ID for this policy. |
| Description | String | The seller-defined description of the return policy for internal use (this value is not displayed to end users). |
| Name | String | The category type to which the policy applies (motor vehicles or non-motor vehicles). |
| CategoryTypesName | String | The category type to which the policy applies (motor vehicles or non-motor vehicles). |
| MarketplaceId | String | The ID of the eBay marketplace to which this return policy applies. |
| ExtendedHolidayReturnsOffered | String | If set to true, the seller offers an Extended Holiday Returns policy for their listings. |
| InternationalOverrideAggr | String | If populated, specifies the seller's policies for international returns (items that require postage via an international shipping service). |
| RefundMethod | String | Indicates the method the seller uses to compensate the buyer for returned items. The return method specified applies only to remorse returns. |
| RestockingFeePercentage | String | For sellers who accept returns, this field is filled if they charge buyers a restocking fee when items are returned. |
| ReturnInstructions | String | Contains the seller's detailed explanation for their return policy and is displayed in the Return Policy section of the View Item page. |
| ReturnMethod | String | Valid in the US marketplace only, this optional field indicates additional services (other than money-back) that sellers can offer buyers for remorse returns. |
| ReturnPeriodValue | String | Specifies the amount of time the buyer has to return an item. |
| ReturnPeriodUnit | String | Specifies the unit of measure of amount of time the buyer has to return an item. |
| ReturnsAccepted | Boolean | If set to true, the seller accepts returns. |
| ReturnShippingCostPayer | String | This field indicates who is responsible for paying for the shipping charges for returned items. The field can be set to either BUYER or SELLER. |