OrderShippingLines
Lists shipping lines attached to orders, including carrier, rate, and destination data.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderShippingLines WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the shipping line record associated with the order. | |
| CarrierIdentifier | String | A reference identifier for the carrier service that provided the shipping rate. Present when the rate was calculated by a third-party carrier integration. | |
| Title | String | The title or name of the shipping line as it appears to the customer during checkout or on the order summary. | |
| Code | String | A reference code representing the specific shipping method selected for the order. | |
| Custom | Bool | Indicates whether the shipping line was created manually as a custom shipping option rather than automatically calculated. | |
| DeliveryCategory | String | Describes the general delivery method classification, such as standard, express, or same-day. | |
| IsRemoved | Bool | Indicates whether the shipping line has been removed or voided from the order record. | |
| Phone | String | The phone number associated with the shipping address for this shipping line. | |
| ShippingRateHandle | String | A unique system-generated identifier for the shipping rate. The format may change and is not intended for display to customers. | |
| Source | String | Specifies the origin or source of the rate for this shipping line, such as a carrier, fulfillment service, or custom entry. | |
| CurrentDiscountedPriceSetPresentmentMoneyAmount | Decimal | The current discounted shipping amount, expressed in the buyer's presentment currency as a decimal value. | |
| CurrentDiscountedPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the current discounted shipping amount. | |
| CurrentDiscountedPriceSetShopMoneyAmount | Decimal | The current discounted shipping amount, expressed in the shop's base currency as a decimal value. | |
| CurrentDiscountedPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the current discounted shipping amount. | |
| DiscountedPriceAmount | Decimal | The total discounted price for the shipping line, expressed as a decimal value. | |
| DiscountedPriceCurrencyCode | String | The ISO currency code representing the currency for the discounted shipping price. | |
| DiscountedPriceSetPresentmentMoneyAmount | Decimal | The discounted shipping price expressed in the buyer's presentment currency as a decimal value. | |
| DiscountedPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the discounted shipping price. | |
| DiscountedPriceSetShopMoneyAmount | Decimal | The discounted shipping price expressed in the shop's base currency as a decimal value. | |
| DiscountedPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the discounted shipping price. | |
| OriginalPriceAmount | Decimal | The original shipping price before discounts, expressed as a decimal value. | |
| OriginalPriceCurrencyCode | String | The ISO currency code representing the currency for the original shipping price. | |
| OriginalPriceSetPresentmentMoneyAmount | Decimal | The original shipping price before discounts, expressed in the buyer's presentment currency as a decimal value. | |
| OriginalPriceSetPresentmentMoneyCurrencyCode | String | The ISO currency code representing the presentment currency for the original shipping price. | |
| OriginalPriceSetShopMoneyAmount | Decimal | The original shipping price before discounts, expressed in the shop's base currency as a decimal value. | |
| OriginalPriceSetShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the original shipping price. | |
| RequestedFulfillmentServiceId | String | The unique identifier of the fulfillment service responsible for processing this shipping line. | |
| OrderId | String |
Orders.Id | The unique identifier of the order associated with this shipping line. |
| TaxLines | String | A collection of tax line objects detailing the taxes applied to this shipping line, including rate and amount information. |