Hi
Is there any way to export orders to excel or csv?
There used to be a hack for VM1.x but I can't find a single component or plugin that does it.
Except for that CSVI, but I mean in a more simple and friendly way.. to use daily and not to export products etc as CSVI does.
Is a nightmare not having an export buton and having to copy orders manually.
Yep we use xls for our transport sytem :o
Hello,
I believe that CSVI is the easiest and more safe way to do it. You could easy create a template for that export and each time you want it you just run it or create a cron job to create it automatically and just pick up the file.
Regards
Ill give it a try again then, thanks bytelord.
Yes it's easy just need to work some hours with it, it's a little bit more complex because gives you too many options so you will be able to find your custom export template for you.
Also you could edit the template files (needs a little bit PHP knowledge) and ajdust them as you wish.
The problem is that it exports to csv which is quite messy, but we can still change it to xls with columns.
Regards
Import your csv file into an xls file and make columns, etc as you wish ... automatically and that one ... you can have your excel file grap the csv from a http server and import the records as you want
http://office.microsoft.com/en-001/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx
Thanks a lot bytelord! I will look carefully in to this.
Regards
I import the csv file into OpenOffice Calc (it has more flexibility than Excel) and then it looks like an Excel spreadsheet, can be manipulated etc. Also it can be exported frpom Calc as .xls file for import into Excel.
Thanks jenkinhill, I will look in to that too, first thing is creating a template in that CSVI to export orders, then ill try both of your suggestions and test,
Regards
Hi guys just to let you know or any one searching for the same, seems what we need can't be done with CSVI.
That component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.
We found this component which seems to be more capable of what we want http://extensions.joomla.org/extensions/administration/admin-reports/12250 or this one http://extensions.joomla.org/extensions/extension-specific/virtuemart-extensions/virtuemart-orders/19558
Regards
Nice,
Thanks for sharing :)
Hello,
Old topic I know but people still read it and there is something I would like to clear up.
QuoteThat component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.
This only applies to the Free version of CSVI, not the Pro version. The Pro version does allow to export the product_name.
Quote from: RolandD on June 19, 2014, 08:11:42 AM
Hello,
Old topic I know but people still read it and there is something I would like to clear up.
QuoteThat component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.
This only applies to the Free version of CSVI, not the Pro version. The Pro version does allow to export the product_name.
1. Can you export a file based in order status? I mean export all the "confirmed" orders for example?
2. Can you select the fields and ordering of the exported fields?
We dont mind if its CSV, XLS or PDF.
Exporting a simple list of orders in VM2 seems a nightmare.