Administrator area - Tools |
- Database Backup
- Banner Manager
- Define Languages
- File Manager
- Send Email
- Newsletter Manager
- Server Info
- Who's Online
- Html catalog
Database Backup
Here you can view details about existing backup copies of the store's database and make a current backup copy.

Purpose of control elements:
- Bottom right "Backup" button.
Create a current backup copy. The resulting file may be kept on the server or downloaded for local storage. These and other options are available in the dialog window that will pop up when you click the button. - Bottom right "Restore" button.
Restore the database using a locally stored backup file (downloaded from the server to your computer).
The main portion of the page is a table, with rows containing details about available backup copies of the database. Each record contains several fields:
- Title - name of the backup file.
- Date - date of its creation.
- Size - its size.
- Compression - a check box indicating whether the file was compressed after creation.
-
Action - this field contains several buttons,
which allow to perform the following operations:
- Restore - restore the database contents using this backup file.
- Delete - delete this backup file.
Banner Manager
Here you can manage the banners of your virtual store, as well as add, edit, delete or view the usage statistics.

Purpose of control elements:
Bottom right "New Banner" button. Create a new banner. To do this, you need to specify the following details in the pop-up window:

- Banner Title - banner name, which will be shown in the statistics.
- Banner URL - hyperlink to a page that will be visited by customers after clicking on the banner.
- Banner Group - a group of banners where you want to put your new banner. You can either choose it from the list or enter a new name into the field in the next row. The name should be alphanumeric. Afterwards, you will be able to rotate randomly selected banners from a certain group, rather than just one specified banner.
- A banner can be set up as an image file or as HTML code,
which may contain various elements.
Respectively, you should select one of the two options:
"Image" or "HTML
Text".
-
Image - name of the file
with the banner image. If you want to upload an image from
your local computer to the server, then click
the "Browse..." button and select
the desired file. In the "Image Target (Save To)" field
enter the name, under which the uploaded image file
will be saved on the server.
If the required image file is already available on the server, you may just specify its name in the field in the next line after the "Image". In this case you don't need to specify "Image Target (Save To)", as the file is already on the server.
- HTML Text - enter HTML code that will be dsplayed as a banner.
-
Image - name of the file
with the banner image. If you want to upload an image from
your local computer to the server, then click
the "Browse..." button and select
the desired file. In the "Image Target (Save To)" field
enter the name, under which the uploaded image file
will be saved on the server.
- You can plan the banner display periods using two variables:
"Scheduled At" and "Expires On". If none of them is defined,
the will be no restrictions on the time during which the banner will be shown,
therefore it may be shown at any time. If you specify a date in the "Scheduled
At" field, then the banner will not be shown until this date.
It can only be displayed after this date.
If you use the "Expires On" field, then after this date (or after the banner has been shown the number of times specified in the "impressions/views" field) the banner will become inactive and will not be shown any more. You may select only one value for the Expires On field: either "date", or "impressions/views", but not both of them simultaneously.
- Scheduled At - the date when the banner becomes active and will be displayed to customers. The banner will be inactive and will not be shown before this date.
- Expires On - after this date, or after the specified number of impressions (if you specify the number of "impressions/views", rather than a date), the banner will become inactive and will not be shown to customers any more.
Main portion of the page is a table, with rows containing information about available banners. Each record contains several fields:
- Banners - banner name, date of creation, and (if specified) display start date, display end condition, last deactivation ("status change") time.
- Groups - banner group which the banner belongs to.
- Displays / Clicks - number of banner impressions and clicks.
- Status - banner status ("active/inactive"). The status can change in several cases: manual creation or modification of a banner on the page in question, as well as automatic verification of the banner display start/end conditions, that is performed during the download of any page in the Catalog Area.
-
Action - This field contains several buttons
that allow to perform the following operations:
- View - display the banner in a new window.
- Statistics - show statistics on banner impressions/views. You may select data grouping options: "Daily", Monthly, or Yearly. Depending on you choice, you may need to specify Year, or Year and Month. The data for the selected period will be displayed on the page: as a table at the top of the page, and as a bar diagram at the bottom of the page. The Back button allows to return to the main window ("Banner Manager").
- Edit - switch to banner editing mode. Values for the input fields are the same as those used for banner creation in the "New Banner" window.
- Delete - delete the banner.
Define Languages
Here you can create, edit or delete translations of various phrases used in the store's interface. Phrases are grouped by language and source text files of the website pages where they are displayed.
Purpose of control elements:
- Pull-down list in the top left area of the page contains names of the languages, translations into which are currently available for editing. You can modify this list in the Administrator area - Localization - Languages.
- Bottom right "File Manager" button. Allows to move to the "Administrator area - Tools - File Manager" menu where you can create files and folders required for translation, as well as edit or delete the existing files and folders.
The main portion of the page is a table with the names of the files containing phrases to be translated. To edit a selected file, click on its name. A new window with the edit field will open. The edit field will display the content of the file to be edited. As you will see, translation of a phrase is defined as a character string:
Let's use file account_edit.php as an example for English language:
define('HEADING_TITLE', 'My Account Information');
If you wish to replace 'My Account Information' with another heading, e.g. 'View Account Information', you need to replace the above-mentioned character string in the file:
define('HEADING_TITLE', 'View Account Information');
If you want to add to the file a translation for some phrase (PHP constants), just add the appropriate string to the file. Don't forget the parenthesis, inverted commas and semicolon.
To save the edited file, click "Save"; to return to the previous window without saving, click "Cancel".
File Manager
Here you can create, edit or delete files and directories on your server, as in any file manager. There are some points to mention.
Control elements include:
- The pull-down list in the top left section of the page is filled when you move along the folder tree. By selecting one of the items in the tree, you can move directly to the required folder.
- The "Reset" button in the bottom left corner. It allows to move from the current position to the root folder of your site.
- The "Upload" button in the bottom right corner. It allows to call up a file upload window from your local file system. Select one or more files in this window, by clicking the "Browse..." button, which will open a file selection window. To upload the selected files, click "Upload".
- Icons to the left from each file name allow to download these files from the server and make a local copy.
Send Email

