Export Orders to CSV customization question

[_stardust_]

Hi,

 

I have an export orders module and I'm trying to customize it to where it won't display multiple rows of the same order#. Can someone point me in the right direction? I've attached the module in question. Thanks.

exportordersQBcsv1.1.zip

[Online Matrix]

Hi,

 

you can try adding "GROUP BY id_order" at line 231.

 

Before

INNER JOIN "._DB_PREFIX_."country_lang ON "._DB_PREFIX_."country_lang.id_country = "._DB_PREFIX_."state.id_country WHERE ${where}";

 

After

INNER JOIN "._DB_PREFIX_."country_lang ON "._DB_PREFIX_."country_lang.id_country = "._DB_PREFIX_."state.id_country WHERE ${where} GROUP BY id_order";

 

 

Thanks for the module !