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