JDBC Driver for WooCommerce

Build 24.0.9062

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 References Description
Id [KEY] Long 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 Long 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 Long 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.

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