Community Add-Ons

Same version as below with a fix for the french localization of the spiffyCal JS component.

What's modified?
* fixed localizations:
* use of currency class, to use global currency settings (€, £, $)
* use of PHP server date/time format (fr_FR, en-EN, ...)
* fixed: code merging
* before: copy/paste had been used
* now:
* same code appears once
* sql requests have completely been rewritten
* sql requests have been speeded up
* html code renewed (html tags are now OK)
* better display of pages
* added: PHP file including functions only : stats_manufacturers_sales_functions.php
* added: some styles in "printer.css" and "stylesheet.css"
* added: possibility to see sold products :
* for all manufacturers
* by one manufacturer
* by all the customers of one manufacturer
* by every customers of one manufacturer
* by one customer of one manufacturer
* for each request, there is the possibility to print a simple page
* when listing products, there is now a link to the product detail
What's need to be fixed?
* french date format gestion with SpiffyCal


-------------------------

Installation instructions: the same as original package
Source page:
http://robertheath.net/installation-instructions/manufacturer-sales-report/

WARNING: french language included
=> use procedure of orignal french package to install

Updated French translation for this contribution.

Some users have experienced issues with the money_format function that is built into PHP. Windows and some versions of Linux do not support this function. money_format has been replaced with $currencies->format() which is built into osCommerce. This should also display results correctly if you are using a currency other than the US dollar as your default currency.

View sales and tax individually or combined

Integrated SpiffyCal for easier date range filtering

Rewrite of all logic to improve performance and simplify code

This is an updated version including new ReadMe.txt and screenshots.

Support: http://robertheath.net/archives/11
Screenshot: http://robertheath.net/wp-content/uploads/2007/05/screenshot.png

In this version you can view the sales report in a printer friendly window.
The report will show:
Store name,
Time when the report was made,
Report Period,
And the rest of the information that came before this version.

Things that could be done in the future:
Show total with both tax and without tax, at the moment you can only view without tax.

This is the unique Language file, translated in correct French.

Unzip and install.
FIle must be placed in :

/catalog/admin/includes/french/

Hi, thanks for this great contribution, here is the German translation for the administration language file. Only extract, folder structure is in the zip file.

Cheers

This version adds the ability to view a breakdown of products sold by manufacturer in addition to total sales by manufacturer as well as incorporating Fencer04's bug fix which fixes sql errors resulting from manufacturer names that contain a single quote.

If any of the manufacturers had a single quote in it the SQL query would throw an error. This has been fixed by replacing this single quote int eh query. I have reuploaded the entire package but the changes have only been made to the stats_manufacturers_sales.php file located in catalog/admin.

This is the entire package including updated ReadMe.txt and the missing language from the previous versions.

Minor cosmetic changes to stats_manufacturers_sales.php. Updated ReadMe.txt file includes missing installation steps.

The only change in this package is the Read Me file.

Display total items sold and gross sales by manufacturer with date range filter.