PDA

View Full Version : Exporting order info



little-linguist
02-10-2007, 14:50
Is there a way of exporting orders within a specific date range? At the end of each month, I like to export all orders to check against our accounting info. It would be great if we could choose a start and end date and possibly be able to select / deselect other criteria as well, rather in the way that you can tailor product data exports. For example, the current order export includes each line of each order, whereas I'd quite like to be able to just download the order totals.
Is this feature something that could appear in the future?

Rich
02-10-2007, 17:22
If you don't specify an order number to begin the export from, the export button will export all of the orders being displayed - affected by selected filters. So, if you select to display "Last Month" instead of "All Orders" and click the export button, only last month's orders will be exported.

At the moment, there's no way to tailor the product export. We may review this in the future, but it's unlikely that we'll build an interface of the scale of the product export.

Chris
03-10-2007, 08:35
Is there a way of exporting orders within a specific date range?

We also export our orders and do all sorts of things with them. It forms part of our despatch process, monthly accounting like you, and general stats.

We download everything and then run some macros on the data in Excel. Having all the data exported is great 'cos it means you can analyse it any way you choose. If you think of a new report, you should be able to get the info you need from the raw data, then record a macro to do it speedy next time.

Obviously the macro would need some manual tweaking. I'm no VB programmer but I found most of what I needed by doing a quick search on google. When you've got the basic macro recorded it's not too bad to edit using a bit of trial and error.