Warehouses
Lists warehouses.
Select
The driver 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 driver.
- Id supports the following operator: =.
SELECT * FROM Warehouses WHERE Id = 8688You 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 warehouses. | |
WarehouseName | String | Name of the warehouse. | |
CreateDate | Datetime | Create date of the record. | |
ExtInventoryIdentity | String | Inventory Identity. | |
IsDefault | Boolean | Whether it is default warehouse or not. | |
OriginAddressAddressVerified | String | Origin address is verified or not. | |
OriginAddressCity | String | Origin city of the warehouse. | |
OriginAddressCompany | String | Origin country of the warehouse. | |
OriginAddressCountry | String | Origin name of the warehouse. | |
OriginAddressName | String | Origin phone of the warehouse. | |
OriginAddressPhone | String | Origin phone of the warehouse. | |
OriginAddressPostalCode | String | Origin postal code of the warehouse. | |
OriginAddressResidential | Boolean | Origin residential of the warehouse. | |
OriginAddressState | String | Origin state of the warehouse. | |
OriginAddressStreet1 | String | Origin street of the warehouse. | |
OriginAddressStreet2 | String | Origin street of the warehouse. | |
OriginAddressStreet3 | String | Origin street of the warehouse. | |
RegisterFedexMeter | String | Register Fedex Meter. | |
ReturnAddressAddressVerified | String | Return address is verified or not. | |
ReturnAddressCity | String | Return city of the warehouse. | |
ReturnAddressCompany | String | Return company of the warehouse. | |
ReturnAddressCountry | String | Return country of the warehouse. | |
ReturnAddressName | String | Return Name of the warehouse. | |
ReturnAddressPhone | String | Return phone of the warehouse. | |
ReturnAddressPostalCode | String | Return postal code of the warehouse. | |
ReturnAddressResidential | String | Return residential of the warehouse. | |
ReturnAddressState | String | Return state of the warehouse. | |
ReturnAddressStreet1 | String | Return street of the warehouse. | |
ReturnAddressStreet2 | String | Return street of the warehouse. | |
ReturnAddressStreet3 | String | Return street of the warehouse. | |
SellerIntegrationId | String | Seller Integration Id. |