In summary. The ABC cycle counting method divides the catalogue into three groups according to turnover and value, and assigns a different counting frequency to each throughout the year. Odoo manages the classification, schedules the counts, allows them to be executed with a scanner from a mobile device, and records each adjustment in an audited manner. The result is continuous stock control without massive shutdowns and with complete accounting traceability for Spanish SMEs.
Annual inventory is the great enemy of retail in Spain. Two days closed, the whole team counting boxes, and in the end, discrepancies appear that no one expected. There's a better way to do it: cycle counting with the ABC method. And Odoo solves it without the need to close the shop.
The ABC method allows Spanish SMEs to count only what's necessary each week, reducing inventory errors and improving business profitability.
Why annual inventory no longer works in retail?
The traditional inventory model in retail has a structural problem: it concentrates all effort into one or two days a year. During that time, the shop closes, the team works under pressure, and errors multiply. When the count finishes, the discrepancies are so large that it's difficult to know if they come from theft, poor goods reception, or errors from the previous year.
Furthermore, annual inventory doesn't offer continuous visibility. If a fast-moving product has systematic shrinkage, you don't discover it until you've been losing it for twelve months. For a Spanish SME with tight margins, that delay can be very costly.
Cycle counting resolves this by distributing counts throughout the year. There's no D-day. There are small, frequent, and organised counts that keep stock aligned with reality without interrupting daily operations.
Odoo, as an integrated management platform, incorporates this methodology natively. There's no need to add external tools or export data to spreadsheets. Everything happens within the same system that already manages sales, purchases, and accounting.
What the ABC method is and why it's the standard in retail?
The ABC method is a classification of catalogue products into three groups according to their importance to the business. The logic comes from the Pareto principle: a minority of products generates the majority of the value. That's why it doesn't make sense to count all products with the same frequency.
The usual classification works like this:
- Class A: the group of products with the highest turnover or highest economic value. They represent approximately 20% of the catalogue but generate close to 80% of sales. They are the ones that pose the highest risk of discrepancy.
- Class B: the next segment. Around 30% of the catalogue, with medium turnover and relevant contribution to margin. They deserve periodic attention without being absolute priorities.
- Class C: the long tail of the catalogue. The remaining 50% of products, with slow or occasional movement. Their individual impact is low, but collectively they can represent a lot of tied-up capital.
This classification isn't static. A product can move from C to A due to a seasonal campaign, and return to C when it ends. That's why periodic review of the classification is part of the process, not a one-off task.
In the Spanish context, where many retail SMEs operate with catalogues containing several thousand references, the ABC method is especially useful. It allows the control effort to be focused where it truly matters.
How to classify the catalogue in Odoo?
Odoo allows you to assign the ABC class to each product manually or by relying on the sales data already held by the system. For a business that has been using Odoo for some time, the second option is the most efficient: the stock movement and sales history is already there.
The classification process starts with turnover analysis. Products are ordered by volume of outflows over a representative period, for example, the last twelve months, and the class is assigned based on the percentile each one falls into. Odoo facilitates this analysis from its inventory and sales reports.
Once the class is assigned, it's recorded on the product's data sheet. From that moment, when creating an inventory count, the system can filter by class and generate differentiated work lists for each group.
Some practical criteria for classification in Spanish retail:
- Use real data from the last twelve months as a basis. If you have marked seasonality, weight the strong months.
- Review the classification at least twice a year, before peak season periods.
- Don't classify solely by units sold. Combine volume with unit margin so that high-value products are well represented in Class A.
- Newly added products start in Class B by default until they have sufficient history.
How to schedule cycle counts in Odoo?
Once the catalogue is classified, the next step is to establish the counting frequency for each class. The usual recommendation in retail is as follows:
- Class A: monthly count. These products cannot go without review for more than thirty days.
- Class B: quarterly count. Sufficient to detect discrepancies without overloading the team.
- Class C: half-yearly count. January and July are good times to reconcile the long tail of the catalogue.
This frequency is indicative. Each business can adjust it according to its volume, team structure, and stock criticality. The important thing is that it is systematic and does not depend on anyone's memory.
Odoo allows you to create scheduled inventory operations with the products corresponding to each class. Thus, on the day of the count, the team doesn't have to decide what to count: the list is already prepared. It just needs to be executed.
Some operational recommendations for scheduling:
- Assign Class A counts to times of lower commercial activity within the month, such as the early hours of the morning before opening or first thing on Mondays.
- Avoid scheduling Class B or C counts during campaign weeks or peak season.
- Designate a clear person in charge for each count. Traceability matters.
- When the Class A count coincides with a Class B or C count in the same period, group them to avoid duplicating movements around the warehouse.
How to perform the count with a scanner from a mobile phone?
This is where Odoo makes a difference compared to manual processes. The code-reading application integrated into Odoo allows physical counting from any mobile device or tablet with a camera, or with a standard range Bluetooth scanner.
There's no need to invest in industrial warehouse terminals or proprietary hardware. A desktop or handheld scanner from common brands in the Spanish market connected to a tablet is sufficient for most shops.
The workflow during the count is simple:
- The operative opens the day's inventory operation on the device.
- Navigates to the physical location in the warehouse or shop that needs counting.
- Scans the code of each product found in that location.
- Enters the physical quantity found.
- The system compares it in real time with the theoretical stock recorded.
- If there is a difference, it is marked for immediate review or adjustment.
This process eliminates paper, reduces transcription errors, and allows two people to work in parallel on the same count from different areas of the warehouse without getting in each other's way.
For shops with multiple points of sale or warehouses, Odoo manages locations separately. The count can be organised by location, making it easier for each area manager to be responsible for their area.
How to manage discrepancies and adjust stock?
Once the count has been performed, Odoo compares the recorded physical quantities with the theoretical stock and shows the differences. Here comes the most valuable part of the process: understanding why there's a discrepancy and recording it correctly.
Odoo allows each stock adjustment to be closed with a reason. This is not a minor detail: it's what turns cyclical inventory into a real management tool, not just product accounting.
The most common adjustment reasons in retail are:
- Shrinkage: natural deterioration of the product, especially in food or perishable goods.
- Theft or pilferage: unjustified differences that point to unknown loss.
- Receiving error: product that was incorrectly counted upon receipt.
- Unregistered return: merchandise returned that went back into stock without going through the system.
- Previous count error: correction of a discrepancy originating from a poorly executed prior inventory.
Recording the correct reason is fundamental for subsequent reports to have value. If all adjustments go into a generic category, you lose the ability to detect patterns.
For example: if in the monthly Class A counts the same product always appears with fewer units than expected, that pattern indicates a systematic problem. It could be pilferage at a specific point on the shelf, a fault in that supplier's receiving process, or that the sales process is not properly recording outgoing items. Without recording reasons, that pattern does not emerge.
Reporting, traceability and accounting compliance
Well-executed cyclical inventory in Odoo generates a complete history of all counts: what was counted, when, who did it, what differences appeared, and what adjustments were applied. This history has value on several levels.
From an operational point of view, it allows identifying trends and making decisions. If a Class A product shows recurrent shrinkage, you can act before the economic impact becomes significant.
From an accounting point of view, the audited record of stock adjustments is necessary to justify inventory variations in the accounts. In Spain, accounting regulations require stock variations to be documented. Odoo complies with this automatically: each adjustment generates the corresponding accounting entry if the company's configuration requires it.
For a review by the management consultancy or the Tax Agency, having a detailed history of cyclical counts is much more robust than a single annual inventory without intermediate traceability.
For SMEs operating with multiple warehouses or shops, Odoo consolidates all information in a single place. There's no need to cross-reference files from different systems or manually reconcile data.
Integration with the rest of the operations
An important advantage of managing cyclical inventory within Odoo is that stock is always connected to the rest of the business. Inventory adjustments affect the availability of products at the point of sale, automatic replenishments, and purchasing reports in real time.
If, after a Class A count, you adjust a product's stock because there were fewer units than expected, the system automatically updates the availabilities. If that product had a replenishment rule, it can automatically generate a purchase order to cover the established minimum.
This integration is what distinguishes Odoo from managing inventory in a separate tool or in spreadsheets. There is no need to manually synchronise anything because everything resides in the same system.
What are the common mistakes when implementing cycle counting in retail?
Implementing the ABC method without the correct foundations can generate more confusion than benefit. These are the most common mistakes we see in Spanish SMEs when starting with cycle counting:
- Classifying by intuition instead of by data. Class A products are not those the owner believes are important. They are the ones that sales and turnover data confirm to be important.
- Never reviewing the classification. The catalogue changes, demand changes, and seasons change. A classification made once and never reviewed loses its usefulness within months.
- Counting without recording the reason for adjustments. Adjusting stock without documenting the reason eliminates the analytical value of the process.
- Assigning the count to whoever is available instead of a fixed responsible person. Traceability requires each count to have a clear owner.
- Mixing cycle counts with ad-hoc urgent adjustments. If a specific problem arises with a product outside the usual cycle, it should be managed as an extraordinary adjustment, not contaminating the record of the scheduled cycle count.
- Not adapting the frequency to the real business. A too ambitious frequency that the team cannot sustain is worse than a more spaced-out but consistently met frequency.
Frequently asked questions
Is the ABC method only for large warehouses?
No. The ABC method scales perfectly to small shops. In fact, a stationer's or a hardware store with a few thousand references benefits particularly because Class A counts are manageable in time and effort. The key is that the classification is correct, not that the catalogue is large.
Can I do the count without closing the shop?
Yes, and that is one of the great advantages of cycle counting. Counts can be done before opening, during periods of low activity, or in areas of the warehouse that do not affect customer service at that moment. Odoo allows working on the count while the rest of the operations remain active.
How do discrepancies affect the SME's accounting?
In Odoo, when an inventory adjustment is validated, the system can automatically generate the corresponding accounting entry. This keeps physical stock and accounting aligned without manual intervention. For the accounting firm and for the closing of the financial year, having this continuous record greatly simplifies the work.
Do I need specific training for the team to perform the counts?
The learning curve for scanner counting in Odoo is short. An operator without prior experience can learn the basic process in one session. What requires more preparation is the initial system configuration: the ABC classification, replenishment rules, and adjustment reasons. That part is managed by the implementer along with the warehouse manager.
What if a very large difference appears during the count?
Odoo allows for scaling the validation of large adjustments. It can be configured so that adjustments exceeding a certain threshold require manager approval before being applied to the stock. This prevents an isolated counting error from generating an incorrect accounting adjustment without anyone reviewing it.
Can the ABC method be applied to a shop with online sales in addition to physical sales?
Yes. If you have the online channel integrated into Odoo along with the physical shop, stock movements from both channels feed the same information. The ABC classification reflects the actual product turnover regardless of the channel through which it was sold. This is especially relevant for retailers who manage a single warehouse for both channels.
Can cycle counting become a real competitive advantage?
Well-implemented cycle counting is not just an operational improvement. It is a competitive advantage. A business that knows its real stock at all times makes better purchasing decisions, detects problems sooner, and does not discover surprises at the financial year-end.
For a Spanish retail SME, where capital tied up in stock is one of the biggest costs, having continuous visibility over inventory is directly money. Fewer stock-outs for Class A products, less immobilisation in Class C products that do not turn over, and fewer losses due to shrinkage or theft not detected in time.
Odoo provides all the necessary tools for this in a single system. ABC classification, scheduling of counts, mobile scanning, and audited record of adjustments do not require additional developments or complex integrations. It is native, ready-to-use functionality.
If your shop still relies on annual inventory or you manage stock in a separate tool from the rest of the business, it's time to consider if that model is still sustainable.
The next step is to analyse your specific situation: catalogue size, team structure, and maturity of the current process. From there, the implementation of cycle counting in Odoo adapts to what your business needs, not the other way around.
Indicative information. Actual timelines, costs, and scopes are confirmed after a personalised analysis. JLM Business Solutions SL · B16842831.
Frequently asked questions
Is the ABC method only for large warehouses?
No. The ABC method scales perfectly to small shops. A stationer's or a hardware store with a few thousand references benefits particularly because Class A counts are manageable in time and effort. The key is that the classification is correct, not that the catalogue is large. Odoo allows managing catalogues of any size with the same logic.
Can I do the count without closing the shop?
Yes, and that is one of the great advantages of cycle counting. Counts can be done before opening, during periods of low activity, or in areas of the warehouse that do not affect customer service at that moment. Odoo allows working on the count while the rest of the operations remain active, without interruptions in sales or customer service.
How do inventory adjustments affect the SME's accounting?
In Odoo, when an inventory adjustment is validated, the system can automatically generate the corresponding accounting entry. This keeps physical stock and accounting aligned without manual intervention. For the accounting firm and for the closing of the financial year, having this continuous and audited record greatly simplifies the work and reinforces documentary robustness against any review.
What if a very large difference appears during the count?
Odoo allows configuring staggered validation workflows. Adjustments that exceed a certain threshold may require manager approval before being applied to actual stock. This prevents an isolated counting error from generating an incorrect accounting adjustment without prior review. The level of control is configurable according to the needs of each company.
Do I need special hardware to perform the counts with Odoo?
It is not necessary to invest in industrial terminals. A standard-range Bluetooth scanner, from common brands in the Spanish market, connected to a tablet or mobile is sufficient for most shops. Odoo is compatible with the most common models on the market. For very large catalogues or warehouses with high turnover, more robust hardware may be considered, but it is not the general rule.
Can the ABC method be applied if we have a physical shop and online sales?
Yes. If the online channel is integrated into Odoo along with the physical shop, stock movements from both channels feed the same base information. The ABC classification reflects the product's actual turnover regardless of the sales channel. This is especially useful for retailers who manage a single warehouse for both channels and need unified visibility.