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. |
| QuantityPurchased | Integer | This value indicates the number of identical items purchased at the same time by the same buyer from one listing. |
| 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. |
| 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. |