Glossary (EDGEBIC)

What Is a Product Category in Manufacturing Software?

User Solutions TeamUser Solutions Team
|
5 min read

A product category is a named grouping applied to a product record that organizes the catalog for browsing, filtering and reporting, without changing how anything is routed or scheduled. It is the label that turns a flat list of several hundred part numbers into something a planner can read: raw materials in one band, sub-assemblies in another, finished goods in a third. In EDGEBIC by User Solutions the product list is grouped by category by default, so the categories you choose are the first structure anyone sees when they open the catalog.

How it works

Categories are maintained as their own small set of records and then assigned to products one at a time or in bulk. The category record itself is short:

FieldWhat it holds
NameThe label shown in the grid band and in the product form's dropdown
CodeA short, stable code for grids and exported files
DescriptionFree-form notes about what belongs in the band
ActiveWhether the category is still offered for new assignments

On the product form the Category dropdown assigns one of them, and a product with nothing assigned reads as no category. You can create a category on the spot from beside that dropdown, which matters more than it sounds: the alternative is abandoning a half-finished product form to go and define a band first, and the shortcut is what keeps catalog hygiene from becoming an interruption.

Once assigned, categories work in three places. The product list groups by category, so the bands can be collapsed and expanded to reduce a long catalog to the part of it you care about. A toolbar filter narrows the list to one category, with an all-categories option and a clear button to reset. And reports that group by category inherit the same structure, so the way the catalog reads on screen is the way it reads on paper.

What categories deliberately do not do is behave like rules. A category never restricts which work centers a product can use, never changes a promise date, never affects capacity. The scheduler reads a product's routing steps, the work centers those steps point at, and the hours each step consumes. Nothing in that chain consults a category. That is a feature: it means you can reorganize the catalog on a Friday afternoon with zero risk to Monday's plan.

Because there is no product type switch on the form, categories carry a second job. A product's real role comes from how it is used, and the category is where you make that role legible. See what is a procured item in manufacturing for the flag that pairs with the category on purchased stock, and what are bill of routing status buckets for the column that reports whether a product has a routing at all.

A concrete example

Watch the sample plant's catalog take shape and the categories arrive naturally rather than as an exercise.

The planner adds Widget-A first: product id Widget-A, unit of measure Each, sale price 120.00, rollup cost 48.50, a two-day delivery-ready tail. The category Finished Goods does not exist yet, so it is created from beside the dropdown in the same breath. Bracket-B follows into the same band at sale price 14.00 and rollup cost 10.00. Frame-S, a sub-assembly with a routing of its own but no sale price because it is never sold alone, goes into Sub-Assemblies. Steel-Plate-4mm, rollup cost 6.20, goes into Raw Materials with no routing planned.

Four products, three bands. The grid now shows three collapsible groups, and the routing status column reads Active BOR inside the first two bands once their routings are built, and No BOR inside Raw Materials, which is exactly right for a bought item. A planner who opens the catalog six months later, with two hundred rows in it, still reads the same three bands and still finds the mill part they were looking for inside the one that makes sense.

How EDGEBIC uses it

Category assignment travels with the product record everywhere. The categories window handles the set itself: create with a name and code, edit, and deactivate the ones that have outlived their usefulness. The product form assigns them, the toolbar filters by them, and the grid groups by them.

The bulk path matters for any catalog beyond a couple of dozen items. A product import mask maps your file's columns onto product fields once, including a category column, so a legacy type or class field in a spreadsheet becomes a proper category band on the first run and stays current on every run after it. Matching is by product id and is not case sensitive, and blank cells on an update preserve the existing value rather than wiping it, so a partial file can safely carry category changes alone. The mechanics of that are covered in what is an import entity type and what is an upsert in data import.

Column widths, grouping and filters are remembered per user, so a planner who prefers the catalog filtered to Finished Goods finds it that way tomorrow without re-applying anything.

Two habits are worth adopting. Keep the set small and honest, because a band that holds three products earns nobody anything. And name bands after how the shop talks, not after an accounting hierarchy, since the people reading the grid are planners rather than controllers.

The takeaway

A product category is cheap structure with real payoff: it makes a growing catalog navigable, it gives reports a natural grouping, and it costs nothing at scheduling time because it changes no behavior. Define three or four bands, assign them in bulk on the next import, and leave the routing and capacity questions to the fields that actually drive them. To see the grouped catalog in a working plan, explore EDGEBIC, and if you are arriving from the older Resource Manager lineage, the move from RMDB to EDGEBIC shows what carries across. For neighboring master-data terms, read what is a product id and what is a department in manufacturing.

Expert Q&A: Deep Dive

Q: Should I use categories or the procured flag to mark purchased parts?

A: Use both, because they answer different questions. The procured flag is a fact about the item: it is bought rather than made, so it will never carry a routing or consume capacity. The category is a label for how you want the catalog organized, and Raw Materials is the usual home for purchased stock. A planner scanning the grid reads the category band first because it groups dozens of rows at once, then reads the flag on the individual row. Neither replaces the other, and filling in both costs one dropdown per product.

Q: We inherited a catalog with no categories at all. Where do we start?

A: Start with three bands and resist the urge to be clever: Raw Materials, Sub-Assemblies, Finished Goods. That split maps onto how people already talk about the shop and immediately makes the grid navigable, because the list groups by category by default. Assign them in bulk through a product import rather than one dialog at a time, mapping your file's existing type or class column onto the category field. Refine later if a real reporting need appears; a fourth or fifth band added deliberately is fine, and twenty invented on day one is not.

Frequently Asked Questions

Ready to Transform Your Production Scheduling?

User Solutions has been helping manufacturers optimize their production schedules for over 35 years. One-time license, 5-day implementation.

User Solutions Team

User Solutions Team

Manufacturing Software Experts

User Solutions has been developing production planning and scheduling software for manufacturers since 1991. Our team combines 35+ years of manufacturing software expertise with deep industry knowledge to help factories optimize their operations.

Let's Solve Your Challenges Together