ERP Systems for Retail Inventory and Merchandising Training Course

Course overview

Retail inventory teams are expected to maintain availability without tying up cash in excess stock, while merchandising teams need reliable product, price, promotion and supplier data to make profitable decisions. ERP systems sit at the centre of these processes, but value is lost when replenishment parameters, item hierarchies, purchase orders, stock transfers and sales data are configured or interpreted in isolation. This course addresses the operational gap between ERP transactions and the retail outcomes they are meant to support: fewer stock-outs, lower markdown exposure, cleaner inventory records and faster action on exceptions.

Participants learn how retail merchandising and inventory processes are represented in an ERP environment, from item master and supplier set-up through assortment planning, purchase orders, goods receipt, allocation, replenishment, transfers, returns and stock adjustments. They work with retail KPIs including sell-through, stock turn, weeks of supply, gross margin return on inventory investment (GMROI), fill rate and inventory ageing. The course also covers ERP controls, master-data governance, integration points with POS and warehouse systems, and practical reporting techniques for diagnosing inventory discrepancies and demand-versus-supply exceptions.

Delivered over five instructor-led days in a classroom or live online setting, the programme combines guided system-process walkthroughs, retail case data, Excel-based analysis and structured workshops. Participants complete a capstone retail inventory improvement pack containing an item and hierarchy design, replenishment parameter recommendations, an exception-report specification, KPI calculations and a 90-day implementation plan. This tangible deliverable can be adapted for use in their own category, store estate or supply chain function.

The course is designed for intermediate retail professionals who already work with merchandise, inventory, supply or ERP data and need to translate system capability into disciplined day-to-day retail decisions. It is equally valuable for managers sponsoring ERP adoption, process standardisation or inventory accuracy improvement initiatives.

Course objectives

By the end of this course, participants will be able to:

• Configure retail item, supplier, location and merchandise hierarchy attributes for controlled ERP master data.
• Map an end-to-end procure-to-sell workflow from purchase order creation through receipt, allocation, sale, return and reconciliation.
• Calculate sell-through, stock turn, weeks of supply, GMROI, fill rate and inventory ageing from ERP and POS data.
• Set replenishment parameters including lead time, safety stock, reorder point, minimum presentation stock and order multiples.
• Analyse inventory exceptions using stock-on-hand, open-order, sales and forecast data to prioritise corrective action.
• Design allocation and stock-transfer rules that support store demand, assortment plans and inter-store balancing.
• Apply role-based controls, approval workflows and audit-trail requirements to inventory adjustments, markdowns and returns.
• Produce a retail ERP inventory improvement pack with KPI definitions, exception reports and a 90-day action plan.

Benefits of attending

Target competencies

Who should attend

• Retail Inventory Managers — who must improve availability, stock accuracy and working-capital performance across stores or channels.
• Merchandise Planners — who need to connect assortment, sales plans and open-to-buy decisions to ERP inventory data.
• Replenishment Analysts — who set order parameters and resolve demand, supply and allocation exceptions.
• Category Managers — who need dependable SKU, supplier, pricing and performance data for range decisions.
• ERP Business Analysts — who translate retail operating requirements into ERP configuration, reports and controls.
• Retail Supply Chain Managers — who coordinate purchasing, distribution, transfers and store replenishment processes.

Requirements and prerequisites

Participants should have at least six months of experience in retail merchandising, inventory control, replenishment, buying, supply chain operations or ERP support. They should understand basic retail terms such as SKU, purchase order, goods receipt, stock on hand, sell-through, lead time and store transfer, and be comfortable using spreadsheets for sorting, filtering and simple formulas. Familiarity with any ERP, POS, warehouse management or retail planning system is useful but not mandatory. Prior SAP or Oracle certification, programming, database administration and advanced statistics are not required.

Training methodology

The instructor uses a retail trading case that follows seasonal products from item creation and purchase order through warehouse receipt, store allocation, point-of-sale sales, returns and markdowns. Short taught modules establish the process and control concepts, followed by hands-on exercises using ERP-style transaction scenarios and Excel data extracts. Participants work in groups to resolve stock and replenishment exceptions, defend parameter choices and define report requirements. Each day adds artefacts to an individual capstone pack, culminating in a peer-reviewed 90-day implementation plan.

Course outline

Day 1: Retail ERP foundations and master data

• Retail ERP process architecture from supplier to customer sale
• Item master attributes, variants, packs and unit-of-measure controls
• Merchandise hierarchies for department, category, subcategory and SKU reporting
• Supplier, location and distribution-network master data
• GS1 GTIN, barcode and product-identification standards
• Data ownership, approval workflows and effective-dating rules
• POS, warehouse management and finance integration touchpoints

Workshop: Participants audit a flawed seasonal SKU file and produce a corrected item, supplier and merchandise-hierarchy master-data template.

Day 2: Buying, receiving and inventory integrity

• Purchase order lifecycle, tolerances and vendor lead-time records
• Open-to-buy concepts and committed inventory visibility
• Advance ship notices, goods receipt and invoice-matching controls
• Costing methods, landed cost and retail margin implications
• Stock-on-hand, stock-in-transit and available-to-promise definitions
• Cycle counts, physical inventory and inventory-adjustment reason codes
• Supplier returns, customer returns and reverse-logistics transactions

Workshop: Using a purchase-to-receipt case, participants reconcile ordered, received, invoiced and available stock and document the causes of variance.

Day 3: Replenishment, allocation and store transfers

• Demand signals from POS sales, forecasts and promotional calendars
• Reorder point, safety stock and service-level calculations
• Lead time, review period, order multiple and minimum-order constraints
• Minimum presentation stock and shelf-capacity considerations
• Store allocation methods for newness, core range and seasonal products
• Inter-store transfer rules and stock-balancing decisions
• Replenishment exception queues and prioritisation logic

Workshop: Participants set replenishment parameters for a retail category and create an allocation and transfer response for stores with uneven demand.

Day 4: Merchandising performance and inventory analytics

• Sell-through, stock turn and weeks-of-supply calculations
• GMROI, gross margin, markdown and margin-leakage analysis
• Inventory ageing, slow-mover and obsolete-stock segmentation
• Fill rate, on-shelf availability and lost-sales indicators
• Assortment performance by store cluster and merchandise hierarchy
• ERP report design using filters, drill-downs and exception thresholds
• Excel PivotTables and XLOOKUP for ERP and POS data reconciliation

Workshop: Participants build an inventory performance dashboard and prioritised exception list from a multi-store ERP and POS data extract.

Day 5: Controls, implementation and operating discipline

• Role-based access for purchasing, receiving, pricing and stock adjustment
• Segregation-of-duties risks in retail inventory transactions
• Approval controls for markdowns, write-offs and inventory corrections
• Audit trails, exception evidence and period-end reconciliation
• Retail ERP process KPIs and operational governance cadence
• Requirements prioritisation for ERP reports, workflows and enhancements
• Ninety-day inventory improvement roadmap and benefit tracking

Workshop: Participants present their retail ERP inventory improvement pack, including controls, KPI definitions, exception reports and a 90-day action plan.

Tools & standards covered

SAP S/4HANA, Oracle Retail Merchandising System, Microsoft Excel, GS1 Standards

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions