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

#   Is there a way to rearrange layout of Export CSV

##

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

Less More

- Posts: 3
- Thank you received: 0
-
-

11 years 1 week ago [\#217780](#217780) by [joelapiana](/forum/user/36581-joelapiana "View joelapiana's Profile")  *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#217780 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")* was created by *[joelapiana](/forum/user/36581-joelapiana "View joelapiana's Profile")*

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.6.0

I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?

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

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

11 years 6 days ago [\#217797](#217797) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#217797 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Hi,

You can potentially edit the view "order / export" in the backend template and there edit the "$this-&gt;orders" PHP object at the top of the file in order to change the columns ordering.
So it require PHP knowledges.

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

- **[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")**
- [![thagh05t's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/penguin.jpg)](/forum/user/39302-thagh05t "View thagh05t's Profile")
- [ Offline](/forum/user/39302-thagh05t)

Less More

- Posts: 21
- Thank you received: 0
-
-

11 years 19 hours ago [\#218422](#218422) by [thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")  Replied by *[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218422 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Hello, was reading a bit through the forum and couldn't really get a definitive answer. I need to either create a report or maybe a cron job to run, or maybe even just use the reports I already have to be able to export a couple things. I want to be able to export only certain fields on an order so I can keep a record as well as upload a list for my mailing address book. I generally use excel for keeping a record of all sales and used to manually type in user information as well as manually insert the same on USPS web site. This is too time consuming for me so i decided to try hikashop out. I purchased the business version and have a more than what I need in some areas and other areas it lacks. But over all it is a great product with great potential.

Question1: What are the steps I need to take to create a custom export for orders that are ready to ship.
Question2: if I make changes regarding the above question then will it effect ALL exports?
Question3: is there a better way to set the CSV delimiter other than modifying core code?
Question4: is there an intuitive way to create custom reports that will be sent to my email daily with a CSV attached with a list of orders ready to ship and a list of the people who made those orders that I can upload to USPS?

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

- **[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")**
- [![thagh05t's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/penguin.jpg)](/forum/user/39302-thagh05t "View thagh05t's Profile")
- [ Offline](/forum/user/39302-thagh05t)

Less More

- Posts: 21
- Thank you received: 0
-
-

11 years 19 hours ago [\#218423](#218423) by [thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")  Replied by *[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218423 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

I should also add, I was ok with the extra data being passed in the export function from the orders page but it was a pain in the neck. So I created macros that would sanitize the data to my needs. But when I upgraded to Business my exports are different and my data after the macros is not correct.

I really have many many questions about hikashop and the possibilities of hikashop, and I think there is some sort of support right? I may want to utilize the support but keep my questions and answers in the forum here for future users such as myself. One of these questions I have is what can cron be used for.

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

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

11 years 7 hours ago [\#218446](#218446) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218446 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Hi,

So with all these informations I think that you must use the mass actions.
In HikaShop &gt; System &gt; Mass Action, you can set up mass actions which can be launched at specific periods, or launched on changes, etc. So you can create an order mass action, triggered every days, filter on specific order statuses, and use the "export a csv file" action.

In this action, you can directly select the fields to export in your csv file, and you can fill the email address field to receive the csv file directly. The only thing which seems to be missing in your case is the ordering of the exported fields.

But that can be achieved with some PHP modifications in the plugin code.

Here is the mass action documentation:
[ www.hikashop.com/support/support/documen...massaction-form.html](http://www.hikashop.com/support/support/documentation/167-massaction-form.html)

So:
1/ Use the mass actions
2/ Via the mass actions, no this will not impact other exports
3/ In Configuration &gt; Main &gt; Files &gt; "CSV separator" option.
4/ Idem than 1/

The support of HikaShop is done via this forum directly.

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

- **[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")**
- [![thagh05t's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/penguin.jpg)](/forum/user/39302-thagh05t "View thagh05t's Profile")
- [ Offline](/forum/user/39302-thagh05t)

Less More

- Posts: 21
- Thank you received: 0
-
-

11 years 7 hours ago [\#218512](#218512) by [thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")  Replied by *[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218512 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Ok I will have a look at creating a couple mass actions to do this. Can you tell me which file controls csv so I can edit it or create an override?

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

- **[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")**
- [![thagh05t's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/penguin.jpg)](/forum/user/39302-thagh05t "View thagh05t's Profile")
- [ Offline](/forum/user/39302-thagh05t)

Less More

- Posts: 21
- Thank you received: 0
-
-

11 years 7 hours ago [\#218515](#218515) by [thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")  Replied by *[thagh05t](/forum/user/39302-thagh05t "View thagh05t's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218515 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Massaction does sound like a great approach. Can you explain con a bit? In the context of hikasho that is.

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

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

10 years 11 months ago [\#218518](#218518) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#218518 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

Hi,

The file which is controlling the order export is the plugin "hikashop / massaction_order".
(plugins/hikashop/massaction_order/massaction_order.php, function onProcessOrderMassActionexportCsv() )

But you can create a new plugin, copy the current code, paste it in your plugin and adapt it to your needs.
That way you will have created a new action without editing the existing one.

Here is the developer documentation for the mass actions:
[ www.hikashop.com/support/support/documen...s-action-plugin.html](http://www.hikashop.com/support/support/documentation/168-create-you-own-mass-action-plugin.html)

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

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

Less More

- Posts: 11
- Thank you received: 1
-
-

10 years 11 months ago [\#220508](#220508) by [psymedia](/forum/user/38357-psymedia "View psymedia's Profile")  Replied by *[psymedia](/forum/user/38357-psymedia "View psymedia's Profile")* on topic *[Is there a way to rearrange layout of Export CSV](/forum/37-import-export-csv-xls/879940-is-there-a-way-to-rearrange-layout-of-export-csv#220508 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.6.0  I'm in Hikashop -&gt; Orders -&gt; and I'm clicking the export button on the upper left side of the screen. Is there a way to rearrange the layout? I want the name, address, and email column all moved to the front of the csv file, but I can't seem to rearrange it. Can you help me out?")*

HI,

I think i have achieved the same sa your trying to do but for Amazon, after an order is payed for hikashop data is pushed into a custom DB table and exported as csv in the format required by amazon to dispatch from the warehouse, it works with multi item orders, and multi orders, I'm guessing we could convert this with very little work to do what you want. Happy to discuss further contact me via our site [ articconsultants.com/hikashop-development](http://articconsultants.com/hikashop-development)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84Nzk5NDAtaXMtdGhlcmUtYS13YXktdG8tcmVhcnJhbmdlLWxheW91dC1vZi1leHBvcnQtY3N2P3RtcGw9bWFya2Rvd24=) 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.405 seconds

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

[](#top)
