 Online Help |
|
Online Help |
|
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.
ORDER_ID
PROCESSED
ORDER_DATE
ORDER_TIME
SHIP_FNAME
SHIP_LNAME
SHIP_EMAIL
SHIP_COMP
SHIP_PHONE
SHIP_FAX
SHIP_ADDR
SHIP_CITY
SHIP_STATE
SHIP_ZIP
SHIP_CNTRY
BILL_FNAME
BILL_LNAME
BILL_EMAIL
BILL_COMP
BILL_PHONE
BILL_FAX
BILL_ADDR
BILL_CITY
BILL_STATE
BILL_ZIP
BILL_CNTRY
PROD_CODE
PROD_NAME
PROD_UPSLD
PROD_PRICE
PROD_QUANT
PROD_ATTR
PROD_OPT
OPT_PRICE
ORDER_TAX
ORDER_SHIP
ORDER_TOTL