ShippingLocations
Retrieve shipping zone locations.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available column for this
table is: ZoneId. All other columns are processed client side. If the 'ZoneId' filter is not specified,
the add-in will fetch a list of all the zones and perform a request for each zone in the list.
SELECT * FROM ShippingLocations WHERE ZoneId = 13
Columns
Name | Type | References | Description |
Code | String | Shipping zone location code. | |
Type | String | Shipping zone location type. Options: postcode, state, country and continent. Defaults to country. | |
ZoneId | Long | Id of the shipping zone. |