Add GA and FB Ecommerce Tracking 2.0.3.1 2.2.2 Bravo Net Solution http://bravonet.my db->query("SELECT * FROM " . DB_PREFIX . "order_total WHERE code = 'tax' AND order_id = '" . $order_id . "' LIMIT 1"); return $query->row; } public function getOrderShipping($order_id){ $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_total WHERE code = 'shipping' AND order_id = '" . $order_id . "' LIMIT 1"); return $query->row; } public function getOrderProducts($order_id){ $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . $order_id . "'"); if($query->num_rows){ return $query->rows; } else { return false; } } ]]> session->data['order_id'])) {]]> session->data['order_id']; ]]> data['heading_title'] = $this->language->get('heading_title');]]> load->model('checkout/order'); //GET ORDER DETAILS $order_info = $this->model_checkout_order->getOrder($order_id); //NEW MODEL TO COLLECT TAX $get_order_tax = $this->model_checkout_order->getOrderTax($order_id); if($get_order_tax){ //ASSIGN TAX TO NEW VARIABLE $order_tax = $get_order_tax['value']; } else { //THERE WAS NO TAX COLLECTED $order_tax = ''; } //NEW MODEL TO COLLECT SHIPPING $get_order_shipping = $this->model_checkout_order->getOrderShipping($order_id); if($get_order_shipping){ //ASSIGN SHIPPING TO NEW VARIABLE $order_shipping = $get_order_shipping['value']; } else { //THERE WAS NO SHIPPING COLLECTED $order_shipping = 0; } //NEW MODEL TO COLLECT ALL PRODUCTS ASSOCIATED WITH ORDER $get_order_products = $this->model_checkout_order->getOrderProducts($order_id); //CREATE ARRAY TO HOLD PRODUCTS $order_products = array(); foreach($get_order_products as $prod){ $order_products[] = array( 'order_id' => $order_id, 'model' => $prod['model'], 'name' => $prod['name'], 'category' => '', 'price' => number_format($prod['price'], 2, '.', ','), 'quantity' => $prod['quantity'] ); } //NEW ORDER ARRAY $order_tracker = array( 'order_id' => $order_id, 'store_name' => $order_info['store_name'], 'total' => $order_info['total'], 'tax' => $order_tax, 'shipping' => $order_shipping, 'city' => $order_info['payment_city'], 'state' => $order_info['payment_zone'], 'country' => $order_info['payment_country'], 'currency' => $order_info['currency_code'], 'products' => $order_products ); $this->data['order_tracker'] = $order_tracker; } ]]> ]]> '; $tracking_info .= "ga('require', 'ecommerce');"; //ADD TOP LEVEL TRACKING INFO $tracking_info .= "ga('ecommerce:addTransaction', { id: '" . $order_tracker['order_id'] . "', affiliation: '" . $order_tracker['store_name'] . "', revenue: '" . $order_tracker['total'] . "', shipping: '" . $order_tracker['shipping'] . "' , tax: '" . $order_tracker['tax'] . "' }); "; //ADD INFO FOR EACH PRODUCT foreach($order_tracker['products'] as $product){ $tracking_info .= "ga('ecommerce:addItem', { id: '" . $order_tracker['order_id'] . "', sku: '" . $product['model'] . "', name: '" . $product['name'] . "', category: '', price: '" . $product['price'] . "', quantity: '" . $product['quantity'] . "'});"; } $tracking_info .= "ga('ecommerce:send');"; $tracking_info .= ''; echo $tracking_info; ?> ]]>