Deep Vision

Auto parts store: analogs, cross-references and 7,000+ SKUs without confusion

How an auto parts store keeps thousands of SKUs, analogs and cross-references under control: sourced numbers, dead stock control and Timsoll's 18-branch case.

Published: 6 min read
Short answer: Auto parts inventory software has to keep thousands of part numbers in one database together with OEM numbers, analogs (cross-references) and vehicle fitment. Then a salesperson finds the right part and its interchange in seconds, stock is visible across branches, and dead stock is caught in time. In Odoo ERP this is built with codes on the product card, analog groups and inventory reporting.

A customer walks in: "I need front brake pads for a Nexia 3." The salesperson checks the shelf, then flips through a notebook, then calls a more experienced colleague. The original part is out of stock, but the warehouse holds an exact equivalent from another brand, filed under a different code. The salesperson does not know, and the customer walks to the shop next door. In the auto parts business this happens dozens of times a day. This article covers how to work with analogs and cross-references, how not to get lost among thousands of SKUs, and what automation changes in numbers.

What is the core problem in auto parts retail?

The core problem in auto parts retail is that a part with the same function exists under dozens of codes and brands, and the salesperson cannot link them together.

The market is growing. According to Uzbekistan's Statistics Agency, as of 1 April 2026 individuals owned 4,903.1 thousand registered vehicles, of which 4,552.3 thousand were passenger cars. The number of passenger cars grew by 344.6 thousand in a year (stat.uz, 2026). Every new car means future demand for filters, brake pads, shock absorbers and hundreds of other parts.

Catalogue complexity is even higher. TecDoc, a parts catalogue widely used in Europe, holds 12.8 million articles, more than 1,200 brands, more than 260,000 vehicle types and over 724 million part-to-vehicle links (TecAlliance). A single shop sells only a fraction of that, but even 7,000 SKUs is more than anyone can keep in their head.

What are OEM numbers, analogs and cross-references?

An OEM number is the original code the carmaker gave the part; an analog is a part from another brand that fits the same position; a cross-reference is the interchange table that links them.

In practice one fuel filter can have an OEM code, codes from three aftermarket brands and the supplier's internal part number. If each of these lives in the software as a separate product, problems follow:

  • Search only works on the exact code, so the analog stays invisible.
  • The same part gets bought twice because the codes differ.
  • Price comparison is hard: the salesperson does not know a cheaper analog exists.
  • Stock shows "none" while an analog sits in the warehouse.

We explain the difference between a part number and a SKU in what is a SKU.

How do you avoid getting lost among thousands of SKUs?

In a well-built system, each product card stores:

  • The main part number and brand.
  • A list of OEM numbers.
  • An analog group: all interchangeable parts are linked into one group.
  • Fitment: make, model, year, engine.
  • Stock in each branch and the date of the last sale.

The salesperson types any code, and the system shows the original, all its analogs, their prices and availability by branch on one screen.

A large share of auto parts orders comes by phone: a mechanic or a service station calls and asks for a part by VIN or model. If calls are not logged, nobody knows which request became a sale and which was lost with "out of stock". Deep Vision's own product dooCall tracks calls even on an ordinary phone, as described in our article on a call centre for your sales team. The list of requests the system could not match becomes a clear signal for the next purchase order. For selection criteria, see how to choose software for a shop.

How much money does dead stock tie up?

Dead stock is inventory that has not sold a single unit for a long time, usually 6–12 months, yet still ties up cash and shelf space.

In auto parts the problem is especially sharp: models age, analogs multiply, and a part customers asked for two years ago is no longer needed. Globally, IHL Group estimates retail losses from inventory distortion at $1.77 trillion: $1.2 trillion from out-of-stocks and $562 billion from overstocks (Chain Store Age, IHL Group). An auto parts shop often has both at once: the part you need is missing while the one nobody wants gathers dust.

When processes and reporting change, results change. Truck Parts & Service reports that the parts manager at Blaine Brothers cut aging inventory by 50% in about two years after putting tracking processes in place (Truck Parts & Service).

For example, take a shop holding 5 billion so'm of stock. If 20% of it has not moved for more than a year, 1 billion so'm is out of circulation. The figure is an assumption, but most owners cannot see their own number without an ERP report.

What changes after automation: in numbers

  • New product setup: at Timsoll, setting up a new product went from 6–8 months to 2–3 days (Timsoll case).
  • Aging inventory: after tracking processes were introduced, Blaine Brothers cut it by 50% in about two years (Truck Parts & Service).
  • Inventory levels: early adopters of AI-enabled supply chain management cut inventory by 35% and raised service levels by 65% (McKinsey, 2021).
  • ERP return: Nucleus Research found that every dollar spent on ERP returned $7.23 on average (Nucleus Research, 2014).
  • Lost sales: out-of-stocks cost global retail $1.2 trillion; showing analogs wins part of those sales back (Chain Store Age, IHL Group).

The Timsoll case: 18 branches and 7,000+ SKUs

Timsoll, an auto parts company from Kokand, is one of Deep Vision's public cases. The company runs 18 branches and more than 7,000 SKUs. After Odoo ERP went live, setting up a new product in the system went from 6–8 months to 2–3 days. For an auto parts business whose catalogue keeps growing, this is the number that matters: a new brand or a part for a new model is on sale in every branch within days. Read the full story in the Timsoll case.

How does Deep Vision approach this?

Deep Vision is an official Odoo Gold Partner in Tashkent. According to its Odoo partner page, the team has 7 Odoo-certified experts, most of its 24 client references are in wholesale, retail and manufacturing, and customer retention is 89%. Our team produced Odoo's Uzbek translation, which matters for sales staff in regional branches.

In the projects of Deep Vision founder Amon Olimov's team, auto parts shops often look the same: the catalogue lives in Excel and the analogs live in the head of the most experienced salesperson. In these companies we usually work like this:

  • Clean the catalogue: merge duplicates, split OEM and brand codes into separate fields.
  • Build analog groups and import them.
  • Set up a warehouse per branch and transfers between them.
  • Add a monthly dead stock report and markdown rules.
  • Connect our Didox module for e-invoices.

Standard Sales and Inventory often go live in 6–8 weeks; a full project takes 2–6 months. If you also sell wholesale, see Odoo ERP for wholesale. To discuss your case, fill in a brief or see our Odoo implementation service.

Frequently asked questions

How do you link analogs in Odoo?

In Odoo a product card can hold several codes and alternative products. For auto parts, an "analog group" and an OEM number list are usually added through a small customisation, so a search on any code shows the whole group.

Do we have to connect TecDoc?

No. Many shops work with their own catalogue and suppliers' cross-reference tables. Companies with a very large catalogue treat integration with an external catalogue as a separate project.

How do we see stock across branches?

Each branch is run as its own warehouse. Search results show stock in every branch, and the salesperson can create a transfer order right there.

Does the system find dead stock by itself?

Yes, the inventory report filters by the date of last movement. For example, a list of items with no sales in 180 days is produced automatically every month.

Is moving from 1C hard?

Moving the catalogue and stock takes preparation, but it is a standard process. We cover it in our guide to migrating from 1C to Odoo.

Sources

Want to bring order to your auto parts catalogue? Leave a brief or call +998 77 093 00 07.