Retrieves all subscription shipping 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 SubscriptionShippingLines 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 SubscriptionShippingLines WHERE SubscriptionId = 4

-- Query by parent subscription
SELECT * FROM SubscriptionShippingLines WHERE ParentId = 4

-- Query excluding a parent subscription
SELECT * FROM SubscriptionShippingLines WHERE ParentId != 4

-- Query using a list of parent subscriptions
SELECT * FROM SubscriptionShippingLines WHERE ParentId IN (4, 5)

-- Query excluding a list of parent subscriptions
SELECT * FROM SubscriptionShippingLines WHERE ParentId NOT IN (4, 5)

-- Filter by subscription status and customer
SELECT * FROM SubscriptionShippingLines WHERE Status = 'pending' AND CustomerId = 501

-- Filter by product
SELECT * FROM SubscriptionShippingLines WHERE Product = 101

Columns

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.