Get Catalog Rule Price
get_catalog_rule_priceRetrieve indexed catalog rule price for a given SKU, website ID, and customer group for today. Reads from catalogrule_product_price index only; no live calculation.
Instructions
Returns indexed catalog rule price for a SKU on a website and customer group for today. Does NOT calculate rules live — reads catalogrule_product_price index only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | Yes | Product SKU. Use find_product_by_sku instead of guessing EAV table joins. | |
| profile | No | Override the MAGENTO_SQL_PROFILE env var for this call only. Use list_connection_profiles to see available names. | |
| website_id | No | Website ID for catalog rule price scope (default 1). | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. | |
| customer_group_id | No | Customer group ID for catalog rule price (default 0 = NOT LOGGED IN). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |