Getting item location into new_order.html

[sachin427]

Hello,

 

I was wondering if anyone knows how to get the location of the item (stored in product_attribute -> location in the database) to appear in the e-mail new_order.html. I have modified my template new_order.html to accomodate for a new column, and have tried entering the following codes into mailalerts.php (with no luck) within the $itemsTable part of the file:

 

<td style="padding:0.6em 0.4em;">'.$product['location'].'</td>

 

<td style="padding:0.6em 0.4em;">'.$product_attribute['location'].'</td>

 

Thanks in advance for any clues.

 

locations of the aformentioned files:

\modules\mailalerts\mails\en\new_order.html

\modules\mailalerts\mailalerts.php

[bellini13]

adding the following line to the $itemsTable in mailalerts.php should have done it. You would need to alter the new_order.html so that there are 6 table columns, so that it would align properly, but you should atleast see the value. Did you confirm that the database has a value in the location column?

 

<td style="padding:0.6em 0.4em;">'.$product['location'].'</td>

[sachin427]

Thanks for your response. The information is contained inside table 'ps_product_attribute' in field 'location'. I also tried the following with no luck.

 

<td style="padding:0.6em 0.4em;">'.$product['attribute_location'].'</td>