Print this page

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.

promote demote