Excel Add-In for BigCommerce

Build 23.0.8839


Refund payments made to payment providers.

Table Specific Information


The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

  • OrderId supports the '=, IN' comparison.
  • OrderRefundsId supports the '=, IN' comparison.

The rest of the filter is executed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM OrderRefundsItems WHERE OrderRefundId = 2

SELECT * FROM OrderRefundsPayments WHERE OrderId = 2


Name Type References Description
Id [KEY] Integer The ID of the refund payment.
OrderRefundId Integer


The ID of the order refund.
OrderId Integer


Reference to order id.
ProviderId String Reference to payment provider.
Amount Decimal A non-negative 2 decimal place rounded value that represents the amount that can be charged/refunded via payment providers.
Offline Boolean Indicate whether payment was offline.
IsDeclined Boolean Indicate if this payment has been declined by payment provider.
DeclinedMessage String Message indicate why payment was declined.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839