For video tutorials, you can visit YouTube.com and type in osCommerce.

Here is a quick search of some video tutorials from YouTube.

Fantastico Upgrade:

The Fantastico upgrade procedure is quite straight forward. All you need to do is login to cPanel -> Fantastico -> OS Commerce and click the Upgrade link. However, please note that besides Fantastico performs automatic backup it might get corrupted if the size of your website is too big. Thus, it is best to manually create backups of your OS Commerce installation prior to attempting the upgrade. Please note also that the automatic backup is only possible for the most recent OS Commerce versions after 2.2 RC1. For previous versions you should refer to the manual upgrade instructions.

To back up the osCommerce files to your computer please, use an FTP client to connect to your account. Then navigate to your osCommerce application folder and download it to your local computer.

Manual Upgrade:

The latest osCommerce versions include specific upgrade instructions in the “upgrade.html“ file for the installation package. Unfortunately the procedure varies depending on the current  version of OS Commerce you are running and different steps have to be accomplished. We strongly recommend to create a backup of your website before you initiate the upgrade procedure.

First, you need to know of what does your store consist and what should be backed up and restored. Usually sites are composed of files and databases. You should take care of them all if you want to have your site exactly the way it has been before.

How to Backup/restore your osCommerce files?

To back up the osCommerce files to your computer please, use an FTP client to connect to your account. Then navigate to your osCommerce application folder and download it to your local computer.

To enable SEF functionality in your osCommerce, you need to install a SEF contribution. There are several SEF contributions for osCommerce, but in this tutorial we’ll focus on installing (probably the best) one - Ultimate SEO URLs. You can download Ultimate SEF contribution here.

After downloading the .zip archive on your local computer, please extract it in a directory of your choice.

Please make sure you backup up your files and database before installing the contribution.

Then you should upload the files from the catalog folder to your osCommerce directory, overwriting the existing files. Please note that if your shop is highly modified, overwriting the existing files may break your osCommerce installation.

After that you should modify the .htaccess file, changing catalog in this line:

RewriteBase /catalog/

to the folder of your osCommerce.

Then, in the admin/includes/languages/english/categories.php file, before the final ?> you should add:

define(‘TEXT_PRODUCTS_SEO_URL’, ‘Products SEO URL:’);
define(‘TEXT_EDIT_CATEGORIES_SEO_URL’, ‘Category SEO URL:’);
define(‘TEXT_CATEGORIES_SEO_URL’, ‘Category SEO URL:’);

The last step is updating your database. Please go to your cPanel -> MySQL Databases -> phpMyAdmin. Once there, select your osCommerce database from the drop-down menu on the left, click on SQL and in the blank field paste these SQL queries:

ALTER TABLE ‘categories_description’ ADD ‘categories_seo_url’ VARCHAR( 100 ) NOT NULL ;
ALTER TABLE ‘products_description’ ADD ‘products_seo_url’ VARCHAR( 100 ) NOT NULL;

Then click on [Go] and the queries will be executed.

Now you should login to your osCommerce admin area. Under Configuration you will have a new setting - SEO URLs. Click on it to configure your newly installed SEF contribution:

Setting up special prices (discounts, etc.) is easy with osCommerce. To create up a special item, you should login to your osCommerce admin area, go to Catalog and select the Specials link in the leftmost column. Then click the [New Product] button under the special products list.

You will be prompted to select an item and create a special price for it. You should also enter an expiration date – this determines until what day the discount will be active.

After you have filled in the details, you should click the [Insert] button. The new special item will immediately be included in the list.

With osCommerce you can also set up the sales taxes for certain regions of countries or states. That can be done in theLocations / Taxes section of the administrative interface.

To change the languages and currencies, you will need to visit the Localization section.

Currencies in osCommerce

The currencies that are included in the standard installation will be listed, with US Dollar being the default one.

You can define other currencies as well, according to your preference. Please note that in case you are having more than one currency, you will need to specify values for the additional ones, relative to the default one (the default currency value should become 1, and all other have values relative to it in order to have the prices calculated correctly).

Languages in osCommerce

New languages can be downloaded from the address below:

http://www.oscommerce.com/community/contributions/category,7

The language packs include instructions on how to set up the new language.

Next step is to set up payment handling. For this to happen, you will need a merchant account with a payment processor, e.g. PayPal, Authorize.net or 2CheckOut.com. If you already have one, please locate the Payment link under the Modules icon in the administration index page of your osCommerce and click it.

A list of payment options will appear. These are all included in the default osCommerce, but you need to install a module in order to be able to receive payments.

