Completions

Data-layer swarm · Product-catalog-canonicalization agent · Versioned-product-history skill · Build pillar · Published July 12, 2026

How to build versioned product history for recall traceability across multi-vendor supply chains

Multi-vendor multi-banner operators running recall-sensitive supply chains work above a strong PIM + traceability + bitemporal- storage + GS1 EPCIS primitives layer (Akeneo + Salsify + Inriver + Bluestone PIM + Pimcore + Stibo Systems + Riversand + Contentserv + Plytix + Productsup for PIM; Trustwell FoodLogiQ + ReposiTrak + Wherefour + iTradeNetwork + IBM Food Trust + SAP Track and Trace + Oracle + Optel for traceability; Snowflake Time Travel + Apache Iceberg + Delta Lake + Apache Hudi + XTDB + Datomic + CrateDB + MarkLogic + Cassandra time-series + Clickhouse time-series for bitemporal storage). The orchestration that sits above those primitives — a bitemporal version graph spanning system time, business valid time, and effective time; per-SKU recall cohort resolution with temporal and spatial bounding; per-SKU supplier- to-shelf chain-of-custody via GS1 EPCIS plus FSMA-204 KDE/CTE plus FDA DSCSA T3; a multi-LLM pre-publish substantiation check; a feedback loop; a per-SKU compliance gate — is operator-side architecture. This guide explains how to architect the versioned-product-history skill on the product-catalog- canonicalization agent end-to-end.

What you will build

  • A per-SKU per-lot per-batch bitemporal version graph that tracks system time, business valid time, and effective time on an operator-chosen bitemporal store (Snowflake Time Travel, Apache Iceberg, Delta Lake, Apache Hudi, XTDB, Datomic, CrateDB, MarkLogic, Cassandra time-series, or Clickhouse time-series). Per-attribute history covers name, description, ingredient, nutrition, allergen, country of origin, HTS code, NAFTA/USMCA certificate, CPSIA classification, FDA 21 CFR Part 117 attribution, and FDA Title 21 attribution.
  • A per-attribute change-trigger registry that records the cause of every attribute change (supplier change, formulation change, packaging change, label change, pricing change, policy change) with operator-data-team-maintained taxonomy.
  • A per-SKU recall cohort resolution engine that turns a recall trigger (FDA Class I/II/III, USDA FSIS, CPSC, NHTSA 49 CFR Part 573, EPA FIFRA, DEA controlled substance) into a temporally-bounded (manufacture-date window, sale-date window, best-by window) and spatially-bounded (banner, location, DMA, state) cohort, with handoffs to POS receipt integration for loyalty-purchase identification and to lifecycle orchestration for customer notification.
  • A per-SKU supplier-to-shelf chain-of-custody layer that captures every change-of-custody event via GS1 EPCIS standards-compliant objects, with FSMA-204 Key Data Elements and Critical Tracking Events for foods on the Food Traceability List and FDA DSCSA T3 records for prescription drugs.
  • A multi-LLM pre-publish substantiation checkensembling multiple vendor LLM APIs for ingredient claim substantiation, nutrition claim substantiation, allergen disclosure, recall disclosure, FTC substantiation, Lanham Act comparative-advertising consistency, Prop 65 disclosure, and privacy regime compliance, with self-consistency checks and chain-of-thought extraction.
  • A per-SKU compliance gate anchored on FDA FSMA-204 KDE/CTE, FDA DSCSA T3, GS1 EPCIS, FDA 21 CFR Part 11 electronic records, agency-specific recall regimes (FDA Class I/II/III, USDA FSIS, CPSC CPSIA, NHTSA 49 CFR Part 573, EPA FIFRA, DEA CSA), and temporal/spatial cohort bounding, extended to FDA 21 CFR Part 117 + FDA Title 21 + Lanham Act + FTC substantiation + FTC MARS + Prop 65 + CCPA/CPRA + GDPR + COPPA + EU AI Act + NIST AI RMF + ISO 42001/27001 + SOC 2 Type II + Sarbanes-Oxley Section 302/404 via policy-as-code (OPA Rego, AWS Cedar, Casbin, Cerbos, Oso) that operator counsel reviews.
  • A feedback loop comparing realized vs projected recall cohorts, customer notification delivery, recall cost, and supplier corrective action; bitemporal version graph drift detection; chain-of-custody and attribute history completeness recalibration; emerging supplier risk detection.
  • Cross-skill handoffs and an audit trail to siblings on the product-catalog-canonicalization agent and broader swarm, with audit trail to operator-controlled WORM storage at per-statute retention windows (FDA 2-year traceability, USDA 3-year traceability, DEA 5-year traceability, IRS 7-year) operator counsel sets.

