CODEWITHSUNDEEP
wordpresswoocommercesubscription
TARKUS
TARKUS

Reputation: 2200

WooCommerce v6.4.1 - How do I get product id/name associated with a subscription id?

We operate a subscription service with three subscription levels. I'll call them Silver, Gold, and Platinum. The subscriptions are associated with variable products. So, you can buy a Silver subscription at $11-a-month, $22-a-month, $44-a-month, and up it goes to $1000-a-year. These all have descriptive names like "Six Month Gold Member", etc.

Before posting this question, I've tried many, many answers I've found to very similar questions, but I think they must not work any more with WC 6.n. Or, maybe it has something to do with our products or settings or environment.

My flow looks like this:

It's that second step I'm stuck on.

The code I use to get the current user's active subscriptions works great:

$subscriptions = wcs_get_subscriptions( //query WC for this user's active subscriptions.
        array(
            'customer_id' => $user_id,
            'subscription_status' => 'active',
            'subscriptions_per_page' => - 1
        )
);

// iterate through each subscription to extract the subscription id.
foreach($subscriptions as $subscription){ 
    $subscription_id = $subscription->get_id();
    echo $subscription_id . "<br>";
    $subscription_products = $subscription->get_items();
    $order_key = $subscription->get_order_key(); // I do get an order_key
    $order_id = $subscription->get_parent_id(); // I do get an order_id
    //echo $order_id . "<br>"; // 
    $order = new WC_Order( $subscription_id ); // No errors here.

    // This doesn't produce anything.
    foreach($order->get_items() as $item) {
        $product_name = $item['name'];
        echo $product_name . "<br>";
    }
    //print_r($order);
}

I've scoured SO and elsewhere for a method to retrieve the product name from a member's subscription. Even Subscription Details on the My Account page never show exactly what package I bought.

A few answers to my question can be found on the forum dating up to 2017, but I think WC has made quite a few changes, with deprecated functions that no longer work.

If I try this:

$subscription_products = $subscription->get_items();
$order_key = $subscription->get_order_key();
$order_id = $subscription->get_parent_id();
echo $order_id . "<br>";
$order = new WC_Order( $subscription_id );
        
print_r($order->get_items()); // returns an empty array

...it returns an empty array.

Finally, I notice that in the actual WP->WooCommerce->Subscriptions->Edit a subscription panel, I get the same information as my code does, and nowhere in the WooCommerce Subscriptions dashboard does it show the actual product name a user bought.

Upvotes: 0

Views: 644

Answers (1)

Vinay Jain
Vinay Jain

Reputation: 882

Here's the code that should work for you:

$subscriptions = wcs_get_subscriptions(
        array(
            'customer_id' => $user_id,
            'subscription_status' => 'active',
            'subscriptions_per_page' => - 1
        )
);

// iterate through each subscription to extract the subscription id.
foreach ($subscriptions as $subscription) { 
    $related_orders_ids_array = $subscription->get_related_orders();

    foreach ( $related_orders_ids_array as $order_id ) {

        $order = new WC_Order( $order_id );
        //$items = $order->get_items(); 
        $items = $order->get_items( apply_filters( 'woocommerce_purchase_order_item_types', 'line_item' ) );

        //This will get items in order
        foreach ( $items as $product ) {
            print_r( $product ); //this will give you product object
        }
    }
}

Let me know if this works for you or you face any issues with this code.

Upvotes: 1

Related Questions