How do I export order items to a text file?

Started by Mike Griggs, August 22, 2008, 12:27:40 PM

Previous topic - Next topic

Mike Griggs

To export order items to a text file for data processing please do the following

Setup the export format

1. In the SuperManager click "View->Program Settings" and then click the "Export formats" tab
2. Click "Add" and then enter a name for the export format..  "Item Export"
3. Select the following settings for the export format
    a. This format exports: "Orders"
    b. File header: Checked
4. Enter the following text in both text boxes..

order_date,order_id,ship_first_name ship_last_name,item_quantity,item_price,item_code,item_description,item_option_choices

5. Click "OK" to close the window.


Export order items to text file

1. Select the orders in the order list that you would like to export products for.
2. Right click on the selected orders and select "Export->Item Export"
3. Save the file to your computer with a .txt extension
4. Import the file into excel for data processing.