E-commerce New Product Operations Monitor

E-commerce new-product review often stalls in manual spreadsheet checks: off-shelf items, missing daily rows, traffic waste, and under-exposed converters get buried in raw exports. This skill is aimed at a Shengyicanyou 'regular update view' export plus a user-provided product list, producing an auditable monitoring report.

Core capabilities

• Exception first: flags off-shelf products with all affected dates and latest-day status; detects missing dates and separates intermittent gaps from off-shelf-related gaps.
• Ops quadrants: labels low-conversion/high-traffic, high-conversion/low-traffic, and healthy growth using cumulative visitor and conversion medians.
• Focus and Top10: computes 7-day Top10 by visitors, cart adds, conversion, buyers, and payment amount, then links strong-focus items to unranked status.

How it works

1. preprocess.py validates columns I-AJ and cleans numeric fields.
2. analyze.py matches product IDs, computes metrics and marks risk signals.
3. build_report.py renders a Chart.js HTML report.
4. export_excel.py exports a multi-sheet Excel workbook.

Boundaries

Both the latest export and the current product list must be provided in each run; missing product code, display name, or strong-focus columns cause failure. HTML preview requires network access.