xoops_market_spinfo2.sql

自己实现一个实用的商店应用系统

update xoops_market_spinfo set sp_sj=80.00,sp_cb=45,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110101'; ##  枣片-精装（阿胶味）700g
update xoops_market_spinfo set sp_sj=80.00,sp_cb=55,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110102'; ##  枣片-精装（维钙味）700g
update xoops_market_spinfo set sp_sj=80.00,sp_cb=55,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110103'; ##  枣片-精装（西洋参味）700g
update xoops_market_spinfo set sp_sj=80.00,sp_cb=55,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110104'; ##  枣片-精装（柑桔味）700g
update xoops_market_spinfo set sp_sj=20.00,sp_cb=12,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110105'; ##  枣片-简装（柑桔味）280g
update xoops_market_spinfo set sp_sj=20.00,sp_cb=12,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110106'; ##  枣片-简装（草莓味）280g
update xoops_market_spinfo set sp_sj=20.00,sp_cb=12,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110107'; ##  枣片-简装（西洋参味）280g
update xoops_market_spinfo set sp_sj=20.00,sp_cb=12,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110108'; ##  枣片-简装（阿胶味）280g
update xoops_market_spinfo set sp_sj=6.00,sp_cb=3,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110109'; ##  枣片-4种口味装70g
update xoops_market_spinfo set sp_sj=8.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110110'; ##  枣片-精装小盒-维钙味70g
update xoops_market_spinfo set sp_sj=8.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110111'; ##  枣片-精装小盒-西洋参味70g
update xoops_market_spinfo set sp_sj=8.00,sp_cb=4.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110112'; ##  枣片-精装小盒-阿胶味70g
update xoops_market_spinfo set sp_sj=8.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110113'; ##  枣片-精装小盒-柑桔味70g
update xoops_market_spinfo set sp_sj=120.00,sp_cb=55,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110114'; ##  枣片-精装（草莓味）700g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110115'; ##  枣片-精装（草莓味）70g
update xoops_market_spinfo set sp_sj=24.00,sp_cb=14,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110166'; ##  枣片-5种口味360g
update xoops_market_spinfo set sp_sj=10.00,sp_cb=6.2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110202'; ##  红枣干100克
update xoops_market_spinfo set sp_sj=18.80,sp_cb=11,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100110203'; ##  红枣干200g
update xoops_market_spinfo set sp_sj=108.00,sp_cb=65,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100111204'; ##  红枣干900g
update xoops_market_spinfo set sp_sj=40.00,sp_cb=20,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100112301'; ##  红枣粉（花粉味）480g
update xoops_market_spinfo set sp_sj=25.00,sp_cb=13.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100112302'; ##  红枣粉（原味）360g
update xoops_market_spinfo set sp_sj=40.00,sp_cb=20,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100112303'; ##  红枣粉（维钙味）480g
update xoops_market_spinfo set sp_sj=25.00,sp_cb=13.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100112304'; ##  红枣粉（野酸枣味）360g
update xoops_market_spinfo set sp_sj=268.00,sp_cb=150,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113401'; ##  黄帝御枣（红枣）960g
update xoops_market_spinfo set sp_sj=120.00,sp_cb=70,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113402'; ##  贡枣460g
update xoops_market_spinfo set sp_sj=238.00,sp_cb=115,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113403'; ##  新郑香枣1080g（特需专供）
update xoops_market_spinfo set sp_sj=48.00,sp_cb=26,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113404'; ##  新郑红枣-壹级1600g
update xoops_market_spinfo set sp_sj=15.00,sp_cb=8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113405'; ##  新郑红枣-壹级450g
update xoops_market_spinfo set sp_sj=29.00,sp_cb=16,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113407'; ##  新郑红枣-壹级900g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.389,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113458'; ##  新郑香枣小袋（特需专供）60g
update xoops_market_spinfo set sp_sj=62.00,sp_cb=35,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113461'; ##  贡枣小盒230克
update xoops_market_spinfo set sp_sj=4.50,sp_cb=2.2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113468'; ##  枣粒粒50g
update xoops_market_spinfo set sp_sj=10.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113478'; ##  红枣果干200g
update xoops_market_spinfo set sp_sj=58.00,sp_cb=24,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113482'; ##  枣吧320g
update xoops_market_spinfo set sp_sj=8.50,sp_cb=4.375,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113485'; ##  枣吧-小袋25g
update xoops_market_spinfo set sp_sj=130.00,sp_cb=70,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113486'; ##  枣吧-精装400g
update xoops_market_spinfo set sp_sj=16.80,sp_cb=8.75,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113487'; ##  枣吧-小袋50g
update xoops_market_spinfo set sp_sj=126.00,sp_cb=75,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100113489'; ##  黄帝御枣（红枣）_小盒480g
update xoops_market_spinfo set sp_sj=138.00,sp_cb=82,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114501'; ##  枣博士470g
update xoops_market_spinfo set sp_sj=258.00,sp_cb=138,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114502'; ##  特级健康红枣礼盒2000g
update xoops_market_spinfo set sp_sj=18.00,sp_cb=9.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114503'; ##  健康红枣果干220克
update xoops_market_spinfo set sp_sj=198.00,sp_cb=100,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114504'; ##  特级健康红枣1800g
update xoops_market_spinfo set sp_sj=118.00,sp_cb=67,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114505'; ##  特级健康红枣1000g
update xoops_market_spinfo set sp_sj=49.00,sp_cb=30,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114506'; ##  特级健康红枣450g
update xoops_market_spinfo set sp_sj=25.00,sp_cb=15,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114507'; ##  特级健康红枣220g
update xoops_market_spinfo set sp_sj=95.00,sp_cb=50,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114509'; ##  壹级健康红枣1000g
update xoops_market_spinfo set sp_sj=36.00,sp_cb=22,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114510'; ##  壹级健康红枣450g
update xoops_market_spinfo set sp_sj=18.00,sp_cb=11,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114511'; ##  壹级健康红枣220g
update xoops_market_spinfo set sp_sj=268.00,sp_cb=138,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114512'; ##  超特级健康红枣1530g
update xoops_market_spinfo set sp_sj=15.00,sp_cb=7.667,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114515'; ##  超特级健康红枣-小袋85g
update xoops_market_spinfo set sp_sj=13.00,sp_cb=6.9,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114530'; ##  特级健康红枣礼盒100g(小袋)
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.7,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114561'; ##  特级健康红枣100克
update xoops_market_spinfo set sp_sj=15.00,sp_cb=7,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114562'; ##  红枣新一代80克
update xoops_market_spinfo set sp_sj=72.00,sp_cb=41,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100114566'; ##  枣博士小盒235克
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100115601'; ##  无核红枣_壹级220g
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100115602'; ##  金丝枣_壹级220g
update xoops_market_spinfo set sp_sj=13.00,sp_cb=7,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100115603'; ##  无核红枣_壹级450g
update xoops_market_spinfo set sp_sj=13.00,sp_cb=6.2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100115604'; ##  金丝枣_壹级450g
update xoops_market_spinfo set sp_sj=3.00,sp_cb=2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116701'; ##  红枣新茶（红枣姜茶）500ml
update xoops_market_spinfo set sp_sj=6.00,sp_cb=2.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116702'; ##  红枣醋500ml
update xoops_market_spinfo set sp_sj=6.00,sp_cb=3,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116703'; ##  红枣醋饮240ml
update xoops_market_spinfo set sp_sj=18.00,sp_cb=8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116704'; ##  新郑红酒125ml
update xoops_market_spinfo set sp_sj=72.00,sp_cb=25,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116705'; ##  新郑红酒500ml
update xoops_market_spinfo set sp_sj=98.00,sp_cb=48,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116706'; ##  新郑红酒750ml(礼盒装)
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116710'; ##  红枣醋340ml
update xoops_market_spinfo set sp_sj=3.00,sp_cb=2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100116712'; ##  红枣新茶350ml
update xoops_market_spinfo set sp_sj=85.00,sp_cb=40,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117801'; ##  红枣家园360gX8盒
update xoops_market_spinfo set sp_sj=11.00,sp_cb=5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117802'; ##  红枣家园360g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.3,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117803'; ##  阿胶枣70g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117804'; ##  八珍枣70g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117805'; ##  玫瑰枣70g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117806'; ##  野酸枣100克
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117807'; ##  OK圣女果脯60g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117808'; ##  玫瑰枣280g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117809'; ##  野酸枣280克
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117810'; ##  阿胶枣280g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=6.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117811'; ##  八珍枣280g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=2.1,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117812'; ##  鲜蜜枣120g
update xoops_market_spinfo set sp_sj=12.00,sp_cb=5.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117813'; ##  好想你OK(蜜枣)500g
update xoops_market_spinfo set sp_sj=13.80,sp_cb=7,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117814'; ##  好想你OK(蜜枣)450g
update xoops_market_spinfo set sp_sj=6.00,sp_cb=2.6,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117815'; ##  玉枣100g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100117856'; ##  野酸枣70克
update xoops_market_spinfo set sp_sj=55.00,sp_cb=35,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100118901'; ##  枣花蜂蜜900ml
update xoops_market_spinfo set sp_sj=28.00,sp_cb=18,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100118902'; ##  枣花蜂蜜450ml
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.65,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119901'; ##  香心枣70g
update xoops_market_spinfo set sp_sj=4.00,sp_cb=1.65,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119902'; ##  芝麻枣70克
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119903'; ##  香心枣150克
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119904'; ##  芝麻枣150克
update xoops_market_spinfo set sp_sj=7.00,sp_cb=3.2,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119906'; ##  香酥枣120g
update xoops_market_spinfo set sp_sj=6.00,sp_cb=2.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119910'; ##  枣上好120g
update xoops_market_spinfo set sp_sj=8.00,sp_cb=3.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119911'; ##  枣上好（红枣）80g
update xoops_market_spinfo set sp_sj=18.00,sp_cb=9,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100119912'; ##  早上好80克
update xoops_market_spinfo set sp_sj=268.00,sp_cb=140,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100120489'; ##  有机枣
update xoops_market_spinfo set sp_sj=24.00,sp_cb=9,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100121101'; ##  枣馍馍240g
update xoops_market_spinfo set sp_sj=1.00,sp_cb=0.5,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100121199'; ##  各类散卖商品
update xoops_market_spinfo set sp_sj=40.00,sp_cb=22,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100140101'; ##  散野酸枣
update xoops_market_spinfo set sp_sj=6.00,sp_cb=3.8,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100160101'; ##  雪山牌咖喱牦牛肉干40g
update xoops_market_spinfo set sp_sj=58.00,sp_cb=38,sp_fjcb=0.0 where store_id='420101f278' and sp_code='100100160102'; ##  雪山牌咖喱牦牛肉干400g