get_product_overrides_by_website
Retrieve product price overrides for all customer groups across a website. Get pricing data for every customer segment in a single request.
Instructions
Get product overrides for all customer groups in a website.
This retrieves price overrides for all customer groups, not just one.
Useful when you need to see pricing across all customer segments.
Args:
environment_id: Adobe Commerce Cloud environment ID
website_code: Website code (e.g., 'base')
skus: List of product SKUs to retrieve overrides for
filter_virtual_cgs: Filter out virtual customer groups (default: False)
use_tls: Whether to use TLS connection (default: True)
timeout: Request timeout in seconds (default: 15.0)
Returns:
Dict containing product overrides with keys:
- overrides: List of product override dictionaries (all customer groups), each containing:
- customer_group_code: SHA1 hash of customer group ID
Use get_customer_group_id_from_code() to decode to numeric ID
Common hashes:
'b6589fc6ab0dc82cf12099d1c2d40ab994e8410c' = ID 0 (NOT LOGGED IN)
'356a192b7913b04c54574d18c28d46e6395428ab' = ID 1 (General/Logged In)
'da4b9237bacccdf19c0760cab7aec4a8359010b0' = ID 2 (Wholesale)
- sku, website_code, currency, prices, tier_prices, etc.
- count: Number of overrides retrieved
- status: Success or error status
Example:
>>> result = get_product_overrides_by_website.invoke({
... 'environment_id': 'abc123',
... 'website_code': 'base',
... 'skus': ['SKU123']
... })
>>> # Returns overrides for all customer groups
>>> for override in result['overrides']:
... group_id = get_customer_group_id_from_code(override['customer_group_code'])
... print(f"Group ID {group_id}: {override['customer_group_code']}, Price: {override['prices']}")
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skus | Yes | ||
| timeout | No | ||
| use_tls | No | ||
| website_code | Yes | ||
| environment_id | Yes | ||
| filter_virtual_cgs | No |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |