Product Range and Inventory Management in E-Commerce: From ABC Analysis to Purchasing Automation

Content

Introduction: Why Assortment Management is Critical to Business

Assortment and inventory management is a strategic process that determines the profitability of an online store. Research shows that optimal inventory management can reduce operating costs by 15-30% and increase product turnover by 20-40%.

Key tasks of assortment management:

• Determination of the optimal product matrix
• Monitoring the availability of in-demand positions
• Minimizing frozen capital in illiquid goods
• Automation of procurement and replenishment processes
• Balancing the breadth and depth of the product range

Effective inventory management This helps avoid two critical mistakes: out-of-stock items and overstocking. Each of these mistakes directly impacts a store's profits and reputation.

Product Matrix: The Basis of Product Strategy

Assortment matrix A product catalog is a structured product catalog that defines the composition and parameters of a store's product offering. It includes information on categories, brands, price segments, and product characteristics.

Main parameters of the product range matrix:

Principles of forming an assortment matrix:

1. Target audience analysis - determination of needs, purchasing power and preferences of customers
2. Competitive analysis - studying competitors' product range to identify gaps and opportunities
3. Category management — division of goods into groups taking into account their role in the overall strategy:
   • Traffic generators - popular products that attract buyers
   • Profit-generating - high-margin products
   • Image — products that shape brand perception
   • Additional - products for cross-selling
4. Regular updating - revision of the matrix based on sales data and market trends

A properly formed product mix allows you to increase the average bill by 25-35% due to the competent combination of products of different price categories and purposes.

ABC and XYZ Analysis: Classifying Products by Performance

ABC analysis — is a method of classifying products by their contribution to total revenue or profit. The method is based on the Pareto principle: 20% of products generate 80% of revenue.

ABC analysis method

The products are divided into three categories:

• Category A — bring in 70-80% of revenue (usually 10-20% of goods)
• Category B — bring in 15-20% of revenue (usually 30% of goods)
• Category C — bring in 5-10% of revenue (usually 50-60% of goods)

Step-by-step algorithm for conducting ABC analysis:

1. Collect sales data for all products for the period being analyzed (usually a quarter or six months)
2. Calculate revenue for each product item
3. Sort products by decreasing revenue
4. Calculate the share of each product in total revenue
5. Calculate the accumulated total of shares
6. Distribute products into categories A, B, C

Example of ABC analysis:

Strategies for different categories:

• Category A: maximum availability control, priority placement, regular monitoring of balances
• Category B: standard control, inventory optimization, analysis of potential for transition to Category A
• Category C: minimum stocks, consideration of removing illiquid items from the product range

XYZ Analysis: Sales Predictability

XYZ analysis Assesses the stability of demand for products. It complements ABC analysis by showing how predictable sales are for each item.

Classification is based on the coefficient of variation (V):

• Category X: stable demand, V< 10% — легко прогнозировать
• Category Y: average stability, V = 10-25% - trend analysis required
• Category Z: unstable demand, V> 25% - difficult to forecast

Formula for the coefficient of variation:

V = (σ / x̄) × 100%, where σ is the standard deviation of sales, x̄ is the mean value of sales

Combined ABC/XYZ analysis

Combining the two methods creates a 9-segment matrix that allows you to develop precise inventory management strategies:

For more information on practical applications of analytics, see How to conduct an ABC analysis of products and understand what brings you the most profit?

Balance between deficit and surplus

Inventory management requires a constant balancing act between two opposing risks: out-of-stock and overstock. Both situations negatively impact a business, but in different ways.

Out-of-stock problem

Out-of-stock (stock out) occurs when a popular item is out of stock when a customer is ready to buy it.

Consequences of deficiency:

• Direct revenue loss — According to statistics, 72% of buyers switch to competitors if they don’t have the product they need.
• Declining loyalty — a negative experience reduces the likelihood of a repeat purchase by 40-60%
• Reputational risks — especially critical for goods of category A and AX
• Deterioration of positions in marketplaces — algorithms downgrade products without remaining stock in search results
• Loss of search engine rankings — Products with the "out of stock" status receive less traffic

Reasons for the deficiency:

1. Inaccurate demand forecasting
2. Delays in deliveries from suppliers
3. Insufficient safety stock
4. A sharp surge in demand (seasonality, promotions, viral effect)
5. Technical errors in the accounting system

Methods to prevent out-of-stock:

• Setting the reorder point - automatic order generation upon reaching the minimum level
• Safety stock - additional stock to compensate for fluctuations in demand and delivery times
• Multi-channel supply — working with multiple suppliers for critical goods
• Alert system — notifications when balances are critically low
• Trend analysis — monitoring seasonality and market trends
• Pre-order — the ability to place an order for a product that is temporarily out of stock

The optimal level of product availability (in-stock rate) for category A should be 98-99%, for category B – 95-97%, for category C – 90-95%.

Overstock risks

Overstock (overstocking) - excess inventory of goods that freeze working capital and create additional costs.

Consequences of excess inventory:

• Frozen capital — money invested in illiquid goods does not generate profit
• Storage costs — warehouse space rental, logistics, personnel
• Moral obsolescence — especially critical for electronics, fashionable clothing, seasonal goods
• Physical damage — for food products, cosmetics, medicines
• The need for sales - Reducing the price to eliminate the remaining balance reduces the margin

Indicators for overstock control:

Overstock Strategies:

1. Regular inventory audit - monthly analysis of idle goods
2. Dynamic pricing - gradual price reduction to stimulate sales
3. Cross-selling and bundles - bundling slow moving goods with popular ones
4. Return to supplier - under the terms of the contract for unclaimed goods
5. Sales and promotions - targeted measures to eliminate the remains
6. Alternative distribution channels — outlet, marketplaces, wholesale

Read more about availability control in Out of Stock: How to Stop Losing Customers Due to Out-of-Stock?

Expanding the product range: searching for new products

Expansion of the product range — a strategic process of adding new product lines to expand customer coverage and drive revenue growth.

Sources of ideas for expanding the range:

1. Search demand analysis

• Google Trends - Trend Tracking
• Google Keyword Planner - Search Volume Analysis
• Search suggestions – what users are looking for
• Internal Site Search - Unmet Customer Requests

2. Competitor analysis

• Competitors' bestsellers
• New in the category
• Products with high ratings and reviews
• Price niches not covered by your product range

3. Data on purchasing behavior

• Frequently viewed but not purchased items
• Support requests
• Customer comments and reviews
• Abandoned Cart Analysis

4. Marketplaces and aggregators

• Product ratings on international platforms:
  • For Ukraine: Rozetka, Prom.ua
  • For the EU: Amazon.de, Amazon.fr, eBay, Allegro (Poland), Bol.com (Netherlands)
  • For the US: Amazon.com, eBay, Walmart Marketplace
• High-demand categories
• Seasonal trends

Automated search for new products

Modern solutions allow for the automatic identification of promising products using machine learning algorithms:

• Parsing supplier price lists - automatic detection of new products
• Marginality analysis — selection of products with an optimal price-to-profit ratio
• Competitiveness assessment - comparison of your offer with the market
• Demand forecasting - assessment of sales potential of new items

For example, Elbuz automatic price list processing system Allows you to download price lists from suppliers, analyze new items, and automatically add promising products to your catalog based on specified criteria.

Criteria for selecting new products

1. Matching the store profile - the new product must fit into the positioning
2. Marginality — the minimum markup must cover costs and provide the target profit
3. Turnover — projected sales speed
4. Delivery terms — minimum order quantity, delivery times, return policy
5. Price competitiveness - your offer must be attractive
6. Quality and reputation - analysis of reviews, return rate

Stages of new product introduction

1. Test purchase — minimum lot to test demand
2. Creating a quality card — photo, description, specifications, SEO optimization
3. Promotional activities — announcement in the newsletter, social media, banners on the website
4. Sales monitoring — tracking the dynamics in the first 30-60 days
5. Scaling or deleting — decision based on test results

Regularly updating the product range (15-25% new items per quarter) increases the customer return rate by 30-40% and increases the average bill.

Details of the product range expansion process are described in How to automatically find new products in supplier price lists.

Managing product variations

Product variations — these are various modifications of one basic product, differing in color, size, material, configuration, or other parameters.

Why are variations needed?

• Convenience for the buyer - the ability to select the appropriate option on one page
• SEO effect - one page instead of many duplicates concentrates SEO weight
• Simplifying analytics — sales of all variants are counted as one product
• Reducing content costs - one description and photo session for all options

