Virtuemart CSV Order List and Email

VM Order List

Virtuemart Order List is a Joomla compoment that will allow the user to on demand or by executing a cron to generate a CSV or a TXT file that is emailed to one or two email addresses. The CSV or TXT file can then be opened and used as an Excel spreadsheet.  Once the component is installed, sign into the backend and find VM ORDER LIST. Next fill in the email addresses, subject line, body text message and select the fields that you want to see included in the CSV or TXT file.

Component Setup

The component installs as any other Joomla 2.5 component. After installation, access the component from the components menu and proceed with the set up steps recommended below.

The screen captures below are of the options for the component set up. They are mostly self-explanatory. Where needed, some notes are included following the screen capture.  In the backend go to VMORDERLIST and click the options button  on the top left of the screen.
 

The order status codes let you choose to show all orders, regardless of status, or select statuses only. Limiting the CSV to showing only Confirmed orders will prevent a fulfillment house from shipping orders that have not been fully paid.The order status codes let you choose to show all orders, regardless of status, or select statuses only. Limiting the CSV to showing only Confirmed orders will prevent a fulfillment house from shipping orders that have not been fully paid.

More than 60 of the most commonly used field are available to print on the excel spreadsheet.  Each element has a field name, that doesn't change.  Each element has a Excel Column Name that can be easily customized to be whatever is required for your installation.  Each element also has a Print Sequency Number.  This number if set to 000 specifies the field is not to print.  Any other value and it is printed in the order of these fields.  Therefore you control which fields print and in what order. 

 Front-end

To execute VM ORDER LIST on demand create a menu link to the component.   When you click on the menu link, the component will display the 1st day of the current month and the last day of the month along with the default email address to recieve the spreadsheet.  Simply modify the date range and change the receiving email address if needed and submit.  The CSV or TXT file will be emailed to the address specified. You can also use this option to generate a different file type than is set for the default used by the CRON method. Use the front-end for ad hoc reports as needed.

Cron Job

/usr/bin/wget "http://www.yoursite.com/index.php?option=com_vmorderlist&task=cron"

As Copy of this CRON job is included it the VM Orderlist package. Unzip first to locate it.

Modifying CSV/TXT File Headings

Select the field you wish to change from the list and choose Edit.  Change the Excel Column Name to your  desired value
and when complete press Save or Save & Exit.

Changing the Order of the Fields

Select the field you wish to change from the list and choose Edit.  Change the Excel Column Name to your  desired value
and when complete press Save or Save & Exit.

Saving the Attachment

In addition to sending the output file as an attachment, the system can save the attachment with a unique file name based on the time and date. 

If the "Keep File vmordyyyymmddhhmm" option is set to "No," the component will generate the order attachment as "vmorderlist" and will overlay the previous file on the server root with the new file when it is generated.

Setting the option to "Yes" (this is the default) will create a new file on the server root named vmordyyyymmddhhmm.csv or .txt.  If a new file were generated on September 23, at 8:30 AM the name of the file created would be vmord201110230830.csv or .txt. This option allows you to keep backups of the sent files on the server root, and makes sure that the receipient of the emailed file can tell when the file was created.

If this option is used, you may set up a cron job that runs as often as needed and each email generated will have a unique attachment id that will also be saved in the root folder of your server. 

 To Purchase VM Order List Click Here