The installation process is very easy. Simply select the vendor you have an account with and click the [Install] button.

When the installation is complete, you will notice that the symbol 0 appears on the row. In the rightmost column two buttons will appear: [Remove] and [Edit].

Clicking the [Edit] button will allow you to insert your merchant account details, set your preference for e-mail notifications, etc.

There are two important choices that have to be made: one is the Transaction Mode and the other one is Sort order of display.

The Test transaction mode can be used for checking whether the payment links are correct or when your store is offline. It is important to switch to Production mode once your store goes live.

Transaction Mode to Production

Sort order of display refers to the payment handler preference: the lower the number – the higher the preference for the particular module, with 0 representing top choice. When done click the [Update] button to save your changes.

Sort order of display - the lower the number – the higher the preference

OsCommerce works with WorldPay payment gateway. The connection between them is being done with the Gary Burton’s module Worldpay v4.0 – 1.8, which can be downloaded here.

In order to install the module, you first have to have a WorldPay merchant account.

1. Edit the filenames.php file from the cPanel of your account:

Go to File Manager in your cPanel and find the folder where you have installed the osCommerce.

Then click on the folder includes and look for the file called filenames.php.

Edit the file and somewhere between the

tags put the following line:

Do not forget to save the file after you have completed the change.

2. Log into the WorldPay Admin area:

Find the option called Set callback URL and enter the following:

– In case that you are using SSL for the checkout procedure:

– In case that you are NOT using SSL for the checkout procedure:

Check if the following parameters are set correctly:

–Callback Enabled: make sure it is ticked on

–Use callback response: make sure it is ticked on

They are ticked in case that they are enabled.

–Callback suspended: make sure this option is unchecked- this automatically selects if callback fails.

–Do not use callback passwords – it is not enabled!

3. Unzip the .zip archive of the module and upload it via FTP into your OsCommerce directory.

Overwrite certain files when you are asked to do it.

4. Go to the OsCommerce admin panel and activate the WorldPay payment type.

Click the red button next to it. You will be asked to enter your Worldpay ID and the mode:

–100 is for test mode

–0 is for live mode

The next step is to add categories that will contain the products you will be selling in your store. To do that, please select the [Catalog] icon from the administration index page. You will be taken to a page where the three default categories are being displayed. You will be able to edit or delete an existing category, or add a brand new one after clicking the respective button.

After clicking the [New category] button the page will refresh and a box for the new category name will appear in the rightmost column.

Since osCommerce is a multi-language shopping cart, you will be able to add category names for German and Spanish as well as for the default English name. Please note that these are only optional and you may leave them blank. You can also select an image to represent the specific category (images are also optional and you can ignore warnings for a missing image). It can be uploaded from your local computer. The last thing to do before clicking the [Save] button is to select the order number for the category. The lower the number – the higher in the list will your new category appear (zero will represent the top of the list).

Next you should add a product to your new catogory. To do this, please click on [New Product].

First off, select whether you have the product in stock or not. Next, select the availability date and the manufacturer. Type in the name of the product on the languages you have installed and decide whether the item is taxable or not; select the Net and the Gross price.

Enter the product description in the language fields, the quantity of the product and its model. Images can also be uploaded from your local computer – osCommerce automatically creates a thumbnail. If you are linking to an external product page, please enter the address without the http:// part for the specific languages. Last thing to add is the product weight, since this will help in determining the shipping costs. When done, hit the [Preview] button to see the result.

Then scroll down to the bottom of the previewing page and select one of the three buttons ([Back] to continue editing, [Insert] to confirm product creation and [Cancel] to drop the new entry). If you have not uploaded an image, you can disregard the warning for no uploaded file.

When you insert the product, you will be taken to the category/product list. If you wish to move the product in a parenting directory, select the desired category from the dropdown list and click the [Move] button in the rightmost column.

You will be able to see the new addition at the top of your product list when you visit the store. The new item will also increase the count of items in a category.

Let’s start customizing your osCommerce. The first thing to do is check the settings of the shop. To do that, please login to your store administration area, using the bookmarked address and the login credentials you provided upon installation. To edit store settings, please start by clicking the [Configuration] link in the left menu.

On the new page you will see a list of chapters (My Store, Minimum Values, etc.). In the middle of the screen chapter details are listed. In order to change a setting please select a row and it will be highlighted. An [Edit] button will appear in the right column.

Click that to be able to edit the details. When you type in the correct details, please use the [Update] button to apply your changes.

When you are done with all the applicable details in a section, you can proceed with the next section by selecting it from the leftmost column and updating the details the very same way.