Return rate<\/li>\n<\/ul>\nProvide the result as a markdown table.`;<\/p>\n
const response = await openai.createChatCompletion({<\/p>\n
model: \"gpt-4o-mini\", \/\/ \u4f7f\u7528\u6700\u65b0 ChatGPT \u7248<\/p>\n
messages: [{ role: \"user\", content: prompt + \"\\n\" + JSON.stringify(orders) }],<\/p>\n
temperature: 0,<\/p>\n
});<\/p>\n
return response.data.choices[0].message.content;<\/p>\n
}<\/p>\n\n
\/\/ 4. \u4e3b\u51fd\u6570<\/p>\n
(async () => {<\/p>\n
const orders = await getOrders();<\/p>\n
const report = await generateReport(orders);<\/p>\n
console.log(report);<\/p>\n
})();<\/p>\n<\/code><\/pre>\n
\u628a .env<\/code> \u6587\u4ef6\u91cc\u586b\u597d OPENAI_API_KEY<\/code>\u3001SHOPIFY_API_KEY<\/code>\u3001SHOPIFY_PASSWORD<\/code>\u3001SHOPIFY_STORE<\/code>\u3002<\/p>\n<\/li>\n\u8fd0\u884c\u811a\u672c<\/strong>\uff1a\u5728\u7ec8\u7aef\u6267\u884c node report.js<\/code>\uff0c\u51e0\u79d2\u949f\u540e\u4f1a\u5728\u63a7\u5236\u53f0\u770b\u5230\u7c7b\u4f3c\uff1a<\/li>\n## \u672c\u6708\u9500\u91cf\u6982\u89c8\n| \u6307\u6807 | \u6570\u503c |<\/p>\n
|------|------|<\/p>\n
| \u603b\u9500\u552e\u989d | $12,340 |<\/p>\n
| \u5e73\u5747\u8ba2\u5355\u4ef7\u503c | $78.5 |<\/p>\n
| \u9000\u8d27\u7387 | 2.1% |<\/p>\n\n
\u70ed\u9500\u524d5\u4ea7\u54c1<\/h3>\n
| \u4ea7\u54c1\u540d\u79f0 | \u9500\u552e\u6570\u91cf |<\/p>\n
|----------|----------|<\/p>\n
| Bluetooth Earbuds | 320 |<\/p>\n
| Skin Care Serum | 210 |<\/p>\n
| ... |<\/p>\n<\/code><\/pre>\n
\u628a\u62a5\u8868\u81ea\u52a8\u5199\u5165 Google Sheet<\/strong>\uff08\u53ef\u9009\uff09\uff1a\n\n- \u5728 Google Cloud Console \u5f00\u901a
Google Sheets API<\/code>\uff0c\u83b7\u53d6 OAuth2 \u51ed\u8bc1\u3002<\/li>\n- \u4f7f\u7528
googleapis<\/code> npm \u5305\uff0c\u628a\u4e0a\u9762\u7684 markdown \u8f6c\u6210\u8868\u683c\u5199\u5165\u6307\u5b9a Sheet\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\u907f\u5751\u63d0\u9192<\/h3>\n\n- API \u8c03\u7528\u91cf\u8981\u63a7\u5236\u5728\u514d\u8d39\u989d\u5ea6\u5185\uff0c\u5efa\u8bae\u5148\u628a
temperature<\/code> \u8bbe\u4e3a 0\uff0c\u907f\u514d\u751f\u6210\u5197\u4f59\u6587\u5b57\u3002<\/li>\n- Shopify \u8fd4\u56de\u7684\u8ba2\u5355\u5b57\u6bb5\u5f88\u591a\uff0c\u53ea\u53d6
line_items<\/code>\u3001total_price<\/code>\u3001fulfillment_status<\/code> \u7b49\u5fc5\u8981\u5b57\u6bb5\uff0c\u907f\u514d token \u8d85\u652f\u3002<\/li>\n- \u751f\u4ea7\u73af\u5883\u8bf7\u4f7f\u7528\u73af\u5883\u53d8\u91cf\u6216\u5bc6\u94a5\u7ba1\u7406\u5de5\u5177\uff08\u5982 AWS Secrets Manager\uff09\uff0c\u522b\u628a\u94a5\u5319\u786c\u7f16\u7801\u3002<\/li>\n<\/ul>\n
\u5b9a\u4ef7\u4e0e\u66ff\u4ee3\u65b9\u6848<\/h3>\n\n- OpenAI API\uff1a\u514d\u8d39\u989d\u5ea6 5 \u4e07 token \/ \u6708<\/strong>\uff0c\u7ea6\u7b49\u4e8e 2\u20133 \u6b21\u5b8c\u6574\u62a5\u8868\u751f\u6210\u3002\u8d85\u51fa\u540e
gpt-4o-mini<\/code> \u7ea6 $0.015\/1k token\uff0c\u6210\u672c\u51e0\u5206\u94b1\u5373\u53ef\u5b8c\u6210\u4e00\u6b21\u6708\u62a5\u3002<\/li>\n- \u5982\u679c\u9884\u7b97\u6781\u7d27\uff0c\u53ef\u7528
Claude \u6700\u65b0\u7248<\/code>\uff08\u540c\u4ef7\u4f4d\uff09\u6216\u56fd\u5185\u7684 \u8baf\u98de\u661f\u706b<\/code>\u3001\u6587\u5fc3\u4e00\u8a00<\/code>\uff08\u514d\u8d39\u5957\u9910\u4e5f\u80fd\u8dd1\u5c0f\u6279\u91cf\uff09\u3002\u529f\u80fd\u4e0a\u57fa\u672c\u4e00\u81f4\uff0c\u53ea\u662f Prompt \u7ec6\u8282\u7565\u6709\u4e0d\u540c\u3002<\/li>\n<\/ul>\n\u6548\u679c\u5bf9\u6bd4\uff08\u5b9e\u6d4b\u4f53\u611f\uff09<\/h3>\n