Product Images on Invoice, Email, etc [Support Thread]

This is the official support thread for the following module:
Product Images on Invoice, Email, etc

is not working with edit orders and Ty Package Tracker can some one merge them for me orders.php

Hi 21 yanks, try using a tool such as WinMerge to merge the changes with your existing orders.php: http://winmerge.org/

All of this mod's edits are carefully commented with "JT mod - Product Image", so they should be easy to spot.

Thank you jackie.taferner!
I must say I'm not surprised this support thread is so short. Product Images on Invoice, Email, etc is the 15th plugin in the Zen Cart installation I'm currently working on, but one of very few that installed without a single glitch! What I'm even more impressed with is that it works retroactively - the test orders placed before I installed this plugin magically acquired images in their invoices, packing slips and customers' order history pages. On top of that, it's incredibly easy to install, just 5 files. I had to merge 3 of them with code modified by other plugins, but it was very easy - indeed the JT mod snippets are very easy to find and copy over.
Thanks again,
Magz

Thanks magz, glad to hear you find the mod useful and easy to install. We are happy to contribute to the community in any way we can.

Where, for example, in the admin packing slip, can I change the link to the images folder?

during ssl state, my site refers to https://stargate.terrassl.net/~candlewithcare so the image when opening the packing slip wants to link to http://stargate.terrassl.net/images and doesn't show.

Is it this line?
' <td class="dataTableContent" valign="top" align="right"><img src="' . DIR_WS_CATALOG . DIR_WS_IMAGES . zen_get_products_image($order->products[$i]['id']) .'" align="left" width="' . SMALL_IMAGE_WIDTH . '" height="' . SMALL_IMAGE_HEIGHT . '" />' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

CandleMan:

Where, for example, in the admin packing slip, can I change the link to the images folder?

during ssl state, my site refers to https://stargate.terrassl.net/~candlewithcare so the image when opening the packing slip wants to link to http://stargate.terrassl.net/images and doesn't show.

Is it this line?
' <td class="dataTableContent" valign="top" align="right"><img src="' . DIR_WS_CATALOG . DIR_WS_IMAGES . zen_get_products_image($order->products[$i]['id']) .'" align="left" width="' . SMALL_IMAGE_WIDTH . '" height="' . SMALL_IMAGE_HEIGHT . '" />' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

I changed the
<img src="' . DIR_WS_CATALOG . DIR_WS_IMAGES . zen_get_products_image($order->products[$i]['id']) .'
to
<img src="https://stargate.terrassl.net/~candlewithcare/images/'. zen_get_products_image($order->products[$i]['id']) .'

it now works

Thank you for your great mod.
1.How do I change how do I change format of "Date ordered" to Short format? For now it's Long format in English (example:Monday 16 September, 2013). Also it's possible to translate Long date format to other local language? Which file do I need to edit?

2. How do I customize (edit) text of below section of invoice? I want to translate it.Which file do I need to edit
Sub-Total: $12.00
Shipping: $0.00
Total: $12.00

Please let me know.

CandleMan:

I changed the
<img src="' . DIR_WS_CATALOG . DIR_WS_IMAGES . zen_get_products_image($order->products[$i]['id']) .'
to
<img src="https://stargate.terrassl.net/~candlewithcare/images/'. zen_get_products_image($order->products[$i]['id']) .'

it now works

i have installed this mod but for some reason the InvoiceImage sql is not working properly. i go to admin/confi/iamges/ then i have no option
to change the size of the pics please help . thanks

21yanks:

i have installed this mod but for some reason the InvoiceImage sql is not working properly. i go to admin/confi/iamges/ then i have no option
to change the size of the pics please help . thanks

I just tried this again on a test server (and have it running on two production sites) it worked as expected.
Make sure you have included the semicolon ; at the end of the command.

I went to admin, under "Tools/Install SQL Patches" I pasted the following into the "SQL Query Executor" box:

INSERT INTO configuration 
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 
VALUES
('Image - On Invoice Height', 'IMAGE_ON_INVOICE_IMAGE_HEIGHT', '30', 'The pixel height of images on Invoice', 4, 49, NULL, now(), NULL, NULL),
('Image - On Invoice Width', 'IMAGE_ON_INVOICE_IMAGE_WIDTH', '30', 'The pixel width of images on Invoices', 4, 49, NULL, now(), NULL, NULL);

