ShipmentItems
Returns data from Items within a shipment.
Table Specific Information
Select
The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- OrderShipmentId supports the = comparison.
- OrderId supports the = comparison.
The rest of the filter is executed client-side within the driver.
For example, the following queries are processed server-side:
SELECT * FROM ShipmentItems WHERE OrderShipmentId = 1
SELECT * FROM ShipmentItems WHERE OrderId = 2
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer |
OrderItems.Id | Id of the Product within the order. |
| ProductId [KEY] | Integer |
Products.Id | Numerical Id of the product. |
| OrderShipmentId [KEY] | String | Id of the shipment. | |
| Quantity | Integer | Quantity of product shipped. | |
| OrderId | Integer | ID of the order associated with this shipment. |