[Skip to main content](#vessel-content) # Auto export sales to a Google Spreadsheet? ## - **[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")** - [![Hikarioo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/56346-hikarioo "View Hikarioo's Profile") Topic Author - [ Offline](/forum/user/56346-hikarioo) Less More - Posts: 50 - Thank you received: 1 - - 8 years 6 months ago [\#290895](#290895) by [Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile") *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#290895 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* was created by *[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")* -- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 8 years 6 months ago [\#290896](#290896) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#290896 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Hi, You can potentially configure a mass action to generate a CSV of the sales periodically and email it to a specific email address: [ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html) However, the dashboard itself is only available in the backend of Joomla and thus requires at least a user account allowed to log onto the backend and there is no easy way to do differently to access it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")** - [![Hikarioo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/56346-hikarioo "View Hikarioo's Profile") Topic Author - [ Offline](/forum/user/56346-hikarioo) Less More - Posts: 50 - Thank you received: 1 - - 6 years 10 months ago [\#313916](#313916) by [Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile") Replied by *[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313916 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* No emails are sent when I click execute. Is there anything glaringly wrong on this set up? I would like to get a CSV of **all** ticket sales when a new order is confirmed. Emails are sent by the server for other services, all that is working fine. Thanks! - [ ![1_2019-12-11.png](/forum/attachment/48387) ](/forum/attachment/48387 "1_2019-12-11.png") [ ](/forum/attachment/48387?download=1 "1_2019-12-11.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 654 - - 6 years 10 months ago [\#313925](#313925) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313925 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Hello, I'm sorry but your screenshot is impossible to read, and so hard to get the root issue from this. Sorry for this return, and awaiting news to move forward on your subject. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")** - [![Hikarioo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/56346-hikarioo "View Hikarioo's Profile") Topic Author - [ Offline](/forum/user/56346-hikarioo) Less More - Posts: 50 - Thank you received: 1 - - 6 years 10 months ago [\#313945](#313945) by [Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile") Replied by *[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313945 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Oops. Sorry about that. These new screenshots should work. Unrelated to that and I hope it's ok to ask in the same thread how can I add <br> between "Proceed to checkout"and the amount? Screenshot #4. I couldn't find the appropriate display > view > cart file I guess. - [ ![2019-12-12_09-10-40.811.png](/forum/attachment/48394) ](/forum/attachment/48394 "...-10-40.811.png") [ ](/forum/attachment/48394?download=1 "...-10-40.811.png") - [ ![2019-12-12_09-10-14.990.png](/forum/attachment/48395) ](/forum/attachment/48395 "...-10-14.990.png") [ ](/forum/attachment/48395?download=1 "...-10-14.990.png") - [ ![2019-12-12_09-09-56.144.png](/forum/attachment/48396) ](/forum/attachment/48396 "...-09-56.144.png") [ ](/forum/attachment/48396?download=1 "...-09-56.144.png") - [ ![2019-12-12_09-13-312.png](/forum/attachment/48397) ](/forum/attachment/48397 "..._09-13-312.png") [ ](/forum/attachment/48397?download=1 "..._09-13-312.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 6 years 10 months ago [\#313946](#313946) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313946 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Hi, 1. I think that your problem is with the export path which is not a file but a folder. please change it to something like /my/website/path/myscvfile.csv 2. Regarding the cart module, you'll have to edit the file "cart" of the view "product" via the menu Display>Views for your frontend template. There's only one such file. Now I would rather recommend to do that change with only CSS code. That shouldn't be a problem and the less view overrides you make the easier future updates will be. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")** - [![Hikarioo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/56346-hikarioo "View Hikarioo's Profile") Topic Author - [ Offline](/forum/user/56346-hikarioo) Less More - Posts: 50 - Thank you received: 1 - - 6 years 10 months ago [\#313972](#313972) by [Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile") Replied by *[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313972 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* I added the file path. Unfortunately no export file can be found in the root directory. Is there a log or some debug file that could help me see what is happening in the background when I click process? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 6 years 10 months ago [\#313981](#313981) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#313981 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Hi, There is no log/debug of that process. You would have to add your debug in the file administrator/components/com_hikashop/classes/massaction.php, before the line: JFile::write($uploadFolder.$name, $data); which is the line writing the content of the CSV to the CSV file on the hard drive of the server. For example: var_dump($uploadFolder.$name); exit; When you run the export, you'll see a blank page with the file path where the CSV is written (supposing that it doesn't stop the process before for some reason). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")** - [![Hikarioo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/56346-hikarioo "View Hikarioo's Profile") Topic Author - [ Offline](/forum/user/56346-hikarioo) Less More - Posts: 50 - Thank you received: 1 - - 6 years 10 months ago [\#314187](#314187) by [Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile") Replied by *[Hikarioo](/forum/user/56346-hikarioo "View Hikarioo's Profile")* on topic *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#314187 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Unfortunately I lack the skill to do this. I've been trying for a while and no luck. Any suggestions on an alternative way to do this? Our theater manager would prefer to have a quick view summary of how many tickets are sold with peoples name and quantity in a list format. He would prefer not to login anywhere since passwords are difficult for him but could use a secret URL bookmark or maybe an email. Sorry to be a pest about this, it's an older gentlemen volunteer and I'm trying to make it easier for him. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) 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 - - - 6 years 10 months ago [\#314202](#314202) 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 *[Auto export sales to a Google Spreadsheet?](/forum/25-install-update/894366-auto-export-sales-to-a-google-spreadsheet#314202 "-- HikaShop version -- : 3.4.0 I need some way to make Dashboard visible to a user who does not have login access to the site. What would be the best way to do this? Right now we are using Google Spreadsheets, it would be great if there was an automatic way to update the spreadsheet.")* Hello, We can eventually add that debug line and run the test for you to check the file path or if there's an error message but we'll need a temporary back-end and FTP access to your website. You can send it using our contact form and by specifying a link to that thread : [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Kind regards, Mohamed. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2luc3RhbGwtdXBkYXRlLzg5NDM2Ni1hdXRvLWV4cG9ydC1zYWxlcy10by1hLWdvb2dsZS1zcHJlYWRzaGVldD90bXBsPW1hcmtkb3du) 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.402 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)