Kinetic Edge Health

Module: Transaction Item-Level Breakdown & Mapping

TC_ID: TR_ITEM_01
Title: Verify item-level records created after successful payment
Preconditions: Successful cart payment
Steps:

Add multiple items to cart
Complete payment
Check database
Test Data: Multiple items
Expected Result: Separate record created for each item linked to transaction ID

TC_ID: TR_ITEM_02
Title: Verify transaction ID mapping with all items
Preconditions: Payment completed
Steps:

Perform checkout
Fetch transaction and item records
Test Data: Transaction ID
Expected Result: All items correctly linked to same transaction ID

TC_ID: TR_ITEM_03
Title: Verify correct item details stored in database
Preconditions: Successful payment
Steps:

Complete payment
Check stored item details
Test Data: Item ID, name, price, quantity
Expected Result: All item attributes stored correctly

TC_ID: TR_ITEM_04
Title: Verify item-wise amount calculation in records
Preconditions: Multiple items with quantities
Steps:

Complete payment
Validate item-level totals
Test Data: Price and quantity
Expected Result: Each item total = price × quantity

TC_ID: TR_ITEM_05
Title: Verify sum of item-level amounts equals transaction total
Preconditions: Payment completed
Steps:

Fetch all item records
Sum item totals
Compare with transaction total
Test Data: Transaction data
Expected Result: Sum of items equals total transaction amount

TC_ID: TR_ITEM_06
Title: Verify no item-level records created on failed payment
Preconditions: Payment failure
Steps:

Attempt checkout with failed payment
Check database
Test Data: Failed transaction
Expected Result: No item-level records stored

TC_ID: TR_ITEM_07
Title: Verify no partial item mapping on failure
Preconditions: Payment failure during processing
Steps:

Simulate failure
Check DB
Test Data: Multiple items
Expected Result: No partial records saved

TC_ID: TR_ITEM_08
Title: Verify item mapping consistency for multi-item transactions
Preconditions: Multiple items in cart
Steps:

Complete payment
Validate mapping
Test Data: Multiple items
Expected Result: Each item uniquely mapped without duplication

TC_ID: TR_ITEM_09
Title: Verify handling of duplicate webhook/payment response
Preconditions: Same transaction processed twice
Steps:

Simulate duplicate success response
Check DB
Test Data: Same transaction ID
Expected Result: No duplicate item records created

TC_ID: TR_ITEM_10
Title: Verify reconciliation readiness with stored data
Preconditions: Transactions available
Steps:

Compare stored item-level data with Square transaction
Test Data: Transaction details
Expected Result: Data matches and supports reconciliation

TC_ID: TR_ITEM_11
Title: Verify item mapping with metadata from payment request
Preconditions: Metadata included in request
Steps:

Complete payment
Validate stored mapping
Test Data: Metadata (item IDs)
Expected Result: Items correctly mapped using metadata

TC_ID: TR_ITEM_12
Title: Verify performance for large item breakdown storage
Preconditions: Large cart
Steps:

Add many items
Complete payment
Test Data: 50+ items
Expected Result: All item records stored correctly without delay

TC_ID: TR_ITEM_13
Title: Verify data integrity for concurrent transactions
Preconditions: Multiple users
Steps:

Perform simultaneous payments
Check DB
Test Data: Multiple transactions
Expected Result: Correct mapping without cross-linking

TC_ID: TR_ITEM_14
Title: Verify audit fields in item-level records
Preconditions: Payment completed
Steps:

Check DB records
Test Data: Transaction
Expected Result: Created date, transaction ID, user ID stored correctly