You can generate a comma delimited file from an open order book manually. This functionality is refered to as Ad-hoc output and is quite useful when you need to produce a file to upload to your shipping company to populate address list and produce shipping labels, or when you need to select a batch of orders and create a fulfilment list for a drop shipper.
The system will generate a CSV file in the location you have setup in the ad-hoc export configuration.
Only the orders you have selected will be included in the the file. Also, if you have Conditions specified, only orders that fulfil the specified condition will be included in the output.
Before you can use ad-hoc output you need to configure the format of the files that will be produced and set where the files will be created.
Go to Settings > Import / Export Automation > Data Export > Adhoc Output.
The export settings are arranged into groups which may contain several files which will be produced. For example you can setup ad-hoc export group which will generate 3 files to be uploaded to your shipping courier, such that when you select this group in the Open Orders the system will take all selected orders, run an conditional expression for each order to see which file to include the order into. Lets look at a specific example:
To accommodate these requirement you will need do the following:
Condition Expression is a logical statement which checks whether a selected order qualifies for the inclusion into the file. You can check any logical statement (for example 1=2 is a logical statement which checks whether 1 equal 2, which will of course yields false, unless you are an electron). Similarly you can check whether a cCountry field equals 'United Kingdom' etc. You can see the fields you can evaluate in the column mapping selection.