Skip to main content

Parts categories: how to set them up and report on them

Organize parts into categories and subcategories in EasyTruckShop, then see margin by category on Part Revenue and stock value by category on Inventory Value.

Written by Vladimir

What parts categories are for

Categories let you group your parts — filters, tires, brakes, electrical — so you can answer questions about a whole product group instead of one part at a time. "What is my margin on filters?" and "how much money do I have tied up in tires?" both need categories set up first.

Each part belongs to one category, or to none. Parts with no category are gathered under Unassigned.

Where categories live

  1. Click Parts in the top menu bar.

  2. Click the Categories tab. It sits between Inventory and Locations.

The left sidebar shows your category tree, starting with All Parts and Unassigned. Clicking any category filters the part list on the right to just that category. A category with a + beside it has subcategories inside it — click the + to expand.

The Parts Categories page in EasyTruckShop, with the category tree in the left sidebar and the filtered part list on the right.

How do I create a category?

  1. Go to Parts > Categories.

  2. Click the small category icon to the right of the sidebar search box. The Create new Category box opens.

  3. Type a Name.

  4. To nest it inside an existing category, switch on Make this a Subcategory and pick the parent.

  5. Click Create.

That is the whole thing — a name and an optional parent. There are no other settings on a category.

How do I put parts into a category?

Two ways:

  • From the part. Edit the part and choose its category.

  • From the Categories page. Each part row has a drag handle on its left. Drag a part onto a category in the sidebar to move it there. Tick the checkboxes to select several parts at once.

You can change a part's category at any time. Existing parts can be categorized whenever you get to it — you do not have to do it all at once.

Where categories actually show up in reporting

This is the payoff, and it is worth being precise about which screens do it. There are three, and no others.

Question

Where to go

What is my margin by category?

Reports > Part Revenue, then Grouped by > Category. You get Revenue, Cost, Profit and Margin per category. This is the only screen in EasyTruckShop that reports profitability by category.

How much stock value is in a category?

Reports > Inventory > Inventory Value, then the Categories filter. The value cards and the parts list narrow to that category.

Category detail, line by line

Reports > Sales > Export > Product List. The file has a Part Category column beside Cost, Total Cost, Price and Profit — pivot on it in Excel for anything the two screens above do not give you.

The Sales report does not group by category. Its Group by list is Customer, Customer Group, Ownership, Sale Type, Vehicle, Vehicle Type and Invoice. For revenue by category, use Part Revenue grouped by Category, or the Product List export.

What permission you need

Creating and editing categories needs permission to manage parts. Seeing the cost, profit and margin figures on the Part Revenue and Inventory Value reports needs View Prices, Costs and Usage as well as access to Reports — without it those columns come out blank.

Designing your categories

  • Start broad. Filters, Tires, Brakes, Electrical. Add subcategories later once you can see what is worth splitting.

  • Design them around the question you want answered. If you want to know your margin on tires, "Tires" needs to be one category, not spread across three.

  • Keep the naming consistent so the report rows read cleanly.

  • Do not over-nest. Two or three levels is usually enough — the reports group by the category a part is actually assigned to, so very deep trees just make thin rows.

What categories do not do

  • A part cannot be in two categories. One category per part, which is what keeps the reports from double-counting.

  • There is no category filter on the Sales report. See the table above for where to go instead.

  • Categories do not affect pricing. They are for grouping and reporting only — markup comes from your part price matrix.

  • Categories are not locations. Where a part sits on the shelf is the Location field, on its own tab.

  • Uncategorized parts are not hidden. They collect under Unassigned and still count in your totals.

Accounting words and what they are called in EasyTruckShop

What your accountant says

What EasyTruckShop calls it

Product line / product group

A category

Product line profitability

Part Revenue > Grouped by > Category

Inventory valuation by product line

Inventory Value with the Categories filter set

Uncategorized / miscellaneous

Unassigned

Cost of goods sold by product line

The Cost column on Part Revenue grouped by Category

Other ways shops ask this question

  • "How do I group my parts?" — Parts > Categories, then create a category.

  • "What is my margin on filters?" — Reports > Part Revenue, Grouped by Category.

  • "How much do I have tied up in tires?" — Reports > Inventory > Inventory Value, set the Categories filter.

  • "Which category sells the most?" — Reports > Part Revenue, Grouped by Category, sort by Revenue.

  • "Can a part be in two categories?" — No. One each.

  • "Where did my uncategorized parts go?" — the Unassigned entry at the top of the sidebar.

  • "Can I see sales by category on the Sales report?" — no, the Sales report has no category grouping. Use Part Revenue grouped by Category.

Video walkthrough

A short recording showing how to create a parts category and move parts into it in EasyTruckShop.

Still need help?

Start a chat with us from inside EasyTruckShop and tell us how you want to group your parts and what you are trying to measure. We will help you lay the categories out so the reports come out the way you need them.

Did this answer your question?