> For the complete documentation index, see [llms.txt](https://docs.hostinger.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hostinger.com/wordpress/hostinger-plugins/ai-plugin/abilities/woocommerce-orders.md).

# WooCommerce Orders & Reports

WooCommerce Orders & Reports abilities of the Hostinger AI plugin's WordPress site MCP server. Manage orders and read sales, order, product, customer, coupon and review totals.

Manage orders and read sales, order, product, customer, coupon and review totals.

**Available:** Only while WooCommerce is active on the site.

| Ability                                                               | What it does                                                                                                | Type                             |
| --------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- | -------------------------------- |
| [Create WooCommerce Order](#create-woocommerce-order)                 | Create a WooCommerce order from customer details and line items.                                            | Changes the site                 |
| [Delete WooCommerce Order](#delete-woocommerce-order)                 | Move a WooCommerce order to the trash; it can be restored from the trash.                                   | **Destructive** · Safe to retry  |
| [Get WooCommerce Order](#get-woocommerce-order)                       | Get one WooCommerce order by ID with all its fields.                                                        | Read-only                        |
| [Search WooCommerce Orders](#search-woocommerce-orders)               | Search and filter WooCommerce orders by status, customer, product or date, with pagination.                 | Read-only                        |
| [Update WooCommerce Order](#update-woocommerce-order)                 | Update the status or other editable fields of a WooCommerce order.                                          | Changes the site · Safe to retry |
| [Get WooCommerce Coupons Report](#get-woocommerce-coupons-report)     | Get the number of WooCommerce coupons by coupon type.                                                       | Read-only                        |
| [Get WooCommerce Customers Report](#get-woocommerce-customers-report) | Get the number of WooCommerce customers, paying and non-paying.                                             | Read-only                        |
| [Get WooCommerce Orders Report](#get-woocommerce-orders-report)       | Get the number of WooCommerce orders by status.                                                             | Read-only                        |
| [Get WooCommerce Products Report](#get-woocommerce-products-report)   | Get the number of WooCommerce products by product type.                                                     | Read-only                        |
| [Get WooCommerce Reviews Report](#get-woocommerce-reviews-report)     | Get the number of WooCommerce product reviews by rating.                                                    | Read-only                        |
| [Get WooCommerce Sales Report](#get-woocommerce-sales-report)         | Get WooCommerce sales and revenue for a period, with totals for orders, items, tax, shipping and discounts. | Read-only                        |

## Create WooCommerce Order

`hostinger-ai/wc-orders-create` · Changes the site

Create a WooCommerce order from customer details and line items.

No required parameters.

<details>

<summary>Optional parameters (9)</summary>

| Parameter              | Type                                                                                                                      | Default   | Description                                                                               |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------- | --------- | ----------------------------------------------------------------------------------------- |
| `status`               | one of `auto-draft`, `pending`, `processing`, `on-hold`, `completed`, `cancelled`, `refunded`, `failed`, `checkout-draft` | `pending` | Order status.                                                                             |
| `customer_id`          | integer                                                                                                                   | `0`       | User ID who owns the order. 0 for guests.                                                 |
| `customer_note`        | string                                                                                                                    |           | Note left by customer during checkout.                                                    |
| `billing`              | object                                                                                                                    |           | Billing address.                                                                          |
| `shipping`             | object                                                                                                                    |           | Shipping address.                                                                         |
| `payment_method`       | string                                                                                                                    |           | Payment method ID.                                                                        |
| `payment_method_title` | string                                                                                                                    |           | Payment method title.                                                                     |
| `set_paid`             | boolean                                                                                                                   | `false`   | Define if the order is paid. It will set the status to processing and reduce stock items. |
| `line_items`           | array of object                                                                                                           |           | Line items data.                                                                          |

</details>

<details>

<summary>Description sent to AI tools</summary>

> Create a WooCommerce order from customer details and line items. Use when asked to place or record an order manually. Line item `product_id` values come from `hostinger-ai/wc-products-search` and `customer_id` from `hostinger-ai/users-search`.

</details>

## Delete WooCommerce Order

`hostinger-ai/wc-orders-delete` · **Destructive** · Safe to retry

Move a WooCommerce order to the trash; it can be restored from the trash.

| Required parameter | Type    | Description                        |
| ------------------ | ------- | ---------------------------------- |
| `id`               | integer | Unique identifier for the resource |

<details>

<summary>Description sent to AI tools</summary>

> Move a WooCommerce order to the trash; it can be restored from the trash. Use when asked to remove an order. Needs `id` from `hostinger-ai/wc-orders-search`.

</details>

## Get WooCommerce Order

`hostinger-ai/wc-orders-get` · Read-only

Get one WooCommerce order by ID with all its fields.

| Required parameter | Type    | Description                        |
| ------------------ | ------- | ---------------------------------- |
| `id`               | integer | Unique identifier for the resource |

<details>

<summary>Description sent to AI tools</summary>

> Get one WooCommerce order by ID with all its fields. Use when you need the details of a known order. Needs `id` from `hostinger-ai/wc-orders-search`.

</details>

## Search WooCommerce Orders

`hostinger-ai/wc-orders-search` · Read-only

Search and filter WooCommerce orders by status, customer, product or date, with pagination.

No required parameters.

<details>

<summary>Optional parameters (9)</summary>

| Parameter  | Type                                                                                                                                        | Default | Description                                              |
| ---------- | ------------------------------------------------------------------------------------------------------------------------------------------- | ------- | -------------------------------------------------------- |
| `search`   | string                                                                                                                                      |         | Limit results to those matching a string.                |
| `status`   | array of `any`, `trash`, `auto-draft`, `pending`, `processing`, `on-hold`, `completed`, `cancelled`, `refunded`, `failed`, `checkout-draft` | `any`   | Limit result set to orders which have specific statuses. |
| `customer` | integer                                                                                                                                     |         | Limit result set to orders assigned a specific customer. |
| `product`  | integer                                                                                                                                     |         | Limit result set to orders assigned a specific product.  |
| `include`  | array of integer                                                                                                                            | `[]`    | Limit result set to specific ids.                        |
| `orderby`  | one of `date`, `id`, `include`, `title`, `slug`, `modified`                                                                                 | `date`  | Sort collection by object attribute.                     |
| `order`    | one of `asc`, `desc`                                                                                                                        | `desc`  | Order sort attribute ascending or descending.            |
| `per_page` | integer                                                                                                                                     | `10`    | Maximum number of items to be returned in result set.    |
| `page`     | integer                                                                                                                                     | `1`     | Current page of the collection.                          |

</details>

<details>

<summary>Description sent to AI tools</summary>

> Search and filter WooCommerce orders by status, customer, product or date, with pagination. Use when you need an order ID, or to find, list or count orders.

</details>

## Update WooCommerce Order

`hostinger-ai/wc-orders-update` · Changes the site · Safe to retry

Update the status or other editable fields of a WooCommerce order.

| Required parameter | Type    | Description                        |
| ------------------ | ------- | ---------------------------------- |
| `id`               | integer | Unique identifier for the resource |

<details>

<summary>Optional parameters (9)</summary>

| Parameter              | Type                                                                                                                      | Description                                                                               |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------- |
| `status`               | one of `auto-draft`, `pending`, `processing`, `on-hold`, `completed`, `cancelled`, `refunded`, `failed`, `checkout-draft` | Order status.                                                                             |
| `customer_id`          | integer                                                                                                                   | User ID who owns the order. 0 for guests.                                                 |
| `customer_note`        | string                                                                                                                    | Note left by customer during checkout.                                                    |
| `billing`              | object                                                                                                                    | Billing address.                                                                          |
| `shipping`             | object                                                                                                                    | Shipping address.                                                                         |
| `payment_method`       | string                                                                                                                    | Payment method ID.                                                                        |
| `payment_method_title` | string                                                                                                                    | Payment method title.                                                                     |
| `set_paid`             | boolean                                                                                                                   | Define if the order is paid. It will set the status to processing and reduce stock items. |
| `line_items`           | array of object                                                                                                           | Line items data.                                                                          |

</details>

<details>

<summary>Description sent to AI tools</summary>

> Update the status or other editable fields of a WooCommerce order. Setting the status to refunded does not refund the payment. Use when asked to fulfil, cancel or edit an order. Needs `id` from `hostinger-ai/wc-orders-search`.

</details>

## Get WooCommerce Coupons Report

`hostinger-ai/wc-reports-coupons-totals` · Read-only

Get the number of WooCommerce coupons by coupon type.

No parameters.

<details>

<summary>Description sent to AI tools</summary>

> Get the number of WooCommerce coupons by coupon type. Use when asked how many coupons the store has.

</details>

## Get WooCommerce Customers Report

`hostinger-ai/wc-reports-customers-totals` · Read-only

Get the number of WooCommerce customers, paying and non-paying.

No parameters.

<details>

<summary>Description sent to AI tools</summary>

> Get the number of WooCommerce customers, paying and non-paying. Use when asked how many customers the store has.

</details>

## Get WooCommerce Orders Report

`hostinger-ai/wc-reports-orders-totals` · Read-only

Get the number of WooCommerce orders by status.

No parameters.

<details>

<summary>Description sent to AI tools</summary>

> Get the number of WooCommerce orders by status. Use when asked how many orders the store has or how many are in each status.

</details>

## Get WooCommerce Products Report

`hostinger-ai/wc-reports-products-totals` · Read-only

Get the number of WooCommerce products by product type.

No parameters.

<details>

<summary>Description sent to AI tools</summary>

> Get the number of WooCommerce products by product type. Use when asked how many products the store has.

</details>

## Get WooCommerce Reviews Report

`hostinger-ai/wc-reports-reviews-totals` · Read-only

Get the number of WooCommerce product reviews by rating.

No parameters.

<details>

<summary>Description sent to AI tools</summary>

> Get the number of WooCommerce product reviews by rating. Use when asked how many reviews the store has or how they are rated.

</details>

## Get WooCommerce Sales Report

`hostinger-ai/wc-reports-sales` · Read-only

Get WooCommerce sales and revenue for a period, with totals for orders, items, tax, shipping and discounts.

No required parameters.

<details>

<summary>Optional parameters (3)</summary>

| Parameter  | Type                                         | Description                                                 |
| ---------- | -------------------------------------------- | ----------------------------------------------------------- |
| `period`   | one of `week`, `month`, `last_month`, `year` | Report period. Options: week, month, last\_month, year.     |
| `date_min` | string                                       | Return sales for a specific start date. Format: YYYY-MM-DD. |
| `date_max` | string                                       | Return sales for a specific end date. Format: YYYY-MM-DD.   |

</details>

<details>

<summary>Description sent to AI tools</summary>

> Get WooCommerce sales and revenue for a period, with totals for orders, items, tax, shipping and discounts. Use when asked how much the store sold or earned.

</details>

## Related

* [Abilities Reference](https://docs.hostinger.com/wordpress/hostinger-plugins/ai-plugin/abilities.md)
* [WordPress Site MCP Server](https://docs.hostinger.com/wordpress/hostinger-plugins/ai-plugin/mcp-server.md)
