Adding future date/time to TrustPilot script in Magento Packing Slip

Question

I am about to add a "Structured Data Snippet" to my Magento packing slip emails, which should include a future date.

The snippet looks like this (example data):

<script type="application/json+trustpilot">
{
  "recipientName": "Name MacNameson",
  "recipientEmail": "[email protected]",
  "referenceId": "1234abcd",
  "preferredSendTime": "2016-02-29T13:37:00"
}
</script>

...and the preferredSendTime should be set to 7 days from now. Time could be 18:00 on them all..

So for instance; if the packing slip is created 2018-03-14 in the morning some time, the value should show "2018-03-21T18:00:00" (which is 18:00 the evening 7 days later)

How can I achieve this? Any help appreciated.

Answer 1

In your email template (via editor at Magento admin -> System -> Transactional emails), do;

{{block type='core/template' area='frontend' template='email/custom/trustpilot.phtml' order=$order}}

Make new file in your template folder, app/design/frontend/[your theme]/default/email/custom/trustpilot.phtml

Here's how I do it, I define different for UK and Worldwide, but you can change as you wish (trustpilot.phtml);

<?php $order = $this->getOrder(); ?>
<?php if ($order) { ?>
<?php $country = $order->getShippingAddress()->getCountryModel()->getName(); ?>
<?php $date = $order->getCreatedAtStoreDate()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); ?>
<?php
  if ($country == "United Kingdom") {
    $nextDate =  Mage::getModel('core/date')->date('Y-m-d H:i:s', strtotime($date." +10 days"));
  } else {
    $nextDate =  Mage::getModel('core/date')->date('Y-m-d H:i:s', strtotime($date." +21 days"));
  }

  $nextDate = str_replace(' ', 'T', $nextDate); ?>

<script type="application/json+trustpilot">
{
  "recipientName": "<?php echo $order->getBillingAddress()->getFirstname(); ?>",
  "referenceId": "<?php echo $order->getIncrementId(); ?>",
  "preferredSendTime": "<?php echo $nextDate; ?>",
}
</script>

<?php } ?>