SubscriptionFeeLines
Retrieves all subscription fee lines. This view shows data only if the WooCommerce Subscriptions Plugin is enabled.
View-Specific Information
Select
WooCommerce supports server-side filtering only on a limited set of columns in the SubscriptionFeeLines view. All other filters are applied client-side. The following columns support server-side filtering with the specified operators:
- SubscriptionId supports the '=' operator.
- ParentId supports the '=', '!=', 'IN', and 'NOT IN' operators.
- CustomerId supports the '=' operator.
- Status supports the '=' operator.
- Product supports the '=' operator.
The following examples demonstrate basic queries using supported filters:
-- Query by subscription ID
SELECT * FROM SubscriptionFeeLines WHERE SubscriptionId = 4
-- Query by parent subscription
SELECT * FROM SubscriptionFeeLines WHERE ParentId = 4
-- Query excluding a parent subscription
SELECT * FROM SubscriptionFeeLines WHERE ParentId != 4
-- Query using a list of parent subscriptions
SELECT * FROM SubscriptionFeeLines WHERE ParentId IN (4, 5)
-- Query excluding a list of parent subscriptions
SELECT * FROM SubscriptionFeeLines WHERE ParentId NOT IN (4, 5)
-- Filter by subscription status and customer
SELECT * FROM SubscriptionFeeLines WHERE Status = 'pending' AND CustomerId = 501
-- Filter by product
SELECT * FROM SubscriptionFeeLines WHERE Product = 101
Columns
| Name | Type | References | Description |
| Id | Integer | Item ID. | |
| SubscriptionId | Integer | Subscription ID. | |
| Amount | String | Fee amount. | |
| MetaData | String | Meta data. | |
| Name | String | Fee name. | |
| TaxClass | String | Tax class. | |
| TaxStatus | String | Specifies whether the fee is taxable. Valid values are 'taxable', 'none', and 'inherit'. | |
| Taxes | String | Line taxes. | |
| Total | String | Line total (after discounts). | |
| TotalTax | String | Line total tax (after discounts). | |
| ParentId | Integer | Parent/initial order ID for the subscription. | |
| CustomerId | Integer |
Customers.Id | User ID who owns the subscription. |
| Status | String | Subscription status.
The default value is pending. |
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 | |
| Product | String | Limit result set to subscriptions assigned a specific product ID. | |
| ReferenceNumber | String | This column will be used in Bulk operations to get specific values from the Temp tables. |