MANIFEST REF. PSCI–DRAFT–01Baseline window: Dec 2022 – Jul 2026 · Prepared for PGEP / CertLink

Layout concept — illustrative baseline, not a final score

Pacific Sustainable Commodities Index

Pillar Report

A working mock-up of how PSCI's five pillars could be reported from CertLink's own audit trail — farm-gate purchases, grower registrations, and internal compliance audits — before any indicator has been weighted into a composite score.

RouteVanuatu growers → CertLink → PGEP

Growers on file1,136

Audits on file454

Purchases logged251

Pillar 01 Price & Value Capture Baseline logged

Pillar 02 Market Access Baseline logged

Pillar 03 Organic & Certification Pending confirmation

Pillar 04 Livelihood & Social Data gap flagged

Pillar 05 Environmental Scoping

Pillar 01 — Price & Value Capture

What growers are actually paid

Farm-gate transactions against a world reference price, split by certification status.

Baseline
logged

Farm-gate transactions loggedGrowerpurchase, Dec 2022–Apr 2026	251
Organic-labelled purchasesGrowerpurchase.Cert = ORG	167 (66.5%)
Conventional-labelled purchasesGrowerpurchase.Cert = CON/CNV	84 (33.5%)
Reference price series trackedCommodity_Prices + Coconut_Price	5 commodities
Farm-gate ÷ world reference rationot yet calculable — reference series only 7 days deep	--

Purchases by certification status

Organic (ORG)167

Conventional (CON)79

Conventional, other (CNV)5

251 logged transactions, all-time to date.

Pillar 02 — Market Access

Who's connected to a buyer

Registration, contracts, and active buyer-network coverage across the grower base.

Baseline
logged

Registered growersGrowerSubscription	1,136
Signed farmer agreementFarmer_Agreement_Signed — coverage TBD	field present
Buyer network recorded per purchaseGrowerpurchase.Network / OPPCode	field present
Onboarding fully completeGrowerSubscription.SubscriptionComplete — coverage TBD	field present

1,136 growers registered across the network to date

Active-transacting-grower and onboarding-completion rates aren't computed yet — next pass once coverage on the fields above is confirmed.

Pillar 03 — Organic & Certification

Certified volume & compliance

Organic share of purchased volume, set against internal audit and compliance outcomes.

Pending
confirm

Internal audits on fileGrowerIA, Sep 2020–May 2026	454
Compliance status trackedGrowerIA.ComplianceStatus (Open/Closed)	per audit
Certification status fieldGrowerSubscription.EUstatus — needs confirming as source of truth over the ACO/NOP/EU booleans	6 states
Organic share of logged purchasesGrowerpurchase.Cert	66.5%

Why this pillar is "pending"

ACO_certifiedorganic reads false on all 1,136 grower records — almost certainly an unmaintained field rather than an accurate signal. Before this pillar reports a certified-grower count, confirm with the CertLink team whether EUstatus is the field actually kept current.

Pillar 04 — Livelihood & Social

Income, labour, and who's counted

Household income, labour conditions, and participation — including where the data goes quiet.

Data gap
flagged

Grower gender recordedGrowerSubscription.GrowerSexMF	475 of 1,136 (41.8%)
— of which femaleGrowerSexMF = Female	49 (10.3% of recorded)
Copra cutters on fileCopra_Cutters — flat rate	13, at $15/unit
Crop / livestock types tracked per growerGrowerSubscription, diversification proxy	20+ fields

Gender field coverage

Male426

Female49

Not recorded661

58% blank is the single largest data gap in the index — priority fix before Pillar 4 can report reliably.

Pillar 05 — Environmental

Land, and what's still missing

Certified land under management now; carbon, energy, and natural capital are next scope.

Scoping

Audits with certified area recordedGrowerIA.TotalCertifiedarea	374 of 454 (82.4%)
On-farm processing (own copra dryer)GrowerSubscription.Own_copra_dryer — coverage TBD	field present
Carbon indicatornot yet in schema — Pacific REDD+/blue-carbon benchmark proposed	scoping
Energy use & natural capitalnot yet in schema — with Ian	scoping

82% of internal audits have hectares on file — the strongest land-size figure available today

Data sources. Growerpurchase, GrowerSubscription, GrowerIA, Copra_Cutters, Commodity_Prices, Coconut_Price — CertLink / Caspio, pulled 29 Jul 2026. This page is a layout mock-up only; figures are real counts from the current database, not a computed or weighted index.

Draft · PSCI Working Group