ODBC Driver for eBay

Build 20.0.7587

ItemTransactions

Query order line item (transaction) information for a specified listing. For auction listings, order line items are not created until the auction ends with a winning bidder, or if the Buy It Now feature is enabled for the listing and used by the buyer to purchase the item. For fixed-price listings, order line items are created after a buyer has committed to purchase the item(s).

Table Specific Information

Select

The ItemId column must be specified to retrieve transaction information.

Get all transactions related to a specific item:

SELECT * FROM ItemTransactions WHERE ItemId='012345678901'

Filter the number of transactions returned by specifying the number of days in the past:

SELECT * FROM ItemTransactions WHERE ItemId='012345678901' AND NumberOfDays='25'

Get information for a specific transaction that was made for a specific item:

SELECT * FROM ItemTransactions WHERE ItemId='012345678901' AND TransactionId='0'

Columns

Name Type Description
OrderLineItemId [KEY] String A unique identifier for an eBay order line item. This field is created as soon as there is a commitment to buy from the seller, and its value is based upon the concatenation of ItemId and TransactionId with a hyphen in between these two Ids.
TransactionId String The unique identifier for a transaction that was made for a specific item. If a TransactionId is provided, any specified time filter is ignored.
ItemId String Unique identifier for an eBay item listing.
HandlingCost Decimal The handling cost that the seller has charged for the order line item. This field is only returned after checkout is complete. The value of this field is returned as zero dollars (0.0) if the seller did not specify a handling cost for the listing.
ShippingCost Decimal The shipping cost paid by the buyer for the order line item. This field is only returned after checkout is complete.
AdjustmentAmount Decimal Adjustment amount entered by the buyer. A positive amount indicates the amount is an extra charge being paid to the seller by the buyer. A negative value indicates this amount is a credit given to the buyer by the seller.
AmountPaid Decimal The total amount the buyer paid for the order line item.
Currency String A standard 3-digit ISO 4217 currency code for currency used in countries around the world.
BestOfferSale Boolean Indicates whether or not the order line item was created as the result of the seller accepting a Best Offer from a buyer.
BuyerId String Unique eBay user Id for the user.
BuyerCheckoutMessage String This field is returned if a buyer left a comment for the seller during the checkout flow.
CreatedDate Datetime Indicates the creation time of the order line item.
DepositType String This value indicates whether or not the seller requires a deposit for the vehicle. This field is only applicable to U.S. eBay Motors listings. Otherwise, this field is returned as an empty value.
EBayPlusTransaction Boolean If true, this transaction is for an item that was purchased under the eBay Plus program.
ExtendedOrderId String A unique identifier for an eBay order.
FinalValueFee Decimal A Final Value Fee is calculated and charged to the account of a seller immediately upon creation of an order line item.
Gift Boolean This boolean field is returned as true if the seller is giving a digital gift card to another individual as a gift. This field is only applicable for digital gift card order line items.
GiftSummaryMessage String This free-form text contains the message that the purchaser of the digital gift card left for the recipient of the gift card.
IntangibleItem Boolean This flag indicates whether or not the order line item is an intangible good such as an MP3 track or a mobile phone ringtone. Intangible items are not eligible for the PayPal Seller Protection program, so the seller will not be able to open an Unpaid Item case against the buyer.
InvoiceSentTime Datetime This field indicates the date and time that an order invoice was sent from the seller to the buyer. This field is only returned if an invoice (containing the order line item) was sent to the buyer.
IsMultiLegShipping Boolean If IsMultilegShipping is true, the Global Shipping Program (GSP) will be used to ship the order line item to an international buyer.
LogisticsPlanType String This field will be returned only if the buyer purchased a digital gift card, which is delivered by email, or if the buyer purchased an item that is enabled with the Click and Collect feature.
PaidTime Datetime Indicates the time when the order was marked paid. This field is not returned until payment has been made by the buyer. This field will not be returned for orders where the buyer has received partial or full refunds.
PayPalEmailAddress String The PayPal email address of the seller. This field is only returned if the seller is the authenticated user.
QuantityPurchased Integer This value indicates the number of identical items purchased at the same time by the same buyer from one listing.
ProductName String The name of a Selling Manager product.
ShippedTime Datetime Indicates the time when the items associated with the order were marked as shipped. This value will only be visible to the user on either side of the order. An order can be marked as shipped in My eBay, Selling Manager Pro, or programmatically by the seller through the CompleteSale stored procedure.
ShippingConvenienceCharge Decimal The amount that the seller is being charged for the convenience of an eBay Now delivery.
ExpeditedService Boolean Indicates whether the service is an expedited shipping service.
ShippingServiceImportCharge Decimal The total cost of customs and taxes for the international leg of an order shipped using the Global Shipping Program. This amount is calculated and supplied for each item by the international shipping provider when a buyer views the item properties.
ShippingInsuranceCost Decimal The insurance cost associated with shipping a single item with this shipping service.
ShippingPackageInfo String If the order is being delivered through eBay Now, it contains information on the status of the order, the unique identifier of the store where the order is originating from, and the expected and actual delivery times.
ShippingService String A shipping service option being offered by the seller to ship an item to a buyer.
ShippingServiceAdditionalCost Decimal The cost of shipping each additional item if the same buyer purchases one or more of the same line item.
ShippingServiceCost Decimal The base cost using the shipping service specified in the ShippingService field to ship the item. In the case of a multiple quantity, fixed-price listing, the ShippingServiceAdditionalCost field shows the cost to ship each additional item if the buyer purchases one or more of the same line item.
ShippingServicePriority Integer This integer value controls the order (relative to other shipping services) in which the corresponding ShippingService will appear in the View Item and Checkout page.
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).
ShippingTimeMin Integer The minimum guaranteed number of days in which the shipping carrier can ship an item (not including the time it takes the seller to deliver the item to the shipping carrier).
BuyerSelectedShipping Boolean Indicates whether the buyer has selected shipping details during checkout.
CheckoutStatus String Indicates the current status of the checkout flow for the order.
CompleteStatus String Indicates whether checkout is complete, incomplete, or pending for an order.
DigitalStatus String The current state of a purchased digital gift card.
EBayPaymentStatus String Indicates the success or failure of the online payment for an order by the buyer.
InquiryStatus String This field gives the status of an Item Not Received (INR) Inquiry by the buyer. This field is only returned if the buyer has created an INR Inquiry.
IntegratedMerchantCreditCardEnabled Boolean Indicates whether the item can be paid for through a payment gateway account.
LastTimeModified Datetime Indicates date and time the status of an order was last updated (in GMT).
PaymentHoldStatus String This field indicates the type and/or status of a payment hold on the item.
PaymentInstrument String The payment method used by a German buyer who was offered the Pay Upon Invoice option. This field will only be returned if a German buyer was offered the Pay Upon Invoice option. Otherwise, the payment method selected by the buyer is returned in the PaymentMethodUsed field.
PaymentMethodUsed String The payment method that the buyer selected to pay for the order. If checkout is not yet complete, PaymentMethodUsed is set to whatever the buyer selected as his or her preference on the Review Your Purchase page.
ReturnStatus String This field gives the status of a return request from the buyer. This field is only returned if the buyer has initiated a return request or has escalated an existing return request into a return case.
TransactionPrice Decimal The price of the order line item (transaction).

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
ModTimeFrom String The ModTimeFrom and ModTimeTo fields specify a date range for retrieving order line items associated with the specified ItemId. The ModTimeFrom field is the starting date range.
ModTimeTo String The ModTimeFrom and ModTimeTo fields specify a date range for retrieving order line items associated with the specified ItemId. The ModTimeTo field is the ending date range.
NumberOfDays String This time filter specifies the number of days (24-hour periods) in the past to search for order line items.

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