shujo / ManageInventoryCrawler

// ==UserScript==
// @name         ManageInventoryCrawler
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  consolidate all data found in manage inventory
// @author       shujo
// @match        https://sellercentral.amazon.com/inventory*
// @grant        GM_notification
// @run-at       document-end
// @require      http://code.jquery.com/jquery-3.3.1.min.js
// @license      MIT
// ==/UserScript==

(function() {
    'use strict';
    document.body.onkeyup = function(e){
        if(e.ctrlKey && e.keyCode == 13){ //keyboard shortcut: ctrl key + enter
            let mergeData = manageInventory();
            const els = document.createElement('textarea');
            els.value = mergeData;
            document.body.appendChild(els);
            els.select();
            document.execCommand('copy');
            document.body.removeChild(els)
            GM_notification( { title: "Info", text: "Copied Successfully!", timeout: 2000, image: "https://img.icons8.com/color/50/000000/paste.png" } );
        }
    }
})();

function manageInventory(){
   let data = "SKU\tSTATUS\tSTATUS2\tASIN\tTITLE\tQTY\tFullfilledBy\n";
  document.querySelectorAll("table.a-bordered.a-horizontal-stripes.mt-table > tbody > tr.mt-row").forEach((item)=>{
      let sku = $(item).find('td[data-column="sku"] > div > div[data-column="sku"]').text();
	  let usedStatus = "";
	  let status1 = $(item).find('td[data-column="status"] > div:nth-child(1) > div[data-column="status"] > div > span').text();
	  console.log(status1)
	  if(status1==""){
         usedStatus = $(item).find('td[data-column="status"] > div > div[data-column="status"] > div > a').text();
	  }else{ usedStatus = status1 }
	  let status2 = $(item).find('td[data-column="status"] > div:nth-child(2) > div > div > div').text();
      let asin = $(item).find('td[data-column="title"] > div > div[data-column="asin"]').text();
      let title = $(item).find('td[data-column="title"] > div > div[data-column="title"]').text();
	  let usedQTY = "";
	  let qty = $(item).find('td[data-column="quantity"] > div > div > div > span > input').attr("value");
	  if(qty==undefined){
          usedQTY = $(item).find('td[data-column="quantity"] > div > div > span > div > div > div > a > span').text();
	  }else{
	      usedQTY = qty;
	  }
	  let fullfilledby = $(item).find('td[data-column="fulfillment_channel"] > div > span').text();
      data = data + verifyData(sku) + "\t" + verifyData(usedStatus) + "\t" + verifyData(status2) + "\t" + verifyData(asin) + "\t" + verifyData(title) + "\t" + verifyData(usedQTY) + "\t" + verifyData(fullfilledby) + "\n";
  });
   return data;
}

let verifyData = (data) =>{
	if(data!=undefined){
        return data.replace(/\n|\t|\r|…/g,'').replace(/\s+/g,' ').trim();
	}else{
        return "n/a";
	}
}