ODBC Driver for ShipStation

Build 22.0.8462

ShipmentItems

Lists shipment items.

Select

The driver will use the ShipStation All the filter is executed client side within the driver. You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type References Description
Id [KEY] Integer Id of the ordered Item.
ShipmentId Long Id of the Shipment.
FulfillmentSKU String The fulfillment SKU associated with this OrderItem if the fulfillment provider requires an identifier other then the SKU.
ImageUrl String The public URL to the product image.
LineItemKey String An identifier for the OrderItem in the originating system.
Name String The name of the product associated with this line item. Cannot be null.
OptionsName String Options of the Item.
OptionsValue String Options of the Item.
ProductId Integer Id of the product.
Quantity Integer The quantity of product ordered.
SKU String The SKU (stock keeping unit) identifier for the product associated with this line item.
UnitPrice Double The sell price of a single item specified by the order source.
WarehouseLocation String The location of the product within the seller's warehouse (e.g. Aisle 3, Shelf A, Bin 5).
WeightValue Double The weight value of a single item.
WeightUnits String The units of weight.
WeightWtUnits Integer A numeric value that is equivalent to the units field.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462