On the product detail page, you need to configure the product recordset to filter the product_id column on the product_id query string value.
in the server behaviors panel of the product detail page, double click the product recordset.
In the filtering section, select the product_id column and set it to filter that column being equal to the product_id query string variable.