shopex sdb_goods和sdb_products的区别 商品和货品的区别 商品类型 商品规格 商品属性 商品入库 之间的关系和sql语句 上图

shopex中sdb_goods和sdb_products的区别  商品和货品的区别

先上图 

 

添加商品类型

      INSERT INTO `sdb_goods_type` ( `name`,`alias`,`is_physical`,`schema_id`,`props`,`setting`,`params`,`dly_func`,`ret_func` )

     VALUES ( '手机','','1','custom','a:0:{}','a:5:{s:9:\"use_brand\";s:1:\"1\";s:9:\"use_props\";s:1:\"1\";s:10:\"use_params\";s:1:\"0\";s:9:\"use_minfo\";s:1:\"0\";s:8:\"use_spec\";N;}','a:0:{}','0','0' )

 

 商品规格

INSERT INTO `sdb_specification` ( `spec_name`,`alias`,`spec_show_type`,`spec_type`,`spec_memo` )

VALUES ( 'weight','','flat','text','重量' )

 

INSERT INTO `sdb_spec_values` ( `spec_id`,`spec_value`,`alias`,`spec_image`,`p_order` )

VALUES ( 6,'10','1','',0 )

 

 

      INSERT INTO `sdb_gimages` ( `is_remote`,`source`,`src_size_width`,`src_size_height`,`up_time` ) VALUES ( 'false','gpic/20121207/92ac526a28d82e3d53e32976f1e772f5.jpg',966,926,1354848028 )

 

      INSERT INTO `sdb_gimages` ( `is_remote`,`source`,`src_size_width`,`src_size_height`,`up_time` ) VALUES ( 'false','gpic/20121207/216324ec37bc3ccbe345e27d5de5e67e.jpg',966,926,1354848034 )

 

    INSERT INTO `sdb_gimages` ( `is_remote`,`source`,`src_size_width`,`src_size_height`,`up_time` ) VALUES ( 'false','gpic/20121207/219e0832c85daed50920e087829449a0.jpg',1270,521,1354848038 )

 

     INSERT INTO `sdb_goods` ( `cat_id`,`type_id`,`brief`,`intro`,`mktprice`,`cost`,`price`,`bn`,`name`,`marketable`,`weight`,`unit`,`score`,`spec`,`pdt_desc`,`spec_desc`,`last_modify`,`d_order` ) VALUES ( 8,7,'啊发发阿萨德发','SAFASFDASFAF',558,400,500,'4225785','爱的发','true',50,'克',0,'a:2:{i:6;s:6:\"weight\";i:1;s:6:\"颜色\";}','a:0:{}','a:2:{i:6;a:1:{s:11:\"13548479741\";a:5:{s:10:\"spec_value\";s:2:\"10\";s:9:\"spec_type\";s:4:\"text\";s:13:\"spec_value_id\";s:2:\"81\";s:10:\"spec_image\";s:0:\"\";s:17:\"spec_goods_images\";s:0:\"\";}}i:1;a:2:{s:11:\"13548479772\";a:5:{s:10:\"spec_value\";s:6:\"灰色\";s:9:\"spec_type\";s:5:\"image\";s:13:\"spec_value_id\";s:1:\"8\";s:10:\"spec_image\";s:0:\"\";s:17:\"spec_goods_images\";s:0:\"\";}s:11:\"13548479783\";a:5:{s:10:\"spec_value\";s:9:\"卡其色\";s:9:\"spec_type\";s:5:\"image\";s:13:\"spec_value_id\";s:2:\"11\";s:10:\"spec_image\";s:0:\"\";s:17:\"spec_goods_images\";s:0:\"\";}}}',1354848041,50 )
    SELECT LAST_INSERT_ID() AS lastinsertid

    UPDATE `sdb_goods` SET last_modify=1354848041 WHERE goods_id=78
    UPDATE sdb_goods SET p_order=78 WHERE goods_id=78

 

 

      INSERT INTO `sdb_status` ( `status_key`,`date_affect`,`status_value`,`last_update` ) VALUES ( 'GOODS_ADD','2012-12-07','1',1354848041 )

 

      INSERT INTO `sdb_status` ( `status_key`,`date_affect`,`status_value`,`last_update` ) VALUES ( 'GOODS_ADD','0000-00-00','1',1354848041 )

    INSERT INTO `sdb_goods_memo` ( `goods_id`,`p_key`,`p_value` ) VALUES ( 78,'seo_info','a:3:{s:9:\"seo_title\";s:1:\"A\";s:13:\"meta_keywords\";s:1:\"B\";s:16:\"meta_description\";s:1:\"C\";}' )

 

 

     INSERT INTO `sdb_products` ( `goods_id`,`bn`,`price`,`cost`,`mktprice`,`name`,`weight`,`unit`,`store`,`store_place`,`pdt_desc`,`props`,`last_modify`,`marketable` ) VALUES ( 78,'001',500,400,558,'爱的发',50,'克',100,'121','10、灰色','a:3:{s:4:\"spec\";a:2:{i:6;s:2:\"10\";i:1;s:6:\"灰色\";}s:21:\"spec_private_value_id\";a:2:{i:6;s:11:\"13548479741\";i:1;s:11:\"13548479772\";}s:13:\"spec_value_id\";a:2:{i:6;s:2:\"81\";i:1;s:1:\"8\";}}',1354848041,'true' )

 

   INSERT INTO `sdb_products` ( `goods_id`,`bn`,`price`,`cost`,`mktprice`,`name`,`weight`,`unit`,`store`,`store_place`,`pdt_desc`,`props`,`last_modify`,`marketable` ) VALUES ( 78,'10014',500,400,558,'爱的发',50,'克',100,'121','10、卡其色','a:3:{s:4:\"spec\";a:2:{i:6;s:2:\"10\";i:1;s:9:\"卡其色\";}s:21:\"spec_private_value_id\";a:2:{i:6;s:11:\"13548479741\";i:1;s:11:\"13548479783\";}s:13:\"spec_value_id\";a:2:{i:6;s:2:\"81\";i:1;s:2:\"11\";}}',1354848041,'true' )

 

 

  INSERT INTO sdb_goods_spec_index ( type_id,spec_id,spec_value_id,goods_id,product_id ) VALUES  ( 7,6,81,78,311 ) , ( 7,1,8,78,311 ) , ( 7,6,81,78,312 ) , ( 7,1,11,78,312 )

    INSERT INTO `sdb_goods_memo` ( `goods_id`,`p_key` ) VALUES ( 78,'adjunct' )

 

