Community Add-Ons

Improvements made:
- removed the defined variable and replaced with the built-in OSCommerce currency functions to automatically show prices in the correct currency for each shop
- modified Manufacturers query to show all manufacturers if none are selected
- added search link to the search box to allow quick searches

Improvements made:
- created a defined variable in the language file for the money symbol.
- made it possible to view all years and/or all months
- improved the way the query string was generated (basically cleaned it up and minimized amount of code)
- sort by 'gross' was not working, so i fixed it

I was getting logged out then you have to enter your password with the below package upon choosing by dater ange, I dont know if this affects everyone, if it does use this one instead, simply replace stats_products_purchased.php in catalog/admin with this one.

or you can simply open up catalog/admin/stats_products_purchased.php and find (line 108):

<table border="0" align="left" width="100%" cellspacing="0" cellpadding="2"><?php echo tep_draw_form('date_range', FILENAME_STATS_PRODUCTS_PURCHASED, '', 'get'); ?>

ADD after:

<?php echo tep_hide_session_id(); ?>



Full package included..

Bugs Fixed by: Alexander Dimelow
Date: 05-Aug-2008
Website: http://oscommerce.web-project.co.uk/

Sorry for my english, but i'm French, someone can fix for php5 the contirubitons of insomniac2.

Thanks a lot0

This is based on the May 17th 2005 version by Blacktower. stats_products_purchased_v3

Added all the features from all the versions I think I have added .. except the date range feature.

Instead of the date range feature this uses a pulldown of the months and a year input for the search by date.

This version has the Manufacturer filter to.

Added a keywords field, so that you can filter the items displayed by product name or model #.
Also changed the upper case letters in the folders names.
Dave - Advancedstyle

This is based off the May 6th 2005 version, as reportedly the May 17th didnt work.

The May 6th contribution works. The May 17th contribution only generated a blank page.

There are no files with this contribution.

Updated Products Purchased Report

Added the ability to filter products purchased report by manufacturer/brand. The total number and value of the products purchased is also displayed.

A drop down menu allows you to choose which manufacturer's products to display.

Still able to filter results by date range as well

Updated language file in english only.
Installation is a simple subtitution of existing files.

variable 'TABLE_HEADING_MODEL' was not defined in Admin/Includes/English/stats_products_purchased.php which caused the variable name to be displayed on the result page rather than the variable value.

Added:

define('TABLE_HEADING_MODEL', 'Model');

Appologies in advance if my choice of Swedish translation for Model is incorrect.

Made all the hardcoded textstrings to entrys in the langugagefiles so complete translations is possible. Swedish language added

Took out some unneeded code. Changed the format of the gross column to display
only 2 decimal points. Added the total value of the gross column. This will
tell you the total gross sale number for the date range.

Added ability to view and sort by gross sales per item.

Changed the default report the start from day 1 of month, instead of current day.
Fixed problem with product links
Alternated background color of rows to make report easier to read.

Made the SQL query quicker, removed split results, and added a printable version.

Just replace the file admin/stats_products_purchased.php with the new one. Backup the file first so you can easily switch back if you do not like this.

This tool was designed to give smaller date range results, which is why I removed the split results.

Use at your own risk. Backup first. This works for me, but there is no guarantee it will work for you.

This report pulls information from orders_products instead of products to display what products have been purchased, and how many have been purchased. This report adds the option of specifying a date range, so that you can see how many of each product has been sold over a specific period of time.

Just replace admin/stats_products_purchased.php with the new file.

Support Thread: http://forums.oscommerce.com/index.php?showtopic=118737