How do I get customfield value by woocommerce product ID?

Watson

I am trying to get WooCommerce 's custom field value from a product ID array
Tried $productArray1 is a list of product ID but failed

global $wpdb;
global $product;

foreach ($productArray1 as $value)
{
    $querystr = "
    SELECT meta_value
    FROM $wpdb->postmeta.meta_key
    WHERE $wpdb->postmeta.meta_key = 'product_cip'
    AND $wpdb->posts.$product->ID=$value
    ORDER BY meta_value DESC
    ";

    $productsCIP = $wpdb->get_results($querystr, OBJECT);

    if ( ! $productsCIP ) {
        $wpdb->print_error();
    }
    else {
        echo $productsCIP;
    }
};

I am able to get all product with the same custom field by this

$products = wc_get_products( array( 'product_cip' => '3337875548519' ) );
echo 'PRODUCT WITH SAME CIP (TOTAL : '.count($products).')<br>';

I want to find 'product_cip'by product ID.
Any help

anderson

If you have all the products with 'product_cip' you can go with this

$a=array(
    'post_type'      => 'product',
    'post_status'    => 'publish',
    'posts_per_page' => - 1,
    'meta_query'     => array(
        array(
            'key'    => 'product_cip',
            'value'  => 'some value',
            'compare'=> '='
        )
    ),
    'fields' => 'ids'
);
$b=get_posts($a);
echo count($b);

And if you are looking to get all the product data then

$products_array=array();
foreach($b as $v){
    $_product=wc_get_product($v);
    echo $_product->get_name().',';
    $products_array[]=$_product;
}