Where the orchestration above PIM, traceability, and bitemporal- storage primitives compounds at multi-vendor supply-chain scale

The vendor primitives are strong. PIM vendors ship per-SKU current-state attribute records. Traceability vendors ship per-event records along the supply chain. Bitemporal storage engines ship time-travel queries. GS1 EPCIS ships interoperable event capture standards. The orchestration above those primitives is what compounds at multi-vendor multi- banner scale.

The first operationally distinctive constraint is FDA FSMA-204. The Final Rule on Requirements for Additional Traceability Records for Certain Foods on the Food Traceability List requires Key Data Elements at every Critical Tracking Event from harvest through receiving. The per-SKU gate emits KDE per CTE in the operator format and stores the linkage as a first- class object so a recall request can be answered in the timeframe regulators expect.

The second distinctive constraint is FDA DSCSA. The Drug Supply Chain Security Act requires T3 (Transaction Information, Transaction History, Transaction Statement) at every change of ownership for prescription drug SKUs, with interoperable electronic tracing at the package level. The per-SKU gate routes pharmaceutical SKUs through the DSCSA workflow and preserves the T3 chain alongside the bitemporal version graph.

The third distinctive constraint is GS1 EPCIS. The industry standard for chain-of-custody event capture is GS1 EPCIS; the per-SKU gate emits standards-compliant EPCIS events so trading partners across the supply chain can consume them without per-partner translation.

The fourth distinctive constraint is FDA 21 CFR Part 11. When versioned product history acts as the regulatory record of record, Part 11 governs the audit trail, the access controls, and the signature evidence. The per-SKU gate enforces Part 11 controls on every bitemporal write.

The fifth distinctive constraint is the per-agency recall regime. FDA Class I/II/III food-safety and drug recalls under 21 CFR Part 7; USDA FSIS recalls for meat, poultry, and processed-egg products; CPSC CPSIA recalls for children’s products under 16 CFR Part 1101 et seq; NHTSA 49 CFR Part 573 defect and noncompliance recalls for motor-vehicle equipment; EPA FIFRA recalls for pesticides; DEA Controlled Substances Act recalls for scheduled drugs. The per-SKU gate routes per-agency triggers to per-agency workflows operator counsel approves.

The sixth distinctive constraint is temporal and spatial cohort bounding. A recall cohort is not just a SKU; it is a SKU plus a manufacture-date window plus a sale-date window plus a best-by window plus a banner/location/DMA/state spatial footprint. The per-SKU gate computes the cohort against the bitemporal version graph and emits a defensible cohort definition with confidence and explainability surfaces.

Beyond the six anchors, the per-SKU gate also covers FDA 21 CFR Part 117 food safety; FDA Title 21 cosmetics; FDA Drug Listing under Section 510(j); USDA FSIS labeling rules; FTC substantiation doctrine and FTC MARS multi-location claim consistency; Lanham Act false advertising and comparative- advertising consistency; California Prop 65; CCPA/CPRA + GDPR + PIPEDA + CASL + LGPD + DPDP when traceability data joins customer identity for notification; EU AI Act Articles 13/14 when the recall trigger engine drives automated customer decisions; NIST AI RMF + ISO 42001 + ISO 27001 + SOC 2 Type II; Sarbanes-Oxley Section 302/404 for inventory and product- information accounting controls. The gate is policy-as-code on OPA Rego, AWS Cedar, Casbin, Cerbos, or Oso; operator counsel reviews rule updates.

The real ecosystem the orchestration sits above

PIM primitives

Akeneo, Salsify, Inriver, Bluestone PIM, Pimcore, Stibo Systems, Riversand, Contentserv, Plytix, Productsup. Strong primitives for per-SKU current-state attribute records. The bitemporal version graph and per-attribute change-trigger registry sit above this layer.

