← 返回 Skills 市场

Buyma Order Automation

Name: Buyma Order Automation
Author: innoucon-blip

作者 innoucon-blip · GitHub ↗ · v1.0.0 · MIT-0

cross-platform ⚠ suspicious

227

总下载

当前安装

版本数

在 OpenClaw 中安装

/install buyma-order-automation

功能描述

automate buyma order processing for regular daily runs and ad hoc order-range runs. use when chatgpt needs to access buyma in chrome, check or fill receipt m...

使用说明 (SKILL.md)

Overview

This skill supports two modes:

Regular daily draft creation

Start time can vary
Must ensure mail is sent by 08:30 local time
Orders up to 07:00 must be included
Orders from 07:00 to 08:00 should be included as much as feasible while still guaranteeing mail send by 08:30
If any critical failure occurs, stop immediately and notify via Telegram

Ad hoc range creation

Triggered when the operator requests a specific order-number range
Example: 123450~123470
Complete the draft for that range
Notify via Telegram immediately after completion
Send mail immediately after completion

Core rules

Always use Chrome default profile for BUYMA and Naver Mail
Use the latest delivered workbook first; otherwise use the latest automation-created workbook
Start from the last order number in the most recently delivered file from the operator. If no new delivered file exists, continue from the last workbook previously created by the automation
If BUYMA CSV download fails, allow operator-provided CSV as fallback input
If mail sending fails, notify and attach the result file in Telegram fallback
Follow MEMORY.md and recent memory logs before acting

Base file selection

Select the base order workbook in this order:

latest file in ~/.openclaw/workspace/buyma_order/orders/incoming/
latest file in ~/.openclaw/workspace/buyma_order/orders/current/
~/.openclaw/workspace/buyma_order/templates/tmazonORDERLIST_template.xlsx

Output file naming

Always save output as: tmazonORDERLISTYYMMDD_start-end.xlsx

Example: tmazonORDERLIST260307_123450-123470.xlsx

Receipt memo numbering

Always check memo state for target orders.

If memo already contains a valid 6-digit order number, do not rewrite it
If memo contains text or a number shorter than 6 digits, prepend the 6-digit order number before the existing memo content
In ad hoc range mode, always perform the memo check/input step

See references/memo-rules.md.

Workflow

Determine run mode: regular daily or ad hoc range
Select base workbook
Access BUYMA in Chrome default profile
Check and input receipt memo numbers for target orders
Download shipping CSV (or use provided CSV fallback)
Parse CSV using scripts/parse_buyma_csv.py
Build draft workbook using scripts/build_order_sheet.py
Fill F using Chrome auto-translated Korean product names (browser placeholder step)
Enrich I/J/M from prior workbook history using scripts/enrich_from_history.py
Validate output using scripts/validate_output.py
Save output using scripts/compose_output_filename.py
Send by Naver Mail in Chrome (browser placeholder step)
Update state using scripts/update_state.py
On BUYMA/CSV/mail failure, stop immediately and notify via Telegram with file attachment if available

Browser placeholder steps

This package intentionally leaves browser-only steps as placeholders:

BUYMA login and page navigation
Receipt memo editing in BUYMA UI
BUYMA CSV download click-flow
Product page Korean name capture from Chrome auto-translation
Naver Mail compose/send
Telegram file attachment send from browser/channel tool path

Use these references:

references/workflow.md
references/failure-rules.md
references/run-modes.md

Script entrypoints

scripts/select_base_file.py
scripts/parse_buyma_csv.py
scripts/build_order_sheet.py
scripts/enrich_from_history.py
scripts/validate_output.py
scripts/compose_output_filename.py
scripts/update_state.py

安全使用建议

