Hi kowjirow,
simple script getting all products, next checking if they have woosb_ids meta, next if needed recreate meta to new version with required fields only and saving it to database. To use it save it in php file in the same catalog where you have wp-config and run it.
<?php
require_once(__DIR__ . '/wp-load.php');
$products = wc_get_products(['limit' => -1, 'return' => 'ids']);
foreach ($products as $product_id) {
$meta = get_post_meta($product_id, 'woosb_ids');
if ($meta && count($meta) && !is_array($meta['0'])) {
$meta = getProductsFromMeta($meta['0']);
if($meta) update_post_meta($product_id, 'woosb_ids', $meta);
}
}
function getProductsFromMeta($meta)
{
$output = [];
$produkty = explode(",", $meta);
foreach ($produkty as $singleProduct) {
$productData = explode("/", $singleProduct);
$product = wc_get_product($productData['0']);
if(!$product) return false;
$output[generateKey()] = ['id' => $productData['0'], 'sku' => $product->get_sku(), 'qty' => $productData['1']];
}
return $output;
}
function generateKey()
{
$key = '';
$key_str = 'abcdefghijklmnopqrstuvwxyz0123456789';
$key_str_len = strlen($key_str);
for ($i = 0; $i < 4; $i++) {
$key .= $key_str[random_int(0, $key_str_len - 1)];
}
if (is_numeric($key)) {
$key = generateKey();
}
return $key;
}
The script is simple, I didn’t want to write checking the product type at the beginning or adding additional, unnecessary fields to output, I only did it to make the bundles available for purchase again.
Hope that it will help you,
Have a nice day,
Pawe?
