TenderTransactions
Lists payment tender transactions processed in the shop, including amounts, payment methods, and timestamps.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=, IN' comparison operators.
- Test supports the '=, !=' comparison operators.
- ProcessedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM TenderTransactions WHERE Id = 'Val1'
SELECT * FROM TenderTransactions WHERE Test = true
SELECT * FROM TenderTransactions WHERE ProcessedAt = '2023-01-01 11:10:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the tender transaction record. | |
| Test | Bool | Indicates whether the transaction was created in test mode rather than live mode. | |
| PaymentMethod | String | Specifies the payment method used to complete the transaction, such as credit card or cash. | |
| ProcessedAt | Datetime | The date and time when the transaction was processed by the payment system. | |
| RemoteReference | String | The reference identifier returned by the remote payment gateway for this transaction. | |
| AmountAmount | Decimal | The total amount of the transaction in decimal monetary format. | |
| AmountCurrencyCode | String | The three-letter ISO currency code representing the currency of the transaction. | |
| TenderTransactionCreditCardDetailsCreditCardCompany | String | The name of the credit card company that issued the customer's card, for example 'Visa' or 'Mastercard'. | |
| TenderTransactionCreditCardDetailsCreditCardNumber | String | The masked credit card number used for the payment, displaying only the last four digits (for example, '**** **** **** 1234'). | |
| UserId | String | A globally unique identifier for the staff member associated with the transaction. (Available only to Shopify Plus merchants.) | |
| OrderId | String | A globally unique identifier for the order associated with the transaction. |