[Skip to main content](#vessel-content) # Unable to EXPORT CSV for sub-vendor orders / BackN ## - **[drmad](/forum/user/30566-drmad "View drmad's Profile")** - [![drmad's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30566-drmad "View drmad's Profile") Topic Author - [ Offline](/forum/user/30566-drmad) Less More - Posts: 43 - Thank you received: 2 - - 12 years 5 months ago [\#156635](#156635) by [drmad](/forum/user/30566-drmad "View drmad's Profile") *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156635 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* was created by *[drmad](/forum/user/30566-drmad "View drmad's Profile")* I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/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) - 12 years 5 months ago [\#156647](#156647) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156647 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* Hi, Exporting "subsales" in HikaShop backend is not possible by "definition". In the file "administrator/components/com_hikashop/views/order/view.html.php" at the beginning of the function "export" you will find this code Code: $filters = array('b.order_type=\'sale\''); this filter block the order_type to just "sale". You can edit this line to put Code: $filters = array('(b.order_type=\'sale\' OR b.order_type=\'subsale\')'); in order to allow subsales too. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drmad](/forum/user/30566-drmad "View drmad's Profile")** - [![drmad's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30566-drmad "View drmad's Profile") Topic Author - [ Offline](/forum/user/30566-drmad) Less More - Posts: 43 - Thank you received: 2 - - 12 years 5 months ago [\#156829](#156829) by [drmad](/forum/user/30566-drmad "View drmad's Profile") Replied by *[drmad](/forum/user/30566-drmad "View drmad's Profile")* on topic *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156829 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* Hi Jerome, Thanks for your codes and suggestions. Actually the reason for us to extract vendor report, is to calculate the % commission charges & summarize the amount of money we need to payback respective vendor at month-end. We prefer NOT to have any core-hack / code changes for this purposes. I guess it's hidden somewhere with hikashop/market. (There are too many functions with the reporting tools) Would you mind to guide us how to extract reports for below items? (We will normally do it once a month for all vendors), in CSV format for data record and trending projection. (excel, etc) ** Currency should be included/ indicated into below reports 1) Extract the Sales Records for each vendor in a month, 2) Extract data for Payment Amount we need to pay to our vendors for each end of month 3) Extract data for Commission that we charge for each vendors vs. orders Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/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) - 12 years 5 months ago [\#156855](#156855) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156855 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* Hi, I think I will put something in HikaMarket to override the HikAshop filters during the export. You should be able to export the sub sales too. So in my point of view, it is not a core hack. HikaMarket propose some statistics to the vendors ; we can see to add some reports in the backend too. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[drmad](/forum/user/30566-drmad "View drmad's Profile")** - [![drmad's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30566-drmad "View drmad's Profile") Topic Author - [ Offline](/forum/user/30566-drmad) Less More - Posts: 43 - Thank you received: 2 - - 12 years 5 months ago [\#156875](#156875) by [drmad](/forum/user/30566-drmad "View drmad's Profile") Replied by *[drmad](/forum/user/30566-drmad "View drmad's Profile")* on topic *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156875 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* Hi Jerome, Thanks. So I can safely add your proposed code at the moment and you will enhance the filter in future release (or same stable release), am I correct? Please also consider to add some report that will be run by the market owner, like... 1) Vendor's performance (individual sales) report 2) Vendor's payments / charges report Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/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) - 12 years 5 months ago [\#156997](#156997) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Unable to EXPORT CSV for sub-vendor orders / BackN](/forum/22-market-bug-report/868352-unable-to-export-csv-for-sub-vendor-orders-backn#156997 "I am testing the new shop/market version in our UAT environment, and found below issue. This is an Backend issue: - Unable to EXPORT CSV for sub-order that is filtered by "All Vendors" or any vendors; - I have checked / selected the required orders from the list - file exported is 0 byte without any contents. p.s Using the same method, export CSV for main-order has no issue. Best regards,")* Hi, Yes, you can add the modification. The code I will put in HikaMarket will be different but the result will be the same. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [drmad](/forum/user/30566-drmad "View drmad's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg2ODM1Mi11bmFibGUtdG8tZXhwb3J0LWNzdi1mb3Itc3ViLXZlbmRvci1vcmRlcnMtYmFja24/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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.086 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)