OrderCoupons
Lists all order coupons.
Table Specific Information
Select
The add-in uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' comparison.
- OrderId supports the '=' comparison.
The rest of the filter is executed client-side within the add-in.
For example, the following queries are processed server-side:
SELECT * FROM OrderCoupons WHERE Id = 1 SELECT * FROM OrderCoupons WHERE OrderId = 2
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Numeric ID of this product within this order. | |
| OrderId | Integer | Numeric ID of the associated order. | |
| CouponId | Integer | The coupon id. | |
| Code | String | The code of the coupon. | |
| Amount | Decimal | The amount of the coupon. | |
| Type | Integer | The type of the coupon. | |
| Discount | Decimal | The discount of the coupon. |