ShippingConsignments
Returns consignments and their corresponding shipping orders.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the Id column, which supports the = comparison.
For example, the following queries are processed server-side:
SELECT * FROM ShippingConsignments WHERE OrderId = 123
Columns
| Name | Type | References | Description |
| Id | Integer | ID of the shipping consignment. | |
| OrderId | Integer |
Orders.Id | Identifier for the BigCommerce Order with which this transaction is associated. |
| FirstName | String | First name. | |
| LastName | String | Last name. | |
| Company | String | company. | |
| Street1 | String | Street address (first line). | |
| Street2 | String | Street address (second line). | |
| Country | String | country | |
| State | String | State | |
| String | Recipient?s email address. | ||
| Phone | String | Recipient?s telephone number. | |
| ItemsTotal | Decimal | The total number of items in the order. | |
| ItemsShipped | Decimal | The number of items that have been shipped. | |
| ShippingMethod | String | Text identifying the BigCommerce shipping module selected by the customer. | |
| BaseCost | Decimal | The base shipping cost value. | |
| CostExTax | Decimal | The shipping cost value excluding tax. | |
| CostIncTax | Decimal | The shipping cost value including tax. | |
| CostTax | Decimal | The tax amount on the shipping cost. | |
| CostTaxClassId | Integer | The ID of the tax class applied to the shipping cost. Ignored if automatic tax is enabled. | |
| BaseHandlingCost | Decimal | The base handling charge. | |
| HandlingCostExTax | Decimal | The handling charge, excluding tax. | |
| HandlingCostIncTax | Decimal | The handling charge, including tax. | |
| HandlingCostTax | Decimal | The handling charge, including tax number. | |
| HandlingCostTaxClassId | Integer | The ID of the tax class applied to the handling charge. Ignored if automatic tax is enabled. | |
| ShippingZoneId | Decimal | The numeric ID of the shipping zone. | |
| ShippingZoneName | String | The name of the shipping zone. | |
| ShippingQuotesResources | String | URL where you can use a GET request to get the shipping quotes for the order consignment. | |
| ShippingQuotesUrl | String | Path where you can use a GET request to get the shipping quotes for the order consignment. | |
| ZipCode | String | zip code of the shipping quotes. | |
| ShippingLineItemResources | String | URL where you can use a GET request to get the shipping line items for the order consignment. | |
| ShippingLineItemUrl | String | Path where you can use a GET request to get the shipping line items for the order consignment. | |
| City | String | Path where you can use a GET request to get the shipping line items for the order consignment. | |
| CountryIso | String | Path where you can use a GET request to get the shipping line items for the order consignment. |