Community Add-Ons

v2.9c Reinstated English translation files and created Italian directory.

Complete Package from 2.9a/b

Geoffrey Walton

Fixed link on orders_tracking_countries.php:
Now when you limit per year or month you are not redirected the "zone" file anymore.

Complete package

Fixed todays and yesterdays sales. Previous version took the total # of orders yesterday and subtracted that from the current orders_id #. This caused it to incorrectly list todays and yesterdays sales # as oscommerce by default creates and deletes blank orders if a transaction fails hence the total # of orders may be 50 but the actual last order # from yesterday was 60 orders later because oscommerce deleted some of those orders. Now this is fixed.

PLEASE NOTE: Currently it does not hand days in which no orders have been placed properly. This needs fixed. Otherwise it works very well.

- Fixed repeat customers per year
- Readded estimated inventory value
- Changed % profit back to closer to national retail average (20%)

modified to fix repeat orders/customers code as per notice in install.txt

*NOT FULL PACKAGE

- only includes modified admin/orders_tracking.php

v2.8b (Steel Shadow)
- Fixed date error causing "Yesterday" info to not work since v2.7 came out
- Changed default profit rate from 30% to 60%

Added new report - Order Tracking by Country
Uses default currency as store currency
Incorporates SQL improvement from forum

included correct orders_tracking_zones.php file.

previous one was incomplete.

full package

Changelog:
===========
v2.7 (Jared Call)
- added Orders Tracking by Postal Code (with US zip lookup)
- Thanks to Luqi for sponsoring this feature
- simplified date code (old code still there, just commented)

Full package.

v2.6c (Jared Call)
- added Spanish translation
- added fix from form (Thanks, Young!) where stats would not show up for months with only one order

Fixed only the select queries in orders_tracking.php, so FROM orders became FROM " . TABLE_ORDERS . " and included the german language files.

as always, this is a full package.

There was an error in the readme regarding the MySQL statements that need to be used to add the indexes. Thanks to Young Tae Byun for pointing this out.

Changes from v2.5 to v2.6:

- Added tracking by current order status (Admin >> Reports >> Status Tracking).
-- This shows current database $$ totals (not just for this year) for orders in each order status. For example, if you currently have 20 orders in Pending status, for $20 each, status_tracking.php will show Pending :: 20 :: $400.
- Added MySQL indexes for better performance
- Apostrophes are now stripped in Zone names. This means that orders_tracking_zones.php now works for countries like M'Sila, Côte d'Ivoire, etc. (Thanks, Ted!)

Added configurable gross profit rate (as requested by Calvin the Flying Froogle Monkey)

Typo in install.txt fixed.

Update includes new report for showing orders by zone (as reported in the customers_state field in the orders table). Report can be limited to a particular month or year.

Forum topic starts about here: http://forums.oscommerce.com/index.php?showtopic=58506&view=findpost&p=428524 .

Added to support multi lingua, needs to improve but already aid. English and Portuguese of Brazil

formality: neglected to include proper header in admin/orders_tracking.php.

No actual code change, just giving credit where credit is due.

Changes:
- another fix for yesterday stats
- yesterday stats should now work on January 01
- fixed who's online bug introduced in v2.2
- to-do list moved to TODO.TXT

Known Issues:
- some code could certainly use some optimization
- repeat orders function not working properly. See readme for details.

Update the href links and made the Status query dynamicly, since hardcoding is a very bad solution.
Hardcoding is only smart for pure HTML pages. ;)
We are a 'little' further i hope with coding...
Still needs to be recoded completely but i like the idea so 2 thumbs UP for the original writer

- cleaned up variable names to make changes / enhancements easier to do
- fixed "yesterday" code to work properly on the first day of the month
- fixed typos in readme
- created and included orders_tracking.php language file rather than asking you to create it yourself
- added standard osC author/copyright /version info

- contrib now uses stylesheet
- added ability to select year
- now fits in osC admin pages
- fixed divide by zero errors
- improved date calculations
- improved daily average calculations
- improved per-month calculcations
- made most of the reported stats links to corresponding areas in osC admin


Thanks to Jello, Chris, and everyone else on the forums for helping make this happen!

See http://forums.oscommerce.com/index.php?showtopic=58506 for the official thread.

This package is a stand alone app to report on alot of stuff that osc does not repot. some features include:
Get total dollars in orders, Get total shipping charges, Get total number of customers, Get total number new customers today, Customers online, How many orders today total,
How many orders yesterday, How many repeat customers today total, Daily Averages, Close rate (how many customers sign up and then buy), what your total profit is, ..
plus alot more stuff... this is my first contrip so be easy on me.