An automated data intelligence skill that transforms raw e-commerce product lists (CSV/Excel) into interactive HTML market insight reports across six analytical dimensions.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install product-table-analyzer
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install product-table-analyzer using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Product Table Analyzer?
The Product Table Analyzer is a powerful, locally executed analytical agent skill built to help e-commerce operators, merchandisers, and digital marketers make data-driven product selection decisions. By utilizing this solution from the Openclaw Skills library, users can easily drop raw data sheets exported from major e-commerce platforms or intelligence tools directly into their AI coding agent and watch it parse, categorize, and visualize complex market structures in seconds.\n\nThis tool handles everything from parsing text columns using advanced Chinese word segmentation to computing concentration metrics like CR4/CR10 and the Herfindahl-Hirschman Index (HHI). Ultimately, it creates a gorgeous, interactive HTML report complete with custom charts and highly organized P0/P1/P2 actionable priority recommendations, making it an indispensable asset in any modern seller's toolkit.
Product Table Analyzer Use Cases
- Analyzing e-commerce product data exported from platform backends or research plugins (e.g., DianToushi, Business Staff).\n- Auditing manually tracked competitor spreadsheets to uncover market gaps.\n- Identifying the optimal price bands and product selling points in newly entered niches.\n- Evaluating market concentration and competitive density before launching a new product line using verified Openclaw Skills implementations.\n- Generating responsive, client-ready e-commerce market reports on demand without writing manual python scripts.
How Product Table Analyzer Works
- Trigger & Ingestion: The agent activates when you upload a CSV/Excel sheet, paste tabular data, or prompt for a product table analysis.\n2. Environment & Dependency Check: The script automatically verifies if Python,
jieba(for Chinese tokenization), andopenpyxl(for Excel parsing) are installed locally, installing missing libraries automatically.\n3. Local Algorithmic Processing: It parses the table, mapping columns intelligently and executing 6-dimensional algorithms to evaluate categories, title word frequencies, pricing distributions, seller concentration, and competition index.\n4. Structured JSON Generation: The analytical engine organizes outputs into structured metadata containing exact calculations and e-commerce indicators.\n5. Responsive HTML Generation: An interactive single-page HTML report is built dynamically containing interactive Chart.js charts, toggles, responsive design, and localized labels.\n6. Result Presentation: The agent saves the report to your local workspace directory and displays a textual summary highlighting key competitive findings and top priority recommendations.
Product Table Analyzer Setup
Ensure you have Python installed and configure your environment. This skill automatically handles dependency resolution upon activation, but you can manually set it up by following these steps:\n\nbash\n# Install the required Python packages manually\npip install jieba openpyxl\n\n# Or run the installation via python to ensure correct environment binding\npython -m pip install jieba openpyxl\n\n# Verify your installation\npython -c "import jieba; import openpyxl; print('OK')"\n\n\nNo API keys or internet connections are required as all analysis processes locally on your system, maintaining complete data privacy within the ecosystem of Openclaw Skills.
Product Table Analyzer Data Schema & Taxonomy
The tool expects a structured e-commerce data format to yield maximum insight. It analyzes your table column schemas and outputs a comprehensive interactive HTML file.\n\n### Input Column Requirements\nAt a minimum, the input sheet must contain Product Name (商品名) and Price (价格) columns. Including optional columns significantly improves report depth:\n\n| Column Name (CN/EN) | Requirement | Impact on Report |\n| :--- | :--- | :--- |\n| Product Name / 商品名 | Required | Title word frequency and selling point categorization |\n| Price / 价格 | Required | Price band histogram, average prices, and price-volume maps |\n| Sales / 销量 | Optional | Average sales per category, price-volume correlation charts |\n| Store / 店铺 | Optional | CR4/CR10 concentration metrics, seller competitor matrix |\n| Category / 类目 | Optional | Category market share pie charts, category price comparisons |\n\n### Generated Outputs\nEvery successful execution generates a self-contained, responsive HTML file saved locally:\n- Path: {workspace}/market_insight_report_{timestamp}.html\n- Dependencies: Loads Chart.js dynamically from a CDN for interactive data visualization.
Product Table Analyzer Advanced Features
- Advanced Market Concentration Metrics: Automatically computes HHI (Herfindahl-Hirschman Index) and CR4/CR10 metrics to diagnose whether a niche is a Red Ocean (dominated) or Blue Ocean (fragmented).\n- Resilient Encoding Detection: Gracefully handles legacy and localized file encodings by attempting sequentially UTF-8, GBK, and GB18030 formats.\n- Interactive Filtering & P0/P1/P2 Action Cards: Evaluates market dynamics to generate prioritized, filterable product action recommendations directly within the visual interface.\n- Modern Responsive Color Theme: Generated reports leverage a modern Indigo, Emerald, Amber, and Crimson styling palette complete with collapsing panels, interactive tooltips, and grid layouts.\n- Local Execution and Privacy: Built natively to secure sensitive proprietary e-commerce data by processing entirely offline, standard across Openclaw Skills integrations.
SKILL.md
Loading
Related Openclaw Skills
Store Inspection Manager
An AI-powered chain store inspection assistant providing end-to-end management from planning and 10-dimensional scoring to interactive reporting and marketing optimizations.
Baitan Master
An interactive decision-support and workflow automation tool for street vending entrepreneurs, utilizing real-world data engines.
INVEST Investment Decision System
A local, structured financial co-pilot implementing the INVEST framework to calculate safe position sizing, enforce risk compliance rules, and output rich visualization dashboards.
Master Fisher
An expert AI fishing advisor that analyzes meteorological, tidal, and environmental data to generate optimized strategies for float and lure fishing.
Skill Copywriting & Discovery Optimizer
An AI-powered metadata optimizer designed to refine Skill names, descriptions, and triggers to maximize agent discoverability across various hub platforms.
Work Productivity Weather Current Workflow Helper
A dedicated assistant workflow helper designed to debug, secure, and build reliable weather-style automated tasks for local-friendly AI agents.
Featured*
