How can I use wp_query to show all product data using just the products ID?

Question

While on a product page (product 1), I am trying to pull through information about a different relevant product (product 2).

To create a kind of 'you may also like' list of products.

I am trying the simplest of WP_Query but cannot figure out how to pull through all the product data from one product (product 2) in a list so I can see ahead of time what will be available to bring across to the product I am currently browsing (product 1).

I need something along the lines of this:

<?php
$additional_forms_args = array(
    'post_type' => 'product',
    'posts_per_page' => 1,
    'p' => $other_form_product_id
);

$additional_form_query = new WP_Query($additional_forms_args);

if ( $additional_form_query->have_posts() ) :

    while ( $additional_form_query->have_posts() ) : $additional_form_query->the_post();

            global $product;

            $attributes = $product->get_attributes();

            var_dump( $attributes );

    endwhile;

    wp_reset_postdata();

endif;

I am expecting a var_dump of the products data I have inserted the product_id of.

I expect to see an array of product data for the product with the ID of what I place into the args, instead I get an empty array:

array(0) { }

Please can someone help me to gather all product data associated with a product separate to the one I am currently browsing and dump its data for inspection?

EDIT (refine question):

I also have this snippet creating a variable on my products:

woocommerce_wp_checkbox(
    array(
        'id' => 'greener_production',
        'wrapper_class' => 'show_if_simple',
        'label' => __('Greener Production', 'woocommerce'),
        'description' => __('Tick if this product is the result of Greener Production', 'woocommerce'),
    )
);

Within this same snippet could we query this to see if this is ticked or not 'yes : no'?

Thanks, Jason.

Answer 1

I literally did this same thing this morning. Here's a function that you can use. You can add the function to your functions.php (or wherever) and then call the function on your template:

 /**
 * @param array $product_ids product_id the product id for the product you want to retrieve.
 *
 * @return string the HTML output
 */
function wpse361339_relevant_products( $product_ids = [] ) {
    global $post;

    // Bail early if there is not product ids.
    if ( is_empty( $product_ids ) ) :
         return;
    endif;

    // Args here
    $args = [
        'post_type'      => 'product',
        'posts_per_page' => 1,
        'post__in'       => $product_ids,
        // MORE ARGS HERE IF NECESSARY
    ];

    $related_products = get_posts( $args );

    $product_output = '';

    foreach ( $related_products as $related_product ) {

        // Get the product object so we have access to the attributes.
        $product = wc_get_product( $related_product->ID );

        // $product_output .= BUILD YOUR MARKUP HERE
        echo '<pre>' . print_r( $product, TRUE ) . '</pre>';

    }

    return $product_output;
}

I made it so you can pass whatever product ids you want as an array to the function. Then do what you want with the attributes.

To use on your template: wpse361339_relevant_products( [ 'product_id_here' ] );

EDIT To get the attributes in the WP_Query(), you can simply do this inside of your while loop:

$product_data = wc_get_product( get_the_ID() );
var_dump( $product_data );

In context:

<?php
$additional_forms_args = array(
    'post_type' => 'product',
    'posts_per_page' => 1,
    'p' => $other_form_product_id
);

$additional_form_query = new WP_Query($additional_forms_args);

if ( $additional_form_query->have_posts() ) :

    while ( $additional_form_query->have_posts() ) : $additional_form_query->the_post();

            $product_data = wc_get_product( get_the_ID() );
            var_dump( $product_data );

    endwhile;

    wp_reset_postdata();

endif;

To get specific product data you can use the methods from: https://docs.woocommerce.com/wc-apidocs/class-WC_Product.html

Like $product_data->get_title() will get you the title.

EDIT 2 The checkbox data is saved in the product meta, so you get it: $product_data->get_meta();

Answer 2

You don't really need to use de WP_Query object. The get_posts() function will make it in a much better way. And you can use all the $args that applies to conventional WP posts.

Note the include argument, which includes in the query only the products with given ID.

 $args = array( 'post_type' => 'product', 
            'orderby' => 'date', 'order'=>'DESC', 
            'posts_per_page' => 5,
            'include'=> array(
                'ID' => /*product ID here (int)*/
            ) 
        );
        $product = get_posts( $args );