SSIS Components for WooCommerce

Build 24.0.9062

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 本製品 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

ShippingZones.Id

Id of the shipping zone.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062