With Miva Merchant you can export order information to a flat file — a plain-text file containing set types of data separated by a tab or text character. You can edit this file in any text editor, or import it into a spreadsheet. You can use the data elsewhere or edit it and import the results back into Miva Merchant.
Select a batch of orders.
Order information can be exported one batch at a time. Information for all the orders in the batch is included in a single flat file.
Specify a name for the file where you will export the order information. The default is orders.dat.
You might find it useful to include the date, batch name, or other detail in the file name, like ords-20060131.dat. The file will be saved on the server, under Merchant5/s01/export/filename.dat, where s01 indicates your first store. If you have additional stores, the directory will correspond to the store number (s02, s03, etc.).
Specify how you want the data handled if a file of the same name already exists. Select Append To File to have the newly-exported data added on to the end of the existing file. Select Replace File to discard the earlier version and save only the data currently being exported.
Specify how each data field in a record will be separated from the next. Tab-delimited flat files are common. You can use any character, like a comma, or a vertical line ("pipe") character: |. Be aware that if the specified character appears in the data for an order, such as the comma in "Shirt, Peruvian", that will be interpreted as a break between one field and the next. Choose a character that is not used in any order data.
When you are satisfied with the settings click Export.
The file containing the exported information will be located in the data directory on your server. If you have a problem finding the directory, contact your hosting service and ask where the data directory is located.
The fields of the exported order batch are shown below. The ORDER_ID is the order number. PROCESSED is represented by a 0 or a 1 and denotes whether or not the order has been processed as explained previously in this section. 0 signifies no, 1 signifies yes.