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

productsPrice - What mean this number?
Orderpage- Okay

On my export i have this on productsPrice

2
1

Are these by any chance products where the currency is not USD (e.g. Euro)? In that case AliExpress displays the decimal "comma" instead of the decimal point. With this script the cents are being cut-off on these prices.

1. You can "normalize" the numbers using .replace(',' , '.') in the relevant places
2. I forked a fork of the script here

I combined the tracking tampermonkey script and the order detail one into one unified script. I will preface this that I haven't done any coding in 15 years, so it's mostly trial and error until I get it to work. There are probably many better ways to do this.

• Added tracking to the webpage (not export, if someone can fix this, be my guest)
• Added a button to copy the column header to the clipboard
• Rearranged columns to move less important columns further to the right

https://gist.github.com/poldim/96af32979a838dbb4816bd3352152859

Great "poldim"

I like : Added tracking to the webpage

But miss export yes... :(

I saw you added export "Item Picture URL",do you know how to see in "Google Sheets" ?

It's OK :)

I finished ^^ ! (I am not an DEV...difficult for me !)
Miss again tracking...I don't know why because I added like the first script o_O

So I used part of your script "poldim".

And I added :

• LINK directly on ID.
• LINK directly on image product.

I updated :
https://gist.github.com/dragoncity17/ec236643832f099736e9f41da88a5870

If someone can see why tracking doesn't work... :)

Added preview

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?