Export AliExpress Orders to Excel or CSV

Mis à jour le 5 octobre 2026

You can download your imported AliExpress orders as an Excel or CSV file, for your accountant or for your own analysis in a spreadsheet. The file contains every order that matches the date range and filters of the AliExpress report.

Where
Suppliers > AliExpress, Export in the report toolbar
Time
Under a minute for most accounts

Download the File#

In the sidebar, open Suppliers, then AliExpress.

  1. 1

    Étape 1 sur 3

    Pick the date range and filters#

    Pick the date range, and if you need to, a Delivery country, Product or Supplier. The export contains exactly the orders the report shows.

  2. 2

    Étape 2 sur 3

    Click Export#

    Click Export on the right of the toolbar.

    The AliExpress report. Export is the last button in the toolbar at the top right.

    If the Export button shows an upgrade hint instead of the menu, data exports are not included in your current plan.

  3. 3

    Étape 3 sur 3

    Pick a template and a format#

    Pick a template and a format: Order list or Detailed order list, each as Excel (XLSX) or CSV.

    Use Excel (XLSX) if you open the file in Excel. A CSV file opened in Excel can show amounts and dates in the wrong format, depending on the language settings of your computer.

  4. Terminé

    The file downloads#

    Wait while the button shows Preparing export…. The file downloads by itself when it is ready, and a message Export ready appears with a Download button in case the download was blocked.

Which Template to Pick#

TemplateContains
Order listPer order: date, status, the matching Shopify order, number of items, product total, shipping, tax, discount, order total and currency. Per item: description, variant, store, quantity, unit price and line total.
Detailed order listEverything in Order list, plus the amounts in the currency you paid on AliExpress, payment method and date, tracking numbers and carriers, the delivery address, and per item the product id, shipping method, shipping price and delivery time.

How the File Is Laid Out#

Each order takes several rows: first one order row, then one item row for each product in the order. The first column, row_type, says which one a row is (order or item).

  • Order rows hold the order amounts (product_total, shipping_total, tax, discount, order_total). Their item columns are empty.
  • Item rows hold the item amounts (item_unit_price, item_line_total). Their order amount columns are empty.
  • The order number, date, status and matching Shopify order are repeated on every row, so you can sort and filter without losing track of which order a row belongs to.

Because the other rows are empty in each amount column, you can sum a whole column. Example for an order with two products:

row_typeplatform_order_iditem_descriptionitem_quantityitem_line_totalshipping_totalorder_total
order82017643100259073.2027.70
item8201764310025907Linen cushion215.00
item8201764310025907Bath towel19.50

Total spent in the period. Sum the order_total column. Only order rows have a value there, so each order is counted once. In Excel, =SUM(...) over the column is enough; there is no need to remove duplicate rows.

Number of orders. Filter row_type to order and count the rows.

Limits#

  • The main amount columns (product_total, order_total and the others) are in your report currency (see How to Change the Currency of AliExpress Orders); the currency column on each order row names it. The columns ending in _source in the detailed template keep the currency you paid in, named in currency_source.
  • Cancelled AliExpress orders are included. Check the status column if you want to leave them out.

Articles associés

Cet article vous a-t-il été utile ?

Nous respectons votre vie privée
Nous utilisons des cookies pour améliorer votre expérience. En continuant à utiliser notre site, vous consentez à notre utilisation des cookies.

En cliquant sur "Tout accepter", vous consentez à notre utilisation des cookies.

En savoir plus