You do not need heavy software to follow this approach, though software makes it easier. Here is a routine that works in a small shop.
When stock arrives, record the part, the quantity, the supplier, the date, and the buying price.
When you set up a part for sale, enter the selling price from your current list for each customer type it applies to. Record any special pricing separately so it does not become the default for everyone.
When you write a quote, use the selling price from the list. If a number looks wrong, check the list before you guess or call the supplier from memory. A quick check now prevents a dispute later.
When the job closes, make sure the invoice shows what was installed and at what price. If a part was substituted or a special order was used, update the line before the customer sees the total.
Once a month, look at parts where the gap between buying and selling price has narrowed. Also look at parts with no movement for a long time, because they tie up cash even when the gap is healthy.
Once a quarter, compare the buying prices your suppliers charged with the buying prices recorded in your system. If they do not match, something was missed, either on the invoice or in the record. Fix the record and find out why it happened.
This routine does not need perfect data. It needs both prices recorded, a clear rule for which one goes where, and a habit of checking which one you are using before you commit it to a customer.