我们来查一下商品类型表：

SELECT*
FROM `sdb_goods_type`
WHERE `type_id` =1
LIMIT 0 , 30

			type_id	name	alias	is_physical	supplier_id	supplier_type_id	schema_id	props	spec	setting	minfo	params	dly_func	ret_func	reship	disabled	is_def	lastmodify
			1	通用商品类型	NULL	1	NULL	NULL	simple		NULL	a:4:{s:8:"use_spec";N;s:9:"use_brand";b:1;s:9:"use...	NULL	a:0:{}	0	0	normal	false	true	NULL

发现有个字段props            可以进行反序列化              $props = unserialize( $props );

a:4:{i:1;a:8:{s:4:"name";s:6:"质地";s:5:"alias";N;s:4:"type";s:6:"select";s:6:"search";s:3:"nav";s:7:"options";a:11:{i:0;s:6:"牛皮";i:1;s:6:"羊皮";i:2;s:5:"PU皮";i:3;s:6:"漆皮";i:4;s:6:"帆布";i:5;s:6:"仿皮";i:6;s:6:"蛇皮";i:7;s:6:"毛绒";i:8;s:6:"亚麻";i:9;s:6:"布料";i:10;s:6:"尼龙";}s:11:"optionAlias";a:11:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";i:7;s:0:"";i:8;s:0:"";i:9;s:0:"";i:10;s:0:"";}s:4:"show";i:1;s:8:"ordernum";s:0:"";}i:2;a:8:{s:4:"name";s:6:"风格";s:5:"alias";N;s:4:"type";s:6:"select";s:6:"search";s:3:"nav";s:7:"options";a:6:{i:0;s:6:"休闲";i:1;s:6:"正装";i:2;s:6:"百搭";i:3;s:6:"韩版";i:4;s:6:"日版";i:5;s:6:"欧式";}s:11:"optionAlias";a:11:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";i:7;s:0:"";i:8;s:0:"";i:9;s:0:"";i:10;s:0:"";}s:4:"show";i:1;s:8:"ordernum";s:0:"";}i:3;a:8:{s:4:"name";s:6:"款式";s:5:"alias";N;s:4:"type";s:6:"select";s:6:"search";s:3:"nav";s:7:"options";a:11:{i:0;s:9:"手提包";i:1;s:9:"单肩包";i:2;s:9:"双肩包";i:3;s:9:"手挽包";i:4;s:9:"斜挎包";i:5;s:6:"手包";i:6;s:6:"钱包";i:7;s:6:"腰包";i:8;s:9:"化妆包";i:9;s:9:"行李箱";i:10;s:9:"购物袋";}s:11:"optionAlias";a:11:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";i:7;s:0:"";i:8;s:0:"";i:9;s:0:"";i:10;s:0:"";}s:4:"show";i:1;s:8:"ordernum";s:0:"";}i:4;a:8:{s:4:"name";s:6:"图案";s:5:"alias";N;s:4:"type";s:6:"select";s:6:"search";s:3:"nav";s:7:"options";a:7:{i:0;s:6:"纯色";i:1;s:6:"条纹";i:2;s:6:"印花";i:3;s:6:"绣花";i:4;s:6:"几何";i:5;s:6:"格子";i:6;s:6:"卡通";}s:11:"optionAlias";a:11:{i:0;s:0:"";i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";i:7;s:0:"";i:8;s:0:"";i:9;s:0:"";i:10;s:0:"";}s:4:"show";i:1;s:8:"ordernum";s:0:"";}}

 

 

当我在更改一个商品的时候操作如下sql语句：

      UPDATE `sdb_goods_type` SET `props`='a:1:{i:1;a:8:{s:4:\"name\";s:6:\"mcolor\";s:5:\"alias\";s:1:\"c\";s:4:\"type\";s:6:\"select\";s:6:\"search\";s:3:\"nav\";s:7:\"options\";a:6:{i:0;s:1:\"b\";i:1;s:1:\"g\";i:2;s:1:\"r\";i:3;s:1:\"t\";i:4;s:1:\"m\";i:5;s:1:\"n\";}s:11:\"optionAlias\";a:6:{i:0;b:0;i:1;b:0;i:2;b:0;i:3;b:0;i:4;b:0;i:5;b:0;}s:4:\"show\";i:1;s:8:\"ordernum\";s:1:\"1\";}}' WHERE type_id=7