Trigger: A daily batch of finalized purchase orders (POs) is exported from the retail ERP (e.g., SAP, NetSuite) or procurement system.
Context/Data Pulled: An AI agent retrieves the PO batch file. For each line item, it extracts:
- Supplier ID
- Product SKU or category code
- Quantity
- Spend amount
- Origin country (from supplier master data)
Model/Agent Action: The agent performs a multi-step classification and calculation:
- Supplier Matching: Links the Supplier ID to a master supplier record in the ESG platform (e.g., Novata Data Hub), retrieving any existing supplier-specific emission factors.
- Spend-Based Categorization: For suppliers without primary data, the agent uses NLP on the product description/SKU to categorize the spend into relevant CPA or SPSC codes.
- Emission Factor Application: Applies the appropriate region and category-specific emission factor (e.g., from EXIOBASE, DEFRA) to the spend data.
- Calculation & Validation: Calculates the CO2e, flags any line items where categorization confidence is low or where spend/quantity ratios are outliers for manual review.
System Update: The agent posts the calculated emissions data, tagged by supplier and product category, to the designated table in the carbon accounting platform (e.g., Sweep, Persefoni).
Human Review Point: A weekly report is generated for the sustainability analyst, highlighting flagged items, new suppliers added, and a summary of the calculated footprint for approval before inclusion in the reporting period.