Export aliexpress orders to clipboard as csv

// ==UserScript==
// @name         Aliexpress
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  try to take over the world!
// @author       You
// @match        https://trade.aliexpress.ru/orderList.htm*
// @match        https://trade.aliexpress.com/orderList.htm*
// @match        https://trade.aliexpress.ru/order_list.htm*
// @match        https://trade.aliexpress.com/order_list.htm*
// @grant        unsafeWindow
// @grant        GM_xmlhttpRequest
// @grant    GM_setClipboard
// @require http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js
// ==/UserScript==

(function() {
    'use strict';


})();

var orders = [];
var reqs = [];
$(".order-item-wraper").each((ind, el)=>{
    var products = [];

    $(el).find(".order-body").each((i,e)=>{
        $(e).find(".product-sets").each((i,e)=>{
            let obj = {
                title: $(e).find(".product-title").text().trim(),
                price: parseFloat($(e).find(".product-amount span:first()").text().trim().slice(1).trim()),
                amount: $(e).find(".product-amount span:eq(1)").text().trim().slice(1)
            };
            products.push(obj);
            //        console.log(obj);
        });
        //  console.log(products);
    });

    var hasTracking = $(el).find(".button-logisticsTracking ").length > 0;
    let order = {
        id: $(el).find(".order-info .first-row .info-body ").text().trim(),
        date: Date.parse($(el).find(".order-info .second-row .info-body ").text().trim()),
        status: $(el).find(".order-status .f-left").text().trim(),
        orderPrice: $(el).find(".amount-num").text().trim(),
        productsPrice: products.map((it)=> it.price).reduce((a, b) => a + b, 0),
        productsNames: products.map((it)=> it.title).join(", "),

        hasTracking: hasTracking,
        products: products,
    };
    if (hasTracking){
        var req = new Promise((resolve, reject) => {
            GM_xmlhttpRequest({
                method: "GET",
                url: "https://ilogisticsaddress.aliexpress.com/ajax_logistics_track.htm?orderId=" + order.id + "&callback=test",
                onload:(data)=>{
                    console.log(eval(data.responseText));
                    order.tracking = eval(data.responseText).tracking;
                    order.trackingNumber = order.tracking.map(it=>it.mailNo).join(", ");
                    resolve(order);
                    orders.push(order);
                },
                onerror: () => reject(400)
            });
        });
        reqs.push(req);
    } else{
        orders.push(order);
    }
});


$.when.apply(null, reqs).done(function(){
    //   console.log(orders);
    // console.log(orders.length);
});
//<button id="search-btn" class="ui-button ui-button-primary search-btn" type="button">Search</button>


$('#mybutton').one('click', function(){
    var r=$('<input/>').attr({
        type: "button",
        id: "field",
        value: 'LOAD CSV'
    });
    $("body").append(r);
});


$('<button/>', {
    text: "LOAD", //set text 1 to 10
    id: 'csvBtn',
    click: function () {
        $("#csvBtn").text("Loading...");

        Promise.all(reqs).then(o =>{
            var s = "";// = "date\t trackingNumber\t productsNames\t status\t orderPrice \t productsPrice \t url \n";
            var preview = "<table>";
            orders.sort((a, b)=> b.date - a.date).forEach(e=> {
                console.log(e);

                var d = new Date(e.date);
                var date = d.getFullYear() + "-" + d.getMonth() + "-" + d.getDate();

                s += date + "\t";
                s += (e.trackingNumber || ' ') + "\t"; 
                s += e.productsNames + "\t"; 
                s += e.status + "\t"; 
                s += e.orderPrice + "\t"; 
                s += e.productsPrice + "\t"; 
                s += "https://trade.aliexpress.com/order_detail.htm?orderId=" + e.id;

                s += "\n";

                preview += "<tr>";
                preview += "<td>" + date + "</td>";
                preview += "<td>" +(e.trackingNumber || ' ') + "</td>";
                preview += "<td style='width: 25%'>" +e.productsNames + "</td>";
                preview += "<td>" + e.status + "</td>";
                preview += "<td>" +e.orderPrice + "</td>";
                preview += "<td>" + e.productsPrice + "</td>";
                var url = "https://trade.aliexpress.com/order_detail.htm?orderId=" + e.id;
                preview += "<td><a href='" + url + "'>" + url + "</a></td>";
                preview += "</tr>";

            });
            preview += "</table>";
            console.log(s);
            GM_setClipboard (s);
            $("#csvBtn").text("Loaded to clipboard");
            $("#preview").remove();
            $(preview).attr('id', 'preview').css({"overflow-x": "scroll"}).appendTo("#appeal-alert");
        });


    }
}).appendTo("#appeal-alert");

$('<button/>', {
    text: "Show/hide preview",
    id: 'togglePreview',
    click: function () {
        $("#preview").toggle();
    }}).appendTo("#appeal-alert");


function test(data){ return data;}

Awesome script!!

Note that it requires this to function:
https://chrome.google.com/webstore/detail/tampermonkey/dhdgffkkebhmkfjojejmpbldmpobfkfo/related

Also note that you can right-click on the "10 items per page" dropdown, and "inspect" it, and change it to 100 (or whatever), then when you click that, you can load and extract more than 10/20/30 items in one go!

hi. is it still working? when I click on load button, it stuck - i was waiting for 10mins

Yep, still works for me

Hello guys did you see order page have updated its change look and apirience i supose this script is dont work any more . Did some one make updated ?

Same problem, someone update ? Thanks

Same here, since the new Aliexpress interface there is no way to export the orders to csv. Does someone found a way to do it?

Thank you very much

Same problem, someone update ? Thanks

Hello, have you been able to solve it?