Get Product Attributes
get_product_attributesRetrieves common EAV attributes (name, price, status, visibility, url_key) for a product SKU, using store scope fallback to get accurate frontend values.
Instructions
Returns common EAV attributes (name, price, status, visibility, url_key) for a SKU with store scope fallback. Does NOT return all attributes — use get_eav_attribute + execute_select_query for custom attributes.
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. | |
| store_id | No | Store ID for scoped EAV values (0 = admin default, use store view ID for frontend values). | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |