Skip to main content

ABC analysis report

Categorize your products by pick frequency and optimize your warehouse layout.

The ABC analysis report categorizes your products based on how often they are picked. A products are your most important products that are picked the most, while C products are picked the least. Use this report to optimize your warehouse layout and place your most important products in the most accessible spots.

See ABC analysis for a detailed explanation of how the categorization works and how to organize your warehouse based on the results.

What do you see per product?

Column

Description

Title

The name of the product

EAN

The product's EAN code

SKU

The SKU number

ABC category

A, B or C

Pick frequency

The number of picks over the past 90 days

Cumulative percentage

Where the product falls in the cumulative pick distribution

Available stock

The current quantity in stock

Summary

At the top of the report you see a summary per category:

Metric

Description

Number of products

How many products fall into each category

Number of picks

The total number of picks per category

Percentage

What share of all picks each category represents

Shifts

The report also shows which products have recently changed category. For example, a product that moved from B to A because it was picked more often during the past period. This helps you keep your warehouse layout up to date.

Filtering

You can filter by ABC category to view only products from a specific category. This way you can, for example, show only your A products to check whether they are placed in the right locations.

Good to know

  • The analysis looks at the pick frequency of the past 90 days.

  • If you use pick lists, picks are used. Otherwise, how often a product appears in orders is used.

  • The analysis is updated automatically every night.

  • It is about how often an employee has to walk to a product, not about the number of units that are picked.

Last updated on

Job Jenniskens

Written by

Job Jenniskens, Founder

Started ShopLinkr from his own webshop. Still builds on the platform every day and knows every corner of the code.

LinkedIn

Still have questions?

We are happy to help. Send a message or book a call.