Items of the orders.

Select

The connector 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 connector.

• OrderId supports the following operator: =.

Note: OrderId is required in order to query OrderItems. For example, the following query is processed server side:

SELECT * FROM OrderItems WHERE OrderId = 2810333

Columns

Name	Type	References	Description
OrderItemId [KEY]	Long		Id of the Ordered Item.
ImageUrl	String		URL of the ordered Item Image.
LineItemKey	String		Key of the line Item.
Name	String		Name of the ordered Item.
Options	String		List of options associated with this order item.
Quantity	Integer		Quantity of the ordered Item.
ShippingAmount	Double		Shipping amount for the ordered Item.
SKU	String		SKU of the ordered Item.
TaxAmount	Double		Tax amount for the ordered Item.
UnitPrice	Double		Unite price of the Ordered Item.
WarehouseLocation	String		Ordered Item warehouse location.
ProductId	Integer	Products.Id	Product Id of the ordered Id.
FulfillmentSKU	String		Fulfillment SKU for the ordered Item.
Adjustment	Boolean		Adjustment is there are not for ordered Item.
Upc	String		UPC of the ordered Item.
CreateDate	Datetime		Create date of this record.
ModifyDate	Datetime		Modify date of this record.
WeightUnits	String		Weight unit of the ordered Item.
WeightValue	Double		Weight value of the ordered Item.
WeightWtUnits	Integer		A numeric value that is equivalent to the units field.
OrderId [KEY]	Long	Orders.Id	Id of the Order.