OrderCustomsItems
Customs Items of the Orders.
Select
The add-in will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- OrderId supports the following operator: =.
Note: OrderId is required in order to query OrderCustomsItems. For example, the following query is processed server side:
SELECT * FROM OrderCustomsItems WHERE OrderId = 2810333
Columns
| Name | Type | References | Description |
| CustomsItemId [KEY] | Long | Id of the customs Item. | |
| CountryOfOrigin | String | Origin country of the customs Item. | |
| Description | String | Description of the customs Item. | |
| HarmonizedTariffCode | String | Harmonized tariff code of the customers Item. | |
| Quantity | Integer | Quantity of the customs Item. | |
| Value | Double | Value of the customs Item. | |
| OrderId [KEY] | Long | Id of the Order. |