How to display "Products URL" on invoice ?

[sab522]

Hi,

I'm using Zen Cart 1.3.8.
I want to add the "Product URL" to the invoice. The "Product URL" is found in the products_description Table.
How can I do that ? Please help. Thank you.

Sabrina

[Ajeh]

I would not recommend this ...

Too many URLs = spamm flag

Too many URLs = multiple open windows

Just the one URL to their Account History works well and you do not run into tripping various spamm flags ...

What did you want to do with the separate Product URLs that you could do with the My Account history?

[sab522]

Hi Linda,

We need add an additional field to product : Location (warehouse gate number) and display it on the invoice.

As we don't have time and don't need the URL field, we just want to put this Location information into this URL field.

My question is how can I display this Location at the bottom of the invoice ? (please see the image attached)

Here's the code for that in my invoice.php (Item and Qty are OK, but it doesn't work for the Location:
<table width="50%" align="center">
<tr>
<td align="center"><b>Item</b></td>
<td align="center"><b>Qty</b></td>
<td align="center"><b>Location</b></td>
</tr>
<tr>
<td align="center"><?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {echo $order->products[$i]['model']. "<br />"; }
?></td>
<td align="center"> <?php for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {echo $order->products[$i]['qty']. "<br />"; }
?></td>
<td align="center"> <?php for ($i = 0, $n = sizeof($pInfo->products); $i < $n; $i++) {echo $pInfo->products[$i]['url']. "<br />"; }
?></td>
</tr>
</table>

Please help. Thank you.
Sabrina

[sab522]

Here is the image I forgot to attach.

[Ajeh]

The URL is not saved to the orders tables ...

However, you can look up the URL from the products table with the function:

/*
 * Return any field from products or products_description table
 * Example: zen_products_lookup('3', 'products_date_added');
 */
  function zen_products_lookup($product_id, $what_field = 'products_name', $language = '') {

[susb8383]

Linda, is your code above complete? It looks to me like it might have been cut off. I see an a lone { at the end of the final line.

[Ajeh]

I was just showing the start of the function that can be used and its syntax ... this is not the actual code to use, just what function you can use ...

[susb8383]

Gotcha.

Thanks.