Types of variations

Strategies for managing residual variations

1. ABC analysis within variations

Determine which options (sizes, colors) sell best and prioritize their availability.

Example: For T-shirts, sizes M and L can account for 70% of sales, while XS and XXL account for only 10%. Accordingly, stock up on M and L sizes, and stock up on XS and XXL sizes in minimal quantities.

2. Matrix purchasing

Generate orders to suppliers based on historical sales structure data:

3. Dynamic display of availability

• Show actual balances for each variation
• Use Low Inventory Indicators to Stimulate Demand
• Provide notification of availability for missing variations
• Highlight available options visually

4. Cross-selling between variations

If the color or size you need is not available, please offer:

• Similar colors/sizes
• Similar products from other brands
• Pre-order available

Technical aspects

Data structure for variations:

• Parent product - a basic card with a general description
• Subsidiary products - each variation with a unique SKU
• Variation Attributes - color, size, etc.
• Individual balances - separate accounting for each variation
• Possibility of different prices — for variations of different configurations

Automation of variation management

Modern product range management systems allow:

• Automatically create variations when loading price lists from suppliers
• Synchronize inventory across all sales channels
• Generate orders to suppliers taking into account the sales structure by variations
• Analyze the effectiveness of each variation

More details about this can be found in the material How to manage products with different sizes, colors, and other characteristics.

Procurement Optimization: Automation and Planning

Procurement optimization — the process of determining optimal volumes and timing of product orders to maximize profits while minimizing purchasing and storage costs.

Key procurement management models

1. Fixed Order Quantity (EOQ) Model

The classic formula for calculating the optimal order size:

EOQ = √(2 × D × S / H), where:
D is the annual demand in units
S is the cost of placing one order
H is the cost of storing a unit of goods per year

Example: Annual demand for the product is 1200 units, order cost is €50, storage cost is €2/unit per year.

EOQ = √(2 × 1200 × 50 / 2) = √60,000 = 245 pcs.

2. Reorder Point

The inventory level at which a new order must be placed is:

ROP = (Average Sales Per Day × Delivery Time in Days) + Safety Stock

Example: Average sales are 10 units/day, delivery time is 7 days, safety stock is 30 units.

ROP = (10 × 7) + 30 = 100 pcs.

When the balance reaches 100 pieces, the system automatically generates an order.

3. Fixed order interval system

Orders are placed at regular intervals (e.g. every Monday) and the order volume varies:

Order quantity = Maximum stock - Current stock - Goods in transit

Calculation of safety stock

Safety stock protects against demand fluctuations and supply delays:

Safety stock = Z × σ × √L, where:
Z — service level coefficient (1.65 for 95%, 2.33 for 99%)
σ is the standard deviation of daily sales
L — delivery time in days

Purchasing strategies for different product categories

Working with suppliers

Supplier selection criteria:

1. Reliability of supply — percentage of orders completed on time (should be >95%)
2. Flexible conditions — possibility of ordering small quantities, fast delivery
3. Price and payment terms - competitive price, deferred payment
4. Product quality — percentage of defects and returns (<2%)
5. Technologicality — the possibility of electronic data exchange (EDI, API)

Automation of interaction with suppliers:

• Automatic download of price lists - updating prices and balances without manual labor
• Forming orders in the supplier format — export to Excel, XML, EDI
• Tracking order status — notifications of shipment and delivery
• Reconciliation of deliveries - automatic comparison of ordered and received goods

Procurement efficiency KPIs

• Fill Rate — percentage of customer orders completed without delays (standard >95%)
• Inventory Turnover — inventory turnover (the standard depends on the industry)
• Days of Supply — the number of days that current reserves will last
• Stockout Rate — percentage of time when the product is out of stock (should be<2% для категории A)
• Gross Margin Return on Investment (GMROI) - return on investment in inventories

System automatic processing of Elbuz price lists Integrates with accounting systems and allows for the complete automation of the procurement cycle: from inventory analysis to the generation of orders for suppliers.

Read more about procurement optimization in What are product bundles and how do they help increase the average order value?

Automation tools

Modern inventory management is impossible without automation. Manually processing hundreds and thousands of SKUs is too time-consuming and error-prone.

Key functions of automation systems

1. Price list management

