Sold Products Tools

MCP tools for querying sold products — product catalog, periods, and Scope 3 Cat 11 emissions

Sold Products Tools

Query sold product data — product definitions, reporting periods, and per-country Scope 3 Category 11 (“Use of Sold Products”) emissions. These tools complement get_use_of_product_emissions which returns pre-aggregated emission totals.

For aggregated Scope 3 “Use of Sold Products” totals, use get_use_of_product_emissions. The tools below expose the underlying data collection — individual products, their reporting periods, and detailed per-country emissions.

list_sold_products

List all sold products for an organization. No pagination — returns the full product catalog.

Parameters:

Parameter	Type	Required	Default	Description
name	string	No	—	Filter by product name (contains match)
organization_id	string	No	default org	Organization UUID

Example response:

{
  "items": [
    {
      "id": "sp-uuid-...",
      "name": "Industrial Motor EM-500",
      "category": "electrical_equipment",
      "organization_id": "org-uuid-..."
    },
    {
      "id": "sp-uuid-2-...",
      "name": "Heat Pump HP-200",
      "category": "hvac",
      "organization_id": "org-uuid-..."
    }
  ]
}

Key response fields:

Field	Description
name	Product name or model
category	Product category classification

Example prompts:

"List all sold products"
"Which sold products match 'motor'?"
"Show me the product catalog for this organization"

---

get_sold_product_periods

Get all reporting periods for a sold product. Each period represents a date range during which the product was sold in specific countries and quantities.

Parameters:

Parameter	Type	Required	Default	Description
sold_product_id	string	Yes	—	Sold product UUID
organization_id	string	No	default org	Organization UUID

Example response:

{
  "items": [
    {
      "id": "period-uuid-...",
      "start_date": "2025-01-01",
      "end_date": "2025-06-30",
      "sold_product_id": "sp-uuid-..."
    },
    {
      "id": "period-uuid-2-...",
      "start_date": "2025-07-01",
      "end_date": "2025-12-31",
      "sold_product_id": "sp-uuid-..."
    }
  ]
}

Key response fields:

Field	Description
start_date	Period start date (YYYY-MM-DD)
end_date	Period end date (YYYY-MM-DD)

Example prompts:

"What reporting periods exist for this product?"
"Show me the periods for the EM-500 motor"

---

get_sold_product_period_emissions

Get detailed Scope 3 emissions for a specific reporting period of a sold product. Returns per-country breakdowns and emission factors used.

Parameters:

Parameter	Type	Required	Default	Description
sold_product_id	string	Yes	—	Sold product UUID
period_id	string	Yes	—	Period UUID
organization_id	string	No	default org	Organization UUID

Example response:

{
  "total_co2e": 12.5,
  "items": [
    {
      "country": "ES",
      "units_sold": 500,
      "co2e": 8.0,
      "emission_factor": 0.016
    },
    {
      "country": "FR",
      "units_sold": 300,
      "co2e": 4.5,
      "emission_factor": 0.015
    }
  ]
}

Key response fields:

Field	Description
total_co2e	Total emissions for this period (tCO2e)
country	ISO 3166-1 alpha-2 country code
units_sold	Number of units sold in that country
co2e	Emissions for that country (tCO2e)
emission_factor	Emission factor applied per unit

Example prompts:

"What are the emissions for this product in H1 2025?"
"Show per-country emissions breakdown for period X"
"Which country has the highest emissions for this product?"

---

Workflow

A typical workflow for analyzing sold product emissions:

1. list_sold_products — find the product of interest
2. get_sold_product_periods — see reporting periods for that product
3. get_sold_product_period_emissions — get detailed per-country emissions for a period
4. get_use_of_product_emissions — compare with aggregated Scope 3 Cat 11 totals

get_sold_product_period_emissions shows emissions for one product and one period. For organization-wide Scope 3 Cat 11 totals across all products, use get_use_of_product_emissions or get_greenhouse_gas_emissions with a use_of_product_* category.

Related

Emissions Tools

Aggregated GHG emissions and validated views

Waste Water Tools

Wastewater treatment records and emissions