how to customize xls-list content (too many columns)

-- HikaShop version -- : 3.5.0
-- Joomla version -- : 3.6.5
-- PHP version -- : 7.1.18
-- Browser(s) name and version -- : firefox

Hi together

I do need your help again My question is about the Excel-download of customer orders. The download works propper but I would like to specify the xls-list.
Right now the list includes 130 columns with many many informations which is uncomfortable to handle. I tried to find the concerning file on our server – but i was not successful.
Would you be so kind to tell me which file in which folder is responsible for the xls-lists content?

Thank you so much in advance
Frank

I have the same question about export customer orders.
Is there any simpler method? to set up the columns that needs to be export, and then just let others press the export button?

Thanks for your reply,
If I need to change the CSV columns display of the data by the export button, as the reply above, I need to edit via the menu Display>Views.
Could you please give some basic example for the code?
ex. I just need to export "order_full_price","order_number","username"...

nicolas wrote: Hi,

If you want to do that for the export button, then you indeed have to change the code of the export view file as explained before.

In that order/export.php view file, you can add such line:

unset($order->XXX);

before the line:

$nbProd = count(@$order->products);

for each column you wish to remove and where XXX is the name of the column.
For the columns of the items, you can just use unset($order->products); to remove them all.

Hi!
I changed the export.php as mentioned above. And it works perfectly.

But what do I have to add if I would like to remove columns like item1_order_product_id, item1_order_product_tax, and so on. I failed in modifying the "unset-code"


AND: is it possible to change the language code from "utf-8" to "ISO-8859-1" ?

BR, Frank

Dear Nicolas,

again - thanks for your support concerning my concern.

unset($order->XXX); helped me to reduce the columns concerning the order data.

I even managed to reduce the product fields by using

for($i=1;$i<=$maxProd;$i++){
			foreach($productFields as $field){
				if (
				$field === 'order_product_quantity'
				|| $field === 'order_product_code' ) {
				$first[] = 'item'.$i.'_'.$field;	
				}
			}
		}