A Items Mnufacturer Part Number how to add or apply

Hello, I am new to ERPNext so my apologies if the question is simple…
I am trying to understand the difference between the fields “Item ID” and “Item Code”.
In my current use, I use the Item ID as my internal SKU number (123456).
The name of the item “Widget” and the Brand “BestWidgets”
What I am in need of is having a specific manufacturers part number of that item.

I preemptively entered it into the Manufacturing module, but the item is not used for manufacturing it is sold in retail and distributed.

I am trying to determine if I should be populating an “Item Code” for the manufacturers Part Number or a different field?
Can anyone offer me some guidance?

I am trying to

I think you are free to use the fields as you wish.

ERPNext can be used in so many types of organizations.

Consider the visibility of this field and if you’d want to expose a manufacturer part number (enticing your customers to buy directly and eliminate your company from the transaction).

I think some may use Item ID as a SKU or part number while using Item Code as a more text based (searchable string or abbreviations of Item Name or Description).

1 Like

Thank you.
In my industry many shop specifically by the original part number of the manufacturer. For items that are my own house brand I use a “private” coding intentionally.

What I am confused on is that I want my internal item ID in a series like “BIZ123456” but I want an “Item Code” to be something else.
On extraction, and in the item list setting - it seems that they are one in the same?

All records have a unique identifier. In Frappe this is called ‘name’ in the database table and it is labeled as “ID” in list format. This field is generally automatically created by a nameing series or naming rule per doctype. You can however manually
create the ID by setting as “prompt user”.

Table columns for Item"
name, item_name, item_code are unique fields. They translate to “ID”, “Item Name”, and “Item Code” respectively in the front end.

By default, the item_code will be used to create the unique ID in the naming rule (which is the table column = name, and the ID field in list view).

If you set the naming as “user defined” you’ll be able to create unique values for (item_name, item_code, and ID).

After changing the nameing settings, you’ll be able to export ID, and Item Code separately.

Change the naming setting by “Customize Item”

one-b

Now creating a new item will allow you to enter the ID in the “name” field.
two

When you export, you’ll see the ID field is now available.

1 Like

This was helpfull beyond so many levels. Thank You!
I just was not wrapping this stuff around my head at all, and this has opened allot of doors for me.