1.6.13 - Invoices and Delivery Slips missing product attribute

[chrismcb]

Just upgraded to 1.6.13 from 1.6.10 and noticed that on the order detail lines, the attribute chosen for the product is not displayed on PDF invoices and Delivery Slips.

 

In this instance it is a selected size.

 

These do appear in the main order screen in the admin.

 

 

Can anyone advise how to get these listed here? It makes it impossible to pack an order from the PDFs.

[chrismcb]

Replying to my own question with a solution here, which I would class as a bug.

 

In classes\order\OrderInvoice.php #143, the select should be:

SELECT *, od.`product_name` as product_name

When it was actually:

SELECT *, pl.`name` as product_name

I also modified the ORDER BY statement to order by od.`product_reference`, as it is more suitable for me in this instance.

Edited April 26, 2017 by chrismcb (see edit history)

[ssvapes]

Worked. Thanks

Edited April 26, 2017 by ssvapes (see edit history)

[ssvapes]

Worked. Thanks

In classes\order\OrderInvoice.php #143, the select should be:

1. SELECT *, od.`product_name` as product_name

When it was actually:

SELECT *, pl.`name` as product_name

[techtech]

I too have this issue from upgrading 1.6.1.12 to 1.6.1.13.

 

Ok, it worked! I changed the code and updated the server.

 

Thanks!

Edited May 1, 2017 by techtech (see edit history)

[fdny895]

I followed these steps in line 143 to show:

 

SELECT *, od.`product_name` as product_name

 

 

and then when the next order came in the invoice didnt even exist out of thousands of orders after this was changed. I want to be able to show the product attributes

[rprangov]

Thank you.

Very useful.

I have fought with this problem last 5 days and you save me.

Your solution works for me .

[0121stephen]

Awesome thanks, worked for me.

[yog_sothoth]

Worked!!!

Thanks