ShippingItems
Query order shipping.
View-Specific Information
Select
The cmdlet uses the Shopify API to process search criteria that refer to the OrderId and OrderUpdatedAt columns. The supported SQL operators are '=' for OrderId and '>' and '<' for OrderUpdatedAt. The cmdlet processes other filters client-side within the cmdlet. For example, the following queries are processed server-side.
SELECT * FROM ShippingItems WHERE OrderId = '123'
SELECT * FROM ShippingItems WHERE OrderUpdatedAt > '2018-05-05'
Columns
Name | Type | References | Description |
Id [KEY] | Long | The id of the shipping item. | |
OrderId [KEY] | Long |
Orders.Id | The id of the order. |
OrderUpdatedAt | Datetime | The date and time when the order was last modified. | |
Price | Decimal | The price of this shipping method. | |
Code | String | A reference to the shipping method. | |
Title | String | The title of the shipping method. | |
Source | String | The source of the shipping method. | |
CarrierIdentifier | String | A reference to the carrier service that provided the rate. | |
RequestedFulfillmentServiceId | String | A reference to the fulfillment service that is being requested for the shipping method. |