Creating test products using direct SQL...
Product: Paracetamol 500mg - Stock: 3 - Purchase: MWK 200 - Sell: MWK 250
Product: Ibuprofen 400mg - Stock: 3 - Purchase: MWK 150 - Sell: MWK 200
Product: Amoxicillin 250mg - Stock: 3 - Purchase: MWK 300 - Sell: MWK 400

=== TEST SCENARIO ===
1. Total Products: 3
2. Total Stock: 9 units
3. Total Cost: MWK 650.00
4. Total Value: MWK 850.00
5. Expected Profit: MWK 200.00

=== READY FOR TESTING ===
Products created successfully!
You can now test:
- Sales transactions
- Stock adjustments
- Profit/Loss reports
- Stock expiry reports