ADO.NET Provider for WooCommerce

Build 20.0.7587

Categories

Retrieve product categories.

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, Parent, Product. All other columns are processed client side.

SELECT * FROM Categories WHERE Id = 4
SELECT * FROM Categories WHERE Slug = 'criteria'
SELECT * FROM Categories WHERE Parent = 2

Insert

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

INSERT INTO Categories (Name) VALUES ('category_name')

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier for the resource.

Name String False

Category name.

Slug String False

An alphanumeric identifier for the resource unique to its type.

Parent Integer False

The ID for the parent of the resource.

Description String False

HTML description of the resource.

Display String False

Category archive display type. Options: default, products, subcategories and both.

MenuOrder Integer False

Menu order, used to custom sort the resource.

Count Integer True

Number of published products for the resource.

ImageId Integer False

Image ID.

ImageDateCreated Datetime True

The date the image was created, in the site's timezone.

ImageDateModified Datetime True

The date the image was last modified, in the site's timezone.

ImageSrc String False

Image URL.

ImageName String False

Image name.

ImageAlt String False

Image alternative text.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Product Integer

Limit result set to resources assigned to a specific product.

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