Provinces
Query and update information regarding different provinces.
Table-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the ProductId, UpdatedAt, and Handle columns. The supported SQL operators are '=' and 'IN' for ProductId, '=' for Handle, and '>' for the CreatedAt column. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
For example, the following queries are processed server side:
SELECT * FROM Provinces
SELECT * FROM Provinces WHERE CountryId='123'
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. |