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. |