# Export / orders list # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Getting started In this article, you can learn about **export / orders list** functionality, which will allow you to export created e-commerce orders with their basic information. In order to access this module you have to have **BOK supervisors**, **MC business admin,** **Administrator**, **Super administrator**, or **Root** group. You can find the example export file under the URL: [https://knowledge.tauceti-digital.com/orders\_export\_file\_example.xlsx](https://knowledge.tauceti-digital.com/orders_export_file_example.xlsx "https://knowledge.tauceti-digital.com/orders_export_file_example.xlsx")
![POWERPNT_h6wEpFGvDv.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287921788956.png)
*Visualization of the exported orders list*
To open the Export / orders list view, in the admin panel, navigate to: ***Import / export > Export / orders list*** All possible operations to perform on the **Export / orders list** view can be done in the **Filters (1) **and **Export / orders list (2)** tabs.
![Screenshot_2023-01-11_at_11-22-20_Export___orders_list_-_Admin_module.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287832739996.png)
*Visualization of the export / orders list module in the administrator panel*
Table of contents: 1. [ Filters section](#bkmrk-filters-section) 2. [ Export / orders list section](#bkmrk-export-%2F-orders-list) 3. [ Exporting orders to the xlsx](#bkmrk-exporting-orders-to-) --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Filters section The **Filters** section allows the sorting of the orders in the **export / orders list** module, based on the available filters. Orders are not visible by default and it is required to apply any filter first in order to see them. Below you will find a description of each filter.
![POWERPNT_JPwy7xKNGH.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287933535900.png)
*Visualization of the filters tab*
- **Order ID** - Orders internal ID. - **Processed on** - A range of dates when the order was processed. - **Order value** - A range of total order values. - **Alt shop** - Altshop name where the order was placed on. - **Status** - Current status of the order. - **Delivery method** - Selected orders delivery method. - **Payment method** - Selected orders payment method. - **Deffered payment status** - Current status of the deffered payment. - **Check status** - Current internal check status of the order. - **Paid?** - Order payment status. - **Customer ID** - ID of the customer. - **Phone number** - Customer's phone number. - **Package number** - Number of the delivery package. - **Only with vouchers** - A tickbox that allows seeing only orders with vouchers. - **Status (Balikobot)** - Order status acquired from Balikobot (when Balikobot is used). After defining the above filters, select the **Apply Filters** button to get a list of sites according to the applied filters. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Export / orders list section The **Export / orders list** section allows to further narrow down the list of orders. Below you will find a description of possible actions.
![POWERPNT_8AbtFe4XwA.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287921787548.png)
*Visualization of the export / orders list section*
- Select the **Show X entries** **(1)** field to set the number of orders, displayed on one page (min 10 / max 100). - The names of the columns **(2)** that contain information about a given order. Each column is susceptible to sorting. To sort the records, click on the title of the column in question. - **Order ID** - Orders internal ID. By clicking on the order ID you will be redirected to the detailed order information located in the **Orders > Orders / list.** - **Processed on** - A range of dates when the order was processed. - **Value** - A range of total order values. - **First name** - Customer's first name. - **Last name** - Customer's last name. - **E-mail** - Customer's e-mail address. - **Paid?** - Order payment status. - **DP status** - Current status of the deffered payment. - **Status** - Current status of the order. - **Phone number** - Customer's phone number. - **Package number** - Number of the delivery package (Carrier Barcode). - Select the **Export to xlsx (3)** button to export all filtered orders to the xlsx file. You can learn more about exported xlsx file in the [ Exporting orders to the xlsx](#bkmrk-exporting-orders-to-) section - **Search box** **(4)** where you can search for desired orders by their ID, first name, last name, e-mail address, status, phone number, and package number. - **Page buttons** **(5)**, which allow users to change the page of currently viewed orders. --- # ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Exporting orders to the xlsx By pressing the Export to xlsx button shown in the [ Export / orders list section](#bkmrk-export-%2F-orders-list) chapter you are able to export all the filtered orders to the xlsx file and download it. You can find the example export file under the URL: [https://knowledge.tauceti-digital.com/orders\_export\_file\_example.xlsx](https://knowledge.tauceti-digital.com/orders_export_file_example.xlsx "https://knowledge.tauceti-digital.com/orders_export_file_example.xlsx")
![POWERPNT_h6wEpFGvDv.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/7287921788956.png)
*Visualization of the exported orders=s*
Xlsx file contains the following fields: - **OrderID** - Orders internal ID. - **Processed on** - A range of dates when the order was processed. - **Order\_value\_gross** - A range of total order values. - **Customer\_first\_name** - Customer's first name. - **Customer\_last\_name** - Customer's last name. - **Customer\_email** - Customer's e-mail address. - **Paid** - Order payment status. - **DP status** - Current status of the deffered payment. - **Status** - Current status of the order. - **Customer\_mobile** - Customer's phone number. - **Tracking\_code** - Number of the delivery package (Carrier Barcode). - **Invoice\_number** - Number of the invoice. - **Delivery\_street** - The street name to which the package will be delivered. - **Delivery\_building** - The building number to which the package will be delivered. - **Delivery\_flat** - The flat number to which the package will be delivered. - **Delivery\_postal\_code** - The postal code to which the package will be delivered. - **Delivery\_city** - The city name to whihc the package will be delivered. - **Delivery\_company\_name** - Company name defined by the customer when placing the order. - **Delivery\_tax\_id - Tax ID** defined by the customer when placing the order. - **Delivery\_company\_id** - Company ID defined by the customer when placing the order - **Delivery\_method** - Used delivery method in the order. - **Parcel\_machine\_id** - Parcel ID in case of deliveries to the parcel points. - **Country\_code** - Country code of the country from which the order was created (e.g. HU). - **Product\_list** - The list of products separated by pipes (" | "), The list contains its SKU, quantity and price in a SKU;Quantity;Price format. For example: 01569;3;38,90|NOGIFT;1;0,00|60735;5;55,90|59137;1;99,00 - **Tracking\_number** - Tracking number of the package provided by the delivery service. - **Campaign\_code** - The campaign code that was used when placing the order by the customer. - **Delivery\_fee** - Delivery fee which customer paid for the selected order. - **Payment\_fee** - Payment fee which customer paid for the selected order.