-- Truncate Products and Stock Data
-- This will remove all products, inventory, and transaction records
-- WARNING: This action cannot be undone!


-- Truncate transaction history
TRUNCATE TABLE stock_transactions;

-- Truncate inventory
TRUNCATE TABLE inventory;

-- Truncate products
TRUNCATE TABLE products;


-- Verify tables are empty
SELECT 'Products count:' as info, COUNT(*) as count FROM products
UNION ALL
SELECT 'Inventory count:', COUNT(*) FROM inventory
UNION ALL
SELECT 'Transactions count:', COUNT(*) FROM stock_transactions;
