Breakdown of Product Purchases

[greyhoundfriends]

I run a catalog for a non-profit organization and a large part of our sales are membership and donations. I can see the # of orders in the Best Products Purchases Screen under Reports. Does anyone know an easy way to separate the $ amount for certain items?

[♥mdtaylorlrim]

I run a catalog for a non-profit organization and a large part of our sales are membership and donations. I can see the # of orders in the Best Products Purchases Screen under Reports. Does anyone know an easy way to separate the $ amount for certain items?

I think I understand your question...I'll probably write the reply and read your question a couple of more time and think how much of an idiot I am...

 

In /admin/stats_products_purchased.php find this code:

 $products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id. "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name";

and change the 'order by p.products_ordered' to 'order by p.products_price'

 

May have to include the p.products_price in the select part also..

[greyhoundfriends]

I think I understand your question...I'll probably write the reply and read your question a couple of more time and think how much of an idiot I am...

 

In /admin/stats_products_purchased.php find this code:

 $products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id. "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name";

and change the 'order by p.products_ordered' to 'order by p.products_price'

 

May have to include the p.products_price in the select part also..

[greyhoundfriends]

mdtaylorlrim,

 

Many thanks for your informative response. However, I cannot figure out how to get into the stats area that you mention.

 

My admin area has these choices:

 

Configuration

Catalog

Modules

Customers

Locations / Taxes

Localization

Reports

Tools

 

The main page before admin has this box with stats (see below) but I cannot click to alter it

Statistics

Customers: 1106

Products: 207

Reviews: 2

 

If you are able to help that would be much appreciated! Thank you.

Dawn

[♥mdtaylorlrim]

mdtaylorlrim,

 

Many thanks for your informative response. However, I cannot figure out how to get into the stats area that you mention.

 

My admin area has these choices:

 

That's because the changes I mentioned is not in the admin section of the shop, but in the code in the php files that runs the shop. If you are not up to programming code changes then...

[greyhoundfriends]

That's because the changes I mentioned is not in the admin section of the shop, but in the code in the php files that runs the shop. If you are not up to programming code changes then...

 

 

Thanks, Mark. I will probably need to refer this one to our programmer....