SystemStatus
Retrieves system status items.
View-Specific Information
Select
The SystemStatus view represents a singleton entity. When queried, it returns a single row with system status and environment configuration details from the WooCommerce store.
Filters are not supported on this view. SELECT queries return the full set of columns in a single response.
The following example demonstrates a basic query:
-- Retrieve current WooCommerce system status
SELECT * FROM SystemStatus
Columns
| Name | Type | References | Description |
| ActivePluginsAggregate | String | Active plugins. | |
| PagesAggregate | String | WooCommerce pages. | |
| EnvironmentHomeUrl | String | Home URL. | |
| EnvironmentSiteUrl | String | Site URL. | |
| EnvironmentWcVersion | String | WooCommerce version. | |
| EnvironmentLogDirectory | String | Log directory. | |
| EnvironmentLogDirectoryWritable | Boolean | Is log directory writable? read-only | |
| EnvironmentWpVersion | String | WordPress version. | |
| EnvironmentWpMultisite | Boolean | Is WordPress multisite? read-only | |
| EnvironmentWpMemoryLimit | Integer | WordPress memory limit. | |
| EnvironmentWpDebugMode | Boolean | Is WordPress debug mode active? read-only | |
| EnvironmentWpCron | Boolean | Are WordPress cron jobs enabled? read-only | |
| EnvironmentLanguage | String | WordPress language. | |
| EnvironmentServerInfo | String | Server info. | |
| EnvironmentPhpVersion | String | PHP version. | |
| EnvironmentPhpPostMaxSize | Integer | PHP post max size. | |
| EnvironmentPhpMaxExecutionTime | Integer | PHP max execution time. | |
| EnvironmentPhpMaxInputVars | Integer | PHP max input vars. | |
| EnvironmentCurlVersion | String | cURL version. | |
| EnvironmentSuhosinInstalled | Boolean | Is SUHOSIN installed? read-only | |
| EnvironmentMaxUploadSize | Integer | Max upload size. | |
| EnvironmentMysqlVersion | String | MySQL version. | |
| EnvironmentDefaultTimezone | String | Default timezone. | |
| EnvironmentFsockopenOrCurlEnabled | Boolean | Is fsockopen/cURL enabled? read-only | |
| EnvironmentSoapclientEnabled | Boolean | Is SoapClient class enabled? read-only | |
| EnvironmentDomdocumentEnabled | Boolean | Is DomDocument class enabled? read-only | |
| EnvironmentGzipEnabled | Boolean | Is GZip enabled? read-only | |
| EnvironmentMbstringEnabled | Boolean | Is mbstring enabled? read-only | |
| EnvironmentRemotePostSuccessful | Boolean | Remote POST successful? read-only | |
| EnvironmentRemotePostResponse | String | Remote POST response. | |
| EnvironmentRemoteGetSuccessful | Boolean | Remote GET successful? read-only | |
| EnvironmentRemoteGetResponse | String | Remote GET response. | |
| DatabaseWcDatabaseVersion | String | WC database version. | |
| DatabasePrefix | String | Database prefix. | |
| DatabaseMaxmindGeoipDatabase | String | MaxMind GeoIP database. | |
| DatabaseTablesAggregate | String | Database tables. | |
| ThemeName | String | Theme name. | |
| ThemeVersion | String | Theme version. | |
| ThemeVersionLatest | String | Latest version of theme. | |
| ThemeAuthorUrl | String | Theme author URL. | |
| ThemeIsChildTheme | Boolean | Is this theme a child theme? read-only | |
| ThemeHasWoocommerceSupport | Boolean | Does the theme declare WooCommerce support? read-only | |
| ThemeHasWoocommerceFile | Boolean | Does the theme have a woocommerce.php file? read-only | |
| ThemeHasOutdatedTemplates | Boolean | Does this theme have outdated templates? read-only | |
| ThemeOverridesAggregate | String | Template overrides. | |
| ThemeParentName | String | Parent theme name. | |
| ThemeParentVersion | String | Parent theme version. | |
| ThemeParentAuthorUrl | String | Parent theme author URL. | |
| SettingsApiEnabled | Boolean | REST API enabled? read-only | |
| SettingsForceSsl | Boolean | SSL forced? read-only | |
| SettingsCurrency | String | Currency. | |
| SettingsCurrencySymbol | String | Currency symbol. | |
| SettingsCurrencyPosition | String | Currency position. | |
| SettingsThousandSeparator | String | Thousand separator. | |
| SettingsDecimalSeparator | String | Decimal separator. | |
| SettingsNumberOfDecimals | Integer | Number of decimals. | |
| SettingsGeolocationEnabled | Boolean | Geolocation enabled? read-only | |
| SettingsTaxonomiesAggregate | String | Taxonomy terms for product/order statuses. | |
| SecuritySecureConnection | Boolean | Is the connection to your store secure? read-only | |
| SecurityHideErrors | Boolean | Hide errors from visitors? read-only | |
| SubscriptionsCacheUpdateFailures | Integer | The number of times report cache updates have failed. | |
| SubscriptionsLiveUrl | String | The URL Subscriptions considers to be the site's live URL. | |
| SubscriptionsMode | String | Whether the site is in 'live' or 'staging' mode. | |
| SubscriptionsPaymentGatewayFeatureSupport | String | A breakdown of the features supported by the active payment gateways. | |
| SubscriptionsReportCacheEnabled | Boolean | Whether the report caches are enabled. | |
| SubscriptionsStatusesAutoDraft | String | Auto Draft Status. | |
| SubscriptionsStatusesTrash | String | Trash Status. | |
| SubscriptionsStatusesWcActive | String | Active Status. | |
| SubscriptionsStatusesWcCancelled | String | Cancelled Status. | |
| SubscriptionsStatusesWcOnHold | String | On hold Status. | |
| SubscriptionsStatusesWcPending | String | Pending Status. | |
| SubscriptionsStatusesWcPendingCancel | String | Pending Cancel Status. | |
| SubscriptionsSubscriptionsByPaymentGateway | String | A breakdown of subscriptions by the gateway and their status. | |
| SubscriptionsWcsDebug | Boolean | Is WC Subscriptions debugging mode active? | |
| InactivePlugginsAggregate | String | Inactive Plugins | |
| PostTypeCountsAggregate | String | Post type counts | |
| LoggingEnabled | Boolean | If the logging is enabled. | |
| LogDefaultHandler | String | The default handler location for the log. | |
| LogRetentionPeriodDays | Integer | Log retention period in days. | |
| LogLevelThreshold | String | The level threshold set for the logs. | |
| LogDirectorySize | String | Log size in KB. |