Hello.
Are there an option where I can export the orders received in a .csv file format? Thanks.
Export orders
- Jan
- Phoca Hero
- Posts: 47810
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Export orders
Hi, for now, there is no such option.
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 16 May 2018, 19:46
Re: Export orders
Ouch, this would be really needed and important for many I think...I am looking at phpmyadmin, but the problem is that its in 2 separate tables. One is the order ID with the products and one with the user, and order ID only. Connecting those 2 would be an immense help.
-
- Phoca Member
- Posts: 32
- Joined: 16 May 2018, 19:46
Re: Export orders
Hi Jan,
Is there an update on this issue? My solution at the time was to export the notification emails and put them into a table. It would be lovely to have an export button at orders menu;-)
Is there an update on this issue? My solution at the time was to export the notification emails and put them into a table. It would be lovely to have an export button at orders menu;-)
- Jan
- Phoca Hero
- Posts: 47810
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Export orders
Hi, there is a feature request to export orders e.g. for accounting systems, but I still didn't find time to take a look at it
Jan
Jan
If you find Phoca extensions useful, please support the project
-
- Phoca Member
- Posts: 32
- Joined: 16 May 2018, 19:46
Re: Export orders
Hey, here is my "solution" until a proper export is being implemented.
In the orders menu on the backend I checked the urls of the invoices.
They looked like this: mysite/administrator/index.php?option=com_phocacart&view=phocacartorderview&tmpl=component&id=160&type=2
I created a spreadsheet containing all URLS changing just the ID-s.
I put this list of urls into tab save chrome extension: https://chrome.google.com/webstore/deta ... jdbaekacki
Exported all orders in separate index.html files with one click.
These index.htmls can be merged in TC, reformatted into csv or printed when needed.
In the orders menu on the backend I checked the urls of the invoices.
They looked like this: mysite/administrator/index.php?option=com_phocacart&view=phocacartorderview&tmpl=component&id=160&type=2
I created a spreadsheet containing all URLS changing just the ID-s.
I put this list of urls into tab save chrome extension: https://chrome.google.com/webstore/deta ... jdbaekacki
Exported all orders in separate index.html files with one click.
These index.htmls can be merged in TC, reformatted into csv or printed when needed.
- Jan
- Phoca Hero
- Posts: 47810
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Export orders
Ok, thank you for the info.
Jan
Jan
If you find Phoca extensions useful, please support the project