am: 20. Dezember 2011, 21:51:00
Hallo,
ich würde gerne über Google Analytics nachvollziehen, ob bei einer Bestellung ein Rabattcode eingegeben wurde.
Eigentlich muss ich dazu doch nur die "checkout_success.php" und "checkout_success.html" anpassen und eine Custom Variable in Google Analytics anlegen.
Ich weiß allerdings nicht wie der Couponcode in der "checkout_success.php" ausgegeben werden kann.
Es geht um diesen Teil, da müsste ich den Couponcode irgendwie hinzufügen:
Auszug "checkout_success.php":
//Google Analytics E-Commerce-Tracking start$smarty->assign('oID',$last_order);$smarty->assign('CITY',$orders['customers_city']);$smarty->assign('STATE',$orders['customers_state']);$smarty->assign('COUNTRY',$orders['customers_country']);$orders_total_shipping_query = xtc_db_query
("select value from ".TABLE_ORDERS_TOTAL
." where orders_id = '".$last_order."' and class='ot_shipping'");$orders_total_shipping = xtc_db_fetch_array
($orders_total_shipping_query);$smarty->assign('SHIPPING',$orders_total_shipping['value']);$orders_total_tax_query = xtc_db_query
("select value from ".TABLE_ORDERS_TOTAL
." where orders_id = '".$last_order."' and class='ot_tax'");$orders_total_tax = xtc_db_fetch_array
($orders_total_tax_query);$smarty->assign('TAX',$orders_total_tax['value']);$orders_total_query = xtc_db_query
("select value from ".TABLE_ORDERS_TOTAL
." where orders_id = '".$last_order."' and class='ot_total'");$orders_total = xtc_db_fetch_array
($orders_total_query);$smarty->assign('VALUE',$orders_total['value']);$order_query = xtc_db_query
("SELECT categories_name, p.products_id, orders_products_id, products_model, products_name, products_price, products_quantity FROM ".TABLE_ORDERS_PRODUCTS
." p, ".TABLE_PRODUCTS_TO_CATEGORIES
." ptc, ".TABLE_CATEGORIES_DESCRIPTION
." cd WHERE p.products_id = ptc.products_id AND ptc.categories_id=cd.categories_id AND cd.language_id = 2 AND orders_id='".$last_order."'"); $order_data = array ();while ($order_data_values = xtc_db_fetch_array
($order_query)) {$order_data[] = array ('PRODUCTS_MODEL' => $order_data_values['products_id'],'PRODUCTS_NAME' => $order_data_values['products_name'],'CAT' => $order_data_values['categories_name'],'PRODUCTS_SINGLE_PRICE' => $order_data_values['products_price'],'PRODUCTS_QTY' => $order_data_values['products_quantity']);}$smarty->assign('order_data', $order_data);//Google Analytics E-Commerce-Tracking end Könnt ihr mir helfen?
Vielen Dank schon mal!
Gruß
Linkback: https://www.modified-shop.org/forum/index.php?topic=17493.0