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;}

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?