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

[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

[potteryhouse]

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);

[21yanks]

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 ..

[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?

[potteryhouse]

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.

[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 ;)

[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.

[caborela]

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!!!

[caborela]

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

[marton_1]

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 had the same problem; I changed INSERT INTO to INSERT and the sql ran as expected.

The plugin works great; it looks better to these images.