script for thank you page

[100asa]

A service for trusted reviews have asked me to add this code

<script type="text/javascript" src="https://tracking.trovaprezzi.it/javascripts/tracking.min.js" async="true"></script>

  <script type="text/javascript">
      window._tt = window._tt || [];
      window._tt.push({ event: "setAccount", id: /* keymerchant */ });
      window._tt.push({ event: "setOrderId", order_id: /* idorder */ });
      window._tt.push({ event: "setEmail", email: /* emailcucstomer */ });
      window._tt.push({ event: "addItem", sku: /* sku */, product_name: /* product_name */ });
      window._tt.push({ event: "orderSubmit"});
  </script> 

They asked me to put this code into thank you page.
Where can I put this code into zencart?
Many thanks to who help me.

[store-support]

Hi
You can add it at the bottom of includes/templates/yourtemplate/templates/tpl_checkout_success.php file, just remember to replace these tags /* keymerchant */ ... with proper zencart variables.

[lat9]

Create the file /includes/modules/pages/checkout_success/jscript_tracking.php that contains:

<?php
//-Add the tracking script only for the checkout_success page
?>
  <script type="text/javascript" src="https://tracking.trovaprezzi.it/javascripts/tracking.min.js" async="true"></script>

  <script type="text/javascript">
      window._tt = window._tt || [];
      window._tt.push({ event: "setAccount", id: /* keymerchant */ });
      window._tt.push({ event: "setOrderId", order_id: /* idorder */ });
      window._tt.push({ event: "setEmail", email: /* emailcucstomer */ });
      window._tt.push({ event: "addItem", sku: /* sku */, product_name: /* product_name */ });
      window._tt.push({ event: "orderSubmit"});
  </script>

[100asa]

Ok, thanks. But how can retrieve the orderID, custoemr email and product_name (sku)?

[100asa]

you can see an example here: https://tracking.trovaprezzi.it/guida.html

[lat9]

That will need a bit more processing, similar to:

<?php
//-Add the tracking script only for the checkout_success page
$customer_email_info = $db->Execute ("SELECT customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id = " . (int)$_SESSION['customers_id'] . " LIMIT 1");
if (!$customer_email_info->EOF) {
  $customers_email_address = $customer_email_info->fields['customers_email_address'];
?>
  <script type="text/javascript" src="https://tracking.trovaprezzi.it/javascripts/tracking.min.js" async="true"></script>

  <script type="text/javascript">
      window._tt = window._tt || [];
      window._tt.push({ event: "setAccount", id: /* keymerchant */ });
      window._tt.push({ event: "setOrderId", <?php echo $order_id; ?>: /* idorder */ });
      window._tt.push({ event: "setEmail", "<?php echo $customers_email_address; ?>": /* emailcucstomer */ });
<?php
  foreach ($orders->products as $current_product) {
?>
      window._tt.push({ event: "addItem", "<?php echo $current_product['model']; ?>": /* sku */, "<?php echo $current_product['name']; ?>": /* product_name */ });
<?php
  }
?>
      window._tt.push({ event: "orderSubmit"});
  </script>
<?php
}

Please note that the item-related output will most likely fail if you have a product that doesn't have a model number. You'll need to "hardcode" whatever your merchant account key is into the id spot; make sure to enclose it in quotes, e.g. "XYZZY-001".

[100asa]

sorry, but the variables to substitute with zencart values are enclosed into /* */
as /* idorder */ and /* emailcustomer */ .....

[lat9]

How's this:

<?php
//-Add the tracking script only for the checkout_success page
$customer_email_info = $db->Execute ("SELECT customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id = " . (int)$_SESSION['customers_id'] . " LIMIT 1");
if (!$customer_email_info->EOF) {
  $customers_email_address = $customer_email_info->fields['customers_email_address'];
?>
  <script type="text/javascript" src="https://tracking.trovaprezzi.it/javascripts/tracking.min.js" async="true"></script>

  <script type="text/javascript">
      window._tt = window._tt || [];
      window._tt.push({ event: "setAccount", id: /* keymerchant */ });
      window._tt.push({ event: "setOrderId", order_id: <?php echo $order_id; ?> /* idorder */ });
      window._tt.push({ event: "setEmail", email: "<?php echo $customers_email_address; ?>" /* emailcucstomer */ });
<?php
  foreach ($orders->products as $current_product) {
?>
      window._tt.push({ event: "addItem", sku: "<?php echo $current_product['model']; ?>" /* sku */, product_name: "<?php echo $current_product['name']; ?>" /* product_name */ });
<?php
  }
?>
      window._tt.push({ event: "orderSubmit"});
  </script>
<?php
}

[100asa]

Thank you so much for your help!
I wait for the mechant-key from Trovaprezzi search engine, and then let you know if your script works well.

[100asa]

<?php
//-Add the tracking script only for the checkout_success page
$customer_email_info = $db->Execute ("SELECT customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id = " . (int)$_SESSION['customers_id'] . " LIMIT 1");
if (!$customer_email_info->EOF) {
  $customers_email_address = $customer_email_info->fields['customers_email_address'];
?>
  <script type="text/javascript" src="https://tracking.trovaprezzi.it/javascripts/tracking.min.js" async="true"></script>

  <script type="text/javascript">
      window._tt = window._tt || [];
      window._tt.push({ event: "setAccount", id: "RMUnJ1SUw1" });
      window._tt.push({ event: "setOrderId", order_id: "<?php echo $order_id; ?>" });
      window._tt.push({ event: "setEmail", email: "<?php echo $customers_email_address; ?>"  });
<?php
  foreach ($orders->products as $current_product) {
?>
      window._tt.push({ event: "addItem", sku: "<?php echo $current_product['model']; ?>" , product_name: "<?php echo $current_product['name']; ?>" });
<?php
  }
?>
      window._tt.push({ event: "orderSubmit"});
  </script>
<?php
}

but nothing happens