Excel Add-In for ShipStation

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060