Disputes
Shows payment dispute cases raised by customers, including dispute type, amount, and resolution status.
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.
- Status supports the '=, !=' comparison operators.
- InitiatedAt supports the '=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM Disputes WHERE Id = 'Val1'
SELECT * FROM Disputes WHERE Status = 'Val1'
SELECT * FROM Disputes WHERE InitiatedAt = '2023-01-01 11:10:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the dispute record. | |
| LegacyResourceId | String | The ID of the corresponding resource in the REST Admin API, maintained for backward compatibility. | |
| EvidenceDueBy | Date | The deadline date by which the merchant must submit evidence in response to the dispute. | |
| EvidenceSentOn | Date | The date when the merchant submitted evidence to contest the dispute. Returns 'null' if evidence has not yet been provided. | |
| Status | String | The current status of the dispute, such as 'under_review', 'won', 'lost', or 'needs_response'. | |
| Type | String | Indicates the nature of the dispute, specifying whether it is in the inquiry stage or has escalated to a chargeback. | |
| FinalizedOn | Date | The date when the dispute was finalized or closed by the payment network. Returns 'null' if still open or unresolved. | |
| InitiatedAt | Datetime | The timestamp indicating when the dispute was first created or reported by the card network. | |
| Amount | Decimal | The disputed monetary amount being contested in the chargeback or inquiry case. | |
| AmountCurrencyCode | String | The ISO currency code representing the currency of the disputed amount. | |
| OrderId | String | The unique identifier of the Shopify order associated with the disputed transaction. | |
| ReasonDetailsReason | String | The reason provided by the cardholder's bank for initiating the dispute, such as 'fraudulent transaction' or 'product not received'. | |
| ReasonDetailsNetworkReasonCode | String | The specific reason code assigned by the payment network that categorizes the nature of the dispute. |