php sku设计,PHP 产品库 SPU、SKU 如何设计？

其实没必要这么设置， 商品表设置两个表， 一个主表good_common, 一个商品表good表，在主表中 你设置添加两个字段 一个是规格名字;spec_name 一个是规格值;spec_value, 吧商品选中的规格和选中的规格值 都保存进去， 储层为序列化值就好了， 这个是主表的入库， 主表入库之后，得到刚刚入库的主表中的good_commid, 在根据表单的这个规格循环下， array (size=4)

'i_5860' =>

array (size=10)

'goods_id' => string '34280' (length=5)

'color' => string '58' (length=2)

'sp_value' =>

array (size=2)

58 => string '白色' (length=6)

60 => string '白色' (length=6)

'first_price' => string '558.00' (length=6)

'second_price' => string '560.00' (length=6)

'marketprice' => string '568.00' (length=6)

'price' => string '568.00' (length=6)

'stock' => string '98' (length=2)

'alarm' => string '0' (length=1)

'sku' => string '' (length=0)

'i_5861' =>

array (size=10)

'goods_id' => string '' (length=0)

'color' => string '58' (length=2)

'sp_value' =>

array (size=2)

58 => string '白色' (length=6)

61 => string '黑色' (length=6)

'first_price' => string '' (length=0)

'second_price' => string '' (length=0)

'marketprice' => string '568.00' (length=6)

'price' => string '568.00' (length=6)

'stock' => string '12' (length=2)

'alarm' => string '0' (length=1)

'sku' => string '' (length=0)

'i_5960' =>

array (size=10)

'goods_id' => string '34281' (length=5)

'color' => string '59' (length=2)

'sp_value' =>

array (size=2)

59 => string '黑色' (length=6)

60 => string '白色' (length=6)

'first_price' => string '558.00' (length=6)

'second_price' => string '560.00' (length=6)

'marketprice' => string '568.00' (length=6)

'price' => string '568.00' (length=6)

'stock' => string '99' (length=2)

'alarm' => string '0' (length=1)

'sku' => string '' (length=0)

'i_5961' =>

array (size=10)

'goods_id' => string '' (length=0)

'color' => string '59' (length=2)

'sp_value' =>

array (size=2)

59 => string '黑色' (length=6)

61 => string '黑色' (length=6)

'first_price' => string '' (length=0)

'second_price' => string '' (length=0)

'marketprice' => string '568.00' (length=6)

'price' => string '568.00' (length=6)

'stock' => string '14' (length=2)

'alarm' => string '0' (length=1)

'sku' => string '' (length=0)

类似这种数据格式， 循环插入商品表就好了， 但是每个的价格可能是不一样的，其他的应该都是一样的吧，