About this skill

Problem

In pharma O2O operations, stores often receive competitor price-comparison Excel files where the competitor-name column may be incorrect and column names are inconsistent. Manually checking SKU prices, delivery costs, and margins across multiple stores is slow. The skill helps answer operational questions: which products should match price, which can protect margin, and which high-price items need attention.

How It Works

It takes price comparison data and an O2O price list as input, extracts competitor names from file names to reduce reliance on unreliable columns, and matches delivery prices by UPC. The matching rate is usually 90%–100%; unmatched items are skipped. The core v3 bidding strategy tiers competitor monthly sales: above 50 orders may use max(competitor price - 0.01, delivery price * 1.05); 10–50 orders may use competitor price * 0.95; other tiers apply different margin targets. Outputs include multiple Excel sheets: Overview, Pricing Suggestions, Low-Price Advantage, High-Price Disadvantage, and Full Details, making it easier to review results by store and competitor.

Boundaries

It fits environments with stable store-to-competitor mappings and predictable file naming. New stores must be added to STORE_MAP, and new competitor files need to be placed in the expected directory before rerunning. It depends on local file paths and Excel file state; locked files may be skipped, and missing UPC values cannot be filled automatically. The output is operational analysis, not a substitute for procurement approval, supplier negotiation, or final pricing systems.

Screenshots

Use Cases

O2O operators receive weekly competitor price-comparison Excel files and need batch pricing suggestions by store.
Regional leads review trade-area pricing across stores and need to identify low-price and high-price gaps quickly.
Data analysts reconcile comparison files with price lists and need UPC-based delivery price matching and bidding tiers.
Store operations add new competitor files and need to rerun the analysis to verify overview, suggestions, and detail sheets.

Best For

O2O operators managing competitor price reviews across stores need batch pricing suggestions, low-price, and high-price gap sheets.
Data analysts matching price-comparison and price-list files need UPC-based delivery price matching and margin calculations.
Regional owners maintaining store-to-competitor lists need quick reruns after adding new stores or competitor files.
Procurement or operations staff designing pharma bidding strategy need competitor sales tiers, confirmed prices, and margin targets.