Edit export options

hi,

i'm using the export button to export my orders to a csv file so i can view in excel.

is there a way to edit which db fields are exported?

at the moment i'm having to manually delete a lot of columns in excel that i dont need every time i export.

i'd like it to just be order number, name, address and a few others.

thanks

Hi,

I think that in your case, the best solution would be to directly import your database table (through phpmyadmin) in a CSV format.

Hope this will help you.

thanks for the reply but that's not really what i'm looking at.

i'd like to customise what fields the 'export' button exports. i need it to be easy to use and not require me to use phpmyadmin.

where in the hikashop directory can i find the code for the 'export' button to see how it generates it's export? can i edit this?

Hi,

You can edit the view "order / export" to change the row content.
Then if you need more, the file "administrator/components/com_hikashop/views/order/view.html.php" function "export()" can be useful.
And the helper "spreadsheet" in "administrator/components/com_hikashop/helpers/spreadsheet.php" allow you more changes.

Be careful the two last files are HikaShop core file, so if you edit them you will lose your changes at each update.