Scheduled Orders: Affiliate Order Attribution to Created Scheduled Orders for Future Processing

In the example below, a developer captures a user's Affiliate Id and adds it to the created Scheduled Order's metadata at checkout. This attribution will be used (in this case added as an Order Note) when the Scheduled Order processes in the future.

Remember: Always test code on a staging site before adding it to your live site

Code Example:

 * Add Order Attribution to an Autoship Order's Metadata for future use in processed orders.
 * Example is each WC Checkout Order has an affiliate id which should carry on to all
 * Scheduled Orders spawned from that Checkout Order.
 * @param array $scheduled_order_data The Scheduled Order data to be sent to QPilot
 * @param int $order_id The WC Order ID
 * @return array The filtered Scheduled Order Data
function xx_add_inherited_metadata_to_scheduled_orders( $scheduled_order_data, $order_id ){

  // Retrieve the Affiliate ID from the WC Order and Attach it to the Scheduled Order data.
  $affliate_id = get_post_meta( $order_id, '_affiliate_id', NULL );

  // If there is an associated affiliate id then get the current orders metadata
  // add the affiliate id to that data and re-attach to the scheduled order data array
  if ( isset( $affliate_id ) ){

    $metadata = isset( $scheduled_order_data['metadata'] ) ? $scheduled_order_data['metadata'] : array();
    $metadata['wc_affiliate_id'] = $affliate_id;
    $scheduled_order_data['metadata'] = $metadata;


  return $scheduled_order_data;

add_filter( 'autoship_create_scheduled_order_data', 'xx_add_inherited_metadata_to_scheduled_orders', 10, 2 );

 * Adds An Order Note based on Attribution passed through from the Original Checkout Order.
 * @param int $order_id The WC Order ID
function xx_add_note_based_on_inherited_metadata( $order_id ){

  // Retrieve the WC Order
  $order = wc_get_order( $order_id );

  if ( !$order )

  // Retrieve the QPilot Metadata & The Partner Info if it exists
  $qpilot_metadata  = get_post_meta( $order->get_id(), '_qpilot_scheduled_order_metadata', true );
  $wc_affiliate_id  = isset( $qpilot_metadata['wc_affiliate_id'] ) ? $qpilot_metadata['wc_affiliate_id'] : '';

  // If there is an associated partner id & name so add a note to the order.
  if ( !empty( $wc_affiliate_id ))
  $order->add_order_note( sprintf( 'This order originated from affiliate %s checkout order.', $wc_affiliate_id ) );

add_action( 'woocommerce_payment_complete', 'xx_add_note_based_on_inherited_metadata', 10, 1 );


Affiliate Id added to Scheduled Order metadata at Checkout (viewable with API client like Postman GETing the Scheduled Order by Id)

Oder Note added when Scheduled Order processes in the future