O2O Product Stockout Weekly Report Analysis

The Problem It Solves

In O2O store operations, stock availability for top-selling products is often scattered across ERP exports, inventory sheets, and manual checks. A single-store weekly report may be manageable, but batch review across many stores becomes harder: files are dispersed, formats are inconsistent, and replenishment priorities can be unclear, which may lead to missed issues or inconsistent criteria.

How The Skill Works

This skill is aimed at store hot-product stockout weekly reports. The core input is an ERP-exported xls or xlsx file containing at least the item code, item name, and quantity fields. It processes stores in batches and uses a fixed hot-product catalog plus warehouse inventory data to produce reports and comparisons suitable for business review:

• Data preparation: converts source files into usable xlsx weekly report structures.
• Stockout grading: classifies items as fully out of stock, tight inventory, low inventory, or normal inventory based on quantity.
• Cross-store comparison: outputs multi-store stockout rate comparisons in xlsx and html formats.
• Replenishment list: compiles candidate items for immediate restocking in the suggested replenishment sheet.

Boundaries And Considerations

The skill depends on local fixed files, such as the hot-product catalog and warehouse inventory sheet, and expects input files to be accessible from paths like Downloads or the Desktop. For Chinese file paths, running it through a Python script is preferred over ad hoc python -c commands. Batch processing identifies stores by file name and aliases, so naming should remain stable; changed store names may affect automatic grouping.