Adding Model Number to Reports

[margecc]

I am trying to figure out how to add the Product Model number to the stats_products_viewed.php and stats_products_purchased.php files.

[mc12345678]

Not sure at what stage the trouble is being had, but in $products_query_raw, after the select statement if you added:

p.products_model,

then the products model field would be available for use/display in the field area(s) below that.

Stats_products_purchased already displays the products_model information so, what is it that is to be done further with it? (default install of ZC 1.5.4 anyways)

Also there is the admin function:

zen_get_products_model($products_id);

which will look up the products_model information when provided the $products_id.

[margecc]

Not sure at what stage the trouble is being had, but in $products_query_raw, after the select statement if you added:

p.products_model,

then the products model field would be available for use/display in the field area(s) below that.

Stats_products_purchased already displays the products_model information so, what is it that is to be done further with it? (default install of ZC 1.5.4 anyways)

Also there is the admin function:

zen_get_products_model($products_id);

which will look up the products_model information when provided the $products_id.

Thanks for the (very quick) help. That made my life a lot easier. The trouble is that I only know enough PHP to make me dangerous. As for the Products purchased, I have an unaltered install and there is no model number on it. The ID's mean nothing to us since we use our internal model numbers.

[mc12345678]

Well I did look a little further as well, and didn't realize that on the products_purchased page the model only appears when a filter is applied... Guess that could be modified to always apply as an alternative. I had already exceeded the timeout and figured the discussion would lend itself to address the remainder. :)