Export orders from Woocommerce in JSON FORMAT

Question

I'm trying to export orders item from the plugin of wordpress Woocommerce and I create a template in wordpress with my querys for get the data of orders inside of array ``` <?php //query global $woocommerce; global $wpdb; global $product; $args = array( 'post_type' => 'shop_order', 'orderby' => 'ID', 'post_status' => 'publish', 'posts_per_page' => -1, 'tax_query' => array(array( 'taxonomy' => 'shop_order_status', 'field' => 'slug', 'terms' => array('processing')))); $loop = new WP_Query( $args ); $order_id = $loop->post->ID; $order = new WC_Order($order_id); $product = new WC_Product($order_id); //Email verificacion if is suscribed or not $sql = "SELECT * FROM dsr_wysija_user WHERE email='". $order->order_custom_fields['_billing_email'][0] ."'" ; $res = mysql_query($sql); if (mysql_num_rows($res)== 1){ $email = 'true'; }else{ $email = 'false'; } // Getting names of categories and quantity foreach($order->get_items() as $item) { $item['name']; $item['qty']; } //Collecting data in ARRAY…

Accepted Answer

Assuming this is your items loop

```
// Getting names of categories and quantity 
foreach($order->get_items() as $item) 
{
   $json['items'][] = array (
       'name' => $item['name'],
       'quantity' => $item['qty']
}
```

Try above code just before `while ( $loop->have_posts() )`

Export orders from Woocommerce in JSON FORMAT

Solution

Problem