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: 41483
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: 17
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: 17
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: 41483
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: 17
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.

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

Re: Export orders

Post by Jan » 19 May 2019, 23:22

Ok, thank you for the info.

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

Post Reply