{"id":86959,"date":"2026-07-29T14:24:41","date_gmt":"2026-07-29T06:24:41","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/86959.html"},"modified":"2026-07-29T14:24:41","modified_gmt":"2026-07-29T06:24:41","slug":"%e5%bd%b1%e5%88%80rpa%e5%ae%9e%e6%93%8d%e6%8c%87%e5%8d%97%ef%bc%9a%e7%94%b5%e5%95%86%e5%ba%97%e7%be%a4%e6%95%b0%e6%8d%ae%e5%af%b9%e8%b4%a6%e4%b8%8e%e5%ba%93%e5%ad%98%e7%9b%91%e6%8e%a7%e8%87%aa","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/86959.html","title":{"rendered":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf"},"content":{"rendered":"

\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357：\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf<\/h2>\n

\u5e97\u7fa4\u8fd0\u8425\u523010\u4e2a\u5e97\u94fa\u4ee5\u4e0a，\u6700\u75db\u82e6\u7684\u4e8b\u4e0d\u662f\u8fd0\u8425，\u800c\u662f\u5bf9\u8d26\u2014\u2014\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u548c\u94f6\u884c\u6d41\u6c34\u5bf9\u4e0d\u4e0a\u3001\u6dd8\u5b9d\u652f\u4ed8\u5b9d\u8d26\u5355\u5dee\u51e0\u5757\u94b1\u3001TEMU\u7684\u7f8e\u5143\u7ed3\u7b97\u6c47\u7387\u6bcf\u6b21\u90fd\u4e0d\u4e00\u6837\u3002\u6708\u5e95\u624b\u5de5\u5bf9\u8d26\u80fd\u628a\u4eba\u903c\u75af，\u4e00\u7b14\u4e00\u7b14\u6838\u5bf9，\u7a0d\u6709\u758f\u5ffd\u5c31\u662f\u51e0\u767e\u5757\u7684\u5dee\u989d\u3002<\/p>\n

\u81ea\u52a8\u5316\u5bf9\u8d26\u7cfb\u7edf\u662f\u5e97\u7fa4RPA\u7684\u5929\u82b1\u677f\u573a\u666f\u2014\u2014\u6570\u636e\u6e90\u591a\u3001\u903b\u8f91\u590d\u6742\u3001\u5bb9\u9519\u7387\u8981\u6c42\u6781\u9ad8\u3002<\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u8fd9\u5957\u7cfb\u7edf\u6211\u8fed\u4ee3\u4e86\u4e09\u4e2a\u7248\u672c\u3002\u7b2c\u4e00\u7248\u53ea\u5bf9\u603b\u989d，\u53d1\u73b0\u5dee1\u5206\u94b1\u90fd\u8981\u4eba\u5de5\u67e5；\u7b2c\u4e8c\u7248\u505a\u4e86\u9010\u7b14\u5339\u914d，\u4f46TEMU\u6c47\u7387\u6ce2\u52a8\u5bfc\u81f4\u5927\u91cf\u8bef\u62a5；\u7b2c\u4e09\u7248\u52a0\u5165\u4e86\u5bb9\u5dee\u673a\u5236\u548c\u6c47\u7387\u81ea\u9002\u5e94，\u8dd1\u4e86\u5927\u534a\u5e74\u96f6\u8bef\u62a5\u3002\u4e0b\u9762\u628a\u5b8c\u6574\u5b9e\u73b0\u62c6\u5f00\u8bb2\u3002<\/p>\n

\u7cfb\u7edf\u67b6\u6784\u603b\u89c8<\/h3>\n

\u5bf9\u8d26\u7cfb\u7edf\u6d89\u53ca\u7684\u6570\u636e\u6e90\u6700\u591a\u3001\u683c\u5f0f\u6700\u6742，\u9700\u8981\u5148\u7406\u6e05\u67b6\u6784：<\/p>\n

\u6570\u636e\u91c7\u96c6\u5c42（\u5f71\u5200RPA\u81ea\u52a8\u6267\u884c）
\n\u251c\u2500\u2500 \u62fc\u591a\u591a\u7ed3\u7b97\u5355 \u2192 \u5bfc\u51faExcel（\u5546\u5bb6\u540e\u53f0\u2192\u8d44\u91d1\u4e2d\u5fc3\u2192\u7ed3\u7b97\u8bb0\u5f55）
\n\u251c\u2500\u2500 \u6dd8\u5b9d\u652f\u4ed8\u5b9d\u8d26\u5355 \u2192 \u5bfc\u51faCSV（\u652f\u4ed8\u5b9d\u5546\u5bb6\u4e2d\u5fc3\u2192\u4ea4\u6613\u8bb0\u5f55）
\n\u251c\u2500\u2500 TEMU\u7ed3\u7b97\u62a5\u8868 \u2192 \u5bfc\u51faCSV（TEMU\u2192Finance\u2192Settlement Report）
\n\u2514\u2500\u2500 \u94f6\u884c\u6d41\u6c34 \u2192 \u4e0b\u8f7dPDF\/CSV（\u7f51\u94f6\u81ea\u52a8\u4e0b\u8f7d）<\/p>\n

\u6570\u636e\u6e05\u6d17\u5c42（Python Pandas）
\n\u251c\u2500\u2500 \u683c\u5f0f\u6807\u51c6\u5316 \u2192 \u7edf\u4e00\u65e5\u671f\/\u91d1\u989d\/\u8ba2\u5355\u53f7\u683c\u5f0f
\n\u251c\u2500\u2500 \u6c47\u7387\u6362\u7b97 \u2192 TEMU\u7f8e\u5143\u2192\u4eba\u6c11\u5e01
\n\u251c\u2500\u2500 \u8d39\u7528\u5206\u7c7b \u2192 \u5e7f\u544a\u8d39\/\u7269\u6d41\u8d39\/\u5e73\u53f0\u4f63\u91d1\/\u9000\u6b3e
\n\u2514\u2500\u2500 \u6570\u636e\u6821\u9a8c \u2192 \u68c0\u67e5\u5fc5\u586b\u5b57\u6bb5\u548c\u91d1\u989d\u5408\u7406\u6027<\/p>\n

![\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0](https:\/\/i-blog.csdnimg.cn\/direct\/15e22ee0c7da45428fbc88a1944f412b.png#pic_center)<\/p>\n

\u5bf9\u8d26\u5f15\u64ce\u5c42（\u6838\u5fc3\u903b\u8f91）
\n\u251c\u2500\u2500 \u9010\u7b14\u5339\u914d \u2192 \u5e73\u53f0\u8ba2\u5355 vs \u94f6\u884c\u6d41\u6c34
\n\u251c\u2500\u2500 \u5dee\u989d\u5206\u6790 \u2192 \u624b\u7eed\u8d39\/\u6c47\u7387\u5dee\/\u9000\u6b3e\/\u5e73\u53f0\u6263\u8d39
\n\u251c\u2500\u2500 \u5bb9\u5dee\u5904\u7406 \u2192 \u8bbe\u5b9a\u53ef\u63a5\u53d7\u8bef\u5dee\u9608\u503c
\n\u2514\u2500\u2500 \u5f02\u5e38\u6807\u8bb0 \u2192 \u65e0\u6cd5\u5339\u914d\u7684\u6761\u76ee\u6807\u8bb0\u4e3a\u5f85\u67e5<\/p>\n

\u8f93\u51fa\u5c42
\n\u251c\u2500\u2500 \u5bf9\u8d26\u62a5\u544aExcel \u2192 \u542b\u5dee\u5f02\u660e\u7ec6\u548c\u539f\u56e0\u5206\u6790
\n\u251c\u2500\u2500 \u98de\u4e66\u901a\u77e5 \u2192 \u5f02\u5e38\u6761\u76ee\u81ea\u52a8\u63a8\u9001
\n\u2514\u2500\u2500 MySQL\u5f52\u6863 \u2192 \u5386\u53f2\u5bf9\u8d26\u6570\u636e\u7559\u5b58<\/p>\n

\u6570\u636e\u91c7\u96c6\u5c42\u7684\u5b9e\u73b0<\/h3>\n

\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u5bfc\u51fa<\/h4>\n

\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u5728\u300c\u8d44\u91d1\u4e2d\u5fc3\u300d\u6a21\u5757\u3002\u5f71\u5200RPA\u64cd\u4f5c\u6d41\u7a0b：<\/p>\n<\/p>\n

\u62fc\u591a\u591a\u5e97\u7fa4\u81ea\u52a8\u5316\u4e0a\u67b6\u65b9\u6848<\/p>\n<\/p>\n

[\u6253\u5f00\u7f51\u9875] \u2192 \u62fc\u591a\u591a\u5546\u5bb6\u540e\u53f0（\u72ec\u7acb\u7a97\u53e3+\u7528\u6237\u6570\u636e\u76ee\u5f55）
\n[\u7b49\u5f85\u7f51\u9875\u5143\u7d20\u51fa\u73b0] \u2192 \u5bfc\u822a\u680f\u300c\u8d44\u91d1\u4e2d\u5fc3\u300d（\u786e\u8ba4\u767b\u5f55\u6210\u529f）
\n[\u70b9\u51fb\u7f51\u9875\u5143\u7d20] \u2192 \u300c\u8d44\u91d1\u4e2d\u5fc3\u300d
\n[\u7b49\u5f85\u7f51\u9875\u5143\u7d20\u51fa\u73b0] \u2192 \u5de6\u4fa7\u83dc\u5355\u300c\u7ed3\u7b97\u8bb0\u5f55\u300d
\n[\u70b9\u51fb\u7f51\u9875\u5143\u7d20] \u2192 \u300c\u7ed3\u7b97\u8bb0\u5f55\u300d<\/p>\n

# \u9009\u62e9\u65e5\u671f\u8303\u56f4
\n![\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0](https:\/\/i-blog.csdnimg.cn\/direct\/68d2e6e6726949a0a0ab68ac06a4ccba.png#pic_center)<\/p>\n

[\u70b9\u51fb\u7f51\u9875\u5143\u7d20] \u2192 \u65e5\u671f\u9009\u62e9\u5668 \u2192 \u9009\u62e9\u300c\u4e0a\u6708\u300d
\n# \u5bfc\u51fa
\n[\u70b9\u51fb\u7f51\u9875\u5143\u7d20] \u2192 \u300c\u5bfc\u51fa\u62a5\u8868\u300d\u6309\u94ae
\n[\u7b49\u5f85\u6587\u4ef6\u4e0b\u8f7d\u5b8c\u6210] \u2192 \u68c0\u6d4b\u4e0b\u8f7d\u76ee\u5f55\u51fa\u73b0\u65b0xlsx\u6587\u4ef6<\/p>\n

\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u7684\u5173\u952e\u5b57\u6bb5：<\/p>\n

# \u7ed3\u7b97\u5355\u5b57\u6bb5\u6620\u5c04<\/span>
\npdd_settlement_cols =<\/span> {<\/span>
\n '\u7ed3\u7b97\u65e5\u671f'<\/span>:<\/span> 'settlement_date'<\/span>,<\/span> # \u683c\u5f0f: 2026-06-25<\/span>
\n '\u8ba2\u5355\u7f16\u53f7'<\/span>:<\/span> 'order_no'<\/span>,<\/span> # \u62fc\u591a\u591a\u8ba2\u5355\u53f7（19\u4f4d）<\/span>
\n '\u5546\u54c1\u540d\u79f0'<\/span>:<\/span> 'product_name'<\/span>,<\/span> # \u7528\u4e8e\u6838\u5bf9\u5546\u54c1<\/span>
\n '\u6210\u4ea4\u91d1\u989d'<\/span>:<\/span> 'order_amount'<\/span>,<\/span> # \u7528\u6237\u652f\u4ed8\u91d1\u989d<\/span>
\n '\u5e73\u53f0\u4f63\u91d1'<\/span>:<\/span> 'platform_fee'<\/span>,<\/span> # \u62fc\u591a\u591a\u62bd\u6210<\/span>
\n '\u6280\u672f\u670d\u52a1\u8d39'<\/span>:<\/span> 'tech_fee'<\/span>,<\/span> # \u6280\u672f\u670d\u52a1\u8d39<\/span>
\n '\u5b9e\u9645\u7ed3\u7b97'<\/span>:<\/span> 'settlement_amount'<\/span>,<\/span> # \u5b9e\u9645\u5230\u8d26\u91d1\u989d<\/span>
\n '\u7ed3\u7b97\u72b6\u6001'<\/span>:<\/span> 'settlement_status'<\/span> # \u5df2\u7ed3\u7b97\/\u5f85\u7ed3\u7b97<\/span>
\n}<\/span><\/p>\n

\u94f6\u884c\u6d41\u6c34\u81ea\u52a8\u4e0b\u8f7d<\/h4>\n

\u94f6\u884c\u6d41\u6c34\u4e0b\u8f7d\u662f\u81ea\u52a8\u5316\u5bf9\u8d26\u4e2d\u6700\u590d\u6742\u7684\u4e00\u73af\u2014\u2014\u6bcf\u5bb6\u94f6\u884c\u7684\u7f51\u94f6\u7cfb\u7edf\u90fd\u4e0d\u540c，\u800c\u4e14\u5927\u90e8\u5206\u8981\u6c42U\u76fe\u9a8c\u8bc1\u3002\u76ee\u524d\u6709\u4e24\u79cd\u53ef\u884c\u65b9\u6848：<\/p>\n

\u65b9\u6848\u4e00：\u624b\u52a8\u5bfc\u51fa\u540e\u5f71\u5200RPA\u81ea\u52a8\u8bfb\u53d6（\u63a8\u8350，\u5b89\u5168\u53ef\u63a7）<\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u65b9\u6848\u4e8c：\u4f7f\u7528\u94f6\u884c\u63d0\u4f9b\u7684\u4f01\u4e1aAPI（\u9700\u8981\u5bf9\u63a5\u94f6\u884c\u5f00\u653e\u5e73\u53f0，\u95e8\u69db\u8f83\u9ad8）<\/p>\n

\u5b9e\u9645\u64cd\u4f5c\u4e2d，\u65b9\u6848\u4e00\u662f\u4e3b\u6d41：<\/p>\n

# \u94f6\u884c\u6d41\u6c34\u8bfb\u53d6\u5b50\u6d41\u7a0b
\n[\u6253\u5f00Excel] \u2192 \u94f6\u884c\u5bfc\u51fa\u7684\u6d41\u6c34\u6587\u4ef6
\n[\u8bfb\u53d6Excel\u533a\u57df] \u2192 \u8bfb\u53d6\u6240\u6709\u884c
\n[\u5faa\u73af] \u904d\u5386\u6bcf\u4e00\u884c:
\n \u251c\u2500\u2500 \u63d0\u53d6: \u65e5\u671f\u3001\u91d1\u989d\u3001\u5bf9\u65b9\u6237\u540d\u3001\u6458\u8981
\n \u251c\u2500\u2500 \u5206\u7c7b:
\n \u2502 \u251c\u2500\u2500 \u5bf9\u65b9\u6237\u540d\u542b\u300c\u62fc\u591a\u591a\u300d\u2192 \u6807\u8bb0\u4e3a\u62fc\u591a\u591a\u7ed3\u7b97
\n \u2502 \u251c\u2500\u2500 \u5bf9\u65b9\u6237\u540d\u542b\u300c\u652f\u4ed8\u5b9d\u300d\u2192 \u6807\u8bb0\u4e3a\u6dd8\u5b9d\u7ed3\u7b97
\n \u2502 \u2514\u2500\u2500 \u5176\u4ed6 \u2192 \u6807\u8bb0\u4e3a\u5176\u4ed6\u6536\u652f
\n \u2514\u2500\u2500 [\u5199\u5165\u53d8\u91cf] \u2192 bank_transactions\u5217\u8868<\/p>\n

\u5bf9\u8d26\u5f15\u64ce\u7684\u6838\u5fc3\u903b\u8f91<\/h3>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u8fd9\u662f\u6574\u4e2a\u7cfb\u7edf\u7684\u7075\u9b42\u3002\u5bf9\u8d26\u5f15\u64ce\u8981\u5904\u7406\u4e09\u79cd\u5339\u914d\u573a\u666f：\u7cbe\u786e\u5339\u914d\u3001\u6a21\u7cca\u5339\u914d\u3001\u65e0\u6cd5\u5339\u914d\u3002<\/p>\n

# \u5bf9\u8d26\u5f15\u64ce\u6838\u5fc3\u903b\u8f91<\/span>
\nimport<\/span> pandas as<\/span> pd
\nfrom<\/span> datetime import<\/span> datetime,<\/span> timedelta<\/p>\n

# ==================== 1. \u6570\u636e\u51c6\u5907 ====================<\/span><\/p>\n

# \u8bfb\u53d6\u5e73\u53f0\u7ed3\u7b97\u6570\u636e<\/span>
\npdd =<\/span> pd.<\/span>read_excel(<\/span>r"C:\\\\RPA_Data\\\\\u5bf9\u8d26\\\\\u62fc\u591a\u591a\u7ed3\u7b97_202606.xlsx"<\/span>)<\/span>
\ntb =<\/span> pd.<\/span>read_csv(<\/span>r"C:\\\\RPA_Data\\\\\u5bf9\u8d26\\\\\u652f\u4ed8\u5b9d\u8d26\u5355_202606.csv"<\/span>,<\/span> encoding=<\/span>'gbk'<\/span>)<\/span>
\ntemu =<\/span> pd.<\/span>read_csv(<\/span>r"C:\\\\RPA_Data\\\\\u5bf9\u8d26\\\\TEMU_Settlement_202606.csv"<\/span>)<\/span><\/p>\n

# \u8bfb\u53d6\u94f6\u884c\u6d41\u6c34<\/span>
\nbank =<\/span> pd.<\/span>read_excel(<\/span>r"C:\\\\RPA_Data\\\\\u5bf9\u8d26\\\\\u94f6\u884c\u6d41\u6c34_202606.xlsx"<\/span>)<\/span><\/p>\n

# ==================== 2. \u6570\u636e\u6807\u51c6\u5316 ====================<\/span><\/p>\n

# \u7edf\u4e00\u65e5\u671f\u683c\u5f0f<\/span>
\npdd[<\/span>'date'<\/span>]<\/span> =<\/span> pd.<\/span>to_datetime(<\/span>pdd[<\/span>'\u7ed3\u7b97\u65e5\u671f'<\/span>]<\/span>)<\/span>
\ntb[<\/span>'date'<\/span>]<\/span> =<\/span> pd.<\/span>to_datetime(<\/span>tb[<\/span>'\u4ea4\u6613\u65f6\u95f4'<\/span>]<\/span>)<\/span>
\ntemu[<\/span>'date'<\/span>]<\/span> =<\/span> pd.<\/span>to_datetime(<\/span>temu[<\/span>'Settlement Date'<\/span>]<\/span>)<\/span>
\nbank[<\/span>'date'<\/span>]<\/span> =<\/span> pd.<\/span>to_datetime(<\/span>bank[<\/span>'\u4ea4\u6613\u65e5\u671f'<\/span>]<\/span>)<\/span><\/p>\n

# TEMU\u6c47\u7387\u6362\u7b97（\u4f7f\u7528\u5f53\u6708\u5e73\u5747\u6c47\u7387）<\/span>
\navg_rate =<\/span> 7.23<\/span> # \u5f53\u6708\u5e73\u5747\u6c47\u7387<\/span>
\ntemu[<\/span>'amount_cny'<\/span>]<\/span> =<\/span> round<\/span>(<\/span>temu[<\/span>'Settlement Amount'<\/span>]<\/span> *<\/span> avg_rate,<\/span> 2<\/span>)<\/span><\/p>\n

# \u7edf\u4e00\u91d1\u989d\u5b57\u6bb5<\/span>
\npdd[<\/span>'amount'<\/span>]<\/span> =<\/span> pdd[<\/span>'\u5b9e\u9645\u7ed3\u7b97'<\/span>]<\/span>
\ntb[<\/span>'amount'<\/span>]<\/span> =<\/span> tb[<\/span>'\u6536\u5165\u91d1\u989d'<\/span>]<\/span> –<\/span> tb[<\/span>'\u652f\u51fa\u91d1\u989d'<\/span>]<\/span> # \u51c0\u6536\u5165<\/span>
\ntemu[<\/span>'amount'<\/span>]<\/span> =<\/span> temu[<\/span>'amount_cny'<\/span>]<\/span><\/p>\n

# ==================== 3. \u9010\u7b14\u5339\u914d ====================<\/span><\/p>\n

matched =<\/span> [<\/span>]<\/span> # \u5df2\u5339\u914d\u8bb0\u5f55<\/span>
\nunmatched_bank =<\/span> [<\/span>]<\/span> # \u94f6\u884c\u6d41\u6c34\u672a\u5339\u914d<\/span>
\nunmatched_platform =<\/span> [<\/span>]<\/span> # \u5e73\u53f0\u6570\u636e\u672a\u5339\u914d<\/span><\/p>\n

# \u5bb9\u5dee\u9608\u503c（\u5143）<\/span>
\nAMOUNT_TOLERANCE =<\/span> 0.05<\/span> # \u5141\u8bb85\u5206\u94b1\u7684\u5dee\u989d<\/span>
\nDATE_TOLERANCE =<\/span> 2<\/span> # \u5141\u8bb8\u00b12\u5929\u7684\u65e5\u671f\u504f\u5dee<\/span><\/p>\n

for<\/span> _,<\/span> tx in<\/span> bank.<\/span>iterrows(<\/span>)<\/span>:<\/span>
\n found =<\/span> False<\/span><\/p>\n

# \u7b2c\u4e00\u8f6e：\u7cbe\u786e\u5339\u914d（\u91d1\u989d\u5b8c\u5168\u76f8\u7b49+\u65e5\u671f\u4e00\u81f4）<\/span>
\n for<\/span> platform_data in<\/span> [<\/span>pdd,<\/span> tb,<\/span> temu]<\/span>:<\/span>
\n match<\/span> =<\/span> platform_data[<\/span>
\n (<\/span>platform_data[<\/span>'amount'<\/span>]<\/span> ==<\/span> tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span>)<\/span> &<\/span>
\n (<\/span>abs<\/span>(<\/span>(<\/span>platform_data[<\/span>'date'<\/span>]<\/span> –<\/span> tx[<\/span>'date'<\/span>]<\/span>)<\/span>.<\/span>days)<\/span> <=<\/span> 0<\/span>)<\/span>
\n ]<\/span>
\n if<\/span> len<\/span>(<\/span>match<\/span>)<\/span> ><\/span> 0<\/span>:<\/span>
\n matched.<\/span>append(<\/span>{<\/span>
\n '\u94f6\u884c\u65e5\u671f'<\/span>:<\/span> tx[<\/span>'date'<\/span>]<\/span>,<\/span>
\n '\u94f6\u884c\u91d1\u989d'<\/span>:<\/span> tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span>,<\/span>
\n '\u5e73\u53f0'<\/span>:<\/span> match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>.<\/span>get(<\/span>'\u5e73\u53f0'<\/span>,<\/span> ''<\/span>)<\/span>,<\/span>
\n '\u5e73\u53f0\u91d1\u989d'<\/span>:<\/span> match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>[<\/span>'amount'<\/span>]<\/span>,<\/span>
\n '\u5339\u914d\u65b9\u5f0f'<\/span>:<\/span> '\u7cbe\u786e\u5339\u914d'<\/span>,<\/span>
\n '\u5dee\u989d'<\/span>:<\/span> 0<\/span>
\n }<\/span>)<\/span>
\n found =<\/span> True<\/span>
\n break<\/span><\/p>\n

if<\/span> not<\/span> found:<\/span>
\n # \u7b2c\u4e8c\u8f6e：\u6a21\u7cca\u5339\u914d（\u91d1\u989d\u5dee\u2264\u5bb9\u5dee + \u65e5\u671f\u5dee\u22642\u5929）<\/span>
\n for<\/span> platform_data in<\/span> [<\/span>pdd,<\/span> tb,<\/span> temu]<\/span>:<\/span>
\n match<\/span> =<\/span> platform_data[<\/span>
\n (<\/span>abs<\/span>(<\/span>platform_data[<\/span>'amount'<\/span>]<\/span> –<\/span> tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span>)<\/span> <=<\/span> AMOUNT_TOLERANCE)<\/span> &<\/span>
\n (<\/span>abs<\/span>(<\/span>(<\/span>platform_data[<\/span>'date'<\/span>]<\/span> –<\/span> tx[<\/span>'date'<\/span>]<\/span>)<\/span>.<\/span>days)<\/span> <=<\/span> DATE_TOLERANCE)<\/span>
\n ]<\/span>
\n if<\/span> len<\/span>(<\/span>match<\/span>)<\/span> ><\/span> 0<\/span>:<\/span>
\n diff =<\/span> round<\/span>(<\/span>tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span> –<\/span> match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>[<\/span>'amount'<\/span>]<\/span>,<\/span> 2<\/span>)<\/span>
\n matched.<\/span>append(<\/span>{<\/span>
\n '\u94f6\u884c\u65e5\u671f'<\/span>:<\/span> tx[<\/span>'date'<\/span>]<\/span>,<\/span>
\n '\u94f6\u884c\u91d1\u989d'<\/span>:<\/span> tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span>,<\/span>
\n '\u5e73\u53f0'<\/span>:<\/span> match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>.<\/span>get(<\/span>'\u5e73\u53f0'<\/span>,<\/span> ''<\/span>)<\/span>,<\/span>
\n '\u5e73\u53f0\u91d1\u989d'<\/span>:<\/span> match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>[<\/span>'amount'<\/span>]<\/span>,<\/span>
\n '\u5339\u914d\u65b9\u5f0f'<\/span>:<\/span> f'\u6a21\u7cca\u5339\u914d(\u65e5\u671f\u5dee<\/span>{<\/span>abs<\/span>(<\/span>(<\/span>match<\/span>.<\/span>iloc[<\/span>0<\/span>]<\/span>[<\/span>"date"<\/span>]<\/span>–<\/span>tx[<\/span>"date"<\/span>]<\/span>)<\/span>.<\/span>days)<\/span>}<\/span><\/span>\u5929)'<\/span><\/span>,<\/span>
\n '\u5dee\u989d'<\/span>:<\/span> diff
\n }<\/span>)<\/span>
\n found =<\/span> True<\/span>
\n break<\/span><\/p>\n

if<\/span> not<\/span> found:<\/span>
\n unmatched_bank.<\/span>append(<\/span>tx)<\/span>
\n print<\/span>(<\/span>f"\u672a\u5339\u914d\u94f6\u884c\u6d41\u6c34: <\/span>{<\/span>tx[<\/span>'date'<\/span>]<\/span>}<\/span><\/span> | <\/span>{<\/span>tx[<\/span>'\u4ea4\u6613\u91d1\u989d'<\/span>]<\/span>}<\/span><\/span> | <\/span>{<\/span>tx[<\/span>'\u5bf9\u65b9\u6237\u540d'<\/span>]<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span><\/p>\n

print<\/span>(<\/span>f"\\\\n\u5bf9\u8d26\u5b8c\u6210!"<\/span><\/span>)<\/span>
\nprint<\/span>(<\/span>f"\u7cbe\u786e\u5339\u914d: <\/span>{<\/span>sum<\/span>(<\/span>1<\/span> for<\/span> m in<\/span> matched if<\/span> m[<\/span>'\u5339\u914d\u65b9\u5f0f'<\/span>]<\/span>==<\/span>'\u7cbe\u786e\u5339\u914d'<\/span>)<\/span>}<\/span><\/span> \u7b14"<\/span><\/span>)<\/span>
\nprint<\/span>(<\/span>f"\u6a21\u7cca\u5339\u914d: <\/span>{<\/span>sum<\/span>(<\/span>1<\/span> for<\/span> m in<\/span> matched if<\/span> '\u6a21\u7cca'<\/span> in<\/span> m[<\/span>'\u5339\u914d\u65b9\u5f0f'<\/span>]<\/span>)<\/span>}<\/span><\/span> \u7b14"<\/span><\/span>)<\/span>
\nprint<\/span>(<\/span>f"\u94f6\u884c\u672a\u5339\u914d: <\/span>{<\/span>len<\/span>(<\/span>unmatched_bank)<\/span>}<\/span><\/span> \u7b14"<\/span><\/span>)<\/span>
\nprint<\/span>(<\/span>f"\u5e73\u53f0\u672a\u5339\u914d: <\/span>{<\/span>len<\/span>(<\/span>unmatched_platform)<\/span>}<\/span><\/span> \u7b14"<\/span><\/span>)<\/span><\/p>\n

\u5dee\u989d\u5206\u6790\u4e0e\u81ea\u52a8\u5206\u7c7b<\/h3>\n

\u5339\u914d\u540e\u8ba1\u7b97\u51fa\u5dee\u989d，\u81ea\u52a8\u5206\u6790\u539f\u56e0：<\/p>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

# \u5dee\u989d\u539f\u56e0\u81ea\u52a8\u5206\u6790<\/span>
\ndef<\/span> analyze_difference<\/span>(<\/span>diff,<\/span> platform_type,<\/span> tx_desc)<\/span>:<\/span>
\n """\u6839\u636e\u5dee\u989d\u5927\u5c0f\u548c\u4ea4\u6613\u7c7b\u578b\u5206\u6790\u539f\u56e0"""<\/span><\/p>\n

if<\/span> abs<\/span>(<\/span>diff)<\/span> <<\/span> 0.01<\/span>:<\/span>
\n return<\/span> "\u65e0\u5dee\u5f02"<\/span><\/p>\n

# \u62fc\u591a\u591a\u5e38\u89c1\u5dee\u989d\u539f\u56e0<\/span>
\n if<\/span> platform_type ==<\/span> '\u62fc\u591a\u591a'<\/span>:<\/span>
\n if<\/span> diff ><\/span> 0<\/span> and<\/span> diff <<\/span> 0.5<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u82b1\u5457\u5206\u671f\u624b\u7eed\u8d39"<\/span> # \u82b1\u5457\u5206\u671f\u8d39\u7528\u901a\u5e38\u51e0\u6bdb\u94b1<\/span>
\n elif<\/span> abs<\/span>(<\/span>diff –<\/span> round<\/span>(<\/span>tx_amount *<\/span> 0.006<\/span>,<\/span> 2<\/span>)<\/span>)<\/span> <<\/span> 0.01<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u4fe1\u7528\u5361\u652f\u4ed8\u624b\u7eed\u8d39(0.6%)"<\/span><\/p>\n

# TEMU\u5e38\u89c1\u5dee\u989d\u539f\u56e0<\/span>
\n if<\/span> platform_type ==<\/span> 'TEMU'<\/span>:<\/span>
\n if<\/span> abs<\/span>(<\/span>diff)<\/span> <<\/span> abs<\/span>(<\/span>tx_amount *<\/span> 0.02<\/span>)<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u6c47\u7387\u6ce2\u52a8（\u4f7f\u7528\u5f53\u6708\u5747\u4ef7，\u4e0e\u5b9e\u9645\u7ed3\u7b97\u6c47\u7387\u6709\u504f\u5dee）"<\/span><\/p>\n

# \u901a\u7528\u5dee\u989d\u539f\u56e0<\/span>
\n if<\/span> abs<\/span>(<\/span>diff)<\/span> <<\/span> 0.10<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u94f6\u884c\u624b\u7eed\u8d39\/\u56db\u820d\u4e94\u5165\u5dee\u5f02"<\/span>
\n elif<\/span> diff <<\/span> 0<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u5e73\u53f0\u6263\u8d39（\u5e7f\u544a\u8d39\/\u6280\u672f\u670d\u52a1\u8d39\u6263\u9664\u3001\u9000\u6b3e\u7b49）"<\/span>
\n else<\/span>:<\/span>
\n return<\/span> "\u53ef\u80fd\u539f\u56e0: \u56de\u6b3e（\u8de8\u6708\u7ed3\u7b97\/\u591a\u7b14\u5408\u5e76\u6253\u6b3e）"<\/span><\/p>\n

\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316<\/h3>\n

\u5bf9\u8d26\u4e4b\u5916，\u5e93\u5b58\u76d1\u63a7\u662f\u5e97\u7fa4\u7ba1\u7406\u7684\u53e6\u4e00\u4e2a\u521a\u9700\u3002\u5546\u54c1\u65ad\u8d27\u4e86\u624d\u53bb\u8865\u8d27，\u4e2d\u95f4\u51e0\u5929\u7684\u9500\u91cf\u76f4\u63a5\u6ca1\u4e86\u3002<\/p>\n

\u5e93\u5b58\u9884\u8b66\u903b\u8f91<\/h4>\n

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

# \u5e93\u5b58\u9884\u8b66\u8ba1\u7b97<\/span>
\nimport<\/span> pandas as<\/span> pd<\/p>\n

# \u8bfb\u53d6\u5404\u5e97\u94fa\u5e93\u5b58\u6570\u636e<\/span>
\ninventory =<\/span> pd.<\/span>read_excel(<\/span>r"C:\\\\RPA_Data\\\\\u5e93\u5b58\u6c47\u603b.xlsx"<\/span>)<\/span><\/p>\n

# \u8ba1\u7b97\u8fd17\u5929\u65e5\u5747\u9500\u91cf<\/span>
\ndaily_avg =<\/span> inventory[<\/span>'\u8fd17\u5929\u9500\u91cf'<\/span>]<\/span> \/<\/span> 7<\/span><\/p>\n

# \u9884\u4f30\u53ef\u552e\u5929\u6570<\/span>
\ninventory[<\/span>'\u53ef\u552e\u5929\u6570'<\/span>]<\/span> =<\/span> (<\/span>inventory[<\/span>'\u5f53\u524d\u5e93\u5b58'<\/span>]<\/span> \/<\/span> daily_avg)<\/span>.<\/span>round<\/span>(<\/span>1<\/span>)<\/span><\/p>\n

# \u5e93\u5b58\u9884\u8b66\u5206\u7c7b<\/span>
\ndef<\/span> classify_stock<\/span>(<\/span>days,<\/span> is_hot_product)<\/span>:<\/span>
\n if<\/span> days <=<\/span> 3<\/span>:<\/span>
\n return<\/span> "🔴 \u7d27\u6025\u8865\u8d27"<\/span>
\n elif<\/span> days <=<\/span> 7<\/span>:<\/span>
\n return<\/span> "🟡 \u9700\u8981\u8865\u8d27"<\/span>
\n elif<\/span> days <=<\/span> 14<\/span> and<\/span> is_hot_product:<\/span><\/p>\n

[<\/span>video(<\/span>video–<\/span>CuDijZhF–<\/span>1785259125460<\/span>)<\/span>(<\/span>type<\/span>–<\/span>csdn)<\/span>(<\/span>url–<\/span>https:<\/span>\/\/<\/span>live.<\/span>csdn.<\/span>net\/<\/span>v\/<\/span>embed\/<\/span>524993<\/span>)<\/span>(<\/span>image–<\/span>https:<\/span>\/\/<\/span>v–<\/span>blog.<\/span>csdnimg.<\/span>cn\/<\/span>asset\/<\/span>a547123d88ad712dccba346c9217e237\/<\/span>cover\/<\/span>Cover0.<\/span>jpg)<\/span>(<\/span>title–<\/span>TEMU\u5e97\u7fa4\u5982\u4f55\u7ba1\u7406\u8fd0\u8425？)<\/span>]<\/span><\/p>\n

return<\/span> "🟠 \u70ed\u9500\u54c1\u5efa\u8bae\u5907\u8d27"<\/span>
\n else<\/span>:<\/span>
\n return<\/span> "🟢 \u5e93\u5b58\u5145\u8db3"<\/span><\/p>\n

inventory[<\/span>'\u9884\u8b66\u72b6\u6001'<\/span>]<\/span> =<\/span> inventory.<\/span>apply<\/span>(<\/span>
\n lambda<\/span> row:<\/span> classify_stock(<\/span>row[<\/span>'\u53ef\u552e\u5929\u6570'<\/span>]<\/span>,<\/span> row[<\/span>'\u662f\u5426\u70ed\u9500'<\/span>]<\/span>)<\/span>,<\/span>
\n axis=<\/span>1<\/span>
\n)<\/span><\/p>\n

# \u7b5b\u9009\u51fa\u9700\u8981\u8865\u8d27\u7684\u5546\u54c1<\/span>
\nneed_replenish =<\/span> inventory[<\/span>inventory[<\/span>'\u53ef\u552e\u5929\u6570'<\/span>]<\/span> <=<\/span> 7<\/span>]<\/span>
\nprint<\/span>(<\/span>f"\u9700\u8981\u8865\u8d27\u7684\u5546\u54c1\u5171 <\/span>{<\/span>len<\/span>(<\/span>need_replenish)<\/span>}<\/span><\/span> \u4e2a:"<\/span><\/span>)<\/span>
\nprint<\/span>(<\/span>need_replenish[<\/span>[<\/span>'\u5e97\u94fa'<\/span>,<\/span>'\u5546\u54c1\u540d\u79f0'<\/span>,<\/span>'\u5f53\u524d\u5e93\u5b58'<\/span>,<\/span>'\u53ef\u552e\u5929\u6570'<\/span>,<\/span>'\u9884\u8b66\u72b6\u6001'<\/span>]<\/span>]<\/span>)<\/span><\/p>\n

# \u8f93\u51fa\u5230\u98de\u4e66\u63a8\u9001<\/span>
\nflow.<\/span>set_variable(<\/span>"replenish_list"<\/span>,<\/span> need_replenish.<\/span>to_json(<\/span>force_ascii=<\/span>False<\/span>)<\/span>)<\/span><\/p>\n

\u5e93\u5b58\u6570\u636e\u91c7\u96c6<\/h4>\n

\u5f71\u5200RPA\u6bcf\u5929\u5b9a\u65f6\u91c7\u96c6\u5404\u5e73\u53f0\u5e93\u5b58\u6570\u636e：<\/p>\n

[\u5b50\u6d41\u7a0b] \u5e93\u5b58\u6570\u636e\u91c7\u96c6
\n\u251c\u2500\u2500 [\u5faa\u73af] \u904d\u5386\u6240\u6709\u5e97\u94fa
\n\u2502 \u251c\u2500\u2500 [\u6253\u5f00\u7f51\u9875] \u2192 \u5e97\u94fa\u540e\u53f0\u5546\u54c1\u7ba1\u7406\u9875
\n\u2502 \u251c\u2500\u2500 [\u7b49\u5f85\u7f51\u9875\u5143\u7d20\u51fa\u73b0] \u2192 \u5546\u54c1\u5217\u8868\u52a0\u8f7d\u5b8c\u6210
\n\u2502 \u251c\u2500\u2500 [\u7ffb\u9875\u5faa\u73af] \u2192 \u9010\u9875\u91c7\u96c6
\n\u2502 \u2502 \u251c\u2500\u2500 [\u83b7\u53d6\u7f51\u9875\u5143\u7d20\u6587\u672c] \u2192 \u5546\u54c1\u540d\u79f0\/SKU\/\u5e93\u5b58
\n![\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0](https:\/\/i-blog.csdnimg.cn\/direct\/9b3a79ea27ed41a0af4d546bdd0523c2.png#pic_center)<\/p>\n

\u2502 \u2502 \u2514\u2500\u2500 [\u5199\u5165\u4e34\u65f6\u53d8\u91cf]
\n\u2502 \u251c\u2500\u2500 [\u6570\u636e\u5904\u7406] \u2192 \u5408\u5e76\u672c\u5e97\u94fa\u6240\u6709\u5546\u54c1\u6570\u636e
\n\u2502 \u2514\u2500\u2500 [\u5173\u95ed\u7f51\u9875]
\n\u2514\u2500\u2500 [Python\u811a\u672c] \u2192 \u5199\u5165MySQL\u5e93\u5b58\u8868 + \u98de\u4e66Base\u5e93\u5b58\u770b\u677f<\/p>\n

\u5b8c\u6574\u7684\u65e5\u5ea6\u5bf9\u8d26\u6d41\u7a0b\u7f16\u6392<\/h3>\n

\u628a\u91c7\u96c6\u3001\u5bf9\u8d26\u3001\u5e93\u5b58\u6574\u5408\u4e3a\u4e00\u4e2a\u65e5\u5ea6\u81ea\u52a8\u5316\u6d41\u7a0b：<\/p>\n

[\u5b9a\u65f6\u89e6\u53d1] \u6bcf\u5929\u51cc\u66682:00（\u907f\u5f00\u5e73\u53f0\u7ed3\u7b97\u65f6\u6bb5）<\/p>\n

\u9636\u6bb5\u4e00：\u6570\u636e\u91c7\u96c6（\u5e76\u884c3\u4e2a\u7ebf\u7a0b）
\n\u251c\u2500\u2500 \u7ebf\u7a0b1: \u62fc\u591a\u591a\u7ed3\u7b97+\u5e93\u5b58 \u2192 \u9884\u8ba115\u5206\u949f
\n\u251c\u2500\u2500 \u7ebf\u7a0b2: \u6dd8\u5b9d\u7ed3\u7b97+\u5e93\u5b58 \u2192 \u9884\u8ba112\u5206\u949f
\n\u2514\u2500\u2500 \u7ebf\u7a0b3: TEMU\u7ed3\u7b97+\u5e93\u5b58 \u2192 \u9884\u8ba118\u5206\u949f<\/p>\n

\u9636\u6bb5\u4e8c：\u6570\u636e\u6e05\u6d17+\u5bf9\u8d26（\u4e32\u884c）
\n\u251c\u2500\u2500 [Python\u811a\u672c] \u2192 \u6807\u51c6\u5316\u6240\u6709\u5e73\u53f0\u6570\u636e
\n\u251c\u2500\u2500 [Python\u811a\u672c] \u2192 \u6267\u884c\u5bf9\u8d26\u5f15\u64ce
\n\u251c\u2500\u2500 [Python\u811a\u672c] \u2192 \u5dee\u989d\u5206\u6790\u4e0e\u5206\u7c7b
\n\u2514\u2500\u2500 [Python\u811a\u672c] \u2192 \u5e93\u5b58\u9884\u8b66\u8ba1\u7b97<\/p>\n

\u9636\u6bb5\u4e09：\u8f93\u51fa+\u63a8\u9001
\n\u251c\u2500\u2500 [\u5199\u5165Excel] \u2192 \u751f\u6210\u5bf9\u8d26\u62a5\u544a.xlsx
\n\u251c\u2500\u2500 [\u5199\u5165\u98de\u4e66Base] \u2192 \u5bf9\u8d26\u7ed3\u679c+\u5e93\u5b58\u9884\u8b66
\n\u251c\u2500\u2500 [\u98de\u4e66\u6d88\u606f\u63a8\u9001] \u2192 \u5f02\u5e38\u6761\u76ee+\u8865\u8d27\u6e05\u5355
\n\u2514\u2500\u2500 [\u5199\u5165MySQL] \u2192 \u5f52\u6863\u5bf9\u8d26\u6570\u636e<\/p>\n

\u5e38\u89c1\u95ee\u9898\/\u6613\u9519\u901f\u67e5<\/h3>\n\n\u95ee\u9898\u539f\u56e0\u89e3\u51b3<\/tr>\n\n\n\n\n\n
\u5bf9\u8d26\u7ed3\u679c\u603b\u6709\u51e0\u5206\u94b1\u5dee\u5f02<\/td>\n\u94f6\u884c\u56db\u820d\u4e94\u5165\u4e0e\u5e73\u53f0\u8ba1\u7b97\u65b9\u5f0f\u4e0d\u540c<\/td>\n\u8bbe\u5bb9\u5dee\u9608\u503c0.05\u5143，\u2264\u5bb9\u5dee\u4e0d\u89c6\u4e3a\u5f02\u5e38<\/td>\n<\/tr>\n
TEMU\u6c47\u7387\u6ce2\u52a8\u5bfc\u81f4\u5927\u989d\u5dee\u989d<\/td>\n\u7ed3\u7b97\u6c47\u7387\u6bcf\u5929\u90fd\u5728\u53d8<\/td>\n\u6539\u7528\u6bcf\u65e5\u5b9e\u9645\u6c47\u7387（\u8c03\u7528\u6c47\u7387API），\u800c\u975e\u6708\u5747\u4ef7<\/td>\n<\/tr>\n
\u591a\u7b14\u5c0f\u8ba2\u5355\u5408\u5e76\u4e3a\u4e00\u7b14\u6253\u6b3e<\/td>\n\u94f6\u884c\/\u652f\u4ed8\u5e73\u53f0\u5408\u5e76\u7ed3\u7b97<\/td>\n\u589e\u52a0\u300c\u591a\u7b14\u8ba2\u5355\u2192\u5355\u7b14\u6d41\u6c34\u300d\u7684\u53cd\u5411\u5339\u914d\u903b\u8f91<\/td>\n<\/tr>\n
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

| \u5e93\u5b58\u6570\u636e\u91c7\u96c6\u4e0d\u5168 | \u5355\u4e2a\u9875\u9762\u7684\u5546\u54c1\u6570\u88ab\u9650\u5236 | \u786e\u8ba4\u7ffb\u9875\u903b\u8f91\u6b63\u786e，\u68c0\u67e5\u662f\u5426\u6709\u5206\u9875\u53c2\u6570\u6f0f\u9875 | | \u5bf9\u8d26\u62a5\u544a\u6587\u4ef6\u8d8a\u6765\u8d8a\u5927 | \u672a\u6e05\u7406\u5386\u53f2\u6570\u636e | \u8bbe\u5b9a\u4fdd\u7559\u5468\u671f（\u598290\u5929），\u8d85\u671f\u6570\u636e\u5f52\u6863\u5230MySQL |<\/p>\n

\u63a8\u8350\u8d44\u6e90<\/h3>\n
    \n
  • \u5f71\u5200RPA\u300c\u5b50\u6d41\u7a0b\u300d\u548c\u300c\u53d8\u91cf\u4f5c\u7528\u57df\u300d\u7684\u5b98\u65b9\u6587\u6863\u2014\u2014\u590d\u6742\u6d41\u7a0b\u62c6\u5206\u7684\u57fa\u7840<\/li>\n
  • Pandas merge \u548c concat \u6587\u6863\u2014\u2014\u5bf9\u8d26\u5339\u914d\u7684\u6838\u5fc3\u7b97\u6cd5\u90fd\u9760\u8fd9\u4e24\u4e2a\u51fd\u6570<\/li>\n
  • \u98de\u4e66Base\u4eea\u8868\u76d8\u7684\u300c\u516c\u5f0f\u300d\u548c\u300c\u67e5\u627e\u5f15\u7528\u300d\u5b57\u6bb5\u2014\u2014\u5e93\u5b58\u770b\u677f\u7684\u6570\u636e\u6e90\u914d\u7f6e<\/li>\n<\/ul>\n
    \n

    #\u5f71\u5200RPA #RPA\u81ea\u52a8\u5316 #\u5e97\u7fa4\u8fd0\u8425 #\u6570\u636e\u5bf9\u8d26 #\u5e93\u5b58\u76d1\u63a7 #\u7efc\u5408\u5b9e\u6218 #\u7535\u5546\u6570\u636e #\u98de\u4e66<\/p>\n

    \"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

    \u4f5c\u8005：\u6797\u7131<\/p>\n

    \u672c\u6587\u4e3a\u300a\u5f71\u5200RPA\u5b66\u4e60\u624b\u518c\u300b\u7cfb\u5217\u6587\u7ae0\u4e4b\u4e00，\u5185\u5bb9\u6e90\u4e8e\u5b9e\u64cd\u7ecf\u9a8c\u7684\u6574\u7406\u4e0e\u5206\u4eab\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357：\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf
    \n\u5e97\u7fa4\u8fd0\u8425\u523010\u4e2a\u5e97\u94fa\u4ee5\u4e0a，\u6700\u75db\u82e6\u7684\u4e8b\u4e0d\u662f\u8fd0\u8425，\u800c\u662f\u5bf9\u8d26\u2014\u2014\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u548c\u94f6\u884c\u6d41\u6c34\u5bf9\u4e0d\u4e0a\u3001\u6dd8\u5b9d\u652f\u4ed8\u5b9d\u8d26\u5355\u5dee\u51e0\u5757\u94b1\u3001TEMU\u7684\u7f8e\u5143\u7ed3\u7b97\u6c47\u7387\u6bcf\u6b21\u90fd\u4e0d\u4e00\u6837\u3002\u6708\u5e95\u624b\u5de5\u5bf9\u8d26\u80fd\u628a\u4eba\u903c\u75af，\u4e00\u7b14\u4e00\u7b14\u6838\u5bf9，\u7a0d\u6709\u758f\u5ffd\u5c31\u662f\u51e0\u767e\u5757\u7684\u5dee\u989d\u3002
    \n\u81ea\u52a8\u5316\u5bf9\u8d26\u7cfb\u7edf\u662f\u5e97\u7fa4RPA\u7684\u5929\u82b1\u677f\u573a\u666f\u2014\u2014\u6570\u636e\u6e90\u591a\u3001\u903b\u8f91\u590d\u6742\u3001\u5bb9\u9519\u7387\u8981\u6c42\u6781\u9ad8\u3002 \u8fd9\u5957\u7cfb\u7edf\u6211\u8fed\u4ee3\u4e86\u4e09\u4e2a\u7248\u672c\u3002\u7b2c\u4e00\u7248\u53ea\u5bf9\u603b\u989d&#xff0c<\/p>\n","protected":false},"author":2,"featured_media":86952,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9126,7558,9823,6818,9822,9824],"topic":[],"class_list":["post-86959","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-9126","tag-ai","tag-rpa","tag-6818","tag-9822","tag-9824"],"yoast_head":"\n\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/86959.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357：\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf \u5e97\u7fa4\u8fd0\u8425\u523010\u4e2a\u5e97\u94fa\u4ee5\u4e0a，\u6700\u75db\u82e6\u7684\u4e8b\u4e0d\u662f\u8fd0\u8425，\u800c\u662f\u5bf9\u8d26\u2014\u2014\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u548c\u94f6\u884c\u6d41\u6c34\u5bf9\u4e0d\u4e0a\u3001\u6dd8\u5b9d\u652f\u4ed8\u5b9d\u8d26\u5355\u5dee\u51e0\u5757\u94b1\u3001TEMU\u7684\u7f8e\u5143\u7ed3\u7b97\u6c47\u7387\u6bcf\u6b21\u90fd\u4e0d\u4e00\u6837\u3002\u6708\u5e95\u624b\u5de5\u5bf9\u8d26\u80fd\u628a\u4eba\u903c\u75af，\u4e00\u7b14\u4e00\u7b14\u6838\u5bf9，\u7a0d\u6709\u758f\u5ffd\u5c31\u662f\u51e0\u767e\u5757\u7684\u5dee\u989d\u3002 \u81ea\u52a8\u5316\u5bf9\u8d26\u7cfb\u7edf\u662f\u5e97\u7fa4RPA\u7684\u5929\u82b1\u677f\u573a\u666f\u2014\u2014\u6570\u636e\u6e90\u591a\u3001\u903b\u8f91\u590d\u6742\u3001\u5bb9\u9519\u7387\u8981\u6c42\u6781\u9ad8\u3002 \u8fd9\u5957\u7cfb\u7edf\u6211\u8fed\u4ee3\u4e86\u4e09\u4e2a\u7248\u672c\u3002\u7b2c\u4e00\u7248\u53ea\u5bf9\u603b\u989d&#xff0c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/86959.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-29T06:24:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/07\/20260729062437-6a699ca507262.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/86959.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/86959.html\",\"name\":\"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-07-29T06:24:41+00:00\",\"dateModified\":\"2026-07-29T06:24:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/86959.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/86959.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/86959.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/86959.html","og_locale":"zh_CN","og_type":"article","og_title":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357：\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf \u5e97\u7fa4\u8fd0\u8425\u523010\u4e2a\u5e97\u94fa\u4ee5\u4e0a，\u6700\u75db\u82e6\u7684\u4e8b\u4e0d\u662f\u8fd0\u8425，\u800c\u662f\u5bf9\u8d26\u2014\u2014\u62fc\u591a\u591a\u7ed3\u7b97\u5355\u548c\u94f6\u884c\u6d41\u6c34\u5bf9\u4e0d\u4e0a\u3001\u6dd8\u5b9d\u652f\u4ed8\u5b9d\u8d26\u5355\u5dee\u51e0\u5757\u94b1\u3001TEMU\u7684\u7f8e\u5143\u7ed3\u7b97\u6c47\u7387\u6bcf\u6b21\u90fd\u4e0d\u4e00\u6837\u3002\u6708\u5e95\u624b\u5de5\u5bf9\u8d26\u80fd\u628a\u4eba\u903c\u75af，\u4e00\u7b14\u4e00\u7b14\u6838\u5bf9，\u7a0d\u6709\u758f\u5ffd\u5c31\u662f\u51e0\u767e\u5757\u7684\u5dee\u989d\u3002 \u81ea\u52a8\u5316\u5bf9\u8d26\u7cfb\u7edf\u662f\u5e97\u7fa4RPA\u7684\u5929\u82b1\u677f\u573a\u666f\u2014\u2014\u6570\u636e\u6e90\u591a\u3001\u903b\u8f91\u590d\u6742\u3001\u5bb9\u9519\u7387\u8981\u6c42\u6781\u9ad8\u3002 \u8fd9\u5957\u7cfb\u7edf\u6211\u8fed\u4ee3\u4e86\u4e09\u4e2a\u7248\u672c\u3002\u7b2c\u4e00\u7248\u53ea\u5bf9\u603b\u989d&#xff0c","og_url":"https:\/\/www.wsisp.com\/helps\/86959.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-07-29T06:24:41+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/07\/20260729062437-6a699ca507262.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/86959.html","url":"https:\/\/www.wsisp.com\/helps\/86959.html","name":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-07-29T06:24:41+00:00","dateModified":"2026-07-29T06:24:41+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/86959.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/86959.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/86959.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u5f71\u5200RPA\u5b9e\u64cd\u6307\u5357\uff1a\u7535\u5546\u5e97\u7fa4\u6570\u636e\u5bf9\u8d26\u4e0e\u5e93\u5b58\u76d1\u63a7\u81ea\u52a8\u5316\u7cfb\u7edf"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/86959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=86959"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/86959\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/86952"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=86959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=86959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=86959"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=86959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}