Traceability primitives

Trustwell FoodLogiQ, ReposiTrak, Wherefour, iTradeNetwork, IBM Food Trust, SAP Track and Trace, Oracle traceability, Optel. Strong primitives for per-event records along the supply chain. The per-SKU supplier-to-shelf chain-of-custody layer with GS1 EPCIS + FSMA-204 KDE/CTE + FDA DSCSA T3 sits above this layer.

Bitemporal storage primitives

Snowflake Time Travel, Apache Iceberg, Delta Lake, Apache Hudi, XTDB, Datomic, CrateDB, MarkLogic, Cassandra time-series, Clickhouse time-series. Strong primitives for time-travel queries against historical state. The per-SKU version graph spanning system time + business valid time + effective time sits above this layer.

Compliance-tooling primitives

Hyperproof + Drata + Vanta + Thoropass for SOC 2 / ISO control evidence; OneTrust + TrustArc + Ketch + Securiti + BigID for privacy program tooling; AccessiBe + UserWay + AudioEye + Level Access + Siteimprove for accessibility tooling. Strong primitives. The per-SKU compliance overlay coordinates them via a policy-as-code gate (OPA Rego, AWS Cedar, Casbin, Cerbos, Oso) that operator counsel reviews.

How the architecture is built

  1. Bitemporal storage substrate. Choose a bitemporal store (Snowflake Time Travel, Apache Iceberg, Delta Lake, Apache Hudi, XTDB, Datomic, CrateDB, MarkLogic, Cassandra time-series, or Clickhouse time-series). Subscribe to PIM webhooks and CDC streams for per-SKU attribute changes and to traceability vendor APIs for per-event records.
  2. Per-SKU version graph. Encode system time, business valid time, and effective time as first-class dimensions. Write every attribute change as a versioned record with the change trigger taxonomy operator data and counsel jointly maintain.
  3. Per-SKU supplier-to-shelf chain-of-custody.Emit GS1 EPCIS events at every change of custody. Layer FSMA-204 KDE and CTE fields on foods on the Food Traceability List. Layer FDA DSCSA T3 records on prescription drugs. Validate per-partner conformance.
  4. Per-SKU recall cohort resolution engine.Accept a recall trigger from FDA, USDA, CPSC, NHTSA, EPA, or DEA workflows. Bound the cohort temporally (manufacture-date, sale-date, best-by) and spatially (banner, location, DMA, state). Join to the bitemporal version graph for affected SKU versions. Hand off to POS receipt integration for loyalty- purchase identification and to lifecycle orchestration for customer notification.
  5. Multi-LLM pre-publish substantiation check.Ensemble multiple vendor LLM APIs for ingredient claim, nutrition claim, allergen disclosure, recall disclosure, FTC substantiation, Lanham Act comparative advertising, Prop 65 disclosure, and privacy regime cross-checks. Run self- consistency checks. Extract chain-of-thought to the audit trail.
  6. Per-SKU compliance gate. Express the gate as policy-as-code on OPA Rego, AWS Cedar, Casbin, Cerbos, or Oso. Encode the six distinctive anchors (FSMA-204, DSCSA, GS1 EPCIS, FDA 21 CFR Part 11, agency-specific recall regimes, temporal and spatial cohort bounding) plus the broader compliance surface. Operator counsel reviews every rule update.
  7. Feedback loop. Compare realized vs projected recall cohorts, customer notification delivery, recall cost, and supplier corrective action. Detect drift in the bitemporal version graph. Recalibrate chain-of-custody and attribute history completeness. Surface emerging supplier risk patterns.
  8. Cross-skill handoffs. Hand off to siblings on the product-catalog-canonicalization agent (product traceability software, product catalog canonicalization, per-SKU canonical master record, per-channel description adaptation, per-vendor attribute mapping, per-SKU image asset management) and across the broader swarm (POS receipt integration, versioned history for regulatory defense, lifecycle flow architecture, push-channel extension, customer data graph, routing audit trail, integration health monitoring, attribution rollup, brand-voice management, forbidden-phrase library).
  9. Audit trail. Emit a per-SKU canonical audit record to operator-controlled WORM storage (AWS S3 Object Lock, GCS retention, Azure Blob immutable, Snowflake Time Travel) with per-statute retention windows operator counsel sets (FDA 2-year traceability, USDA 3-year traceability, DEA 5-year traceability, IRS 7-year).

