← Back to Skills Marketplace
wuminmin

retail-trade-report-generator

by wuminmin · GitHub ↗ · v1.0.0
cross-platform ✓ Security Clean
1605
Downloads
1
Stars
2
Active Installs
1
Versions
Install in OpenClaw
/install retail-trade-report-generator
Description
Generates a consolidated weekly retail trade report by processing 12 Excel sales files, mapping stores to regions, calculating ADA metrics, WoW comparisons,...
Usage Guidance
This package looks coherent and not malicious, but take these practical steps before running it: 1) Review the Python code yourself (or have a developer do so) to confirm the column/row indices and sheet names match your real Excel exports — the script uses hard-coded row ranges and sheet names which may need adjustment. 2) Run it in a controlled environment (local VM or container) and install dependencies from official sources (pip install pandas openpyxl). 3) Provide only the intended input files and the store_mapping.csv; the skill reads only files in the specified input directory and writes an output Excel. 4) Test with sample data to verify results and edge-case handling (e.g., missing sheets, date parsing). If you need the skill to run autonomously on a platform, ensure the runtime includes the required Python packages or add an install step that pins trusted package versions.
Capability Analysis
Type: OpenClaw Skill Name: retail-trade-report-generator Version: 1.0.0 The skill bundle is classified as benign. The `SKILL.md` documentation clearly outlines the purpose and functionality, providing instructions for an AI agent that are aligned with data processing and report generation without any signs of prompt injection or malicious intent. The Python script `scripts/retail_trade_report_generator.py` uses standard libraries (`pandas`, `openpyxl`, `re`, `os`, `datetime`) for reading specified Excel and CSV files from an input directory and writing a consolidated Excel report to an output directory. There is no evidence of data exfiltration, malicious execution (e.g., `eval`, `subprocess`, network calls), persistence mechanisms, or obfuscation. All file operations are confined to expected user-data paths.
Capability Assessment
Purpose & Capability
The SKILL.md, README, and the included Python script all align: they expect 12 Excel files plus a store_mapping.csv and produce a consolidated Excel report. One minor mismatch: the package metadata declares no required binaries or env vars, but the provided code requires a Python runtime with pandas and openpyxl; those dependencies are not declared in the skill metadata or install spec.
Instruction Scope
Runtime instructions and the code limit actions to reading local Excel files and a CSV, aggregating numbers, and writing an Excel output. There are no instructions to read unrelated system files, environment variables, or to send data to external endpoints.
Install Mechanism
There is no install spec (instruction-only), which minimizes install-time risk. However, the shipped Python script requires third-party libraries (pandas, openpyxl) that are not declared; the skill does not provide an install step or pinned package list. This is an operational omission rather than a security red flag, but you should ensure dependencies are installed from trusted sources before running.
Credentials
The skill requests no environment variables, no credentials, and no config paths. Required inputs are explicit (local Excel files and a mapping CSV) and proportional to the stated purpose.
Persistence & Privilege
The skill is not forced always-on and does not request persistent platform privileges. It does not modify other skills or system-wide settings in the provided code.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install retail-trade-report-generator
  3. After installation, invoke the skill by name or use /retail-trade-report-generator
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Retail Trade Weekly Report Generator 1.0.0 - Initial release. - Consolidates 12 weekly sales Excel files into a comprehensive Retail Trade Weekly Report with channel, region, and product breakdown. - Calculates Average Daily Acquisition (ADA) and Week-over-Week (WoW) performance. - Uses detailed mapping rules to aggregate data by standard regions, handling fuzzy store name matching. - Outputs a formatted Excel workbook with styled summary tables and three embedded charts. - Includes robust error handling for missing or mismatched input files.
Metadata
Slug retail-trade-report-generator
Version 1.0.0
License
All-time Installs 2
Active Installs 2
Total Versions 1
Frequently Asked Questions

What is retail-trade-report-generator?

Generates a consolidated weekly retail trade report by processing 12 Excel sales files, mapping stores to regions, calculating ADA metrics, WoW comparisons,... It is an AI Agent Skill for Claude Code / OpenClaw, with 1605 downloads so far.

How do I install retail-trade-report-generator?

Run "/install retail-trade-report-generator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is retail-trade-report-generator free?

Yes, retail-trade-report-generator is completely free (open-source). You can download, install and use it at no cost.

Which platforms does retail-trade-report-generator support?

retail-trade-report-generator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created retail-trade-report-generator?

It is built and maintained by wuminmin (@wuminmin); the current version is v1.0.0.

💬 Comments