Skip to content

TEST_DATA_CREATION_GUIDE.md

Latest commit

 

History

History
524 lines (448 loc) · 16.3 KB

TEST_DATA_CREATION_GUIDE.md

File metadata and controls

524 lines (448 loc) · 16.3 KB

🎯 COMPREHENSIVE TEST DATA CREATION GUIDE

Overview

This guide provides step-by-step instructions for creating robust, diverse test data that will demonstrate all Phase 4 features of the TechSolutionApp. Follow this systematic approach to populate your Salesforce org with meaningful business data.

🚀 STEP 1: ACCESS THE TECH SOLUTIONS APP

Navigate to the Application

  1. Open Salesforce Org: The org should already be open from our verification
  2. Access App Launcher: Click the 9-dot grid icon (⋮⋮⋮) in the top-left corner
  3. Find Tech Solutions: Search for "Tech Solutions" or scroll to find the app
  4. Launch Application: Click on "Tech Solutions" to enter the custom app

Verify App Components

Confirm you can see these tabs in the navigation:

  • ✅ Devices (Device__c)
  • ✅ Device Orders (Device_Order__c)
  • ✅ Customers (Customer__c)
  • ✅ Suppliers (Supplier__c)

📦 STEP 2: CREATE SUPPLIER RECORDS (5-7 Records)

Start with Suppliers since Devices will reference them via lookup relationships.

Supplier 1: TechCorp Solutions

  • Company Name: TechCorp Solutions
  • Contact Person: Sarah Johnson
  • Email: sarah.johnson@techcorp.com
  • Phone: (555) 123-4567
  • Country: United States
  • Supplier Rating: 5 (Excellent)
  • Active: ✅ True

Supplier 2: Global Hardware Inc

  • Company Name: Global Hardware Inc
  • Contact Person: Michael Chen
  • Email: m.chen@globalhardware.com
  • Phone: (555) 234-5678
  • Country: Canada
  • Supplier Rating: 4 (Good)
  • Active: ✅ True

Supplier 3: European Tech Partners

  • Company Name: European Tech Partners
  • Contact Person: Emma Schmidt
  • Email: emma.schmidt@eurotech.de
  • Phone: +49-30-12345678
  • Country: Germany
  • Supplier Rating: 5 (Excellent)
  • Active: ✅ True

Supplier 4: Asia Pacific Systems

  • Company Name: Asia Pacific Systems
  • Contact Person: Hiroshi Tanaka
  • Email: h.tanaka@apsystems.jp
  • Phone: +81-3-1234-5678
  • Country: Japan
  • Supplier Rating: 4 (Good)
  • Active: ✅ True

Supplier 5: Budget Components Ltd

  • Company Name: Budget Components Ltd
  • Contact Person: David Wilson
  • Email: d.wilson@budgetcomp.co.uk
  • Phone: +44-20-7123-4567
  • Country: United Kingdom
  • Supplier Rating: 3 (Average)
  • Active: ✅ True

Supplier 6: Premium Solutions Group

  • Company Name: Premium Solutions Group
  • Contact Person: Maria Rodriguez
  • Email: maria.rodriguez@premiumsol.com
  • Phone: (555) 345-6789
  • Country: United States
  • Supplier Rating: 5 (Excellent)
  • Active: ✅ True

Supplier 7: Local Tech Supplies

  • Company Name: Local Tech Supplies
  • Contact Person: James Thompson
  • Email: james@localtechsupplies.com
  • Phone: (555) 456-7890
  • Country: United States
  • Supplier Rating: 2 (Below Average)
  • Active: ❌ False

💻 STEP 3: CREATE DEVICE RECORDS (10-15 Records)

Create diverse devices across different categories with varied stock levels and pricing.

Hardware Devices (5 Records)

