AliExpress Orders to Clipboard CSV

aliexpress-orders-csv.js

// ==UserScript==
// @name         AliExpress Orders Exporter
// @namespace    https://gist.github.com/
// @version      0.4
// @description  Retrieve Aliexpress order information and export as CSV via clipboard
// @author       You
// @match        https://trade.aliexpress.com/orderList.htm*
// @grant        unsafeWindow
// @grant        GM_xmlhttpRequest
// @grant        GM_setClipboard
// @require      http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js
// @require      https://code.jquery.com/jquery-latest.js
// @require      https://www.17track.net/externalcall.js
// ==/UserScript==

// Original order data script: https://gist.github.com/Bolukan/16146e6e9c3c7e05a8a23f8b2f8a1dc4
// Original order tracking script: https://gist.github.com/rafal83/6dea29d07743a8a7bab091e31e3c9782

function parseDate(txt) {
  // 012345678901234567
  // 10:31 May. 21 2019
  // var d = new Date(year, month (0-11), day, hours, minutes, seconds, milliseconds);
  return new Date(
    txt.slice(14, 18),
    'Jan.Feb.Mar.Apr.May.Jun.Jul.Aug.Sep.Oct.Nov.Dec.'.indexOf(
      txt.slice(6, 10)
    ) / 4,
    txt.slice(11, 13),
    txt.slice(0, 2),
    txt.slice(3, 5),
    0,
    0
  );
}
const orders = [];
const items = [];
const reqs = [];
const options = {
  weekday: undefined,
  year: 'numeric',
  month: '2-digit',
  day: '2-digit',
  hour: '2-digit',
  minute: '2-digit',
};
const listTrack = new Array();
let totalTrack = 0;
let dt = 0;

getTrackingNumber = function (data) {
  console.log(listTrack.length + 1 + '/' + totalTrack);

  const orderId = data.cainiaoUrl.split('=')[1];
  const trackId = data.tracking[0].mailNo;
  const oneUrl = 'https://www.17track.net/fr/track?nums=' + trackId;
  let status = data.tracking[0].keyDesc;

  listTrack.push(trackId);

  if (data.tracking[0].traceList) {
    dt = new Date(data.tracking[0].traceList[0].eventTime);
    status +=
      '<br/>' +
      dt.toLocaleString() +
      '<br/>' +
      data.tracking[0].traceList[0].desc;
  }

  jQuery('.button-logisticsTracking[orderid=' + orderId + ']')
    .before(
      '<td class="tracking_number" style="background-color: red;color: white;font-weight: bold;padding:0px">' +
        '<p> Tracking number </p> <p class="data">' +
        data.tracking[0].mailNo +
        '</p></td></tr>'
    )
    .before(
      '<tr><td class="consolidate_tracking_number" style="background-color: red;color: white;font-weight: bold;padding:0px">' +
        '<p> Consolidated Tracking number </p> <p class="data">' +
        data.tracking[0].consoTagSecondMailNo +
        '</p></td>'
    )
    .before(
      '<span class="tracking_status" style="color: black;font-weight: bold;font-size: 13px;">' +
        '<p> Status </p><p class="data">' +
        status +
        '</p></span>'
    );

  for (const o in orders) {
    if (orders[o].order_id == orderId) {
      orders[o].order_tr_num = data.tracking[0].mailNo;
      orders[o].order_tr_num_2 = data.tracking[0].consoTagSecondMailNo;
      orders[o].order_tr_stat = status;
      break;
    }
  }
};

function getAllTrackingNumber() {
  console.log('Searching orders');

  listTrack.length = 0;
  totalTrack = jQuery('.button-logisticsTracking').length;

  if (totalTrack > 0) {
    console.log('Total trackings ' + totalTrack);

    jQuery('.button-logisticsTracking').each(function () {
      const orderId = jQuery(this).attr('orderid');
      jQuery.ajax({
        url: `${document.location.protocol}//ilogisticsaddress.aliexpress.com/ajax_logistics_track.htm?orderId=${orderId}&callback=getTrackingNumber`,
        dataType: 'jsonp',
      });
    });
  }
}

