VirtueMart Order Export (From Grid)
Often online retailers need to export orders from VirtueMart stores. The necessity to extract sales data into the file occurs when you need the orders to be transmitted to your accountant, to make reports for analysis or use this info integrating with some third-party systems and services.
If you are looking for VirtueMart export module, you are in the right place, as Store Manager for VirtueMart copes with the task in seconds!
Download 14-day fully-functional version to try right now!Try FREE!
Filter Orders to Be Exported
With Store Manager it is possible to use built-in filters or create various custom filters in order to export VirtueMart orders by status, time period, order IDs, order numbers (from - to), customer (full or part of the name), order total and subtotal, payment or shipment methods.
See how this works in action. Imagine that you want to export the orders with total more than $99 that were made during last year. To do so, first you need to use predefined ‘Filter by date’ option and from the drop-down there select ‘Last year’.
Next in orders grid, if you hover your mouse over ‘Orders Total’ column heading you will see small filter sign. After clicking on it, you will see drop-down where you need to select ‘Custom’.
New window will appear where you set conditions for filtering. In our case we will use option ‘is greater than’ and put the value - 99. That’s it - pressing OK to apply the filter you will see only orders matching your search parameters.
Now you can export those filtered orders to the files of different formats.
Export File Formats
Store Manager for VirtueMart supports many file types to export orders.
Using it you can export the predetermined sales records into spreadsheets of the following formats: CSV, TXT, XML, XLS, XLSX or HTML.
Order Grid Export in 2 Clicks
Now from orders menu you can start export process simply by clicking on "Grid Export" button and selecting output file format from the dropdown.
Further you need to select directory where to save the spreadsheet at your PC and change filename if necessary. That’s all. After that you can use send the file to accountant or use for other purposes you need.
What orders info it is possible to bring to the file:
- Order IDs
- Order numbers
- Customer name
- Order total
- Order subtotal
- Order total and subtotal tax
- Payment method
- Shipment method
- Date created