Exporting all Order Information

[newtozc32]

Hey all,

Can you anyone tell me if there is a way to export all order information. I.E. product price, shipping, tax, etc. Preferably all of that information in a .csv or text tab-delimited file type.

I need to be able to export this information for business tax reporting purposes.

I recently installed orders exporter 1.6, it works great, however it does not export the items I mentioned above.

Thanks!

[kobra]

You can determine which tables contain the information you need and using phpmyadmin export them to csv
Then in a spread sheet you can delete the extraneous information you do not need

[newtozc32]

You can determine which tables contain the information you need and using phpmyadmin export them to csv
Then in a spread sheet you can delete the extraneous information you do not need

That's a really great idea! Thanks Kobra! I'll see what I can do and let you know how it works out.

I'm very surprised there's not a plugin to do this?

Possibly this:
http://www.zen-cart.com/downloads.php?do=file&id=77

It's very dated though, but that might not matter. What do you think?

[newtozc32]

That's a really great idea! Thanks Kobra! I'll see what I can do and let you know how it works out.

I'm very surprised there's not a plugin to do this?

Possibly this:
http://www.zen-cart.com/downloads.php?do=file&id=77

It's very dated though, but that might not matter. What do you think?

I did even more research. This plugin is very useful:

http://www.zen-cart.com/downloads.php?do=file&id=734

[gjh42]

I have been updating and modifying Orders Exporter to be completely flexible and able to export any desired fields, with various date/order id limit choices. It is mostly working now, though there are still a few bugs in some aspects of the expanded functionality. The core export works perfectly. When I get all the bugs out I will be submitting v2.0 to Plugins.

Meanwhile, just adding some new fields to v1.6 is not difficult. It just requires duplicating the current $filelayout and $filelayout_sql construction code for the desired fields with the appropriate db field names substituted.