function searchOrders() {
  $('.order-item-wraper').each((_index, eo) => {
    const hasTracking = $(eo).find('.button-logisticsTracking ').length > 0;
    const order = {
      order_id: $(eo).find('.order-info .first-row .info-body ').text().trim(),
      order_time: parseDate(
        $(eo).find('.order-info .second-row .info-body').text().trim()
      ).toLocaleDateString('nl-NL', options),
      order_amount: $(eo).find('.order-amount .amount-num').text().trim(),
      order_status: $(eo).find('.order-status .f-left').text().trim(),
      store_name: $(eo).find('.store-info .first-row .info-body').text().trim(),
      store_url: $(eo).find('.store-info .second-row a:first()').attr('href'),
      order_tr_num: $(eo)
        .find('.order-action .tracking_number .data')
        .text()
        .trim(),
      order_tr_num_2: $(eo)
        .find('.order-action .consolidate_tracking_number .data')
        .text()
        .trim(),
      order_tr_stat: $(eo)
        .find('.order-body .order-action .tracking_status .data')
        .text()
        .trim(),
      product_action: $(eo).find('.product-action span:first()').text().trim(),
      hasTracking: hasTracking,
    };

    orders.push(order);

    console.log('Tracking number: ' + order.order_tr_num);
    console.log('Consolidate Tracking number: ' + order.order_tr_num_2);
    console.log('Tracking status: ' + order.product_action);
    console.log('store_url: ' + order.store_url);

    const products = [];
    let inum = 0;
    $(eo)
      .find('.order-body')
      .each((i, eb) => {
        $(eb)
          .find('.product-sets')
          .each((i, ep) => {
            let product = {
              order_product_num: ++inum,
              product_id: $(ep)
                .find('.product-title .baobei-name')
                .attr('productId'),
              product_title: $(ep)
                .find('.product-title .baobei-name')
                .attr('title'),
              product_url: $(ep)
                .find('.product-title .baobei-name')
                .attr('href'),
              product_pic_url: $(ep).find('.product-left img').attr('src'),
              product_snapshot: $(ep)
                .find('.product-snapshot .baobei-name')
                .attr('href'),
              product_count: $(ep)
                .find('.product-amount span:nth-child(2)')
                .text()
                .trim()
                .slice(1),
              product_price: $(ep)
                .find('.product-amount span:first()')
                .text()
                .trim(),
              product_skuid: $(ep)
                .find('.product-property span:first() span:first()')
                .attr('id'),
              product_property: $(ep)
                .find('.product-property span:first() span:first()')
                .text()
                .trim(),
              order: order,
            };
            products.push(product); // local all products
            items.push(product); // global all products
          });
      });
    /*
    let order = {
      id: $(el).find(".order-info .first-row .info-body ").text().trim(),
      status: $(el).find(".order-status .f-left").text().trim(),
          orderPrice: $(el).find(".amount-num").text().trim(),
          productPriceAndAmount: $(el).find(".product-right .product-amount").text().trim().replace(/(?:\s\s)/g, ""),
          productsNames: products.map((it)=> it.title).join(", "),
        orderDate: $(el).find(".order-info .second-row .info-body").text().trim(),
        sellerName: $(el).find(".store-info .first-row .info-body").text().trim(),
          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)=>{
            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);
    }
  */
  });
}

//console.log(JSON.stringify(orders));

$.when.apply(null, reqs).done(function () {
  // console.log(orders);
  // console.log(orders.length);
});

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

$('<button/>', {
  text: 'Search',
  id: 'searchBtn',
  click: function () {
    getAllTrackingNumber();
    setTimeout(function () {
      searchOrders();
    }, 5000);
  },
}).appendTo('#appeal-alert');

$('<button/>', {
  text: 'Copy Orders CSV',
  id: 'csvBtn',
  click: function () {
    $('#csvBtn').text('Loading...');
    Promise.all(reqs).then((o) => {
      let s = '';
      items.forEach((e) => {
        s += e.order.order_id + '\t';
        s += e.order.order_time + '\t';
        s += (e.order_product_num == 1 ? e.order.order_amount : '') + '\t';
        s += e.order.order_status + '\t';
        s += e.order.hasTracking + '\t';
        s += e.order.order_tr_num + '\t';
        s += e.order.order_tr_num_2 + '\t';
        s += e.order.order_tr_stat + '\t';
        s += e.order_product_num + '\t';
        s += '"' + e.product_title + '"\t';
        s += '"' + e.product_property + '"\t';
        s += e.product_count + '\t';
        s += e.product_price + '\t';
        s += e.order.product_action + '\t';
        s += e.product_id + '\t';
        s +=
          (typeof e.product_skuid == 'undefined'
            ? ''
            : '"' + e.product_skuid + '"') + '\t';
        s += e.order.store_name + '\t';
        s += 'https:' + e.order.store_url + '\t';
        s += 'https:' + e.product_url + '\t';
        s += '"' + e.product_pic_url + '"\t';
        s += 'https:' + e.product_snapshot + '\t';
        s +=
          'https://trade.aliexpress.com/order_detail.htm?orderId=' +
          e.order.order_id +
          '\t';
        s += '\n';
      });

      GM_setClipboard(s);
      $('#csvBtn').text('Orders on clipboard');
    });
  },
}).appendTo('#appeal-alert');

$('<button/>', {
  text: 'Copy HEADER',
  id: 'headerBtn',
  click: function () {
    $('#headerBtn').text('Copied!');

    Promise.all(reqs).then((o) => {
      let h = '';
      h += 'Order Number\t';
      h += 'Order Date\t';
      h += 'Total Order Amount\t';
      h += 'Order Status\t';
      h += 'Tracking Available\t';
      h += 'Tracking Number\t';
      h += 'Consolidate Tracking Number\t';
      h += 'Tracking Status\t';
      h += 'Item Number of Order\t';
      h += 'Item Title\t';
      h += 'Item Selections\t';
      h += 'Item QTY\t';
      h += 'Item Price\t';
      h += 'Item Actions\t';
      h += 'Item Number\t';
      h += 'SKU\t';
      h += 'Store Name\t';
      h += 'Store URL\t';
      h += 'Item URL\t';
      h += 'Item Picture URL\t';
      h += 'Item Snapshot URL\t';
      h += 'Order Detail URL\t';

      GM_setClipboard(h);

      $('#headerBtn').text('Header copied');
    });
  },
}).appendTo('#appeal-alert');