This is a simple email system interface. Select a recipient or recipients from the Customer: pull-down list. If you select "All Customers", then identical letters will be sent out to all customers holding an account at your store. If you select "To All Newsletter Subscribers", then identical letters will be sent out to those customers who selected the "Newsletter" option in their account settings, i.e. to the newsletter subscribers. Then you need to fill the following fields:
From: sender, osCommerce <root@localhost> by default
Subject: - subject of the letter,
Message: - main body of the letter.
By clicking the "Send Mail" button, you will open a window where you can cancel or confirm your desire to send the letter(s). Upon confirmation, you should see a message in the top section of the window that confirms sending out of the letters.
Newsletter Manager
This is another email system interface that offers more functionality than the "Send Email" interface. Letters are created here with the help of various modules. Two modules are available at the moment:
- newsletter - for sending letters to subscribers (see the paragraph "Send Email" above)
- product_notification - for sending letters to customers who have subscribed to mailing lists for various product notifications.
The main portion of the page is a table with descriptions of email templates prepared for sending-out or already sent out. These include:
- Newsletters - heading of the letter
- Size - size of the letter's body in bytes
- Module - module that was used for the creation of the letter: "newsletter" or product_notification.
- Sent - indicates whether this letter has already been sent. Green checkmark means that the letter has already been sent out, red 'x' means that it has never been sent out yet.
- Status - status of the letter - 'locked' or 'open'. If the letter is locked, it means that somebody marked it for sending, which should be taken into account by the administrators.
- Action. This field contains several buttons. Two buttons are available immediately after creation of a letter - "Preview" and "Lock". The first button allows to preview the letter. The second button allows to 'lock' the letter. After the letter has been 'locked', three more buttons become available in the "Action" field, namely "Edit", "Delete", and "Send". When you send a letter using the "product_notification" module, you can select products, to which customers should be subscribed in order to receive the letter. After you click "Submit" button, the contents of the letter and the number of recepients will be displayed once again. If you click "Global", then the letters will be sent out to all customers who have subscribed to notifications regarding at least one product. The letters will be sent out upon confirmation.
The lower section of the screen contains a form for creating a new letter. From the pull-down "Module:" list, select a module to be used for sending out the letter, enter the subject into the "Newsletter Title:" field and the contents (body) of the letter into the "Content:" field.
Server Info
Here you can view information about the settings and configuration of your server: operating system, web (HTTP server, version and settings of PHP and MySQL database.
Who's Online
Here you can view information about the customers who are currently visiting your store.

The main portion of the page is a table, with rows containing information about the customers. Each record contains several fields:
- Online - duration of the customer's visit to the store.
- ID - user ID if the customer is registered in the system, or 0 if he entered the store as a guest.
- Full Name - user name (if registered in the system), otherwise he will be displayed as Guest.
- IP Address - user's IP address.
- Entry Time - time of entry into the store.
- Last Click - time of the last hop between pages.
- Last URL - URL of the last visited page.
- Users Shopping Cart - by clicking on this button you can view the current contents of the customer's shopping cart.
Html catalog
Here you can generate a static copy of the majority of the store's pages
as HTML files.
This may make it easier for search engines
to scan your site and, therefore, make your site more accessible
to customers. Pages for all categories and products will be generated
by default.
Alternatively, you can generate pages
containing reviews. The total number of files ("Total:") may increase
during the generation process depending on the number of
split pages. When the generation process is complete, the
"View catalog" link will be displayed. By clicking on this link,
you may go to the generated HTML catalog.



