Export orders

Phoca Cart - complex e-commerce extension
Alcor17
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 03 Apr 2018, 17:42

Export orders

Post by Alcor17 » 03 Apr 2018, 17:51

Hello.

Are there an option where I can export the orders received in a .csv file format? Thanks.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41130
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export orders

Post by Jan » 08 Apr 2018, 15:03

Hi, for now, there is no such option.

Jan
If you find Phoca extensions useful, please support the project

andraspal
Phoca Member
Phoca Member
Posts: 10
Joined: 16 May 2018, 19:46

Re: Export orders

Post by andraspal » 16 May 2018, 23:27

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.

andraspal
Phoca Member
Phoca Member
Posts: 10
Joined: 16 May 2018, 19:46

Re: Export orders

Post by andraspal » 18 Feb 2019, 15:42

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;-)

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 41130
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export orders

Post by Jan » 19 Feb 2019, 15:45

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
If you find Phoca extensions useful, please support the project

andraspal
Phoca Member
Phoca Member
Posts: 10
Joined: 16 May 2018, 19:46

Re: Export orders

Post by andraspal » 15 May 2019, 21:56

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.

Post Reply