Re: [問題] 如何把蝦皮過去一年的購買金額、總
※ 引述 《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.text
Content))) {
cancelCount++;
cancelTotal += amountValue;
const logStatus = (statusEl && /取消/.test(statusEl.textContent)) ? status
El.textContent : "已取消";
console.log(`[取消] 第 ${index + 1} 筆（${logStatus}）→ ${amountValue.toL
ocaleString()} 元｜商品：${titleText}`);
return;
}
const refundTag = order.querySelector(".jCAyGf");
if ((refundTag && /退款|退貨/.test(refundTag.textContent)) || text.includes(
"退款成功")) {
refundCount++;
refundTotal += amountValue;
console.log(`[退貨] 第 ${index + 1} 筆（退款/退貨）→ ${amountValue.toLoca
leString()} 元｜商品：${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.toL
ocaleString()} 元｜商品：${titleText}`);
return;
}
console.log(`[未知] 第 ${index + 1} 筆狀態不明｜${amountValue.toLocaleString
()} 元｜商品：${titleText}`);
});
console.log("----------------------------------");
console.log(`[完成] ${COMPLETED_NAME} 筆數:`, completedOrPendingCount);
console.log(`[完成] ${COMPLETED_NAME} 總金額:`, completedOrPendingTotal.toLoca
leString(), "元");
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} 筆，總金額 ${completed
OrPendingTotal.toLocaleString()} 元\n` +
`[退貨] ${REFUND_NAME}：${refundCount} 筆，總金額 ${refundTotal.toLocaleStri
ng()} 元\n` +
`[取消] ${CANCEL_NAME}：${cancelCount} 筆，總金額 ${cancelTotal.toLocaleStri
ng()} 元`;
if (maxCompletedAmount > 0) {
alertMessage += `\n\n[統計] 最大單筆消費\n`;
alertMessage += `金額：${maxCompletedAmount.toLocaleString()} 元\n`;
alertMessage += `商品：${maxCompletedTitle}`;
}
alert(alertMessage);
})();
-------------------------------------------------
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 118.169.225.105 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/e-shopping/M.1760797751.A.E4E.html
推
10/18 23:41,
5小時前
, 1F
10/18 23:41, 1F
推
10/19 00:40,
4小時前
, 2F
10/19 00:40, 2F
e-shopping 近期熱門文章
PTT消費區 即時熱門文章
