<h2>Shopping Management System Test</h2>
<pre>
1. Testing database connection...
   ✓ Database connection successful

2. Checking if products table exists...
   ✓ Products table exists

3. Checking table structure...
   Table has 23 columns:
   - id (int(11))
   - name (varchar(500))
   - description (text)
   - price (decimal(10,2))
   - original_price (decimal(10,2))
   - category (varchar(100))
   - image_url (varchar(1000))
   - affiliate_url (varchar(1000))
   - rating (decimal(3,2))
   - reviews_count (int(11))
   - discount_percentage (int(11))
   - availability (enum('in_stock','out_of_stock','limited'))
   - brand (varchar(200))
   - features (text)
   - specifications (text)
   - status (enum('active','inactive'))
   - view_count (int(11))
   - click_count (int(11))
   - tags (longtext)
   - meta_title (varchar(200))
   - meta_description (varchar(300))
   - created_at (timestamp)
   - updated_at (timestamp)

4. Checking existing products...
   Found 3 products in database

5. Testing CRUD operations...
   Testing CREATE operation...
   ✓ Product created with ID: 13
   Testing READ operation...
   ✓ Product retrieved: Test Product - 2025-09-19 16:03:48
   Testing UPDATE operation...
   ✓ Product updated successfully
   Testing DELETE operation...
   ✓ Product deleted successfully

6. Testing statistics queries...
   Total products: 3
   Active products: 3
   Total categories: 1
   Average rating: 4.6

7. Testing search and filtering...
   Products matching 'Samsung': 1
   Products in 'electronics' category: 3
   Active products: 3

8. Testing affiliate URL functionality...
   Products with affiliate URLs: 3
   Sample affiliate products:
   - Samsung Galaxy S24 Ultra: https://www.samsung.com/in/smartphones/galaxy-s24-ultra/
   - Apple iPhone 15 Pro Max: https://www.apple.com/in/iphone-15-pro/
   - Sony WH-1000XM5 Headphones: https://www.sony.co.in/headphones/wh-1000xm5

🎉 ALL TESTS PASSED! Shopping Management System is working correctly.

Key Features Verified:
✓ Database connection and table structure
✓ CRUD operations (Create, Read, Update, Delete)
✓ Statistics and analytics
✓ Search and filtering functionality
✓ Affiliate URL management
✓ Product categorization
✓ Status management

The system is ready for:
• Adding affiliate deals from Amazon, Flipkart, etc.
• Managing product categories and pricing
• Tracking clicks and views
• Search and filter functionality
• Responsive admin interface
</pre>