SSIS Components for WooCommerce

Build 24.0.9062

ShippingZones

Retrieve and modify shipping zones.

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: Id. All other columns are processed client side.

SELECT * FROM ShippingZones WHERE Id = 13

Insert

The following attribute is required when performing an insert: Name.

INSERT INTO ShippingZones (Name) VALUES ('zone_name')

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique identifier for the resource.

Name String False

Shipping zone name.

Order Integer False

Shipping zone order.

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