MCP Server for WooCommerce

Build 25.0.9440

ProductShippingClasses

Retrieve and modify product shipping classes.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side.

  • Id supports the '=,IN,NOT IN' operator.
  • Slug supports the '=' operator.
  • ProductId supports the '=' operator.

SELECT * FROM ProductShippingClasses WHERE Id = 4
SELECT * FROM ProductShippingClasses WHERE Id IN (4,5)
SELECT * FROM ProductShippingClasses WHERE ProductId = 16

Insert

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

INSERT INTO ProductShippingClasses (Name) VALUES ('class_name')

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique identifier for the resource.

Name String False

Shipping class 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 Long False

Limit result set to resources assigned to a specific product.

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
ReferenceNumber String

This column will be used in Bulk operations to get specific values from the Temp tables.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9440