Why can't I find the product id field in a Standard Report?
|Knowledge Article Number||000181271|
The Product ID field is not viewable or reportable in Standard Product Reports.
|Resolution||There are two workarounds for this scenario
1. Create a Custom Report Type for Products.
Please refer: Create a Custom Report Type for creation of Custom Report Type.
Now, click on the Report tab and click on New Report.
Go to the “Category” in which the custom report type is saved.
Select the report type and then click on Create.
In the Fields pane, type in Product and now you can drag and drop the Product ID field onto the report.
2. Create a custom formula field called Product ID with "Id" as the syntax. The return type of this field should be Text
You will be able to use this formula field in a standard Products report.