• Automatic download of price lists from multiple suppliers
• Parsing data from various formats (Excel, CSV, XML, YML)
• Matching supplier products with your catalog
• Real-time price and inventory updates

2. Analytics and reporting

• Dashboards with key metrics (turnover, availability, marginality)
• ABC/XYZ-анализ с визуализацией
• Отчеты по эффективности категорий и поставщиков
• Прогнозирование спроса на основе исторических данных

3. Автоматизация закупок

• Расчет оптимальных объемов заказа
• Формирование заказов поставщикам по установленным правилам
• Контроль точек перезаказа
• Управление страховыми запасами

4. Синхронизация каналов продаж

• Единый учет остатков для сайта, маркетплейсов, офлайн-точек
• Автоматическое резервирование при оформлении заказа
• Предотвращение oversell (продажи больше, чем есть в наличии)

Типы решений

Критерии выбора системы автоматизации

1. Scalability — система должна расти вместе с вашим бизнесом
2. Integrations — возможность подключения вашей CMS, маркетплейсов, поставщиков
3. Ease of use — интуитивный интерфейс для ежедневной работы
4. Качество поддержки — оперативная помощь при возникновении проблем
5. Cost of ownership — не только стоимость лицензии, но и внедрения, обучения, поддержки
6. Flexibility of customization — возможность адаптации под специфику вашего бизнеса

Этапы внедрения системы автоматизации

1. Аудит текущих процессов — выявление проблемных зон и точек роста
2. Формирование требований — определение must-have и nice-to-have функций
3. Choosing a solution — сравнение альтернатив, пилотное тестирование
4. Data preparation — очистка и структурирование справочников, классификаторов
5. Настройка и интеграция — подключение систем, настройка правил и алгоритмов
6. Staff training — тренинги для сотрудников, создание инструкций
7. Запуск и мониторинг — постепенный переход, контроль результатов
8. Optimization — доработка на основе опыта эксплуатации

Правильно внедренная система автоматизации окупается в течение 6-12 месяцев за счет снижения трудозатрат на рутинные операции, уменьшения ошибок и оптимизации запасов.

Conclusion

Effective управление ассортиментом и запасами — это комплексная задача, требующая сочетания аналитического подхода, автоматизации и операционной дисциплины.

Key findings:

1. Используйте данные для принятия решений — ABC/XYZ-анализ, аналитика продаж, мониторинг KPI помогают выявить точки роста и оптимизации
2. Балансируйте риски — избегайте как дефицита востребованных товаров (out-of-stock), так и затоваривания неликвидом (overstock)
3. Регулярно обновляйте ассортимент — расширение ассортимента новыми перспективными позициями поддерживает интерес клиентов и увеличивает продажи
4. Автоматизируйте рутину — оптимизация закупок через автоматические системы освобождает время для стратегических задач и минимизирует ошибки
5. Дифференцируйте подход — разные категории товаров требуют разных стратегий управления запасами и закупками
6. Управляйте вариациями — грамотная работа с вариациями товаров (цвет, размер) улучшает пользовательский опыт и упрощает аналитику
7. Выстраивайте отношения с поставщиками — надежные партнеры с гибкими условиями — основа стабильного наличия
8. Мониторьте и оптимизируйте — контроль наличия и регулярный пересмотр ассортиментной матрицы должны стать постоянной практикой

Next steps

Начните с аудита текущего состояния:

• Проведите ABC/XYZ-анализ вашего ассортимента
• Оцените уровень out-of-stock и overstock
• Рассчитайте оборачиваемость по категориям
• Выявите узкие места в процессах закупок

На основе результатов разработайте план оптимизации и рассмотрите внедрение системы автоматизации, которая позволит масштабировать эффективные практики управления ассортиментом.

Современные инструменты, такие как платформа Elbuz, обеспечивают полный цикл автоматизации — от загрузки прайсов до формирования заказов поставщикам, помогая интернет-магазинам любого масштаба эффективно управлять ассортиментом и запасами.

Useful materials

• Как провести ABC-анализ товаров и понять, что приносит вам основную прибыль?
• Out of Stock: How to Stop Losing Customers Due to Out-of-Stock?
• How to automatically find new products in supplier price lists
• How to manage products with different sizes, colors, and other characteristics
• What are product bundles and how do they help increase the average order value?