PTT評價

Re: [問題] 如何把蝦皮過去一年的購買金額、總

看板e-shopping標題Re: [問題] 如何把蝦皮過去一年的購買金額、總作者
tian1997
(蛋蛋)
時間推噓 9 推:9 噓:0 →:0

※ 引述 《qw5526259 (B.K)》 之銘言:
:  
: 在蝦皮商場買了很多東西
: 如何總計
: 過去一年的購買金額呢?
: 找了好久
: 都找不到這個功能
: 該不會要自己一筆一筆的加總吧!
: 如果是這樣
: 真得是很故意
:  

小弟最近用AI做的,可以滿足原PO的需要
我自己測試可以運作,但不知道別人能不能正常使用
有成功的再留言分享一下

教學,照圖片順序按:
先打開蝦皮"購物清單"頁面
1.按F12,選Console(主控台)
2.按禁止標誌
3.在這裡貼上代碼後,按ENTER,不要動等它跑完,買得愈多跑愈久,我自己跑了2分鐘
https://i.imgur.com/8PYlmke.jpeg

實際成果(ptt沒辦法貼emoji,所以實際是純文字)
https://i.imgur.com/MU2SbrT.jpeg

代碼
-------------------------------------------------
(async () => {
console.log("[開始] 自動滾動中,請勿操作滑鼠...");

let lastScroll = 0;
let sameCount = 0;

while (sameCount < 5) {
window.scrollTo(0, document.body.scrollHeight);
await new Promise(r => setTimeout(r, 1500));

const newScroll = document.body.scrollHeight;
if (newScroll === lastScroll) sameCount++;
else sameCount = 0;

lastScroll = newScroll;
}

console.log("[完成] 已滾到底部,開始分析訂單...");

const orderCards = document.querySelectorAll("div.YL_VlX");
console.log("[資料] 抓到訂單數量:", orderCards.length);

let completedOrPendingTotal = 0, completedOrPendingCount = 0;
let refundTotal = 0, refundCount = 0;
let cancelTotal = 0, cancelCount = 0;

// 【追蹤最高金額訂單】變數
let maxCompletedAmount = 0;
let maxCompletedTitle = "";

const COMPLETED_NAME = "已完成/待收貨訂單";
const REFUND_NAME = "退款/退貨訂單";
const CANCEL_NAME = "已取消訂單";

orderCards.forEach((order, index) => {
const text = order.textContent;

let titleText = "";
let fullTitleText = "";
let highestPrice = 0;

// 1. 找到所有單一商品項目區塊
const itemElements = order.querySelectorAll(".mZ1OWk");

itemElements.forEach(item => {
const nameEl = item.querySelector(".DWVWOJ");
const priceEl = item.querySelector(".nW_6Oi");

if (nameEl && priceEl) {
const currentName = nameEl.textContent.trim();
const priceMatch = priceEl.textContent.match(/[\d,]+/);
const currentPrice = priceMatch ? parseInt(priceMatch[0].replace(/,/g, "")) : 0;

if (currentPrice > highestPrice) {
highestPrice = currentPrice;
fullTitleText = currentName;
titleText = currentName;
}
}
});

if (titleText.length > 20) titleText = titleText.slice(0, 20) + "...";

let amountValue = 0;
const totalAmountEl = order.querySelector(".LwXnUQ .t7TQaf");
if (totalAmountEl) {
const match = totalAmountEl.textContent.match(/[\d,]+/);
if (match) amountValue = parseInt(match[0].replace(/,/g, ""));
}

const statusEl = order.querySelector(".bv3eJE");

const cancelIndicator = order.querySelector('[aria-label*="你取消了訂單"]'); if (cancelIndicator || (statusEl && /取消|賣家選擇不接受/.test(statusEl.textContent))) {
cancelCount++;
cancelTotal += amountValue;
const logStatus = (statusEl && /取消/.test(statusEl.textContent)) ? statusEl.textContent : "已取消";
console.log(`[取消] 第 ${index + 1} 筆(${logStatus})→ ${amountValue.toLocaleString()} 元|商品:${titleText}`);
return;
}

const refundTag = order.querySelector(".jCAyGf");
if ((refundTag && /退款|退貨/.test(refundTag.textContent)) || text.includes("退款成功")) {
refundCount++;
refundTotal += amountValue;
console.log(`[退貨] 第 ${index + 1} 筆(退款/退貨)→ ${amountValue.toLocaleString()} 元|商品:${titleText}`);
return;
}

if (statusEl && /已評價|完成|已完成|待收貨/.test(statusEl.textContent)) { completedOrPendingCount++;
completedOrPendingTotal += amountValue;

if (amountValue > maxCompletedAmount) {
maxCompletedAmount = amountValue;
maxCompletedTitle = fullTitleText;
}

const logStatus = statusEl.textContent;
console.log(`[完成] 第 ${index + 1} 筆(${logStatus})→ ${amountValue.toLocaleString()} 元|商品:${titleText}`);
return;
}

console.log(`[未知] 第 ${index + 1} 筆狀態不明|${amountValue.toLocaleString()} 元|商品:${titleText}`);
});

console.log("----------------------------------");
console.log(`[完成] ${COMPLETED_NAME} 筆數:`, completedOrPendingCount);
console.log(`[完成] ${COMPLETED_NAME} 總金額:`, completedOrPendingTotal.toLocaleString(), "元");
console.log("----------------------------------");
console.log(`[退貨] ${REFUND_NAME} 筆數:`, refundCount);
console.log(`[退貨] ${REFUND_NAME} 總金額:`, refundTotal.toLocaleString(), "元");
console.log("----------------------------------");
console.log(`[取消] ${CANCEL_NAME} 筆數:`, cancelCount);
console.log(`[取消] ${CANCEL_NAME} 總金額:`, cancelTotal.toLocaleString(), "元");
console.log("----------------------------------");

if (maxCompletedAmount > 0) {
console.log("[統計] 最大單筆消費");
console.log(`金額: ${maxCompletedAmount.toLocaleString()} 元`);
console.log(`商品: ${maxCompletedTitle}`);
console.log("----------------------------------");
}

let alertMessage =
`[完成] ${COMPLETED_NAME}:${completedOrPendingCount} 筆,總金額 ${completedOrPendingTotal.toLocaleString()} 元\n` +
`[退貨] ${REFUND_NAME}:${refundCount} 筆,總金額 ${refundTotal.toLocaleString()} 元\n` +
`[取消] ${CANCEL_NAME}:${cancelCount} 筆,總金額 ${cancelTotal.toLocaleString()} 元`;

if (maxCompletedAmount > 0) {
alertMessage += `\n\n[統計] 最大單筆消費\n`;
alertMessage += `金額:${maxCompletedAmount.toLocaleString()} 元\n`;
alertMessage += `商品:${maxCompletedTitle}`;
}

alert(alertMessage);
})();

-------------------------------------------------

--

※ PTT 留言評論
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.169.225.105 (臺灣)

※ 文章網址:
https://www.ptt.cc/e-shopping/E.tVN1mEjSlfbA

shokotan 10/18 23:41好棒 有考慮上github上嗎?

我小白不會用那個東西 而且感覺這個代碼應該過沒多久就會失效了哈哈 重點是我到現在還不知道可用性,就怕別人不能用,還沒看到有人分享

tinabjqs 10/19 00:40厲害!

bogooeiu 10/19 10:18推一個

jiaj 10/19 11:36

※ 編輯: tian1997 (39.12.209.125 臺灣), 10/19/2025 17:11:02

mersma 10/19 18:27好厲害

moon999tw 10/20 07:42讚喔 推一個

thelmalin 10/20 09:59

Missprincess 10/20 11:00

wavier 10/21 13:49好強,感謝分享