Difference Between Product ID and SKU in Magento 2

magento2productsku

What is the difference between Product ID and SKU in Magento 2?

Best Answer

Product ID

is an internal unique identifier of a product in Magento which corresponds to the product increment in Magento's database.

You can't set it manually because it is auto-incremented in catalog_product_entity table.

Product SKU

is also a unique product identifier, but it can be set manually by the administrator while creating a product and it shows on the frontend for customers to see, so they can reference the product by SKU.

SKU is also a product attribute, while Product ID isn't.

And it is often used for connecting products between ERP or commercial software and Magento web shops.

Related Topic