Cmdlets for WooCommerce

Build 20.0.7587

ProductTags

Retrieve and modify product tags.

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 columns for this table are: Id, Slug, Product, HideEmpty. All other columns are processed client side.

SELECT * FROM ProductTags WHERE Id = 4
SELECT * FROM ProductTags WHERE Slug = 'criteria'
SELECT * FROM ProductTags WHERE ProductId = 16

Insert

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

INSERT INTO ProductTags (Name) VALUES ('tag_name')

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier for the resource.

Name String False

Tag name.

Slug String False

An alphanumeric identifier for the resource unique to its type.

Description String False

HTML description of the resource.

Count Integer True

Number of published products for the resource.

ProductId Integer False

Limit result set to resources assigned to a specific product.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587