Wow Damn u ---> ; Did not see that lol. everything working properly, i also winmerge my files really loving the add on. thank you so much for your help Pottery ..

Absolutely love this add on however the product images aren't showing up property in our html emails?

There's just a square box with a broken image link image. Not sure where to even start to try and correct?

LBLJEB:

Absolutely love this add on however the product images aren't showing up property in our html emails?

There's just a square box with a broken image link image. Not sure where to even start to try and correct?

If you find the issue please let all know.

I would start looking in the file:
includes\classes\order.php

The image is applied on line 909, so in that area I suspect the issue resides.

I really like this mod too, but I have a same problem with the html emails as LBLJEB. HTML email image links are broken. Those image links do miss the store server part.
Now the image path in HTML emails is:
images/product_image.jpg

it thould be:
https :// www . google . com/store/images/product_image.jpg

Would it work by modifying this file from the line 909:
includes\classes\order.php
by adding . HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . before the zen_get_products_image?

Like this?

//JT mod - Product Image
'<td class="product-details" align="left" valign="top" width="30">' . HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . zen_get_products_image($this->products[$i]['id'], IMAGE_ON_INVOICE_IMAGE_WIDTH, IMAGE_ON_INVOICE_IMAGE_HEIGHT) . '</td>' . "\n" .
//JT mod - Product Image

* I don't have a testing server and my site is live. So thats why I ask before modifying those core files ;)

Harri:

I really like this mod too, but I have a same problem with the html emails as LBLJEB. HTML email image links are broken. Those image links do miss the store server part.
Now the image path in HTML emails is:
images/product_image.jpg

it thould be:
https :// www . google . com/store/images/product_image.jpg

Would it work by modifying this file from the line 909:
includes\classes\order.php
by adding . HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . before the zen_get_products_image?

Like this?

//JT mod - Product Image
'<td class="product-details" align="left" valign="top" width="30">' . HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . zen_get_products_image($this->products[$i]['id'], IMAGE_ON_INVOICE_IMAGE_WIDTH, IMAGE_ON_INVOICE_IMAGE_HEIGHT) . '</td>' . "\n" .
//JT mod - Product Image

* I don't have a testing server and my site is live. So thats why I ask before modifying those core files ;)

That didn't work. Store url appeared before the <img src -tag. I think this image issue was caused because my store html email template didn't have a base href:
<base href="$BASE_HREF" />
Now it should work.

i tried to install the sql patch but it fails and i go the following error

Error Failed: 1
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I have never installed this module before. why it said it already exist? how can I solve this problem? many thanks!!!

I manually insert the sql via phpmyadmin and it now works! thx!

Have installed the above add on to www.irishshopper.ie ZenCart 1.51 but cannot find the settings in Configuration/Images to adjust the size of the image which appears on the invoice.

Instructions state

Image sizes are controlled by setting located in:
Admin > Configuration > Images > 'Image - On Invoice Height'
Admin > Configuration > Images > 'Image - On Invoice Width'

Image sizes that are appearing are far far too big but don't appear at all on some browsers.

Any suggestions on how to fix this ?

irishshopper:

Have installed the above add on to www.irishshopper.ie ZenCart 1.51 but cannot find the settings in Configuration/Images to adjust the size of the image which appears on the invoice.

Instructions state

Image sizes are controlled by setting located in:
Admin > Configuration > Images > 'Image - On Invoice Height'
Admin > Configuration > Images > 'Image - On Invoice Width'

Image sizes that are appearing are far far too big but don't appear at all on some browsers.

Any suggestions on how to fix this ?

Did you run the install part from the provided script file "InvoiceImage.sql" (there is also a removal part, only run if you want to remove the database change)

-- Paste the following into 'SQL Query Executor' in Admin: (Tools\Install SQL Patches).

INSERT INTO configuration 
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) 
VALUES
('Image - On Invoice Height', 'IMAGE_ON_INVOICE_IMAGE_HEIGHT', '30', 'The pixel height of images on Invoice', 4, 49, NULL, now(), NULL, NULL),
('Image - On Invoice Width', 'IMAGE_ON_INVOICE_IMAGE_WIDTH', '30', 'The pixel width of images on Invoices', 4, 49, NULL, now(), NULL, NULL);

Yes this was run OK and gave from memory a message at top of screen like

3 tables installed or something similar