264 行
9.7 KiB
SQL
264 行
9.7 KiB
SQL
-- 酒类商品demo数据更新脚本
|
|
-- 将药品类商品替换为酒类商品
|
|
|
|
-- 白酒类商品 (goods_class_id = 9)
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '五粮液 52度 500ml',
|
|
retail_price = 899.00,
|
|
purchase_price = 750.00,
|
|
goods_number = 'WLY001',
|
|
goods_code = '6901234567890',
|
|
specifications = '500ml/瓶',
|
|
details = '五粮液是中国著名白酒品牌，采用五种粮食酿造，口感醇厚，香味浓郁。'
|
|
WHERE goods_class_id = 9 AND id = 3985;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '茅台酒 53度 500ml',
|
|
retail_price = 2699.00,
|
|
purchase_price = 2200.00,
|
|
goods_number = 'MT001',
|
|
goods_code = '6901234567891',
|
|
specifications = '500ml/瓶',
|
|
details = '贵州茅台酒，中国国酒，酱香型白酒的典型代表，历史悠久，品质卓越。'
|
|
WHERE goods_class_id = 9 AND id = 3986;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '剑南春 52度 500ml',
|
|
retail_price = 459.00,
|
|
purchase_price = 380.00,
|
|
goods_number = 'JNC001',
|
|
goods_code = '6901234567892',
|
|
specifications = '500ml/瓶',
|
|
details = '剑南春，浓香型白酒，口感绵甜，回味悠长，是四川名酒的代表。'
|
|
WHERE goods_class_id = 9 AND id = 3987;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '水井坊 52度 500ml',
|
|
retail_price = 688.00,
|
|
purchase_price = 580.00,
|
|
goods_number = 'SJF001',
|
|
goods_code = '6901234567893',
|
|
specifications = '500ml/瓶',
|
|
details = '水井坊，中国白酒鼻祖，传承千年酿酒工艺，口感醇和，香气优雅。'
|
|
WHERE goods_class_id = 9 AND id = 3994;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '洋河蓝色经典 52度 500ml',
|
|
retail_price = 368.00,
|
|
purchase_price = 300.00,
|
|
goods_number = 'YH001',
|
|
goods_code = '6901234567894',
|
|
specifications = '500ml/瓶',
|
|
details = '洋河蓝色经典，绵柔型白酒开创者，口感绵柔甘甜，深受消费者喜爱。'
|
|
WHERE goods_class_id = 9 AND id = 3995;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '郎酒 53度 500ml',
|
|
retail_price = 299.00,
|
|
purchase_price = 240.00,
|
|
goods_number = 'LJ001',
|
|
goods_code = '6901234567895',
|
|
specifications = '500ml/瓶',
|
|
details = '郎酒，酱香型白酒，产自四川古蔺，酒体醇厚，香味独特。'
|
|
WHERE goods_class_id = 9 AND id = 3996;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '泸州老窖 52度 500ml',
|
|
retail_price = 199.00,
|
|
purchase_price = 160.00,
|
|
goods_number = 'LZLJ001',
|
|
goods_code = '6901234567896',
|
|
specifications = '500ml/瓶',
|
|
details = '泸州老窖，浓香鼻祖，中国四大名酒之一，口感甘美，回味悠长。'
|
|
WHERE goods_class_id = 9 AND id = 3997;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '西凤酒 45度 500ml',
|
|
retail_price = 158.00,
|
|
purchase_price = 130.00,
|
|
goods_number = 'XF001',
|
|
goods_code = '6901234567897',
|
|
specifications = '500ml/瓶',
|
|
details = '西凤酒，凤香型白酒代表，陕西名酒，口感清香甘润，风味独特。'
|
|
WHERE goods_class_id = 9 AND id = 3998;
|
|
|
|
-- 红酒类商品 (goods_class_id = 21)
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '长城干红葡萄酒 750ml',
|
|
retail_price = 88.00,
|
|
purchase_price = 65.00,
|
|
goods_number = 'CC001',
|
|
goods_code = '6901234567898',
|
|
specifications = '750ml/瓶',
|
|
details = '长城干红葡萄酒，选用优质葡萄酿造，口感醇厚，果香浓郁，是国产红酒的代表品牌。'
|
|
WHERE goods_class_id = 21 AND id = 3982;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '张裕解百纳干红 750ml',
|
|
retail_price = 128.00,
|
|
purchase_price = 95.00,
|
|
goods_number = 'ZY001',
|
|
goods_code = '6901234567899',
|
|
specifications = '750ml/瓶',
|
|
details = '张裕解百纳，中国葡萄酒知名品牌，口感平衡，单宁柔和，适合配餐饮用。'
|
|
WHERE goods_class_id = 21 AND id = 3983;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '王朝干红葡萄酒 750ml',
|
|
retail_price = 68.00,
|
|
purchase_price = 50.00,
|
|
goods_number = 'WC001',
|
|
goods_code = '6901234567900',
|
|
specifications = '750ml/瓶',
|
|
details = '王朝干红葡萄酒，口感柔顺，果香清新，性价比高，适合日常饮用。'
|
|
WHERE goods_class_id = 21 AND id = 3984;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '威龙干红葡萄酒 750ml',
|
|
retail_price = 58.00,
|
|
purchase_price = 42.00,
|
|
goods_number = 'WL001',
|
|
goods_code = '6901234567901',
|
|
specifications = '750ml/瓶',
|
|
details = '威龙干红葡萄酒，来自山东烟台，口感清爽，酸度适中，是入门级红酒的好选择。'
|
|
WHERE goods_class_id = 21 AND id = 3988;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '通化红酒 750ml',
|
|
retail_price = 45.00,
|
|
purchase_price = 32.00,
|
|
goods_number = 'TH001',
|
|
goods_code = '6901234567902',
|
|
specifications = '750ml/瓶',
|
|
details = '通化红酒，东北特色葡萄酒，口感甜润，适合不常饮酒的消费者。'
|
|
WHERE goods_class_id = 21 AND id = 3991;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '新天干红葡萄酒 750ml',
|
|
retail_price = 78.00,
|
|
purchase_price = 58.00,
|
|
goods_number = 'XT001',
|
|
goods_code = '6901234567903',
|
|
specifications = '750ml/瓶',
|
|
details = '新天干红葡萄酒，来自新疆天山北麓，日照充足，葡萄品质优良，酒体饱满。'
|
|
WHERE goods_class_id = 21 AND id = 3992;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '尼雅干红葡萄酒 750ml',
|
|
retail_price = 98.00,
|
|
purchase_price = 75.00,
|
|
goods_number = 'NY001',
|
|
goods_code = '6901234567904',
|
|
specifications = '750ml/瓶',
|
|
details = '尼雅干红葡萄酒，新疆特色红酒，口感浓郁，层次丰富，具有独特的地域风味。'
|
|
WHERE goods_class_id = 21 AND id = 3993;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '楼兰干红葡萄酒 750ml',
|
|
retail_price = 118.00,
|
|
purchase_price = 88.00,
|
|
goods_number = 'LL001',
|
|
goods_code = '6901234567905',
|
|
specifications = '750ml/瓶',
|
|
details = '楼兰干红葡萄酒，新疆吐鲁番产区，沙漠气候造就独特风味，口感醇厚甘美。'
|
|
WHERE goods_class_id = 21 AND id = 3997;
|
|
|
|
-- 啤酒类商品 (goods_class_id = 22)
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '青岛啤酒 500ml',
|
|
retail_price = 8.00,
|
|
purchase_price = 5.50,
|
|
goods_number = 'QD001',
|
|
goods_code = '6901234567906',
|
|
specifications = '500ml/瓶',
|
|
details = '青岛啤酒，中国啤酒知名品牌，口感清爽，泡沫丰富，是夏日消暑的好选择。'
|
|
WHERE goods_class_id = 22 AND id = 3979;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '雪花啤酒 500ml',
|
|
retail_price = 6.00,
|
|
purchase_price = 4.20,
|
|
goods_number = 'XH001',
|
|
goods_code = '6901234567907',
|
|
specifications = '500ml/瓶',
|
|
details = '雪花啤酒，中国销量领先的啤酒品牌，口感淡爽，适合大众消费。'
|
|
WHERE goods_class_id = 22 AND id = 3980;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '燕京啤酒 500ml',
|
|
retail_price = 7.00,
|
|
purchase_price = 4.80,
|
|
goods_number = 'YJ001',
|
|
goods_code = '6901234567908',
|
|
specifications = '500ml/瓶',
|
|
details = '燕京啤酒，北京本土品牌，口感醇和，麦香浓郁，深受北方消费者喜爱。'
|
|
WHERE goods_class_id = 22 AND id = 3981;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '哈尔滨啤酒 500ml',
|
|
retail_price = 7.50,
|
|
purchase_price = 5.20,
|
|
goods_number = 'HEB001',
|
|
goods_code = '6901234567909',
|
|
specifications = '500ml/瓶',
|
|
details = '哈尔滨啤酒，东北老牌啤酒，口感清冽，具有浓郁的麦芽香味。'
|
|
WHERE goods_class_id = 22 AND id = 3988;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '珠江啤酒 500ml',
|
|
retail_price = 6.50,
|
|
purchase_price = 4.50,
|
|
goods_number = 'ZJ001',
|
|
goods_code = '6901234567910',
|
|
specifications = '500ml/瓶',
|
|
details = '珠江啤酒，广东本土品牌，口感清淡，适合南方气候，是广东人的首选啤酒。'
|
|
WHERE goods_class_id = 22 AND id = 3989;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '重庆啤酒 500ml',
|
|
retail_price = 8.50,
|
|
purchase_price = 6.00,
|
|
goods_number = 'CQ001',
|
|
goods_code = '6901234567911',
|
|
specifications = '500ml/瓶',
|
|
details = '重庆啤酒，西南地区知名品牌，口感浓郁，具有独特的山城风味。'
|
|
WHERE goods_class_id = 22 AND id = 3990;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '金威啤酒 500ml',
|
|
retail_price = 9.00,
|
|
purchase_price = 6.50,
|
|
goods_number = 'JW001',
|
|
goods_code = '6901234567912',
|
|
specifications = '500ml/瓶',
|
|
details = '金威啤酒，深圳本土品牌，口感醇厚，泡沫持久，是华南地区的优质啤酒。'
|
|
WHERE goods_class_id = 22 AND id = 3991;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '百威啤酒 500ml',
|
|
retail_price = 12.00,
|
|
purchase_price = 8.50,
|
|
goods_number = 'BW001',
|
|
goods_code = '6901234567913',
|
|
specifications = '500ml/瓶',
|
|
details = '百威啤酒，国际知名品牌，口感纯正，品质稳定，是进口啤酒的代表。'
|
|
WHERE goods_class_id = 22 AND id = 3997;
|
|
|
|
UPDATE ls_retail_goods SET
|
|
goods_name = '喜力啤酒 500ml',
|
|
retail_price = 15.00,
|
|
purchase_price = 11.00,
|
|
goods_number = 'XL001',
|
|
goods_code = '6901234567914',
|
|
specifications = '500ml/瓶',
|
|
details = '喜力啤酒，荷兰进口，口感清爽，具有独特的苦味和香味，是高端啤酒的选择。'
|
|
WHERE goods_class_id = 22 AND id = 3998;
|
|
|
|
-- 更新商品状态为正常
|
|
UPDATE ls_retail_goods SET status = 0 WHERE goods_class_id IN (9, 21, 22) AND status != 2;
|
|
|
|
-- 更新库存数量
|
|
UPDATE ls_retail_goods SET goods_num = 100.000 WHERE goods_class_id IN (9, 21, 22) AND status != 2;
|
|
|
|
-- 更新添加时间为当前时间
|
|
UPDATE ls_retail_goods SET add_time = UNIX_TIMESTAMP() WHERE goods_class_id IN (9, 21, 22) AND status != 2; |