[Skip to main content](#vessel-content) # Edit fields in Order Export ## - **[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")** - [![simplecms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32423-simplecms "View simplecms's Profile") Topic Author - [ Offline](/forum/user/32423-simplecms) Less More - Posts: 86 - Thank you received: 11 - - 10 years 6 months ago [\#239050](#239050) by [simplecms](/forum/user/32423-simplecms "View simplecms's Profile") *[Edit fields in Order Export](/forum/37-import-export-csv-xls/884310-edit-fields-in-order-export#239050 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report?")* was created by *[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")* -- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODQzMTAtZWRpdC1maWVsZHMtaW4tb3JkZXItZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 6 months ago [\#239067](#239067) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Edit fields in Order Export](/forum/37-import-export-csv-xls/884310-edit-fields-in-order-export#239067 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report?")* Hi, For the export button CSV, you have to edit the file "export" of the view "order" for your backend template via the menu Display>Views and add custom code in there in order to remove the columns you don't want. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODQzMTAtZWRpdC1maWVsZHMtaW4tb3JkZXItZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")** - [![simplecms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32423-simplecms "View simplecms's Profile") Topic Author - [ Offline](/forum/user/32423-simplecms) Less More - Posts: 86 - Thank you received: 11 - - 10 years 6 months ago [\#239172](#239172) by [simplecms](/forum/user/32423-simplecms "View simplecms's Profile") Replied by *[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")* on topic *[Edit fields in Order Export](/forum/37-import-export-csv-xls/884310-edit-fields-in-order-export#239172 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report?")* I see no arrays that show the columns just references to "$productFields". Where are the references to the columns? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODQzMTAtZWRpdC1maWVsZHMtaW4tb3JkZXItZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 10 years 6 months ago [\#239177](#239177) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Edit fields in Order Export](/forum/37-import-export-csv-xls/884310-edit-fields-in-order-export#239177 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report?")* Hi, In that file, the first row with the column titles is added with that line: $export->writeLine($first); And then the lines for all the orders are added with that line: $export->writeLine($row); So befroe these lines you need to unset the columns you don't want in these. For example, if you don't want the thrid column and that this column is called "test" you want to add: Code: unset($first[2]); and: Code: unset($row['test']); Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODQzMTAtZWRpdC1maWVsZHMtaW4tb3JkZXItZXhwb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")** - [![simplecms's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32423-simplecms "View simplecms's Profile") Topic Author - [ Offline](/forum/user/32423-simplecms) Less More - Posts: 86 - Thank you received: 11 - - 10 years 6 months ago [\#239282](#239282) by [simplecms](/forum/user/32423-simplecms "View simplecms's Profile") Replied by *[simplecms](/forum/user/32423-simplecms "View simplecms's Profile")* on topic *[Edit fields in Order Export](/forum/37-import-export-csv-xls/884310-edit-fields-in-order-export#239282 "-- HikaShop version -- : 2.6.3 -- Joomla version -- : 3.5.1 I want to be able to use the Export button in Orders for my customer report. My client needs this as he wants to be able to specify the dates of orders for the export - NOT like mass actions which you have to set a period that is fixed. However, the report that is generated has way too many fields that aren't needed. How can I specify which fields to show on this report?")* Gotcha. For other users this is an example of code that won't throw any errors and deletes the columns: Code: unset($first[0], $first[1]); $export->writeLine($first); and Code: unset($row->user_id, $row->user_cms_id); $export->writeLine($row); The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile"), [Galle43](/forum/user/36383-galle43 "View Galle43's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODQzMTAtZWRpdC1maWVsZHMtaW4tb3JkZXItZXhwb3J0P3RtcGw9bWFya2Rvd24=) 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.076 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)