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

[tian1997 (蛋蛋)]

※ 引述 《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
推 shokotan: 好棒 有考慮上github上嗎？
我小白不會用那個東西
而且感覺這個代碼應該過沒多久就會失效了哈哈
重點是我到現在還不知道可用性，就怕別人不能用，還沒看到有人分享
推 tinabjqs: 厲害!
推 bogooeiu: 推一個
推 jiaj: 推
※ 編輯: tian1997 (39.12.209.125 臺灣), 10/19/2025 17:11:02
推 mersma: 好厲害
推 moon999tw: 讚喔 推一個
推 thelmalin: 推
推 Missprincess: 推
推 wavier: 好強，感謝分享
推 yuchi0978: 雲端發票不就可以了
推 hayato1085: 推