[Skip to main content](#vessel-content) # export to csv/xls and email to address not working ## - **[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) - 10 years 8 months ago [\#230219](#230219) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[export to csv/xls and email to address not working](/forum/44-mass-actions/881015-export-to-csv-xls-and-email-to-address-not-working?start=20#230219 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.29 We use Hikashop for employees to place orders for branded merchandise at our company. We have a custom payment method called 'Payroll Deduction'. Currently, when a order is placed via this payment method the Name, Order#, Total & order notes are manually added to a spreadsheet and then forwarded via email to Human Resources to process the deduction. This is done about once a week. I would like to use a mass action to automate this. Here is what is needed: - Only include orders in the report that use the 'payroll deduction' payment method - Generate a csv or xls that includes the following fields: Name, Order#, Date, Total - Report automatically ran once per week and emailed I have created a mass action that is triggered every week, filtered by order_payment_method and shows the columns needed. However, I am having 2 issues: 1) Not sure how to make this only pull a report for orders in the last week - no option for date range 2) I can get it to display to the screen, but cannot get it to save to the export path or send via email Pls advise Thank you")* Hi, I see that we don't answered to this request, do you have solved this issue ? If not we will have a look at your cron subscription on our end. The following user(s) said Thank You: [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile"), [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODEwMTUtZXhwb3J0LXRvLWNzdi14bHMtYW5kLWVtYWlsLXRvLWFkZHJlc3Mtbm90LXdvcmtpbmc/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")** - [![tbroderick's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36185-tbroderick "View tbroderick's Profile") - [ Offline](/forum/user/36185-tbroderick) Less More - Posts: 112 - Thank you received: 3 - - 10 years 8 months ago [\#230278](#230278) by [tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile") Replied by *[tbroderick](/forum/user/36185-tbroderick "View tbroderick's Profile")* on topic *[export to csv/xls and email to address not working](/forum/44-mass-actions/881015-export-to-csv-xls-and-email-to-address-not-working?start=20#230278 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.29 We use Hikashop for employees to place orders for branded merchandise at our company. We have a custom payment method called 'Payroll Deduction'. Currently, when a order is placed via this payment method the Name, Order#, Total & order notes are manually added to a spreadsheet and then forwarded via email to Human Resources to process the deduction. This is done about once a week. I would like to use a mass action to automate this. Here is what is needed: - Only include orders in the report that use the 'payroll deduction' payment method - Generate a csv or xls that includes the following fields: Name, Order#, Date, Total - Report automatically ran once per week and emailed I have created a mass action that is triggered every week, filtered by order_payment_method and shows the columns needed. However, I am having 2 issues: 1) Not sure how to make this only pull a report for orders in the last week - no option for date range 2) I can get it to display to the screen, but cannot get it to save to the export path or send via email Pls advise Thank you")* This issue has been resolved for me. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODEwMTUtZXhwb3J0LXRvLWNzdi14bHMtYW5kLWVtYWlsLXRvLWFkZHJlc3Mtbm90LXdvcmtpbmc/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile")** - [![dustinjc's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar31466.jpg)](/forum/user/31466-dustinjc "View dustinjc's Profile") Topic Author - [ Offline](/forum/user/31466-dustinjc) Less More - Posts: 176 - Thank you received: 5 - - 10 years 8 months ago [\#230681](#230681) by [dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile") Replied by *[dustinjc](/forum/user/31466-dustinjc "View dustinjc's Profile")* on topic *[export to csv/xls and email to address not working](/forum/44-mass-actions/881015-export-to-csv-xls-and-email-to-address-not-working?start=20#230681 "-- HikaShop version -- : 2.6.0 -- Joomla version -- : 3.4.5 -- PHP version -- : 5.5.29 We use Hikashop for employees to place orders for branded merchandise at our company. We have a custom payment method called 'Payroll Deduction'. Currently, when a order is placed via this payment method the Name, Order#, Total & order notes are manually added to a spreadsheet and then forwarded via email to Human Resources to process the deduction. This is done about once a week. I would like to use a mass action to automate this. Here is what is needed: - Only include orders in the report that use the 'payroll deduction' payment method - Generate a csv or xls that includes the following fields: Name, Order#, Date, Total - Report automatically ran once per week and emailed I have created a mass action that is triggered every week, filtered by order_payment_method and shows the columns needed. However, I am having 2 issues: 1) Not sure how to make this only pull a report for orders in the last week - no option for date range 2) I can get it to display to the screen, but cannot get it to save to the export path or send via email Pls advise Thank you")* Things have been running smoothly. The only issue I encountered was the error when setting it up :"Error triggering your website on the url: [ www.xxxxxxxx.com/index.php?option=com\_hi...&ctrl=cron&no\_html=1](http://www.xxxxxxxx.com/index.php?option=com_hi...&ctrl=cron&no_html=1)". However this seems to have had no effect on the cron running properly. All good here! Thank you again! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84ODEwMTUtZXhwb3J0LXRvLWNzdi14bHMtYW5kLWVtYWlsLXRvLWFkZHJlc3Mtbm90LXdvcmtpbmc/c3RhcnQ9MjAmdG1wbD1tYXJrZG93bg==) 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.047 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)