[Skip to main content](#vessel-content) # Export Custom CSV ## - **[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")** - [![pegasus4747's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Topic Author - [ Offline](/forum/user/27920-pegasus4747) Less More - Posts: 5 - Thank you received: 0 - - 13 years 1 month ago [\#123178](#123178) by [pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123178 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* was created by *[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")* Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 1 month ago [\#123185](#123185) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123185 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Hi, I think that one solution will be to do it through your Phpmyadmin, by using an SQL request which will display your affiliate information with the good columns, and then export this result. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")** - [![pegasus4747's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Topic Author - [ Offline](/forum/user/27920-pegasus4747) Less More - Posts: 5 - Thank you received: 0 - - 13 years 1 month ago [\#123234](#123234) by [pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Replied by *[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123234 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* This is for a client, so phpMyAdmin is out of the question. Is there a way to do this in the code? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 1 month ago [\#123276](#123276) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123276 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Hi, Well at this moment I will recommend you to create a custom joomla plugin with a manual trigger action. So in the backend, you will be able to call a special function of the plugin and create the CSV file. You can use the HikaShop Spreadsheet helper to create the CSV file. Otherwise, the view override is still possible. By overriding a specific view, you can read a parameter in the url and generate the CSV if there. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")** - [![pegasus4747's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Topic Author - [ Offline](/forum/user/27920-pegasus4747) Less More - Posts: 5 - Thank you received: 0 - - 13 years 1 month ago [\#123304](#123304) by [pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Replied by *[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123304 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Which view should I override? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 1 month ago [\#123328](#123328) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123328 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Hi, I don't know... What you want ! We are talking about integrating a new feature. So YOU have to know where you want to integrate the feature. It could be the HikaShop user listing in the backend when the right parameter is passed. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")** - [![pegasus4747's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Topic Author - [ Offline](/forum/user/27920-pegasus4747) Less More - Posts: 5 - Thank you received: 0 - - 13 years 1 month ago [\#123329](#123329) by [pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Replied by *[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123329 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* I'm talking about the Affiliate Sales listing, where you can export CSV. I just want to customize the CSV output. Can you point me in the right direction? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 1 month ago [\#123446](#123446) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123446 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Hi, Oh ! Okay I see. Well it's a customization of the order export. The "affiliate sales" export is just a "order export" with some filters in order to select which order has to be exported. All the code which generate the CSV file is in the view " backend | your_backend_template | order | export ". You can edit the view in order to change how the export is made. Removing or adding new columns. The first part of the view create the first line with the column title and after, there is a loop (a "foreach") on every selected orders to export their content. Hope it will help you. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")** - [![pegasus4747's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Topic Author - [ Offline](/forum/user/27920-pegasus4747) Less More - Posts: 5 - Thank you received: 0 - - 13 years 1 month ago [\#123469](#123469) by [pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile") Replied by *[pegasus4747](/forum/user/27920-pegasus4747 "View pegasus4747's Profile")* on topic *[Export Custom CSV](/forum/37-import-export-csv-xls/861919-export-custom-csv#123469 "Hi, I'd like to export our Affiliate Sales csv with columns we don't need (for example, order_tax_info) removed, but also include the following columns - Partner email - Partner name - The User Group that the Partner belongs to Is that possible via code customization/plugins? Thanks. -- HikaShop version -- : 2.2.1 (Business) -- Joomla version -- : 2.5.14 -- PHP version -- : 5.2")* Got it. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjE5MTktZXhwb3J0LWN1c3RvbS1jc3Y/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.106 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)