Power BI Connector for eBay

Build 21.0.7930

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930