· 4 years ago · May 06, 2021, 01:56 PM
1$orders = new Order($accessKey, $secretKey, 99);
2$orders->start();
3
4foreach (commerce_order_load_multiple(array_keys($results['commerce_order'])) as $order) {
5 $data = [];
6 foreach ($order->commerce_line_items[LANGUAGE_NONE] as $item) {
7 $item = commerce_line_item_load($item['line_item_id']);
8 switch ($item->type) {
9 case 'commerce_discount':
10 case 'fee':
11 case 'shipping':
12 break 2;
13 default:
14 $data[] = [
15 'OrderID' => $order->order_id,
16 'UserId' => $order->uid,
17 'Email' => $order->mail,
18 'DateTime' => date('c', $order->placed),
19 'ProdCode' => $item->line_item_label,
20 'Quantity' => $item->quantity,
21 'UnitPrice' => $item->commerce_unit_price[LANGUAGE_NONE][0]['amount'] / 100,
22 ];
23 break;
24 }
25 }
26 $orders->append($data);
27}
28$orders->end();
29