This skill should be used when the user asks about "Rexel prices", "what did we pay for", "material cost", "vendor cost", "margin analysis", "Rexel SKU", "pricebook sync", "pricebook gap", "how much did we spend on", "purchase history", "top materials", "what do we buy from Rexel", or any Rexel vendor/material pricing task. Provides complete Rexel purchase history lookup, margin analysis, and pricebook gap analysis for Phoenix Electric.
Complete operational skill for Phoenix Electric's Rexel purchase history. Covers SKU lookup, pricing, margin analysis, spend tracking, and pricebook synchronization across 1,600+ SKUs and $1M+ in historical invoice data.
| Tool | Purpose |
|---|---|
rexel_lookup | Search by SKU, item #, description keyword, or brand |
rexel_get_sku | Full detail for one SKU — price range, history, jobs, pricebook match |
rexel_margin_check | Cross-ref: Rexel cost vs pricebook sell prices (all 6 price points) |
rexel_top_items | Top N by frequency, quantity, or spend |
rexel_category_summary | Spend by category (Wire, Lighting, Breakers, etc.) |
rexel_build_sync_report | Full comparison: all SKUs vs pricebook with gap analysis |
User asks: "What did we pay for 14-2 Romex?" or "How much is RMX142WG250CL?"
rexel_lookup with the search termrexel_get_sku for full detailUser asks: "What's our margin on GFCI outlets?" or "Are we making money on Romex?"
rexel_margin_check with the search termUser asks: "What Rexel items aren't in our pricebook?" or "Run a sync report"
rexel_build_sync_report for full analysisUser asks: "What do we buy most from Rexel?" or "Show me our top wire purchases"
rexel_top_items with appropriate sort and category filterrexel_category_summary for overall breakdownreferences/sku-reference.md — SKU format conventions and search tipsreferences/margin-rules.md — Phoenix Electric markup and margin targetsreferences/data-sources.md — CSV source files and ETL processreferences/future-phases.md — SFTP auto-fetch, Firecrawl photos, requisitions