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

#   Order csv export in wrong order

##

- **[daveturner101](/forum/user/13550-daveturner101 "View daveturner101's Profile")**
- [![daveturner101's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/guitar.gif)](/forum/user/13550-daveturner101 "View daveturner101's Profile") Topic Author
- [ Offline](/forum/user/13550-daveturner101)

Less More

- Posts: 72
- Thank you received: 0
-
-

13 years 8 months ago [\#92937](#92937) by [daveturner101](/forum/user/13550-daveturner101 "View daveturner101's Profile")  *[Order csv export in wrong order](/forum/3-bug-report/78938-order-csv-export-in-wrong-order#92937 "hi,  i've been using the 'export' button to export all 'confirmed' orders every few days to a csv and then open in excel.  when i tried to do this today, some of the new orders (from the last few days) appeared above my old orders and some appeared below my old orders. i expected them to be in order (either by date or user id or something else..?)  i tried to think what had changed in the last few days and a few days ago i unpublished 2 products from the site and added 1 new one. could this be something to do with the orders appearing in the wrong order in the csv file?  has anyone seen this before?")* was created by *[daveturner101](/forum/user/13550-daveturner101 "View daveturner101's Profile")*

hi,

i've been using the 'export' button to export all 'confirmed' orders every few days to a csv and then open in excel.

when i tried to do this today, some of the new orders (from the last few days) appeared above my old orders and some appeared below my old orders. i expected them to be in order (either by date or user id or something else..?)

i tried to think what had changed in the last few days and a few days ago i unpublished 2 products from the site and added 1 new one. could this be something to do with the orders appearing in the wrong order in the csv file?

has anyone seen this before?

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

13 years 8 months ago [\#93043](#93043) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Order csv export in wrong order](/forum/3-bug-report/78938-order-csv-export-in-wrong-order#93043 "hi,  i've been using the 'export' button to export all 'confirmed' orders every few days to a csv and then open in excel.  when i tried to do this today, some of the new orders (from the last few days) appeared above my old orders and some appeared below my old orders. i expected them to be in order (either by date or user id or something else..?)  i tried to think what had changed in the last few days and a few days ago i unpublished 2 products from the site and added 1 new one. could this be something to do with the orders appearing in the wrong order in the csv file?  has anyone seen this before?")*

Hi,

To order by order date, you can edit the view "order / export" in the backend template and apply a sort on the var "$this-&gt;orders".
You can use PHP sort functions in [ php.net/](http://php.net/) , you will maybe have to transform the object into an array, sort the array and transform it back to an object.

You can sort on the "order_created" or "order_modified" or "order_id".

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

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