Stores
Lists all stores.
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, MarketplaceId and ShowInactive support the following operator: =.
SELECT * FROM Stores WHERE Id = 5603You 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 store. | |
AccountName | String | Account name of the store. | |
Active | Boolean | Whether store is active or not. | |
AutoRefresh | Boolean | Whether refresh is available or not. | |
CompanyName | String | Company name of the store. | |
CreateDate | Datetime | Create date of this record. | |
String | Email id of the store. | ||
IntegrationUrl | String | Integration URL of the store. | |
LastRefreshAttempt | Datetime | Last refresh attempt of the store. | |
MarketplaceId | Integer | Marketplace Id of the store. | |
MarketplaceName | String | Marketplace Name of the store. | |
ModifyDate | Datetime | Modify date of the store. | |
Phone | String | Phone number of the store. | |
PublicEmail | String | Public email of the store. | |
RefreshDate | Datetime | Refresh date of the store. | |
StatusMappings | String | ||
StoreName | String | Name of the store. | |
Website | String | Website of the store. | |
ShowInactive | Boolean | Specifies whether inactive stores will be shown. |