Title: Convert array in JSON
Last modified: October 3, 2019

---

# Convert array in JSON

 *  [Pierre Helium](https://wordpress.org/support/users/pierrethenot/)
 * (@pierrethenot)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/convert-array-in-json/)
 * Hi,
    Is there a way to get arrays for “Others” just like “Coupons” or “Products”
   in JSON?
 * Regards,
 * Pierre

Viewing 1 replies (of 1 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/convert-array-in-json/#post-11991993)
 * hi Pierre
 * Could you test this code ?
    thanks, Alex
 *     ```
       add_filter( "woe_json_output_filter", function($json, $record, $formatter){
       	$record['others'] =  woe_get_order_others(WC_Order_Export_Engine::$order_id); // EDIT key 
       	if ( $formatter->mode == 'preview' ) 
       		$flags = JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT ;
       	else
       		$flags = JSON_UNESCAPED_SLASHES;
       	return json_encode($record,$flags);	
       },10,3);
   
       function woe_get_order_others($order_id) {
       	global $wpdb;
       	$results = array();
       	$types = array( 'fee'=>'_fee_amount', 'shipping'=>'cost', 'tax'=>'tax_amount');
   
       	foreach($types as $type=>$key) {
       		$items = $wpdb->get_results("SELECT items.order_item_name, itemmeta.meta_value FROM {$wpdb->prefix}woocommerce_order_items items
       				INNER JOIN  {$wpdb->prefix}woocommerce_order_itemmeta itemmeta
       				ON items.order_item_id = itemmeta.order_item_id AND itemmeta.meta_key = '$key'
       				WHERE items.order_id = $order_id  AND items.order_item_type = '$type'"
       				);
       		foreach($items as $item)		
       			$results[ $item->order_item_name ] = $item->meta_value;
       	}	
       	return $results;
       }
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Convert array in JSON’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [6 years, 8 months ago](https://wordpress.org/support/topic/convert-array-in-json/#post-11991993)
 * Status: not resolved