No Active Session
WARE TEST-WARE-001 UC: UC-17.1

Import Wares from Source Systems

Userback Reference: Loading...

Prerequisites

  • User is logged in as Admin
  • Source systems are configured and accessible (Internal, Sherpa, e-automate, Autotask)
  • CI/CD pipeline or manual trigger mechanism is available

Test Credentials

Role: Admin
Email: c.chapman.test@circlemsp.com
Password: MyPassw0rd123!

Test Steps

# Action Expected Result Screenshot Result
1
Access the wares import function (via manual trigger or CI/CD pipeline status dashboard)
Import function interface or pipeline status is accessible and ready
-
2
Verify the ETL process runs for each source system: Internal, Sherpa, e-automate, Autotask
ETL pipeline executes and shows progress for each configured source system
-
3
Verify the system fetches data from each source (SQL query, REST API, or local database)
Data retrieval completes for each source system without connection errors
-
4
Verify records are upserted into the wares table using (source_system, source_id) as the deduplication key
Records are inserted for new entries and updated for existing entries based on the composite dedup key
-
5
Verify accessories, categories, pricing, and constraint rules are synchronized
Related data (accessories, categories, pricing, constraints) is imported alongside the primary wares records
-
6
Verify import results show counts: inserted, updated, unchanged, errors
Import summary displays accurate counts for each operation category
-
7
Verify no duplicate records were created by querying the wares table for entries with the same source_system and source_id
Query confirms zero duplicate records exist; each (source_system, source_id) combination is unique
-

Acceptance Criteria