Order Trust Column

TrustLens integrates directly into the WooCommerce orders list by adding a Trust column. Every order shows the customer’s trust score and segment badge inline with the other order data, sortable and filterable by segment. This means moderation context is visible everywhere you already work with orders — no need to context-switch to a separate page to see who’s behind an order.

---

What the Column Shows #

For each order in the WooCommerce orders list:

• The customer’s segment badge (color-coded)
• The customer’s trust score
• Click-through to the TrustLens customer detail page

The values are read from the customer’s record at the time of page load — so they reflect the customer’s current trust score, not the score at the time the order was placed. For historical-state context, see the order-edit-page integration described below.

---

Sorting and Filtering #

The Trust column header is clickable to sort by trust score ascending or descending. The orders list filter bar adds a segment filter — show only orders from VIP, Trusted, Caution, Risk, etc.

Common workflow patterns enabled by sort/filter:

• Daily moderation: Filter to Risk + Critical orders, sort by date desc, review one by one
• VIP fast-track: Filter to VIP orders, ensure fulfillment is prioritized
• Risk cohort fulfillment hold: Filter to Risk orders, bulk update status to On Hold pending review

---

The Order Edit Page #

Open any order in the WooCommerce admin. Alongside the standard order meta boxes, TrustLens adds a meta box showing:

• Customer’s current trust score and segment
• Customer’s trust score at the time of this order — useful for confirming what TrustLens knew at the moment
• Top 3 signals contributing to the current score
• Recent events on the customer (last 5 timeline entries)
• Quick actions: View Customer Profile, Block, Allowlist, Generate Evidence Report (Pro)

This is the right place to make per-order moderation decisions. You see the customer’s risk in context with the order’s specifics (amount, items, shipping address) and can act without leaving the order page.

---

Why Current Score, Not Score-at-Order-Time? #

The Trust column shows current score because the most common workflow question is “should I act on this order now?” — and that depends on the customer’s current state, not their historical state.

The order edit page shows both numbers so post-hoc analysis is possible: “the customer was Trusted when they placed this order but is now Critical — what changed?”

---

Enabling and Disabling the Column #

The Trust column is enabled by default. WordPress’s standard screen-options menu on the orders list page lets users hide it per-user if they don’t want to see it:

1. Open the WooCommerce orders list
2. Click Screen Options in the top-right
3. Uncheck Trust

The setting is per-user, so different team members can have different column visibility.

To disable the column globally for all users: TrustLens → Settings → General → Show Trust column on orders list.

---

HPOS Compatibility #

The Trust column works on both legacy and HPOS (High-Performance Order Storage) order tables. TrustLens declares HPOS compatibility on activation, so WooCommerce’s compatibility checks pass without modification.

If you’ve migrated from legacy to HPOS, the Trust column continues to work without any TrustLens-side intervention. The column reads from the customer record (which is TrustLens-owned), not from order meta.

---

The Performance Story #

Adding a custom column to the WooCommerce orders list can be a performance trap if it triggers extra queries per order. TrustLens handles this with a single bulk lookup:

1. When the orders list renders, TrustLens collects all billing-email hashes for the visible orders (typically 20 per page)
2. One indexed query against the customers table fetches scores and segments for all of them at once
3. The cache is held for the duration of the page render
4. Each row’s Trust column reads from the in-memory cache

Net cost: one additional query per page load, regardless of how many orders are displayed. Negligible.

---

What About Orders Without a Customer Record? #

For orders from customers below the minimum-orders threshold (no TrustLens record yet), the Trust column shows “—” or a “New” badge. These customers haven’t accumulated enough order history to be scored.

For orders from guest checkouts where the email doesn’t match any TrustLens customer, same display.

---

Bulk Actions from the Orders List #

TrustLens doesn’t add bulk actions to the WooCommerce orders list itself — WooCommerce’s bulk action surface is reserved for order-level actions (mark complete, refund, etc.). For customer-level bulk actions, use the Customers list.

However, if you want to bulk-block customers based on their order activity, the workflow is:

1. On the WooCommerce orders list, filter to the relevant order cohort (e.g. recently disputed orders)
2. Note the customers
3. Go to the TrustLens Customers list
4. Search for or filter to those customers
5. Bulk Block

---

Color Reference #

Segment	Color	Quick Read
VIP	Green	Premium order — handle carefully
Trusted	Blue	Reliable customer — normal processing
Normal	Gray	Average — normal processing
Caution	Yellow	Watch — review on suspicion
Risk	Orange	Investigate before processing
Critical	Red	Hold for review or block

Same colors as elsewhere in TrustLens, so segment recognition transfers across admin contexts.