Frequently asked

What does versioned product history for recall traceability do that a PIM current-state record does not?

Product information management vendors (Akeneo, Salsify, Inriver, Bluestone PIM, Pimcore, Stibo Systems, Riversand, Contentserv, Plytix, Productsup) ship strong primitives for per-SKU current-state attribute records. Traceability vendors (Trustwell FoodLogiQ, ReposiTrak, Wherefour, iTradeNetwork, IBM Food Trust, SAP Track and Trace, Oracle, Optel) ship strong primitives for per-event traceability records. Versioned product history sits above this layer for multi-vendor multi-banner operators running recall-sensitive supply chains, and adds: a bitemporal versioning layer that tracks system time (when a record was stored), business valid time (when an attribute value was effective in the real world), and effective time (when a downstream system should treat the value as live), running on a bitemporal storage engine the operator chooses (Snowflake Time Travel, Apache Iceberg, Delta Lake, Apache Hudi, XTDB, Datomic, CrateDB, MarkLogic, Cassandra time-series, or Clickhouse time-series); a per-SKU version graph that records every attribute change (name, description, ingredient, nutrition, allergen, country of origin, Harmonized Tariff Schedule code, NAFTA/USMCA certificate, CPSIA toy/children classification, FDA 21 CFR Part 117 food-safety attribution, FDA Title 21 cosmetics attribution) with the change trigger (supplier change, formulation change, packaging change, label change, pricing change, policy change); a recall cohort resolution engine that turns a recall trigger (FDA Class I/II/III, USDA FSIS, CPSC, NHTSA 49 CFR Part 573, EPA FIFRA, DEA controlled substance) into a temporally-bounded (manufacture-date window, sale-date window, best-by window) and spatially-bounded (banner, location, DMA, state) cohort, with handoffs to POS receipt integration to identify affected loyalty purchasers and to lifecycle orchestration to deliver customer notification; a supplier-to-shelf chain-of-custody layer that joins per-supplier, per-manufacturer, per-co-manufacturer, per-distributor, per-warehouse, per-DC, per-3PL, per-transport-leg, per-location-receiving, and per-shelf-placement events via GS1 EPCIS (Electronic Product Code Information Services) with FSMA-204 Key Data Elements (KDE) and Critical Tracking Events (CTE) and FDA DSCSA T3 (Transaction Information, Transaction History, Transaction Statement) for pharmaceutical SKUs; a multi-LLM pre-publish check that cross-checks ingredient claim substantiation, nutrition claim substantiation, allergen disclosure, recall disclosure, FTC substantiation, Lanham Act comparative advertising, Prop 65 disclosure, and privacy regime compliance; a per-SKU compliance gate (covered in the next answer); a feedback loop that compares realized recall cohorts, customer notification, recall cost, and supplier corrective action against projection and recalibrates the trigger and version-graph models; and an audit trail to operator-controlled WORM storage at per-statute retention windows.

What are the operationally distinctive compliance anchors for multi-vendor recall traceability, and how does the per-SKU compliance gate cover them?