This package's scripts and workflow are coherent for building BUYMA order workbooks, but pay attention to the browser- and messaging-related parts that are left as placeholders. Before installing or running: 1) Review and run the Python scripts in a controlled environment and ensure required Python dependencies (e.g., openpyxl) are installed from official sources. 2) Treat the instruction to 'use Chrome default profile' as sensitive: do not grant automated agents direct access to your main browser profile — create and use a dedicated profile or perform browser steps manually to avoid exposing cookies/session tokens. 3) The Telegram/Naver Mail notification steps are not implemented in code; decide whether notifications will be manual, browser-driven, or require adding secure API integrations (and if so, add explicit credential handling). 4) The skill will write files and a last_state.json under ~/.openclaw/workspace/buyma_order/ — back up or isolate that directory if needed. 5) If you plan to allow any automation to control Chrome, audit how that automation would access the profile and tokens. If unsure, test with a non-production account and a separate Chrome profile to limit exposure.

功能分析

Type: OpenClaw Skill Name: buyma-order-automation Version: 1.0.0 The skill bundle is a legitimate automation tool for BUYMA order processing, featuring well-structured Python scripts for CSV parsing, Excel workbook manipulation, and data enrichment. The scripts (e.g., `parse_buyma_csv.py`, `enrich_from_history.py`, and `build_order_sheet.py`) use standard libraries like `openpyxl` and `csv` to perform specific, transparent tasks aligned with the stated purpose. While the workflow involves high-privilege actions such as using the Chrome default profile for browser automation and sending emails via Naver Mail, these are clearly documented as core functional requirements and lack any indicators of malicious intent, data exfiltration, or unauthorized persistence.

能力评估

✓ Purpose & Capability

The code files (CSV parsing, workbook writing, filename composition, history enrichment, validation, and state update) match the skill's stated purpose of building and managing BUYMA order workbooks. File paths and outputs (~/ .openclaw/workspace/buyma_order/ and tmazonORDERLIST filenames) are consistent with the description.

ℹ Instruction Scope

SKILL.md contains explicit browser-interaction steps (BUYMA login, memo editing, CSV download, Chrome auto-translation capture, Naver Mail send, Telegram fallback) but treats them as 'browser placeholder steps' (i.e., not implemented in code). The instructions also ask the agent to 'Always use Chrome default profile' and to 'follow MEMORY.md and recent memory logs' — these direct the agent/operator toward accessing potentially sensitive local browser state and memory context. The placeholder approach keeps network/API calls out of the Python scripts, but the instructions nonetheless require actions that could expose credentials if automated.

ℹ Install Mechanism

There is no install spec (instruction-only install). The included Python scripts depend on third-party libraries (openpyxl) but do not declare or install them. Lack of an install manifest means the environment must supply dependencies manually; however, there are no remote downloads or obscure install URLs, so on-disk risk from installation is low.

⚠ Credentials

The skill declares no required environment variables or credentials, yet the runtime instructions explicitly require using the Chrome default profile for BUYMA and Naver Mail and call for Telegram notifications on failure. That implies access to browser-stored session tokens/cookies and external messaging capability, but no credentials, API tokens, or guidance for secure integration are declared. This is a mismatch: either the operator is expected to perform those steps manually (safer) or an automated agent would need access to sensitive browser/profile data without any declared or controlled credential mechanism.

✓ Persistence & Privilege

The skill is not always-enabled and does not request elevated platform privileges. It reads and writes files under its own workspace (~/.openclaw/workspace/buyma_order/) and updates a local state file (config/last_state.json), which is reasonable for this workflow. Autonomous model invocation is the platform default and not a unique concern here.

如何使用

确保已安装 OpenClaw（本地或 Docker 部署）
在对话框中输入安装命令：/install buyma-order-automation
安装完成后，直接呼叫该 Skill 的名称或使用 /buyma-order-automation 触发
根据 Skill 的参数说明提供必要输入，即可获得结构化输出

版本历史

v1.0.0

buyma-order-automation 1.0.0 – initial release - Automates BUYMA order processing for daily scheduled runs and ad hoc order-number ranges. - Ensures deadlines, manages fallback CSV inputs, and selects the correct base workbook. - Checks and fills receipt memo numbers per detailed rules. - Generates order workbooks, enriches with historical data, and sends results via Naver Mail. - On any critical failure (BUYMA, CSV, or mail), stops immediately and notifies via Telegram with file attachment.

元数据

Slug buyma-order-automation

版本 1.0.0

许可证 MIT-0

累计安装 1

当前安装数 1

历史版本数 1

常见问题