• US: +1 (716) 989 6531

Demand, Sales and Workload Forecasting Software

osCommerce setup for Lokad Desktop Sales Forecasting

Products » Desktop Sales Forecasting » Here

osCommerce setup for Lokad Desktop

There are several ways to integrate Lokad in your osCommerce applications. This page is describing the two ways that can be used for either Lokad Desktop Sales Forecasting a regular windows application, or Lokad Excel Sales Forecasting an Excel add-in.

OsCommerceProvider (usual case)

If your hosting provider for your osCommerce application let you remotely access to your osCommerce database, then we strongly suggest to go through the usual steps for Lokad Desktop Sales Forecasting using the OsCommerceProvider. You will need to enter the connection string of your MySQL database into the settings panel of Lokad Desktop Sales Forecasting.

Sample connection string: Server=myServer;Database=myDB;Uid=myId;Pwd=myPwd; (MySQL)

LokadWebApiProvider (restricted hosting)

If your hosting provider for your osCommerce application prevent any remote access to your osCommerce database, then we propose a slightly different approach that relies on small PHP script named lokadapi.php. Lokad Desktop Sales Forecasting will connect to lokadapi.php instead of connecting to your database.

Warning: lokadapi.php gives access to your sales data. You probably don't want this data to be publicly accessible on the Internet. We strongly advise you to restrict the access to this script with a .htaccess file (basic network authentication). The following steps explain how to proceed. You might check this guide for more information about .htaccess.

  1. Download lokadapi.php and copy lokadapi.php into the /catalog/admin folder of your osCommerce application.
  2. Create (possible update if they already exists) .htaccess and .htpasswd files in /catalog/admin. You can use the sample files lokad.htaccess and lokad.htpasswd.
  3. Update the .htpasswd file with a line containing username:passwordHash. You can use http://myks.org/utilities/htpasswd.php to create the password hash.
  4. Download and install Lokad Desktop Sales Forecasting.
  5. Run the Lokad Desktop application and go to the Settings panel.
    1. Define the application as the LokadWebApiProvider.
    2. Define the Connection string as the URL of your lokadapi.php script (usually it's http://www.yourstore.com/catalog/admin/lokadapi.php).
    3. Define the Application option as username:password that you have defined in your .htpasswd file. The password should be provided here in its clear (non-hashed) form.

Note: When choosing the password, remember that it will be sent in clear form to the server: do not choose a password that is too important for you.