[Skip to main content](#vessel-content)

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

##

- **[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")**
- [![Frank.Oehlen's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar50131.jpg)](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile") Topic Author
- [ Offline](/forum/user/50131-frank-oehlen)

Less More

- Posts: 20
- Thank you received: 1
-
-
-
- [](http://stattgarde.de)
-

8 years 4 months ago [\#294931](#294931) by [Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")  *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#294931 "-- 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")* was created by *[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")*

-- 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 ![;)](/media/kunena/emoticons/24.png ";)") 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

- [ ![Excel-Download.png](/forum/attachment/44107) ](/forum/attachment/44107 "...l-Download.png") [ ](/forum/attachment/44107?download=1 "...l-Download.png")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

8 years 4 months ago [\#294937](#294937) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#294937 "-- 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")*

Hi,

It's the file "export" of the view "order" that you can edit via the menu Display&gt;Views.
Alternatively, you can create a mass action of the "order" data with an action "export CSV file" which will allow you to select the columns you want in your CSV file.
[ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html)

The following user(s) said Thank You: [rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")**
- [![rakuzen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45598-rakuzen "View rakuzen's Profile")
- [ Offline](/forum/user/45598-rakuzen)

Less More

- Posts: 30
- Thank you received: 0
-
-

8 years 3 months ago [\#295478](#295478) by [rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")  Replied by *[rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#295478 "-- 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?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

8 years 3 months ago [\#295481](#295481) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#295481 "-- 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")*

Hi,

The mass action solution is quite simple. Just create a mass action with an action "export CSV file" and select the columns you want and save the mass action.
Then, when you want to export, just go in the System&gt;Mass actions menu, click on the mass action, and click on the "process" button in order to get the CSV file.
There is no simpler solution.

The following user(s) said Thank You: [rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")**
- [![rakuzen's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45598-rakuzen "View rakuzen's Profile")
- [ Offline](/forum/user/45598-rakuzen)

Less More

- Posts: 30
- Thank you received: 0
-
-

8 years 3 months ago [\#295682](#295682) by [rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")  Replied by *[rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#295682 "-- 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")*

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&gt;Views.
Could you please give some basic example for the code?
ex. I just need to export "order_full_price","order_number","username"...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

8 years 3 months ago [\#295704](#295704) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#295704 "-- 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")*

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: Code:

unset($order-&gt;XXX);

before the line: Code:

$nbProd = count(@$order-&gt;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-&gt;products); to remove them all.

The following user(s) said Thank You: [rakuzen](/forum/user/45598-rakuzen "View rakuzen's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")**
- [![Frank.Oehlen's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar50131.jpg)](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile") Topic Author
- [ Offline](/forum/user/50131-frank-oehlen)

Less More

- Posts: 20
- Thank you received: 1
-
-
-
- [](http://stattgarde.de)
-

7 years 11 months ago -  7 years 11 months ago [\#301605](#301605) by [Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")  Replied by *[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#301605 "-- 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")*

> > 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:
> >
> > Code:
> >
> > unset($order-&gt;XXX);
> >
> >
> >
> > before the line: Code:
> >
> > $nbProd = count(@$order-&gt;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-&gt;products); to remove them all.
>
>
> Hi!
> I changed the export.php as mentioned above. And it works perfectly. ![:-)](/media/kunena/emoticons/3.png ":-)")
>
> 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" :woohoo:
>
>
> AND: is it possible to change the language code from "utf-8" to "ISO-8859-1" ?
>
> BR, Frank

Last edit: 7 years 11 months ago by [Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

7 years 11 months ago [\#301608](#301608) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#301608 "-- 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")*

Hi,

Well, the instruction I gave is what you should do I think in that case, so I don't know what else to say. If you have an issue with that please provide a copy of what you did and the error that you got.

You have the function mb_convert_encoding in php to change the encoding of each text displayed in the exported file. The coding for that would be quite involved compared to just removing columns. If you're not a developer, I would recommend hiring one for that.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")**
- [![Frank.Oehlen's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar50131.jpg)](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile") Topic Author
- [ Offline](/forum/user/50131-frank-oehlen)

Less More

- Posts: 20
- Thank you received: 1
-
-
-
- [](http://stattgarde.de)
-

7 years 10 months ago -  7 years 10 months ago [\#302123](#302123) by [Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")  Replied by *[Frank.Oehlen](/forum/user/50131-frank-oehlen "View Frank.Oehlen's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#302123 "-- 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")*

Dear Nicolas,

again - thanks for your support concerning my concern.

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

I even managed to reduce the product fields by using Code:

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

But now I - sorry - do have a last question (hopefully) ![;)](/media/kunena/emoticons/24.png ";)")
At the moment **utf-8** coding is used when creating the export-csv file. Would it be possible to switch it to **iso-8859-1**?

It would be awesome if it might be possible to chance ![:-)](/media/kunena/emoticons/3.png ":-)")

Looking forward to hearing from you

Frank

Last edit: 7 years 10 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86556
- Thank you received: 14305
-
-

7 years 10 months ago [\#302125](#302125) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[how to customize xls-list content (too many columns)](/forum/37-import-export-csv-xls/895177-how-to-customize-xls-list-content-too-many-columns#302125 "-- 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")*

Hi,

There is no "switch". All the text in the database is in UTF8. If you want the CSV file to not be in UTF8 but something else, it will require converting each text to that other encoding when generating the export.
As I said already in my previous message, you'll have to use the mb_convert_encoding function for each text being output in the export.php view file. So it's possible, but it will require a lot more modifications than what you had to do for the removing of the columns even though it might sounds simpler to you. So as I said in my previous message, if you're not a developer, I would recommend hiring one for that.
If you're one, then look at how works the mb_convert_encoding function and use it on all the text variables.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84OTUxNzctaG93LXRvLWN1c3RvbWl6ZS14bHMtbGlzdC1jb250ZW50LXRvby1tYW55LWNvbHVtbnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.073 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
