Skip to content

URS-027 · Auto-notify distributors on applicable order types

Status: PASS  ·  Duration: 1m 6s  ·  Run Date: April 21, 2026


Step 1: Distributor notification recipients configured

Section titled “Step 1: Distributor notification recipients configured”
PASS

Step 1: Distributor notification recipients configured


PASS

Step 2: Submit dropship order

Step 2: Submit dropship order

Step 2: Submit dropship order

Step 2: Submit dropship order


PASS

Step 3: Submit consignment order

Step 3: Submit consignment order

Step 3: Submit consignment order

Step 3: Submit consignment order


PASS

Step 4: Manufacturer sees orders

PASS

Both the dropship and consignment URS-027 test orders should exist

SELECT id, request_number, order_type, status, notes,
receiving_rep_user_id, fulfilling_organization_id, requesting_organization_id
FROM order_requests
WHERE requested_by_user_id = $1
AND notes LIKE $2
ORDER BY created_at DESC
idrequest_numberorder_typestatusnotesreceiving_rep_user_idfulfilling_organization_idrequesting_organization_id
019dadd8-f871-7376-8a54-f88fe908b204OR-2consignmentsubmittedURS-027 consignment contrast ordera1b2c3d4-e5f6-7890-abcd-ef1234567890b2c3d4e5-f6a7-8901-bcde-f12345678901
019dadd8-b315-76a9-be74-0c713b15a78cOR-1dropshipsubmittedURS-027 dropship distributor-applicable ordera1b2c3d4-e5f6-7890-abcd-ef1234567890b2c3d4e5-f6a7-8901-bcde-f12345678901

Both order types (dropship + consignment) successfully submitted

Section titled “Both order types (dropship + consignment) successfully submitted”
PASS

Both a dropship and a consignment URS-027 order should exist (each must trigger distributor notifications independent of order_type).

SELECT id, request_number, order_type, status, notes,
receiving_rep_user_id, fulfilling_organization_id, requesting_organization_id
FROM order_requests
WHERE requested_by_user_id = $1
AND notes LIKE $2
ORDER BY created_at DESC
idrequest_numberorder_typestatusnotesreceiving_rep_user_idfulfilling_organization_idrequesting_organization_id
019dadd8-b315-76a9-be74-0c713b15a78cOR-1dropshipsubmittedURS-027 dropship distributor-applicable ordera1b2c3d4-e5f6-7890-abcd-ef1234567890b2c3d4e5-f6a7-8901-bcde-f12345678901
019dadd8-f871-7376-8a54-f88fe908b204OR-2consignmentsubmittedURS-027 consignment contrast ordera1b2c3d4-e5f6-7890-abcd-ef1234567890b2c3d4e5-f6a7-8901-bcde-f12345678901

Distributor + manufacturer notification recipients are configured

Section titled “Distributor + manufacturer notification recipients are configured”
PASS

Both ZuriMED and StellarTech must have at least one CC recipient for order_request_submitted notifications

SELECT organization_id, notification_type, email_address, name,
recipient_purpose
FROM organization_notification_recipients
WHERE notification_type = 'order_request_submitted'
AND organization_id = ANY($1)
AND recipient_purpose = 'cc'
AND email_address IS NOT NULL
ORDER BY organization_id, email_address
organization_idnotification_typeemail_addressnamerecipient_purpose
a1b2c3d4-e5f6-7890-abcd-ef1234567890order_request_submittedurs027-distributor-test@zurimed-fulfillment.example.comURS-027 distributor recipientcc
b2c3d4e5-f6a7-8901-bcde-f12345678901order_request_submittedurs027-distributor-test@stellartech-distributor.example.comURS-027 distributor recipientcc

order_request_submitted notification was enqueued/sent for the dropship order

Section titled “order_request_submitted notification was enqueued/sent for the dropship order”
PASS

There should be an email row tied to the dropship order in restate_outbox, restate_outbox_dlq, audit_events, or the spec-captured snapshot dir

restate_outbox + restate_outbox_dlq + audit_events + spec snapshots
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-b315-76a9-be74-0c713b15a78cURS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-1 from StellarTech Medic…true

order_request_submitted notification was enqueued/sent for the consignment order

Section titled “order_request_submitted notification was enqueued/sent for the consignment order”
PASS

There should be an email row tied to the consignment order in restate_outbox, restate_outbox_dlq, audit_events, or the spec-captured snapshot dir

restate_outbox + restate_outbox_dlq + audit_events + spec snapshots
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-f871-7376-8a54-f88fe908b204URS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-2 from StellarTech Medic…true

Dropship email recipients include BOTH the URS-027 distributor + manufacturer marker emails

Section titled “Dropship email recipients include BOTH the URS-027 distributor + manufacturer marker emails”
PASS

The dropship order’s notification(s) must address both the ZuriMED and the StellarTech URS-027 marker recipients (on to or cc) — proves distributor wiring fired.

evidence rows aggregated
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-b315-76a9-be74-0c713b15a78cURS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-1 from StellarTech Medic…true

Consignment email recipients include BOTH the URS-027 distributor + manufacturer marker emails

Section titled “Consignment email recipients include BOTH the URS-027 distributor + manufacturer marker emails”
PASS

The consignment order’s notification(s) must address both the ZuriMED and the StellarTech URS-027 marker recipients (on to or cc).

evidence rows aggregated
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-f871-7376-8a54-f88fe908b204URS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-2 from StellarTech Medic…true

At least one dropship-email subject references the dropship request_number

Section titled “At least one dropship-email subject references the dropship request_number”
PASS

At least one notification email for the dropship order must have a subject that references the dropship order’s request_number

evidence rows aggregated
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-b315-76a9-be74-0c713b15a78cURS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-1 from StellarTech Medic…true

At least one consignment-email subject references the consignment request_number

Section titled “At least one consignment-email subject references the consignment request_number”
PASS

At least one notification email for the consignment order must have a subject that references the consignment order’s request_number

evidence rows aggregated
sourcerelated_entity_idto_addressescc_addressessubjecthas_html
snapshot019dadd8-f871-7376-8a54-f88fe908b204URS-027 distributor recipient <urs027-distributor-test@zu…New Order Request Submitted - OR-2 from StellarTech Medic…true