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 | Description |
| Id [KEY] | Integer | Id of the Product within the order. |
| ProductId [KEY] | Integer | 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. |