Unit and brand definitions are the fastest steps in the setup process. A few records are opened, just enough to get by are defined, and the real focus moves on.
Months later, when a brand-based report is requested, it turns out the same brand was recorded with three different spellings. The report shows three separate rows, and none of them reflect the truth.
In this article, we explained unit conversions, brand hierarchy, model structure, and the impact of these definitions on reporting.
Table of contents
Why is it important?
These definitions do not generate a transaction on their own; however, they form the foundation upon which every product card rests.
Inconsistencies in the foundation affect every report built upon it. A wrong unit skews inventory quantities; a messy brand makes analysis impossible.
Correcting these definitions later is also difficult, as thousands of product cards need to be updated.
Therefore, spending a short time during setup prevents weeks of cleanup work later.
Definitions are managed in the definitions module and linked to product cards.
Unit of measurement definition
Every product must have a base unit, and this unit is the measurement by which stock balance is kept.
When selecting the base unit, the measurement basis used for stock counting should be taken as reference. A product counted by piece in the warehouse should be tracked with the piece unit.
The unit list should be kept simple; unused units create a risk of errors during selection.
Consistency of abbreviations is also important; different spellings of the same unit fragment reports.
Changing the base unit later is almost impossible because it renders past movements meaningless.
Unit conversion
A product can be bought and sold in different units, which requires a conversion definition.
Buying in boxes from a supplier and selling in pieces to customers is a common scenario. If the conversion is defined, the system calculates the quantity automatically.
Entering the conversion factor correctly is critical; an erroneous factor directly distorts the stock quantity.
Coefficient changes also require caution; when the quantity per box changes, a new definition may be needed.
Conversion is even more critical for weight-based products; see the weighing and weighted barcode article.
Box and package structure
In wholesale and distribution businesses, the box structure is decisive on both the ordering and shipping sides.
Having the quantity-per-box information defined ensures that order quantities are rounded to the nearest multiple of a box.
The physical dimensions of the box should also be recorded; shipping cost and vehicle capacity calculations rely on this information.
Pallet structure can also be defined; it significantly facilitates planning in bulk shipments.
These dimensions are used directly in shipping cost calculations.
Brand definition
Brand should be kept as a separate definition in the product card, not as free text.
Free text inevitably generates different spellings, and brand-based reports become fragmented.
The management of the brand list should also be restricted to limited authorization; a structure where anyone can create a brand quickly falls apart.
Brand-based analysis is a valuable breakdown that feeds both sales and supply decisions.
Recording the supplier-brand relationship also simplifies purchasing planning.
Model and feature structure
Model definition is a layer that groups product families under the same brand.
In technical products, model-based analysis shows which family sells more. It also plays a critical role in spare parts management.
Feature fields carry the technical attributes of the product and are used in search and filtering.
Defining features as a selection list yields much more reliable results than free text.
Excessive feature definition, on the other hand, makes creating product cards difficult and fields begin to remain empty.
Relationship with category
Category and brand are two independent breakdowns and should not be confused.
Category shows what the product is, while brand shows by whom it is produced. When used together, analysis deepens.
The category structure can be hierarchical; however, the depth should be kept moderate.
A very deep category tree makes it difficult to find the right place when creating cards and produces erroneous assignments.
Three levels more than adequately meet the needs of most businesses.
Impact on reporting
The true value of these definitions is determining the breakdowns in which reports can be obtained.
A brand-based sales report can only be generated if the brand is defined. A field added later does not cover historical data.
Category-based margin analysis similarly relies on these definitions.
Therefore, which reports will be needed should be listed before installation. The definition structure is designed backwards from this list.
We covered the report reading approach in the report reading guide article.
Definition maintenance
Definition lists grow over time and become unusable if regular maintenance is not performed.
Unused definitions should be cleaned periodically; empty options generate selection errors.
Definitions that look similar should also be merged; the same brand opened with a different spelling should be consolidated into a single record.
Limiting the authorization to create new definitions reduces this maintenance burden right from the start.
Requiring definition requests to go through an approval process is a balanced solution for most businesses.
Points to consider
Keeping the brand as free text is the most common and hardest-to-correct mistake.
Choosing the wrong base unit also creates a problem that cannot be fixed later.
Failure to check conversion factors silently skews inventory quantities.
An overly deep category structure makes card creation difficult and leads to incorrect assignments.
Giving everyone the authority to create definitions quickly scatters the lists.
Frequently asked questions
Can the base unit be changed later?
In practice, it cannot be changed; past movements are recorded according to the old unit and lose their meaning.
How many units can be defined for a product?
Purchase, sales, and inventory units can be different; a conversion factor is defined for each.
Can the brand list be uploaded from an external source?
It can be uploaded; however, duplicate spellings must be cleaned up before uploading.
How is the structure set up for products with variants?
A separate setup is required; variant definitions you can check the article.
Unit, brand, and model definitions look minor, but they are the foundation upon which all reports rest. The short time spent during setup prevents weeks of cleaning up later.
Never keep the brand as free text; when there is no separate definition, the same brand gets recorded with three different spellings.
Also, choose the base unit according to the measure counted in the warehouse; changing it later is practically impossible.
Make sure to check conversion factors; an erroneous coefficient silently skews the stock quantity.
Keep the authority to create definitions limited as well; lists open to everyone quickly become unusable.
By consulting the EQLEM teamYou can set up your definition structure.