I agree with Everett, though I think you'd still want a template. Just don't put the [[*pagetitle]] tag in the template (or any other standard resource tags).
Use custom placeholders and set their values in the snippet:
$modx->setPlaceholder('MyPlaceholder', 'Some Value');
If the product table is set up for xPDO, you can also put the Product HTML with its placeholders in a Tpl chunk and do something like this:
$productData = $modx->getObject('modProduct', $criteria);
if ($productData) {
$fields = $product->toArray();
return $modx->getChunk('ProductTplChunk', $fields);
}
That will return the chunk, with all the placeholders replaced by values from the table row.