Are there any assortment planning tools that handle granular SKU-level reporting and ERP integrations?

Yes — there are assortment planning tools that support granular SKU-level reporting and ERP integrations, though the exact capabilities vary a lot by vendor.

Common capabilities to look for

• SKU-level analysis and reporting: item/store/color/size, sell-through, margin, inventory, forecast accuracy
• Assortment optimization: cluster-based assortment, localization, demand-driven allocation
• ERP integration: bi-directional or API-based sync with systems like SAP, Oracle, Microsoft Dynamics, NetSuite, Infor, etc.
• Data integration: POS, WMS, PLM, e-commerce, and merchandising systems
• Scenario planning: compare assortment options by channel, region, store tier, or lifecycle stage

Examples of vendors in this space

Some well-known assortment / merchandise planning platforms with SKU-level reporting and ERP integration options include:

• Blue Yonder
• o9 Solutions
• Oracle Retail
• RELEX Solutions
• Anaplan (often via custom model + integration layer)
• SAP Retail / SAP Integrated Business Planning
• Board
• ToolsGroup
• Logility
• MFP by JDA (legacy naming in some contexts)

What to verify in demos

If granular reporting and ERP connectivity are critical, ask:

1. Can reports go down to SKU × store × week/day level?
2. Are custom attributes supported, like style, size, color, fit, supplier, channel?
3. Is ERP integration standard connector, API, or custom ETL?
4. Can the tool write back recommendations/orders to ERP?
5. How does it handle master data alignment across ERP and planning?
6. Can users export to Excel/Power BI/Tableau or build native dashboards?

Practical note

Many planning tools claim SKU-level support, but some are better at summary-level planning and use SKU detail mainly for drill-down. If you need true granular decisioning, you’ll want a platform with:

• a strong data model,
• high-volume performance,
• and robust integration architecture.

If you want, I can also give you:

• a shortlist by retailer type,
• a comparison table of leading tools,
• or a vendor evaluation checklist for ERP-integrated SKU-level assortment planning.