Skip to main content

Export / Invoices

Screenshot_2020-04-29_at_19.12.41.png Getting started

In this article, you can learn about export / invoices functionality, which will allow you to export list of orders with their basic invoice and order 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/invoice_report_example.xlsx

POWERPNT_vZRn4iJb9Y.png   Visualization of the exported invoices list
POWERPNT_JTGAQAZ1Mt.png   Visualization of the export / orders list module in the administrator panel

Table of contents:

     Filters section  Export / orders list section  Exporting orders to the xlsx

    Screenshot_2020-04-29_at_19.12.41.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 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 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       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 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 Exporting orders to the xlsx

          By pressing the Export to xlsx button shown in the  Export / orders list section 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/invoice_report_example.xlsx

          POWERPNT_h6wEpFGvDv.png       Visualization of the exported orders=s

          Xlsx file contains the exactly same information as export / orders list tab:

            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.
            Back to top