Hallo!
Ich habe Google eCommerce Tracking in unseren Shop integriert. Es wird auch alles getrackt, bis auf die Kategorie.
Code in der checkout_success.php:
$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); Wenn ich eine Bestellung ausführe und im letzten Schritt, d.h. der checkout_success.html, den Quelltext betrachte, ist alles ausgefüllt. Nur die Kategorie ist leer.
Code in der checkout_success.html:
<script type="text/javascript">
pageTracker._addTrans(
'{$oID}',
"Shop",
'{$VALUE}',
'{$TAX}',
'{$SHIPPING}',
'{$CITY}',
'{$STATE}',
'{$COUNTRY}'
);
{foreach name=aussen item=order_values from=$order_data}
pageTracker._addItem(
'{$oID}',
'{$order_values.PRODUCTS_MODEL}',
'{$order_values.PRODUCTS_NAME}',
'{$order_values.CAT}',
'{$order_values.PRODUCTS_SINGLE_PRICE}',
'{$order_values.PRODUCTS_QTY}'
);
{/foreach}
pageTracker._trackTrans();
</script>
Habt Ihr eine Idee?
Danke und Gruß.
Linkback: https://www.modified-shop.org/forum/index.php?topic=8537.0