Device 1: Dell OptiPlex 7090

  • Name: Dell OptiPlex 7090
  • Type: Computer
  • Description: High-performance desktop computer for business use
  • Price: $1,299.00
  • Cost Price: $899.00
  • Stock Quantity: 25
  • Minimum Stock Level: 10
  • Reorder Point: 15
  • Last Restocked: [Today's date - 30 days]
  • Warranty Period (Months): 36
  • Active: ✅ True
  • Supplier: TechCorp Solutions

Device 2: HP ProLiant DL380

  • Name: HP ProLiant DL380
  • Type: Server
  • Description: Enterprise-grade rack server for data centers
  • Price: $4,599.00
  • Cost Price: $3,299.00
  • Stock Quantity: 8
  • Minimum Stock Level: 5
  • Reorder Point: 7
  • Last Restocked: [Today's date - 45 days]
  • Warranty Period (Months): 60
  • Active: ✅ True
  • Supplier: Global Hardware Inc

Device 3: Cisco Catalyst 2960

  • Name: Cisco Catalyst 2960
  • Type: Networking
  • Description: 24-port managed Ethernet switch
  • Price: $899.00
  • Cost Price: $649.00
  • Stock Quantity: 3
  • Minimum Stock Level: 5
  • Reorder Point: 8
  • Last Restocked: [Today's date - 60 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: European Tech Partners

Device 4: Synology DS920+

  • Name: Synology DS920+
  • Type: Storage
  • Description: 4-bay NAS storage solution
  • Price: $549.00
  • Cost Price: $399.00
  • Stock Quantity: 15
  • Minimum Stock Level: 8
  • Reorder Point: 12
  • Last Restocked: [Today's date - 20 days]
  • Warranty Period (Months): 24
  • Active: ✅ True
  • Supplier: Asia Pacific Systems

Device 5: iPad Pro 12.9"

  • Name: iPad Pro 12.9"
  • Type: Mobile Device
  • Description: Professional tablet with M2 chip
  • Price: $1,099.00
  • Cost Price: $799.00
  • Stock Quantity: 12
  • Minimum Stock Level: 6
  • Reorder Point: 10
  • Last Restocked: [Today's date - 15 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: Premium Solutions Group

Software Licenses (5 Records)

Device 6: Microsoft Office 365

  • Name: Microsoft Office 365
  • Type: Software
  • Description: Business productivity suite annual license
  • Price: $149.00
  • Cost Price: $99.00
  • Stock Quantity: 100
  • Minimum Stock Level: 25
  • Reorder Point: 50
  • Last Restocked: [Today's date - 10 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: TechCorp Solutions

Device 7: Adobe Creative Cloud

  • Name: Adobe Creative Cloud
  • Type: License
  • Description: Complete creative software suite license
  • Price: $599.00
  • Cost Price: $449.00
  • Stock Quantity: 20
  • Minimum Stock Level: 10
  • Reorder Point: 15
  • Last Restocked: [Today's date - 25 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: Premium Solutions Group

Device 8: Salesforce Enterprise

  • Name: Salesforce Enterprise
  • Type: Cloud Service
  • Description: CRM platform enterprise license per user
  • Price: $165.00
  • Cost Price: $125.00
  • Stock Quantity: 50
  • Minimum Stock Level: 20
  • Reorder Point: 30
  • Last Restocked: [Today's date - 5 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: Global Hardware Inc

Device 9: AutoCAD Professional

  • Name: AutoCAD Professional
  • Type: Digital Asset
  • Description: Professional CAD software license
  • Price: $1,775.00
  • Cost Price: $1,299.00
  • Stock Quantity: 10
  • Minimum Stock Level: 5
  • Reorder Point: 8
  • Last Restocked: [Today's date - 40 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: European Tech Partners

Device 10: Antivirus Enterprise

  • Name: Antivirus Enterprise
  • Type: Software
  • Description: Enterprise security software per device
  • Price: $45.00
  • Cost Price: $29.00
  • Stock Quantity: 200
  • Minimum Stock Level: 50
  • Reorder Point: 100
  • Last Restocked: [Today's date - 7 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: Budget Components Ltd

Accessories (5 Records)

Device 11: USB-C Hub

  • Name: USB-C Hub
  • Type: Accessory
  • Description: 7-in-1 USB-C multiport adapter
  • Price: $79.00
  • Cost Price: $45.00
  • Stock Quantity: 35
  • Minimum Stock Level: 15
  • Reorder Point: 25
  • Last Restocked: [Today's date - 12 days]
  • Warranty Period (Months): 6
  • Active: ✅ True
  • Supplier: Asia Pacific Systems

Device 12: HDMI Cable 6ft

  • Name: HDMI Cable 6ft
  • Type: Cable
  • Description: High-speed HDMI cable with Ethernet
  • Price: $24.99
  • Cost Price: $12.00
  • Stock Quantity: 75
  • Minimum Stock Level: 30
  • Reorder Point: 50
  • Last Restocked: [Today's date - 18 days]
  • Warranty Period (Months): 3
  • Active: ✅ True
  • Supplier: Budget Components Ltd

Device 13: Wireless Mouse

  • Name: Wireless Mouse
  • Type: Peripheral
  • Description: Ergonomic wireless optical mouse
  • Price: $39.99
  • Cost Price: $22.00
  • Stock Quantity: 45
  • Minimum Stock Level: 20
  • Reorder Point: 30
  • Last Restocked: [Today's date - 8 days]
  • Warranty Period (Months): 12
  • Active: ✅ True
  • Supplier: Local Tech Supplies

Device 14: RAM Module 16GB

  • Name: RAM Module 16GB
  • Type: Component
  • Description: DDR4 16GB memory module
  • Price: $129.00
  • Cost Price: $89.00
  • Stock Quantity: 22
  • Minimum Stock Level: 10
  • Reorder Point: 15
  • Last Restocked: [Today's date - 35 days]
  • Warranty Period (Months): 24
  • Active: ✅ True
  • Supplier: TechCorp Solutions

Device 15: Printer Toner

  • Name: Printer Toner
  • Type: Consumable
  • Description: Black toner cartridge for HP LaserJet
  • Price: $89.99
  • Cost Price: $55.00
  • Stock Quantity: 18
  • Minimum Stock Level: 12
  • Reorder Point: 20
  • Last Restocked: [Today's date - 22 days]
  • Warranty Period (Months): 6
  • Active: ✅ True
  • Supplier: Premium Solutions Group

👥 STEP 4: CREATE CUSTOMER RECORDS (8-10 Records)

Create diverse customers representing both Business and Individual segments.

Business Customers (6 Records)

Customer 1: Acme Corporation

  • Name: Acme Corporation
  • Type: Enterprise
  • Email: procurement@acmecorp.com
  • Phone: (555) 111-2222
  • Customer Status: Active
  • Credit Limit: $50,000.00

Customer 2: StartUp Innovations LLC

  • Name: StartUp Innovations LLC
  • Type: Small Business
  • Email: orders@startupinnovations.com
  • Phone: (555) 222-3333
  • Customer Status: VIP
  • Credit Limit: $15,000.00

Customer 3: City Government IT Dept

  • Name: City Government IT Dept
  • Type: Government
  • Email: it.procurement@citygovt.org
  • Phone: (555) 333-4444
  • Customer Status: Active
  • Credit Limit: $75,000.00

Customer 4: Education Foundation

  • Name: Education Foundation
  • Type: Non-Profit
  • Email: tech@educationfoundation.org
  • Phone: (555) 444-5555
  • Customer Status: Active
  • Credit Limit: $25,000.00

Customer 5: Global Manufacturing Inc

Customer 6: Local Consulting Group

  • Name: Local Consulting Group
  • Type: Small Business
  • Email: admin@localconsulting.com
  • Phone: (555) 666-7777
  • Customer Status: Prospect
  • Credit Limit: $10,000.00

Individual Customers (4 Records)

Customer 7: John Smith

  • Name: John Smith
  • Type: Individual
  • Email: john.smith@email.com
  • Phone: (555) 777-8888
  • Customer Status: Active
  • Credit Limit: $5,000.00

Customer 8: Emily Davis

  • Name: Emily Davis
  • Type: Student
  • Email: emily.davis@university.edu
  • Phone: (555) 888-9999
  • Customer Status: Active
  • Credit Limit: $2,500.00

Customer 9: Robert Johnson

  • Name: Robert Johnson
  • Type: Senior
  • Email: robert.johnson@email.com
  • Phone: (555) 999-0000
  • Customer Status: VIP
  • Credit Limit: $7,500.00

Customer 10: Sarah Wilson

  • Name: Sarah Wilson
  • Type: Individual
  • Email: sarah.wilson@email.com
  • Phone: (555) 000-1111
  • Customer Status: Inactive
  • Credit Limit: $3,000.00

📋 STEP 5: CREATE DEVICE ORDER RECORDS (15-20 Records)

Create orders spanning the last 90 days with different priorities, statuses, and customer relationships.

Order Creation Strategy

  • Date Distribution: Spread orders across 90 days (use various Order_Date__c values)
  • Status Variety: Mix of Draft, Pending, Confirmed, Shipped, Delivered
  • Priority Levels: Include Critical, High, Medium, Low priorities
  • Customer Mix: Orders from both Business and Individual customers
  • Device Variety: Orders for different device types and price ranges

Sample Orders (Create 15-20 similar records)

Order 1: Enterprise Hardware Order

  • Device: Dell OptiPlex 7090
  • Customer: Acme Corporation
  • Quantity: 5
  • Order Date: [Today - 85 days]
  • Expected Delivery Date: [Order Date + 14 days]
  • Priority: Medium
  • Status: Delivered
  • Discount Percentage: 10%

Order 2: Urgent Server Replacement

  • Device: HP ProLiant DL380
  • Customer: Global Manufacturing Inc
  • Quantity: 2
  • Order Date: [Today - 7 days]
  • Expected Delivery Date: [Order Date + 3 days]
  • Priority: Critical
  • Status: Shipped
  • Discount Percentage: 5%

Order 3: Software License Bulk Purchase

  • Device: Microsoft Office 365
  • Customer: City Government IT Dept
  • Quantity: 25
  • Order Date: [Today - 45 days]
  • Expected Delivery Date: [Order Date + 1 day]
  • Priority: High
  • Status: Delivered
  • Discount Percentage: 15%

Order 4: Individual Consumer Purchase

  • Device: iPad Pro 12.9"
  • Customer: John Smith
  • Quantity: 1
  • Order Date: [Today - 30 days]
  • Expected Delivery Date: [Order Date + 7 days]
  • Priority: Low
  • Status: Delivered
  • Discount Percentage: 0%

Order 5: Student Discount Order

  • Device: Adobe Creative Cloud
  • Customer: Emily Davis
  • Quantity: 1
  • Order Date: [Today - 15 days]
  • Expected Delivery Date: [Order Date + 5 days]
  • Priority: Low
  • Status: Confirmed
  • Discount Percentage: 20%

Continue creating 10-15 more orders following similar patterns...

✅ STEP 6: VERIFICATION AND TESTING

Data Quality Verification

  1. Check Lookup Relationships: Verify all Device-Supplier and Order-Customer relationships
  2. Formula Field Validation: Confirm Profit_Margin__c and Final_Amount__c calculations
  3. Stock Status Updates: Verify Stock_Status__c reflects current inventory levels
  4. Trigger Functionality: Create test orders to verify OrderTrigger execution

List View Testing

  1. Navigate to Enhanced List Views: Test All_Orders_Enhanced, Recent_Orders_Dashboard
  2. Filter Functionality: Use filters to verify data segmentation
  3. Column Display: Confirm all custom fields display correctly

Dashboard Component Testing

  1. Access OrderDashboardMinimal: Navigate to the Lightning Web Component
  2. Data Display: Verify real-time data integration
  3. Filtering: Test any filtering capabilities

📊 EXPECTED OUTCOMES

After completing this data creation process, you should have:

  • ✅ 7 Supplier Records with varied ratings and geographic distribution
  • ✅ 15 Device Records across Hardware, Software, and Accessory categories
  • ✅ 10 Customer Records representing Business and Individual segments
  • ✅ 15-20 Order Records spanning 90 days with varied priorities and statuses
  • ✅ Functional Relationships between all objects
  • ✅ Working Formula Fields with accurate calculations
  • ✅ Active Triggers processing order automation
  • ✅ Enhanced List Views displaying organized data
  • ✅ Functional Dashboard with real-time data integration

🔧 TROUBLESHOOTING TIPS

Common Issues and Solutions

  1. Validation Rule Errors: Ensure positive quantities and required fields
  2. Lookup Relationship Issues: Create parent records (Suppliers, Customers) before child records
  3. Formula Field Problems: Check that referenced fields have values
  4. Stock Status Not Updating: Verify triggers are active and functioning
  5. Dashboard Not Loading: Confirm OrderDashboardMinimal component is deployed

Testing Validation Rules

  • Try Invalid Data: Test negative quantities, missing devices, etc.
  • Verify Error Messages: Confirm validation rules display appropriate messages
  • Test Stock Validation: Attempt to order more than available stock

This comprehensive test data will provide a solid foundation for demonstrating all Phase 4 features and enable meaningful testing of advanced dashboard analytics and visualizations.