One Stop Order Processing allows any view to be exported. To allow easy data conversion to the target system you can also define your own values. These can either contain a single value for all orders, or a different value for each order. These values can be defaulted from any other field and can include calculations based on other fields. For more information see Selecting Display Fields.

To export all the orders (or selected orders) select the Export Orders menu option (under File->Import and Export) or click on Export Orders button ( ).

You can define how you want to export the information displayed on the screen. Only the fields (columns of data) that are marked for export are exported. The columns shown in the Export order details dialog are those that will be exported.

Orders to include
You can either export all the orders displayed shown in the main window or those that you have ticked.

Include header line
If you require information at the start of the file add any text here.

Include footer line
If you require information at the end of the file add any text here.

The header, footer lines and filename can include the following macros. These are replaced when the information is exported.

[%TIME%]   The current date and time.
[%FILENAME%]  The filename exported to.
[%NUM_EXPORTED%]  Number of orders exported
[%NEW_LINE%]   Start a new line. This can be used to put several blank lines (with or without data in) at the start or end of the export file. You can also use the value %NEW_LINE% in a column's definition to export a newline (useful for some export formats).
[%TAB%] Use a tab character.

Include column headers before data
Some 3rd party products want the names of the fields that the information relates to. You can change the names of the columns in the Select fields dialog.

Include column totals after data
You can include the totals of any columns defined in the view as totals required.

Include all fields
When exporting orders ignore any column specific information about not exporting the column. This is useful when you want to export all the order data from the OSOPExport view. This will also include the original column names, rather than any new names that have been entered.

Quote field information
If you are using the separator in your main text you may want to use quoted fields. For example, some applications (e.g. Microsoft Excel) allow the comma separator to be used as field text as long as all the fields are quoted. You can use any character(s) to put around the export field information.

Field separator, to use a tab enter \t
This is the character (or characters) to use between each value. If you need a Tab Separated file (tsv) type in \t.

File to export to
This is the file that will be used to save the information to. This file will be overwritten each time an export is done.

File format
You can export the orders into a CSV or XLS (Excel spreadsheet format).

There are various file formats. For normal CSV files select Standard. For specific formats, they are listed in the bozx on the right, for example, RoyalMail Despatch Express.

Add comment to order memo when exported
You can add text to the order's memo/notes when the order is exported. This can be useful to see if an order has been exported.