Community Add-Ons

- Updated Installation to include steps for osC 2.3 (while preserving 2.2 installation instructions for those in need)
- Added clean install directions with changed files--- execute an add index function in mysql and upload files (for version 2.3) and you are done.

This is a full package!

Rebecca,

- Fixed error: 1054 - Unknown column 'p.products_cost' in 'field list'
- Fixed Profit % not was updated
- Fixed Estimated Inventory Value was not updated
- Added Total Value of Inventory
- Added Total Items in Inventory
- Highlighted clickable items
- Joined all Order Tracking by Country, by Zone, by Postal and by Status in 1 page
- Updated Tables format
- Cleaned up codes
(English version only. Needs to update more languages)

I updated and joined all the order_tracking files in version 2.9c into 1 single order_tracking.php file, so we can access all information in one page instead of change to different pages, and also cleaned up the codes to work properly with osCommerce v2.2.
I have tested the ORDER TRACKING v3.0 on osCommerce v2.2 all features, background, functions with all my best to ensure the released package is ready to use with minimal hassle.

This is a full package!

Andy,

Two significant new features added including monthly & yearly ship charge totals and monthly repeat visitor totals.

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.