WP Data Sync

The only data sync API for WordPress websites.

WP Data Sync Icon

Filter WooCommerce price with search in array of arrays

WP Data Sync Code Example

Search WooCommerce price from an array of arrays. In this example we have multiple arrays of data. We search for the array that contain a certain value. Then, we obtain the price from that array.

Add this code snippet to your themes functions.php file.

NOTICE: Requires WP Data Sync plugin version 2.1.1 or higher.

Sample Data

$post_meta = [
    '_finish'     => 'Foil',
    '_api_prices' => [
        [
		    'subTypeName' => 'Normal',
			'highPrice'   => 199.99,
            'lowPrice'    => 129.99
		],
		[
			'subTypeName' => 'Foil',
			'highPrice'   => 299.99,
            'lowPrice'    => 229.99
		]
	]
];

How does the code work?

The code works by searching the arrays for the subTypeName that equals the value of the _finish field. Then, set the WooCommerce _regular_price with the value of the highPrice field from that array.

We run this on the wp_data_sync_set_property_post_meta filter hook so the _regular_price field will be subject to all other relevant filters.

Code Example

/**
 * DataSync set property post meta filter.
 * 
 * @param array $post_meta
 *                        
 * @return array                       
 */

add_filter( 'wp_data_sync_set_property_post_meta', function( $post_meta ) {

	if ( ! empty( $post_meta['_api_prices'] ) && ! empty( $post_meta['_finish'] ) ) {

		$key = array_search( $post_meta['_finish'], array_column( $post_meta['_api_prices'], 'subTypeName' ) );

		$post_meta['_regular_price'] = $post_meta['_api_prices'][ $key ]['highPrice'];

		unset( $post_meta['_api_prices'] );

	}

	return $post_meta;

}, 20, 1 );

Get Started