CSV File of All Orders

[mbianchi]

Is it possible to download a CSV file of all orders? What I am looking for is a way to get a file that contains both the customer info and the products ordered by that customer. All orders by all customers in one easy CSV file. A date range would be cool, too.

 

I have looked through the contributions but I can't find anything that does exactly what I am looking for. If I were a PHP/MySQL god like some of you here, I would just write it myself! Has anyone else here considered such a feature?

 

Any suggestions?

 

Thanks!

 

Mark Bianchi

Dayton, Ohio

[cali_cobra]

You can access your PHPMYADMIN tool in your host control panel under mySQL and run your query to get your file there.

[Guest]

The MYOB contribution does this.

 

Matti

[mbianchi]

Thanks for the response. Must I use MYOB to get the orders? Why can't I just download a CSV file and open it in Excel?

 

Thanks for all your help!

 

Mark

[AlanR]

Thanks for the response. Must I use MYOB to get the orders? Why can't I just download a CSV file and open it in Excel?

 

Thanks for all your help!

 

Mark

You can. That's what the contribution does. It's your choice what to do with the CSV file.

 

Finally, here it is.

 

What does it do?

 

Exports sales and customer information on a daily basis to a Comma Seperated file suitable for import into MYOB.

[mbianchi]

Thanks, AlanR! None of the documentation for the MYOB contribution made reference to the fact that any program could use to data. Guess I could have figured that one out on my own with a little testing.

 

Works great. I appreciate it!

 

Mark