商城SKU管理代码详解：使用PHP实现

// 获取商品属性信息和属性选项信息
$properties = [
    ['id' => 1, 'name' => '颜色', 'options' => ['红色', '蓝色', '黑色']],
    ['id' => 2, 'name' => '尺寸', 'options' => ['S码', 'M码', 'L码']]
];

// 生成所有可能的SKU编码
$skus = [];
foreach ($properties[0]['options'] as $color) {
    foreach ($properties[1]['options'] as $size) {
        $code = $properties[0]['id'] . ',' . $properties[1]['id'];
        $sku = [
            'code' => $code,
            'color' => $color,
            'size' => $size,
            'stock' => 100,
            'price' => 99.99
        ];
        $skus[] = $sku;
    }
}

// 将SKU信息存储到数据库中
foreach ($skus as $sku) {
    $sql = "INSERT INTO sku (code, color, size, stock, price) 
            VALUES ('{$sku['code']}', '{$sku['color']}', '{$sku['size']}', {$sku['stock']}, {$sku['price']})";
    // 执行SQL语句
    // ...
}

// 查询SKU信息
$productId = 1;  // 商品ID
$sql = "SELECT * FROM sku WHERE product_id = {$productId}";
// 执行SQL语句
// ...

// 更新SKU信息
$skuId = 1;  // SKU ID
$newStock = 50;  // 新的库存量
$sql = "UPDATE sku SET stock = {$newStock} WHERE sku_id = {$skuId}";
// 执行SQL语句
// ...