[Skip to main content](#vessel-content) # Exporting Data ## - **[Greg](/forum/user/1024-greg "View Greg's Profile")** - [![Greg's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1024-greg "View Greg's Profile") Topic Author - [ Offline](/forum/user/1024-greg) Less More - Posts: 1 - Thank you received: 0 - - 15 years 8 months ago [\#7193](#7193) by [Greg](/forum/user/1024-greg "View Greg's Profile") *[Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7193 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* was created by *[Greg](/forum/user/1024-greg "View Greg's Profile")* Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 15 years 8 months ago [\#7194](#7194) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7194 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* It's not yet possible in HikaShop. That's something we want to add in the future though. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")** - [![ctsang007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/657-ctsang007 "View ctsang007's Profile") - [ Offline](/forum/user/657-ctsang007) Less More - Posts: 10 - Thank you received: 0 - - 15 years 8 months ago [\#7482](#7482) by [ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile") Replied by *[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7482 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* That's a pity. I am using the business version for registrations for events/courses/seminars. I need to get an overview of all registrants per course/seminar and their basic details. Can you advise how I can achieve that? Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 15 years 8 months ago [\#7544](#7544) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7544 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Could you be more precise ? How do you handle the registrations on your website ? With custom entry fields ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")** - [![ctsang007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/657-ctsang007 "View ctsang007's Profile") - [ Offline](/forum/user/657-ctsang007) Less More - Posts: 10 - Thank you received: 0 - - 15 years 8 months ago [\#7549](#7549) by [ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile") Replied by *[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7549 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* I have created products (=seminars) that visitors can add to their cart as way of registering (nothing special here I guess). Payment is now done via bank transfer until the Dutch IDEAL plugin is available. I would like to have a report (excel) with the following info: ordered product(seminar), product id, first name, last name, address, zip code, city, country, date registered, name on certificate(customfield in address table), name of association(customfield in address table), order status. The standard reports in the dashboard all don't have the user info (except ID and email) nor custom fields. Does this make sense? I hope you can help me out here. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 15 years 8 months ago [\#7550](#7550) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7550 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* As I said in my first post on that thread there is no such function at the moment in hikashop. Retrieving all that information for each item purchased and making it a CSV file for excel is not something we can do like this. It will require some work. We are currently in discussion with another user to do such custom work for a fee but it's not yet confirmed and will take us a few weeks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")** - [![ctsang007's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/657-ctsang007 "View ctsang007's Profile") - [ Offline](/forum/user/657-ctsang007) Less More - Posts: 10 - Thank you received: 0 - - 15 years 8 months ago [\#7571](#7571) by [ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile") Replied by *[ctsang007](/forum/user/657-ctsang007 "View ctsang007's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7571 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Thanks. Yes, I understood from the previous posts that it is not possible at the moment. I was looking for some suggestions/tips/recommendations as a workaround until the solution is ready. Do you/anyone have experience with this using Joomla extensions or something like that? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 15 years 8 months ago [\#7575](#7575) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#7575 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* I don't know of such extensions capable of that. The only way is to develop an export function. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Chill Creations](/forum/user/564-chill-creations "View Chill Creations's Profile")** - [![Chill Creations's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar564.gif)](/forum/user/564-chill-creations "View Chill Creations's Profile") - [ Offline](/forum/user/564-chill-creations) Less More - Posts: 23 - Thank you received: 0 - - 15 years 6 months ago [\#13526](#13526) by [Chill Creations](/forum/user/564-chill-creations "View Chill Creations's Profile") Replied by *[Chill Creations](/forum/user/564-chill-creations "View Chill Creations's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#13526 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Hi I know there are extensions that enable you to get the database values and export as CSV. They are probably not that easy to use, but you can try them. Here is the link to JED. [ extensions.joomla.org/extensions/migrati...data-import-a-export](http://extensions.joomla.org/extensions/migration-a-conversion/data-import-a-export) @ctsang007: see my "handtekening", iDEAL plugin is ready. Regards David --- [ iDEAL for Hikashop](http://www.chillcreations.com/joomla-extensions/ccideal-platform-ideal-dutch-payment-joomla-extensions.html) by Dutch iDEAL experts Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 15 years 6 months ago [\#13554](#13554) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#13554 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Ah yes, good idea ! Indeed such extensions might be able to do the interim while we develop a great export directly in hikashop. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 1 month ago [\#64902](#64902) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#64902 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* I use (Joomla 2.5) Ari Data Tables to create table from SQL however, because the way Hika Shop does it db tables, there's not common field that I can make a join report. Right now I can only join orders and order products table (order_id in common) without being able to included the associated buyers name (not the choice I was looking for). This can give category and product filtering only. [ www.ari-soft.com/vmchk/Joomla-Components...d-product-flyer.html](http://www.ari-soft.com/vmchk/Joomla-Components/ARI-Data-Tables/Detailed-product-flyer.html) hope this helps. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65008](#65008) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65008 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Hi, If you want to load the user address, including its name, you can use the order_billing_address_id to link the order table with the address table Note that HikaShop already has such reporting tools: [ www.hikashop.com/en/support/documentatio...hop-report-form.html](http://www.hikashop.com/en/support/documentation/133-hikashop-report-form.html) And that it is also possible to feed the ARI Data Tables extension a CSV so you could just export your orders via the corresponding button of the orders listing and use it instead of the tables. The CSV will contain all the information of the orders. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 1 month ago - 14 years 1 month ago [\#65104](#65104) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65104 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Thank you for the information. For my needs I wanted to provide a restricted report view online with only specific fields by pulling via SQL; not allow them access to the backend reporting stats (which are good). Downloading via CSV I still need to format to get rid of those fields I don't want; especially all the empty fields. It's still not a clean easiest process to download for me but for now it will have to do as I've spent the money to buy your Essential level. Maybe I'm still missing something. Last edit: 14 years 1 month ago by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65109](#65109) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65109 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* There is no interface to select the columns you want for the export for now. It's on the todo list for a future release. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 1 month ago [\#65143](#65143) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65143 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Ok so I'm successful in combining 3 tables to get the results I need (code below); however I'm having problems with the 'order_created' date. I don't know the right SQL code to convert this field to date format mm-dd-yyyy. I get a long digit similar to what I get when I export to cvs from the backend. Any suggestions? Thanks SELECT DATE\_FORMAT(jml\_hikashop\_order.order\_created) as 'Order Date', jml\_hikashop\_order.order\_status as 'Status', jml\_hikashop\_order.order\_number as 'Order #', jml\_hikashop\_address.address\_firstname as 'First Name', jml\_hikashop\_address.address\_lastname as 'Last Name', jml\_hikashop\_address.address\_telephone as 'Phone', jml\_hikashop\_order.order\_payment\_method as 'Payment Method', Round(jml\_hikashop\_order.order\_full\_price,2) as 'Total', jml\_hikashop\_order\_product.order\_product\_quantity as 'Qty', jml\_hikashop\_order\_product.order\_product\_name as 'Item', jml\_hikashop\_order\_product.order\_product\_options as 'Options' FROM jml\_hikashop\_address JOIN jml\_hikashop\_order ON (jml\_hikashop\_address.address\_user\_id=jml\_hikashop\_order.order\_user\_id) JOIN jml\_hikashop\_order\_product ON jml\_hikashop\_order.order\_id=jml\_hikashop\_order\_product.order\_id ORDER BY jml\_hikashop\_address.address\_lastname DESC Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 14 years 1 month ago [\#65145](#65145) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65145 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* You should do like that: DATE_FORMAT(DATE( FROM_UNIXTIME(jml_hikashop_order.order_created) ), '%m-%d-%Y' ) AS 'Order Date' Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 1 month ago [\#65152](#65152) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#65152 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* THANK YOU ![:cheer:](/media/kunena/emoticons/10.png ":cheer:") this completes what I need to do on my web site. Here's my final sql coding. I just change my filter to the product code I want to report: SELECT DATE\_FORMAT(DATE( FROM\_UNIXTIME(jml\_hikashop\_order.order\_created) ), '%m-%d-%Y' ) AS 'Order Date', jml\_hikashop\_order.order\_status as 'Status', jml\_hikashop\_order.order\_number as 'Order #', jml\_hikashop\_address.address\_firstname as 'First Name', jml\_hikashop\_address.address\_lastname as 'Last Name', jml\_hikashop\_address.address\_telephone as 'Phone', jml\_hikashop\_order.order\_payment\_method as 'Payment Method', Round(jml\_hikashop\_order\_product.order\_product\_price,2) as 'Item Price', jml\_hikashop\_order\_product.order\_product\_quantity as 'Qty', jml\_hikashop\_order\_product.order\_product\_name as 'Item', jml\_hikashop\_order\_product.order\_product\_options as 'Options' FROM jml\_hikashop\_address JOIN jml\_hikashop\_order ON (jml\_hikashop\_address.address\_user\_id=jml\_hikashop\_order.order\_user\_id) JOIN jml\_hikashop\_order\_product ON jml\_hikashop\_order.order\_id=jml\_hikashop\_order\_product.order\_id WHERE jml\_hikashop\_order\_product.order\_product\_name LIKE '%Member' ORDER BY jml\_hikashop\_address.address\_lastname DESC Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 1 week ago [\#71635](#71635) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#71635 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* Hi, by chance what is the syntax after the date to include the time of the order? Thanks Alana Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/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: 86315 - Thank you received: 14276 - - 14 years 6 days ago [\#71905](#71905) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#71905 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* It should be: DATE_FORMAT(DATE( FROM_UNIXTIME(jml_hikashop_order.order_created) ), '%m-%d-%Y %H:%i' ) AS 'Order Date' [ dev.mysql.com/doc/refman/5.5/en/date-and...function\_date-format](http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mavievs](/forum/user/24180-mavievs "View mavievs's Profile")** - [![mavievs's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/24180-mavievs "View mavievs's Profile") - [ Offline](/forum/user/24180-mavievs) Less More - Posts: 21 - Thank you received: 1 - - 12 years 10 months ago - 12 years 10 months ago [\#134894](#134894) by [mavievs](/forum/user/24180-mavievs "View mavievs's Profile") Replied by *[mavievs](/forum/user/24180-mavievs "View mavievs's Profile")* on topic *[Re: Exporting Data](/forum/2-general-talk-about-hikashop/7193-exporting-data#134894 "Does Hika Shop Essential or Business have a way to download order data in Excel format with all the order data on one row? If so, is it customizable so I can choose which fields download (including custom fields)? Thanks for your help.")* is there any progress in exporting functionality? Last edit: 12 years 10 months ago by [mavievs](/forum/user/24180-mavievs "View mavievs's Profile"). Reason: grammar Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzcxOTMtZXhwb3J0aW5nLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.206 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)