How can I find the inventory ID of a duplicate product?

Make an SQL query to the QSC_PRODUCTS_B table.

For more information on the table, search for QSC_PRODUCTS_B in the Tables and Views for Sales and Fusion Service guide.

You might also want to get a list of all products and product groups in your sales catalog. See How can I get a list of all products and product groups? for more information.