Six anchors sit at the operational center of multi-vendor recall traceability that off-the-shelf catalog compliance overlays often miss. Anchor 1 — FDA FSMA-204 (Food Safety Modernization Act Section 204). The Final Rule on Requirements for Additional Traceability Records for Certain Foods on the Food Traceability List requires Key Data Elements (KDE) at every Critical Tracking Event (CTE) from harvest through receiving. The per-SKU gate emits KDE per CTE in the operator format and stores the linkage as a first-class object so a recall request can be answered in the timeframe regulators expect. Anchor 2 — FDA DSCSA (Drug Supply Chain Security Act). The Act requires T3 (Transaction Information, Transaction History, Transaction Statement) at every change of ownership for prescription drug SKUs, with interoperable electronic tracing at the package level. The per-SKU gate routes pharmaceutical SKUs through the DSCSA workflow and preserves the T3 chain alongside the bitemporal version graph. Anchor 3 — GS1 EPCIS (Electronic Product Code Information Services). The industry standard for chain-of-custody event capture is GS1 EPCIS; the per-SKU gate emits standards-compliant EPCIS events so trading partners across the supply chain can consume them without per-partner translation. Anchor 4 — FDA 21 CFR Part 11 electronic records and electronic signatures. When versioned product history acts as the regulatory record of record, Part 11 governs the audit trail, the access controls, and the signature evidence. The per-SKU gate enforces Part 11 controls on every bitemporal write. Anchor 5 — agency-specific recall regimes. FDA Class I/II/III food-safety and drug recalls under 21 CFR Part 7; USDA FSIS recalls for meat, poultry, and processed-egg products; CPSC CPSIA recalls for children’s products under 16 CFR Part 1101 et seq; NHTSA 49 CFR Part 573 defect and noncompliance recalls for motor-vehicle equipment; EPA FIFRA recalls for pesticides; DEA Controlled Substances Act recalls for scheduled drugs. The per-SKU gate routes per-agency triggers to per-agency workflows operator counsel approves. Anchor 6 — temporal and spatial cohort bounding. A recall cohort is not just a SKU; it is a SKU plus a manufacture-date window plus a sale-date window plus a best-by window plus a banner/location/DMA/state spatial footprint. The per-SKU gate computes the cohort against the bitemporal version graph and emits a defensible cohort definition. Beyond the six anchors, the per-SKU gate also covers FDA 21 CFR Part 117 food safety; FDA Title 21 cosmetics; FDA Drug Listing under Section 510(j); USDA FSIS labeling rules; FTC substantiation doctrine and FTC MARS multi-location claim consistency; Lanham Act false advertising and comparative-advertising consistency; California Prop 65; CCPA/CPRA + GDPR + PIPEDA + CASL + LGPD + DPDP when traceability data joins customer identity for notification; EU AI Act Articles 13/14 when the recall trigger engine drives automated customer decisions; NIST AI RMF + ISO 42001 + ISO 27001 + SOC 2 Type II; Sarbanes-Oxley Section 302/404 for inventory and product-information accounting controls. The gate is policy-as-code on OPA Rego, AWS Cedar, Casbin, Cerbos, or Oso, with operator counsel reviewing rule updates.

How do bitemporal versioning, recall cohort resolution, and supplier-to-shelf chain-of-custody actually work?

Bitemporal versioning tracks three orthogonal time dimensions. System time records when a write hit the store. Business valid time records when the attribute value was effective in the real world (a supplier formulation change effective on a manufacture date that precedes the write). Effective time records when a downstream system should treat the value as live (a label-change rollout that is staged before becoming current). The engine writes each attribute change as a versioned record on a bitemporal store the operator chooses (Snowflake Time Travel, Apache Iceberg, Delta Lake, Apache Hudi, XTDB, Datomic, CrateDB, MarkLogic, Cassandra time-series, or Clickhouse time-series). Queries can ask "what was the ingredient as of manufacture date X" or "what was the allergen disclosure that was effective when this batch shipped" without ambiguity. Recall cohort resolution starts from a recall trigger and bounds the affected population in time and space. Temporal bounds combine manufacture-date window, sale-date window, and best-by window. Spatial bounds combine banner, location, DMA, and state. The cohort engine joins to the bitemporal version graph to determine which SKU versions are in scope, joins to the POS receipt integration to identify affected loyalty purchasers, and joins to lifecycle orchestration to deliver customer notification through email, SMS, push, and outbound call channels. Supplier-to-shelf chain-of-custody captures every change-of-custody event from supplier through manufacturer, co-manufacturer, distributor, warehouse, DC, 3PL, transport leg, location receiving, and shelf placement. Events are recorded as GS1 EPCIS-compliant objects with FSMA-204 KDE and CTE fields for foods on the Food Traceability List, and as FDA DSCSA T3 records for prescription drugs. The per-SKU confidence tier and explainability surface ride alongside every event so the audit trail captures both what happened and how the system knew.

How do the multi-LLM pre-publish check, feedback loop, and cross-skill handoffs work?

