Community Add-Ons

This is only the file for the french traduction.

Place it in this folder :

admin/includes/languages/french/stats_products_per_month.php

This is only the file for the french traduction.

Place it in this folder :

admin/includes/languages/french/stats_products_per_month.php

Hi,

I had a problem where I was always having zeros in all the results, whichever products was chosen.

Added at the beginning of the file stats_products_per_month.php (this will get the product chosen variable when you click on Submit):

if ($HTTP_GET_VARS['prod_num']) $prod_num_chosen = tep_db_prepare_input($HTTP_GET_VARS['prod_num']);

just after:
if ($jahr_end == 0) { $jahr_end = date("Y"); }

Also changed the variable:$prod_num to be $prod_num_chosen in the line:

$products_query_raw = "select op.products_id, op.products_model, op.products_name, sum(op.products_quantity) as quantitysum , sum(op.products_price*op.products_quantity)as gross FROM " . TABLE_ORDERS . " as o, " . TABLE_ORDERS_PRODUCTS . " AS op WHERE op.products_id='$prod_num_chosen' AND o.date_purchased BETWEEN '" . $start_date . "' AND '" . $end_date . " 23:59:59' AND o.orders_id = op.orders_id GROUP BY op.products_id";

Then when I choose a product and click Submit, it shows the results.

Hope this helps,

Pierre Forget

I just modified the products query to select the appropriate language when creating the list of products.When having a multilanguage shop it was listing all the products in all the languages without filtering. Now it display correct product names :)
All creds to the author :)

I added a small modfication to this file, to add a drop down of all the products by name. Before this, it was displaying only the models, which might not very clear to everybody. The drop down box knows features both the name and the model. It is ordered alphabetically by name.

This is the full package.

Last zip file was empty for some reason...

A file was missing from the zip package...

I fixed the 1.2 version to used products_id instead of products_model to find products in the orders. products_model was troublesome because some of my products had a blank products_model, or the text changed over time. products_id is unchanging. This is a full package with the fix.

I've added friendly drop down list for the model names and fixed title of the report in English. Full package.

In the english language file for this contri, change
define('ENTRY_MODEL', ''Model: ');
to
define('ENTRY_MODEL', 'Model: ');

As well, included is a replacement file which leaves out the model number, and now allows you to search for products by their full name.

If you have changed product names in the past, they will not show up unless you search for their origional name.

Just replace the file catalog/admin/includes/stats_products_per_month.php with the included file.

small bug with missing "'" fixed. Complete Package with Screenshot.

I needed a report to get an overview about monthly sales of a single product to figure out the reorder-quantity for a certain period.

This stand-alone-tool shows you for a selectable product (by product_model) and a selectable period (in years) how many items of this product have been sold per month, per quarter and per year and additional the ammount.

Contains German and English language-files and Screenshot.