Provinces
Query and update information regarding different provinces.
Table-Specific Information
Select
The connector uses the Shopify API to process search criteria that refer to the CountryId and Id columns. The supported SQL operator is '=' for ProductId and Id columns. The connector processes other filters client-side within the connector.For example, the following queries are processed server-side:
SELECT * FROM Provinces WHERE CountryId = '123'
SELECT * FROM Provinces WHERE CountryId = '123' and Id = '456'
Update
You must specify the CountryId and Id to update a province. For example:
UPDATE Provinces SET Tax = '3.4' WHERE CountryId = '123' AND Id = '456'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The ID for the province. | |
| CountryId [KEY] | Long | True |
Countries.Id |
The ID for the country that the province belongs to. |
| Name | String | False |
The full name of the province. | |
| Code | String | False |
The standard abbreviation for the province. | |
| Tax | Decimal | False |
The sales tax rate to be applied to orders made by customers from this province.. | |
| TaxPercentage | Double | False |
The province's tax in percent format. | |
| TaxName | String | False |
The name of the tax for this province. | |
| TaxType | String | False |
The tax type. Valid values: normal, null, or harmonized. If the value is harmonized, then the tax is compounded of the provincial and federal sales taxes. | |
| ShippingZoneId | Long | True |
The ID for the shipping zone that the province belongs to. |