[Solved] Adding EAN13 (or other field) to Search

[migash]

Using Prestashop 1.1

I tried to include the ean13 field to search results by adding this line in the AdminSearch.php file:
'.$product['ean13'].'

But nothing will display. Can anyone help explain why this value is not being passed like the others?

[migash]

Figured it out: In classes/Product.php

change:

SELECT p.`id_product`, pl.`name`, pl.`link_rewrite`, p.`weight`, p.`active`, p.`ecotax`, i.`id_image`, p.`reference`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name

to:

SELECT p.`id_product`, pl.`name`, pl.`link_rewrite`, p.`weight`, p.`ean13`, p.`active`, p.`ecotax`, i.`id_image`, p.`reference`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name

and add to the "WHERE" line:

OR p.`ean13` LIKE \'%'.pSQL($query).'%\'

Then just edit the AdminSearch.php file to display the ean13 field in the "fieldsDisplay" and the "Display products" areas.

[VIXUS]

Great!!!

[guest*]

Then just edit the AdminSearch.php file to display the ean13 field in the "fieldsDisplay" and the "Display products" areas.

Sorry I'm trying this, but I'm not a coder. What shall I do and in which line of the AdminSearch.php ?

[guest*]

I got it by myself. Thx for code, it works...

[falconhome]

Migash!

Thanks, it was very useful.

Rgsd,
Tibor

[Requene]

Hi,
i did exactly what migash wrote.
But i dont have the field 'ean13' in the search page of admin.
could anyone help me please?

[Requene]

Thanks Angora,
but i'm in 1.3.5 and all my themes dont work on 1.4.2.5.
I did the migration and i went back because of to much bugs.
So are you able to tell me if it works on 1.3.5?
Or is there any solution on that version?
thank you very much!!!!

[Dallerdkj]

TY, this works in Prestashop 1.5.3.1.

 

Insert to the line in classes/Product.php

 

Line 3240:

p.`ean13`

 

Line:3253

OR p.`ean13` LIKE \'%'.pSQL($query).'%\'

Edited February 27, 2013 by Danielkjdaller (see edit history)

[faDdy]

Hi,

 

Can anyone please tell me how to display UPC/EAN13 for Product Customization ? i am using prestashop 1.4.8.2

 

Thanks.

[seer]

Hi,

 

Can anyone please tell me how to display UPC/EAN13 for Product Customization ? i am using prestashop 1.4.8.2

 

Thanks.

 

on your product.tpl file use {$product->ean13} code to display EAN