How to alter SQL-Query in Catalog -> Products -> Export

[Pronux]

Hi,

 

I need to add an additional db-field to the csv-export function on the page in Catalog -> Products

 

 

My question: In which file can I edit the sql or this function query?

 

Any help is highly appreciated.

Edited April 3, 2015 by Pronux (see edit history)

[PascalVG]

The export function you are talking about ONLY exports the fields shown in the grid (Table) (on the page where you can click export). So, to add it to the export csv file, you first have to add it to this grid (table)

 

An example how to do this, you can see here:

https://www.prestashop.com/forums/topic/434353-display-additional-column-ean13-in-catalog-product-in-back-office/

 

In the example, we add the EAN13 code to the table.

 

When clicking export, we then get this new value in the csv file as well.

 

 

Hope this helps,

pascal.