☰

walmart 绩效快速统计

用在沃尔玛运营时候简化一部分操作用 私人脚本

目前为 2022-03-01 提交的版本。查看 最新版本。

// ==UserScript==
// @name walmart 绩效快速统计
// @namespace http://tampermonkey.net/
// @version 1.1
// @description 用在沃尔玛运营时候简化一部分操作用 私人脚本
// @author w1w
// @match *://seller.walmart.com/partner-analytics/performance/financials*
// @require http://libs.baidu.com/jquery/2.0.0/jquery.min.js
// @icon https://www.google.com/s2/favicons?domain=walmart.com
// @grant none
// @license MIT
// ==/UserScript==
//缝缝补补用三年 简化下沃尔玛后台的运营操作。
window.copy=()=> {
    let transfer = document.createElement('textarea');
    document.body.appendChild(transfer);
    transfer.value = copyData;  // 这里表示想要复制的内容
    transfer.focus();
    transfer.select();
    alert("复制完成");
    if (document.execCommand('copy')) {
        document.execCommand('copy');
    }
    transfer.blur();
    console.log('复制成功');

    document.body.removeChild(transfer);

}


window.todayValue = function() {
    var d = new Date();
    var todayValue = d.getFullYear() + '-' + (d.getMonth() + 1) + '-' + d.getDate();
    return todayValue;
}
window.addZero = function(data) {
    if (data.length < 2) {
        return '0' + data
    } else {
        return data
    }
}

window.id = 'tab' + Date.now();
window.timeIsRight = 1;


var tem =
    ` <form class="newSearch" style="text-align:center;">

    <input type="text" id="nowTime" value=""/>
                            <span>开始时间:</span><input type="text" id="stt" value="2021-10-1"/>
                            <span>结束时间：</span><input type="text" id="ent" value="2021-10-1"/>
                            <!--<input type="button" id='today' value="数据直到今天" />--!>
                            <input type="button" id = 'TDay' value="最近三天" />
                            <input type="button" id = 'SDay' value="最近七天" />
                            <input type="button" id = 'sameDay' value="同一天" />
                            <input type="button" id = 'go' value="开始" />
                        <span>请不要一下子搜索太长时间跨度单次上限100天（不要改系统时区，时间计算会出错的）</span></form>

                        <tab id="` + id + `"><br/></tab>`;

window.templete = `<tr>
            <td class='newT'> Data</td>
            <td class='newT'> ITEM ID</td>
            <td class='newT'> DEPARTMENT</td>
            <td class='newT'> BRAND</td>
            <td class='newT'> GMV</td>
            <td class='newT'> COMMISSION</td>
            <td class='newT'> GMV - COMMISSION</td>
            <td class='newT'> AUR</td>
            <td class='newT'> TOTAL UNITS SOLD</td>
            <td class='newT'> CANCELLED UNITS</td>
            <td class='newT'> CANCELLED SALES</td>
            <td class='newT'> CANCELLED SALES %</td>
            <td class='newT'> CANCELLED UNITS %</td>
            <td class='newT'> ITEM CONVERSION RATE</td>
            <td class='newT'> BASE ITEM ID</td>
            <td class='newT'> SKU</td>
            <td class='newT'> TOTAL PRODUCT VISITS</td>
        </tr>`;

window.getDayilyData = function(dateTime) {
        var getXToken =()=>{
        var r = new RegExp('XSRF-TOKEN=(.*?);')
        var xtoken = document.cookie.match(r)[1].toString();
        console.log(xtoken);
    return xtoken;

    }
    window.tempVal = [];
    let offsetTime = new Date(dateTime);
    offsetTime = offsetTime.getTime() - 86400000 * 1
    offsetTime = new Date(offsetTime)
    offsetTime = offsetTime.getFullYear() + '-' + addZero('' + (offsetTime.getMonth() + 1)) + '-' +
        addZero('' + offsetTime.getDate())

    $.ajax({
        url: 'https://seller.walmart.com/api/aurora/financial/getItemSales',
        type: 'POST',
        async: false,
        contentType: 'application/json',
        dataType: 'json',
        tryCount : 0,
        retryLimit : 5,
        headers: {
            Accept: "application/json",
            'x-xsrf-token': getXToken()

        },
        data: '{"filter":{"filterBy":{"duration":["' + offsetTime + '","' + offsetTime +
        '"],"program":"ALL"},"sortBy":{}},"pagination":{"pageNumber":1,"pageSize":25}}',
        success(e) {
            console.log('seccucs...')
            allDate.push(e['data']);
            tempVal.push(e)
        },
        error (xhr, textStatus, errorThrown ) {
            this.tryCount++;
            if (this.tryCount <= this.retryLimit) {
                //try again
                $.ajax(this);
                return;
            }
        },})
};

window.getDaily = function() {
    window.allDate = [];
    window.tableData = '';
    window.timeList = [];
    let stt = $('#stt').val();
    let ent = $('#ent').val();

    stt = new Date(stt);
    ent = new Date(ent);
    if(stt=="Invalid Date" || ent =="Invalid Date"){
    alert("请输入正确时间格式！");
        timeIsRight = 0;
        return 0
    }
    var stt_T = stt.getTime()
    var ent_T = ent.getTime()
    if (stt_T > ent_T){
        alert("请输入正确时间顺序！");
        timeIsRight = 0;
        return 0
    }else{
        timeIsRight =1 ;
    }

    ent = (ent.getFullYear() + '-' + addZero('' + (ent.getMonth() + 1)) + '-' + addZero('' + ent.getDate()))
    var iii = 100    //单次搜索上限
    let temp = stt.getFullYear() + '-' + addZero('' + (stt.getMonth() + 1)) + '-' + addZero('' + stt.getDate())
    timeList.push(temp)
    if (temp != ent) {
        while (iii > 0) {
            stt_T = 86400000 + stt_T;
            let temDate = new Date(stt_T)
            temp = temDate.getFullYear() + '-' + addZero('' + (temDate.getMonth() + 1)) + '-' + addZero('' + temDate
                                                                                                        .getDate())
            timeList.push(temp)
            if (temp == ent) {
                break
            } else {
                iii--
            }
        }
    }

    return 0
};

