MuleSoft Connector for WooCommerce

Build 21.0.7930


Retrieve product categories.

Table Specific Information


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


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

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


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 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930