Products » Here
Lokad osCommerce Sales Forecasting
Download: Version 2.0.4 (released 2007-05-30)
Open source PHP contribution for
osCommerce. This software requires a
subscription plan on Lokad.com to be fully functional.
If you keep too much inventory, your expenses go up.
But if you reduce too much, you have nothing to sell.
Features
- sales forecasting (daily, weekly, monthly forecasts), directly integrated in osCommerce or CRE Loaded.
- cut & paste your reports to Microsoft Excel.
- easy to deploy add-on (install & uninstall scripts provided).
Resources
3 ways to integrate sales forecasts within osCommerce
Lokad is actually providing 3 distinct methods to deliver sales forecasts for your
osCommerce application. In order to help to choose the method that is the most suited to your needs, the
pros & cons are described below.
| Methods | Pros | Cons |
| Safety Stock Calculator or Excel sales forecasting that connect to the MySQL database directly. | Most easy and straightforward solution. | The database must be remotely accessible. Each user (if there are several users) must setup Safety Stock Calculator or Excel Sales Forecasting on its own computer. |
Excel Sales Forecasting that connect to the LokadWebApiProvider. A custom script named lokadapi.php is installed on the osCommerce application. Within Excel Sales Forecasting, the LokadWebApiProvider is used to retrieve the sales history from the lokadapi.php script. | Easy solution with very limited impact on the osCommerce application. This solution works even if the osCommerce database is not remotely accessible (may happen in shared hosting environments). | Each user (if there are several users) must setup Excel Sales Forecasting on its own computer. |
| Lokad osCommerce (see here above for download). Complete add-on for the osCommerce application. This add-on includes several PHP scripts; it should be deployed and configured within the osCommerce application. | Most complete integration with the osCommerce application. All the users are sharing the same application (can be useful if the merchant and the webmaster are not the same persons). | This add-on requires a bit more CPU / memory resources than what is usually provided in shared hosting environments. In particular, some scripts may be killed by the web server if the PHP execution timeouts are too short. |
Special thanks
- Harald Ponce de Leon for his feedback and coding advice.
- Pavel Boiko for his development contribution.