window.mainLunch = function() {
    console.log("点击开始运行");
    getDaily();
    if (timeIsRight == 0){
        return 0
    }
    console.log(timeList.length);
    for (var i = 0; i < timeList.length; i++) {
        getDayilyData(timeList[i])
    };
    formatTable();
    clearTable();
    insertTable();
    setTimeout(copy,2333);
};
window.clearTable = function() {
    if ($('#' + id).children().length > 1) {
        $('#' + id).children()[0].remove();
    }

}

window.insertTable = function() {
    window.allTable = window.templete + window.tableData;
    window.div_tab = document.createElement('table');

    div_tab.innerHTML = allTable
    $('#' + id).children()[0].before(div_tab);
    $('#' + id).children()[0].style.fontSize = '6px';
    $('#' + id).children()[0].style.border = '1px solid';
    $('#' + id).children()[0].style.textAlign = 'center';
};

window.formatTable = function() {
    window.copyData="";
    for (var i = 0; i < allDate.length; i++) {
        let temp = allDate[i]
        if (temp == []) {
            continue
        } else {
            for (var ii = 0; ii < temp.length; ii++) {
                var tempDate = temp[ii]
                window.copyData+= (timeList[i] +"\t"+
 tempDate['catlgItemId'] +"\t"+
 tempDate['department'] +"\t"+
 tempDate['brandName'] +"\t"+
 tempDate['TotalGMV'] +"\t"+
 tempDate['TotalCommissions'] +"\t"+
 (tempDate['TotalGMV'] - tempDate['TotalCommissions']) +"\t"+
 tempDate['AuthAUR'] +"\t"+
 tempDate['TotalUnits'] +"\t"+
 tempDate['TotalCancelUnits'] +"\t"+
 tempDate['TotalCancelAmt'] +"\t"+
 (tempDate['TotalCancelAmt'] / tempDate['TotalAuthAmt']) +"\t"+
 (tempDate['TotalCancelUnits'] / tempDate['TotalAuthUnits']) +"\t"+
 tempDate['Conversion'] +"\t"+
 tempDate['baseItemId'] +"\t"+
 tempDate['skuId'] +"\t"+
 tempDate['TotalProductVisits'] +"\r\n")








                window.tableData = window.tableData +
                    "<tr><td class= 'newT'>" + timeList[i] +
                    "</td><td class= 'newT'>" + tempDate['catlgItemId'] +
                    "</td><td class= 'newT'>" + tempDate['department'] +
                    "</td><td class= 'newT'>" + tempDate['brandName'] +
                    "</td><td class= 'newT'>" + tempDate['TotalGMV'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCommissions'] +
                    "</td><td class= 'newT'>" + (tempDate['TotalGMV'] - tempDate['TotalCommissions']) +
                    "</td><td class= 'newT'>" + tempDate['AuthAUR'] +
                    "</td><td class= 'newT'>" + tempDate['TotalUnits'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCancelUnits'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCancelAmt'] +
                    "</td><td class= 'newT'>" + (tempDate['TotalCancelAmt'] / tempDate['TotalAuthAmt']) +
                    "</td><td class= 'newT'>" + (tempDate['TotalCancelUnits'] / tempDate['TotalAuthUnits']) +
                    "</td><td class= 'newT'>" + tempDate['Conversion'] +
                    "</td><td class= 'newT'>" + tempDate['baseItemId'] +
                    "</td><td class= 'newT'>" + tempDate['skuId'] +
                    "</td><td class= 'newT'>" + tempDate['TotalProductVisits'] +
                    "</td></tr>";
            }
        }
    }
};



$().ready(function() {
    let date =new Date();
    date = date.getTime()
    let div_section = document.createElement('section')
    let tempDate;
    div_section.innerHTML = tem
    setTimeout(()=>{document.querySelector("#subapp-main-0 > div > div:nth-child(1) > div > div:nth-child(3) > div").before(div_section)
//document.querySelector("span[text='Performance']").before(div_section)

    tempDate = date-86400000*5;
        tempDate = new Date(tempDate);
    $("#ent").val(todayValue());
    $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
    $("#sameDay").bind('click', function() {
        $("#ent").val($("#stt").val());
    });
    $("#TDay").bind('click', function() {
        $("#ent").val(todayValue());

        tempDate = date-86400000*3;
        tempDate = new Date(tempDate);

        $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
    });
    $("#SDay").bind('click', function() {
        $("#ent").val(todayValue());

        tempDate = date-86400000*7;
        tempDate = new Date(tempDate);
        $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
    });
    $("#go").bind('click', function() {
        mainLunch()
    });
    $("#today").bind('click', function() {
        $("#ent").val(todayValue())
    });
    var nowTime = () => {
        let d = new Date()
        $('#nowTime').val('' + d.getHours() + ':' + addZero('' + d.getMinutes()) + ':' + addZero('' + d
                                                                                                 .getSeconds()))
    }
    setInterval(nowTime, 500)},1500)

})

QingJ © 2025

镜像随时可能失效，请加Q群300939539或关注我们的公众号极客氢云获取最新地址