|
Orders are stored in two separate files. The first file is for Orders. This file contains customer information and the total amount for each order. The second file is for Order Line Items. This file contains a detailed listing of all products in each order. Order line items can be matched up with their corresponding order in the Orders file by the OrderID column.
To download order information to Excel:
| 2. | On the top menu, click View Orders under Order. The View Orders page is displayed listing all orders in the database. |
| 3. | Use Search to list only those orders your want to download. Skip this step to download all order information. |
OR
Enter the Beginning Order ID: Enter the order ID from which you want to download. All orders after this order ID will be downloaded.
| 4. | Click Download Orders to Excel to download all listed orders in the Order List. |
OR
Click Download Order line items to Excel to download all listed orders details including the order line items in the Order List.
The File Download dialog box opens.
| 5. | Click Save, to save the file, else skip to step 8 to open the file. The Save As Dialog box opens. |
| 6. | In the Save As dialog box: |
| • | Save in: Select a location where you want to save the downloaded file. |
| • | File Name: Enter a file name. Else leave at default. |
| 7. | Click Save. The Download complete dialog box is displayed. You can view the downloaded file by opening it in Excel from the saved location. |
| 8. | Click Open. The order information file is opened in Excel, listing all the customers and their account details. |
See Also:
Search and view order information
Change order status
Capture
Refund
|