-- Fix all Unicode escape sequences in shop names
-- This script converts Unicode escape sequences to actual Chinese characters

-- First, let's see what we're dealing with
SELECT COUNT(*) as total_problematic FROM products_master WHERE 网店名称 LIKE '%\%';

-- Fix XWG小红书
UPDATE products_master 
SET 网店名称 = '["XWG小红书"]'
WHERE 网店名称 = '["XWG\u5c0f\u7ea2\u4e66"]';

-- Fix ATELIER 小红书
UPDATE products_master 
SET 网店名称 = '["ATELIER 小红书"]'
WHERE 网店名称 = '["ATELIER \u5c0f\u7ea2\u4e66"]';

-- Fix 小晴天7 (corrected: 天 not 大)
UPDATE products_master 
SET 网店名称 = '["小晴天7"]'
WHERE 网店名称 = '["\u5c0f\u6674\u59297"]';

-- Fix 测试店铺
UPDATE products_master 
SET 网店名称 = '["测试店铺"]'
WHERE 网店名称 = '["\u6d4b\u8bd5\u5e97\u94fa"]';

-- Check results
SELECT COUNT(*) as remaining_problems FROM products_master WHERE 网店名称 LIKE '%\%';
SELECT DISTINCT 网店名称 FROM products_master WHERE 网店名称 LIKE '%\%' LIMIT 10;