The multi-LLM pre-publish check ensembles multiple vendor LLM APIs to cross-check ingredient claim substantiation, nutrition claim substantiation, allergen disclosure, FDA Class I/II/III recall disclosure, USDA FSIS recall disclosure, CPSC recall disclosure, NHTSA recall disclosure, EPA FIFRA recall disclosure, FTC substantiation, Lanham Act comparative-advertising consistency, Prop 65 disclosure, and CCPA/CPRA/GDPR/PIPEDA/CASL/LGPD/DPDP requirements. Self-consistency checks and chain-of-thought extraction provide an explainability surface that the audit trail captures. The feedback loop compares realized vs projected recall cohorts, customer notification delivery, recall cost, and supplier corrective action; it detects drift in the bitemporal version graph; it recalibrates chain-of-custody completeness, attribute history completeness, supplier quality signal, and co-manufacturer quality signal; and it surfaces emerging supplier risk patterns plus recall-trigger model recalibration. Cross-skill handoffs route to siblings on the product-catalog-canonicalization agent (product traceability software commercial pillar, product catalog canonicalization, per-SKU canonical master record, per-channel description adaptation, per-vendor attribute mapping, per-SKU image asset management) and across the broader swarm (POS receipt integration, versioned history for regulatory defense, lifecycle flow architecture, push-channel extension, customer data graph, routing audit trail, integration health monitoring, attribution rollup, brand-voice management, forbidden-phrase library).

What does Completions report on a Tier 3 engagement that covers versioned product history for recall traceability?

Tier 3 engagements report against a pre-engagement baseline that the Tier 1 assessment establishes for the operator stack. The reporting cycle covers six workstreams: (1) per-SKU per-lot per-batch ingestion coverage observed across the operator PIM + traceability + bitemporal-storage surface, with per-source event-emission completeness reported; (2) bitemporal version graph completeness observed across system time + business valid time + effective time, with per-attribute change-trigger diagnostics reported; (3) recall cohort resolution surface observed against operator-counsel-reviewed temporal and spatial bound definitions, with per-agency-trigger diagnostics reported; (4) supplier-to-shelf chain-of-custody completeness observed across the per-event surface, with GS1 EPCIS + FSMA-204 KDE/CTE + FDA DSCSA T3 conformance reported per partner; (5) multi-LLM pre-publish check surface observed against operator-labeled holdouts, with per-claim substantiation diagnostics reported; (6) per-SKU compliance gate pass rate observed across FDA FSMA-204 + FDA DSCSA + FDA 21 CFR Part 11 + FDA 21 CFR Part 117 + FDA Title 21 + USDA FSIS + CPSC CPSIA + NHTSA 49 CFR Part 573 + EPA FIFRA + DEA CSA + FTC substantiation + FTC MARS + Lanham Act + Prop 65 + CCPA/CPRA + GDPR + PIPEDA + CASL + LGPD + DPDP + EU AI Act Articles 13/14 + NIST AI RMF + ISO 42001/27001 + SOC 2 Type II + Sarbanes-Oxley Section 302/404 scope. Caveats: PIM/traceability vendor API rate limits, bitemporal-store query budget, GS1 EPCIS partner conformance, LLM-vendor availability, agency rulemaking changes (FSMA-204 enforcement timing, DSCSA implementation milestones), and per-statute retention windows shifting with operator counsel policy sit outside Completions control and are reported alongside observed performance; attorney-client privilege on counsel-reviewed recall-trigger definitions and substantiation records is preserved through every layer of the reporting cycle. Completions does not commit to fixed numeric SLAs on ingestion coverage, version-graph completeness, recall-resolution time, chain-of-custody completeness, or compliance pass rate when those KPIs depend on vendor performance, partner conformance, or counsel policy decisions.

Engage Completions

Start with the AI Readiness Assessment (Tier 1, 2-3 weeks). If the operation is ready to absorb the versioned-product- history skill on the product-catalog-canonicalization agent, the assessment hands off to the AI Swarm Setup Sprint (Tier 2, 4-8 weeks). If the operation needs ongoing orchestration after Tier 2 hand-off, the skill continues under Fractional CMO with AI Swarm (Tier 3, 6-month minimum, 1-2 days/wk embedded). Operator owns every artifact at every tier. Operator can in-house at any time.