shopex是什么意思shopex助理

中间的数字代表sdb_goods_cat表中的cat_id。。。表示数据库中产品分类的id。。。

添加gimagesinsertintosdb_gimages(goods_id,is_remote,source,orderby,src_size_width,src_size_height,small,big,thumbnail,up_time)selectgoods_id,"true","N",
0,"100","100",image_file,image_file,image_file,UNIX_TIMESTAMP(NOW())Fromsdb_goods;

updatesdb_goodsg1,sdb_gimagesg2setimage_default=g2.gimage_idwhereg1.goods_id=g2.goods_id;

修改价格updatesdb_goodssetprice=1950wheregoods_idin(1734,1730);updatesdb_goods_lv_pricesetprice=1950wheregoods_idin(1734,1730);updatesdb_productssetprice=1950wheregoods_idin(1734,1730);