Skip to content

URS-062 · Order Type Options (Dropship, Consignment, Direct Sales)

Status: PASS  ·  Duration: 2m 23s  ·  Run Date: April 21, 2026


PASS

Step 1: Login as sales rep

Step 1: Login as sales rep


PASS

Step 2: All order types visible


PASS

Step 3: Select order types

Step 3: Select order types

Step 3: Select order types


PASS

Step 4: Change delivery location

Step 4: Change delivery location


PASS

Step 5: Consignment order

Step 5: Consignment order

Step 5: Consignment order

Step 5: Consignment order


PASS

Step 6: Direct order

Step 6: Direct order

Step 6: Direct order

Step 6: Direct order


PASS

Step 7: Dropship order

Step 7: Dropship order

Step 7: Dropship order

Step 7: Dropship order


PASS

Step 8: Orders summary

PASS

At least one order should have been created during the test

SELECT id, request_number, order_type, status, location_id, sales_account_id, created_at
FROM order_requests
WHERE requested_by_user_id = $1
AND notes LIKE '%URS-062%'
ORDER BY created_at DESC
idrequest_numberorder_typestatuslocation_idsales_account_idcreated_at
019daddd-84ea-7891-bb7c-7773a2b0a23eOR-3dropshipsubmitteda3e7f8a9-b0c1-2345-0123-4567890123452ac9d0e1-f2a3-4567-2345-6789012345672026-04-21T02:27:49.087Z
019daddd-19cd-7271-a877-a0e18734532eOR-2directsubmitted81c5d6e7-f8a9-0123-8901-2345678901231fb8c9d0-e1f2-3456-1234-5678901234562026-04-21T02:27:21.664Z
019daddc-be72-75a7-860a-98b3ea96d713OR-1consignmentsubmitted6ea3b4c5-d6e7-8901-6789-012345678901fea7b8c9-d0e1-2345-0123-4567890123452026-04-21T02:26:58.278Z

PASS

A consignment order should exist from the test run

SELECT id, request_number, order_type, status, sales_account_id
FROM order_requests
WHERE requested_by_user_id = $1
AND order_type = 'consignment'
AND notes LIKE '%URS-062%'
ORDER BY created_at DESC
LIMIT 1
idrequest_numberorder_typestatussales_account_id
019daddc-be72-75a7-860a-98b3ea96d713OR-1consignmentsubmittedfea7b8c9-d0e1-2345-0123-456789012345

PASS

A direct order should exist from the test run

SELECT id, request_number, order_type, status, sales_account_id
FROM order_requests
WHERE requested_by_user_id = $1
AND order_type = 'direct'
AND notes LIKE '%URS-062%'
ORDER BY created_at DESC
LIMIT 1
idrequest_numberorder_typestatussales_account_id
019daddd-19cd-7271-a877-a0e18734532eOR-2directsubmitted1fb8c9d0-e1f2-3456-1234-567890123456

PASS

A dropship order should exist from the test run

SELECT id, request_number, order_type, status, sales_account_id
FROM order_requests
WHERE requested_by_user_id = $1
AND order_type = 'dropship'
AND notes LIKE '%URS-062%'
ORDER BY created_at DESC
LIMIT 1
idrequest_numberorder_typestatussales_account_id
019daddd-84ea-7891-bb7c-7773a2b0a23eOR-3dropshipsubmitted2ac9d0e1-f2a3-4567-2345-678901234567

PASS

Orders of all three types (consignment, direct, dropship) should exist

SELECT order_type, COUNT(*) as order_count
FROM order_requests
WHERE requested_by_user_id = $1
AND notes LIKE '%URS-062%'
GROUP BY order_type
ORDER BY order_type
order_typeorder_count
consignment1
direct1
dropship1

PASS

Every order should have a delivery location assigned

SELECT orq.id, orq.order_type, orq.location_id, orq.sales_account_id,
rwl.name as location_name, rwl.type as location_type
FROM order_requests orq
LEFT JOIN real_world_locations rwl ON rwl.id = orq.location_id
WHERE orq.requested_by_user_id = $1
AND orq.created_at > NOW() - INTERVAL '30 minutes'
ORDER BY orq.created_at DESC
idorder_typelocation_idsales_account_idlocation_namelocation_type
019daddd-84ea-7891-bb7c-7773a2b0a23edropshipa3e7f8a9-b0c1-2345-0123-4567890123452ac9d0e1-f2a3-4567-2345-678901234567Connecticut Ortho - Shippingasc
019daddd-19cd-7271-a877-a0e18734532edirect81c5d6e7-f8a9-0123-8901-2345678901231fb8c9d0-e1f2-3456-1234-567890123456Copley Hospital - Shippinghospital
019daddc-be72-75a7-860a-98b3ea96d713consignment6ea3b4c5-d6e7-8901-6789-012345678901fea7b8c9-d0e1-2345-0123-456789012345BOSS - Shippinghospital