eCatalog Manual


eCatalogOrder manual.-------------Intro.

How easy easy can be.


eCatalogOrder manual.-------------Lesson 1.

Lets get started.

Company, categories, products, Sub categories.


eCatalogOrder manual.-------------Lesson 2.

Easy going.

Products, Features, Images and Logo


eCatalogOrder manual.-------------Lesson 3.

Over the hump.

Shipping charges, Card charges and other options.


eCatalogOrder manual.-------------Lesson 4.

Finishing Up.

Test, adjustments, Web site links, Reports and Admin operations.

Customer Service Center


eCatalogOrder manual.-------------Lesson 5.


Coupons, Gift certificates, affiliates, Banners, Look and feel.

Tell a friend, Customer Reviews, upload module, banking gateways.

And much much more!


eCatalogOrder manual.-------------Appendix.

Tables, constants, tips and techniques.



eCatalogOrder manual.-------------Intro. How easy easy can be.

Welcome to the profitable world of ecommerce . We at eCatalogOrder like to make your staying with us as painless and productive as possible. However the software system that commands the inner movements of eCatalog is very powerful and versatile and we have took the time to write it with you the user in mind. We believe that you have enough running your business on a daily basis to have to learn new ways to do the things you are use to do now.

With that in mind lets explore how to get the system setup and have it up and running as Fast Secure and Easy as possible.

We have divided this manual on five steps

    1. Lets get started
    2. Easy going.
    3. Over the hump.
    4. Finishing Up.
    5. Emarketing

Also we have some

Tables, constants, tips and techniques.

These steps should guide you through the different settings and options that are available to you during the procedure of putting all of this together.

Without further saying let's get started



eCatalogOrder manual.-------------Lesson 1. Lets get started.

eCatalog is a powerful versatile software solution that allows you to $ell online in no time at all.

We are a Fast Secure and Easy solution to the e-commerce problem that we face when we try to get an entire site displaying products and getting customers to get them ordered online just as if they were on the store. 

To get started

We need to go to the administrator panel located at

or clicking on the Merchant Administration button on the catalog home page located at

Your initial login username and password is User and password.

You must change that on item 26. User Control and from there edit user User and change the password to something that is hard to crack and easy for you to remember.

You will need to re login next time around

Let me recommend that you create another user with all privileges as to have a back door entrance.

O.K. Once that is done let's get to the business at hand.

First we enter 1. Company Information and get your Company name, phone, fax email and sales tax rate on the districts you do business on.

Next we enter 2. Edit Categories were we enter  the company departments or categories of your catalog.

After that we enter 4. Edit Subcategories were we enter sub categories or sub departments.

Next we enter 5. Edit Shipping Methods were we define the shipping methods we use.

Some examples are UPS, FEDEX, actual cost , to be Added at time of shipping , Mail etc.

Next we enter 14. Edit Product Features This a tricky subject. In here we define some common features for the products we sell as in

Some features could be designated as required so we wouldn't proceed until the customer acknowledges the requirement. More on this later.

Next and almost finally we enter 3. Edit Products In here we enter products information.

Needed information is

Auxiliary information

Product Code:. Shown as ccode on the display product list.

Sub-Category: . Sub department or category.

Extended description page: . URL of your extended description page or SHOPEXD.ASP

Feature Numbers: . Number of the desired features of this product.

Features: . List of all the features available.

Image: . URL of the image to show on the product list

Order Button image: . Image for order button for this product.

Stock: . Amount on stock decremented by sales if selected .

Weight: . Product weight needed for UPS or FEDEX online and to determine shipping charges on the fly.

Manufacturer: . Product manufacturer

Supplier : . Product supplier

Cross Selling Products: . Other products id that you will like to suggest to purchase if a customers buy this.

Date available: . Reserved, not currently used

Other1: . Reserved, not currently used

Other2: . Reserved, not currently used

Other3: . Reserved, not currently used

Other4: . Reserved, not currently used

Other5: . Reserved, not currently used

Retail Price: . The suggested retail price that will be showed to compare to your low  priced products.

Special Offer: . Remarks that puts products on top of the list and display on blue bold font.

Allow User Text . Allows customer enter messages about the products.

Keywords: . List of key words that could be searched.

Template file: .

More Information! . Large html description to show when SHOPEXD.ASP is enabled

Large image: . Larger image for the product. Works only on extended description settings.

Selection List: .

Minimum Quantity: . If you will sell not less than this number.

Hide Product: . "Yes" Do not display the product to the customers.

Userid: . Automatically added by the system to determine who added the product to the database.

Shop product features can be



eCatalogOrder manual.-------------Lesson 2. Easy going.

By now you must have finished entering Company information, departments and some few products.

Today we will talk about products, images and extended descriptions.

As you recall the products table has some fields that we should consider now.

They are




Sub department or category.


Amount on stock decremented by sales if selected .


Product manufacturer

Supplier: #

Product supplier

Cross Selling Products:

Other products id that you will like to suggest to purchase if a customers buy this.


List of key words that could be searched.

Template file:

Description settings.

Minimum Quantity:

If you will sell not less than this number.

Hide Product.

"Yes" Do not display the product to the customers.



Feature Numbers:

Number of the desired features of this product.


List of all the features available.

Selection List:

List to be used with automatic features settings.

Shop product features

can be:

  • Drop Down List
  • Check Boxes
  • Radio buttons
  • User supplied text
  • User supplied prices




URL of the image to show on the product list

Order Button image:

Image for order button for this product.

Extended description:

URL of your extended description page or SHOPEXD.ASP

More Information!

Large html description to show when SHOPEXD.ASP is enabled

Large image:

Larger image for the product. Works only on extended

Special Offer:

Remarks that puts products on top of the list and display on blue bold font.

Retail Price:

The suggested retail price that will be showed to compare to your low  priced products.

To better display products you might decide to setup some features.

To do this you need to understand how features options work.

Let's take a look at those features.

Product Features

eCatalog has a number of procedures designed to process product features.

Features could be optional, features can all be required or features can be required on an individual basis.

Features can be:

This routine also adds the quantity, description and price to the internal table that represents the shopping cart.

Making Features Required

If all product features are required, please email and request it as this is a global change and must be done at server side by us.

There is also a field in the ProdFeatures table called "FeatureRequired".

If only a specific feature is required, then set that value to TRUE.

Product Features

Features are handled by the field "Features" in the Products table. If a product has features then the Features field has a list of numbers such as "1,4,23".

The number represents groups of features on the ProdFeatures Table. If there are 4 records in the ProdFeatures table with Featurenum1 then the four are displayed in a drop down list. If there are seven features within Featurenum=4 then the seven items are displayed in another drop down list.

Changing Features

Your eCatalog software defaults to four (4) features. If you want to have more features let us know.

Using Features

Products may or may not have features. Many products can have the same features. For example clothing may have small, medium, large, x-large. The section list generated for a feature comes from the ProdFeatures table. Each feature needs a FeatureNum and a FeatureCaption. For the sizes above, they would all have the same FeatureNum and same FeatureCaption.

Feature Type

The Feature type field in the ProdFeatures table determines the type of display for the features.

Valid entries are shown below. They are not case sensitive.

Multiple Selections

By default all features allow the customer to select one option.

To allow the customer to select multiple options enter the word "Yes" (without quotes) into the FeatureMulti field.

Radio Buttons cannot have multiple selections so they are automatically converted to checkboxes.

User Supplied Text


It is possible to allow the customer to enter their own details.

The caption for the feature is the FeatureCaption field.

The featurename field is reserved for future use.

For compatibility with previous versions you can also enter a caption in the "AllowUserInput" in the products table record. The caption will display above the text input box.

Radio Button


DropDown List

Inline Selection List

Sometimes using features becomes too complex. This happens when a range of products has almost the same set of features but not exactly. For example if colors are unique to each shirt.

To handle this we developed the concept of a SelectList.

SelectList is a field in the products table where you simply enter the colors (or whatever feature) into that field. For example grey, red, blue .

Your eCatalog software will then generate a drop down list with grey, red, and blue.

To use SelectList as a feature, you must create one feature in the ProdFeatures table and assign this feature to the product(s).

The FeatureCaption field will be used as the header for the dropdown list.

To assign prices to any of the options using [price] for example grey [2.00], red, blue [3.00]

grey has a 2 dollar price, red has no additional price and blue is 3 dollars additional.

More SelectList fields

If you need additional fields in the products table to be used to generate select lists, use the "featureother" field in the prodfeatures table. For example create an additional select list using the pother1 field in the products table, set the following in the prodfeatures table.

Your eCatalog software will now look in field Pother1 and generate dropdown lists for anything in that field. It will have same format described above. There are no limits to the number of select fields you can have.


UserPrice can be used for variable amounts. This can be used for example in taking donations.

It looks more complex than what appears however we could assist you should the need arises.


Now that we have features set up it is a turn for the images.

We actually have five images that we could display for every product

They are:


Extended description page

Location of a whole web page or shopexd.asp



Location of an image to display on product list


Order Button

Location of a pre-selected order button


Large Image

Location of a larger image on shopexd.asp


More Information

Html code of ext description on shopexd.asp

If you want your customer to return to your web site to seek more information you must add the URL of the pertinent page on extended description page and add a Order Now button on that page as well as a back button to perhaps allow the customer to continue shopping on the eCatalog software. More on this later. However if you wish the powerful routines of eCatalog software to handle the display of a customized catalog product view you must supply the following information .

With this three pieces of information the eCatalog software will display and extended page that you could now invoke from your web site with the following hyperlink code.

Where xx is the product ID that you wish to display.

I know it has been hard but it is not so overwhelming as it appears.

Let's take it a byte at a time.



eCatalogOrder manual.-------------Lesson 3. Over the hump.

Well let's hope things get easier from here. Let me assure you they are.

All we have to do now is to begin finishing up the site.

Shipping charges, Card charges and other options.

Shipping Charges calculations

eCatalog Software supports seven different types of shipping calculations and is able to support any other calculations you need, just ask for them.

The seven calculation methods are as follows.

Quantity, Weight, Lookup, Other, NoLookup, PriceRange, WeightRange.


Customer selects shipping method but the amount is fixed regardless of what is being ordered.


You set a fixed method and amount.


Shipping data in database is ignored


Shipping is calculated by the total price of products ordered and selection made by customer


Shipping is calculated by weight of products and selection made by customer.


Weight * Quantity * amount. Customer selects shipping method which determines the amount charged.


Quantity * amount. Customer selects shipping method which determines the amount charged


The actual shipping cost is in the product record.

By default the weight field is used.


UPS table lookup or real time (extra fees)

FEDEX table lookup or real time (extra fees)



Simply add your shipping names and prices to the shipmethods table.

The customer selects from the list.

Fields that need to be set in shipmethods table:

















You decide a shipping method and an amount, email it to and we do the rest.

"Your Shipping Method" "3.00" ' your price

Calculating by weight

eCatalog software will calculate the shipping price automatically by reading the shipmethods table. You need to update this table to reflect your shipping methods and costs.

For example given the following values





















ShipBaseCost is the amount that will be charged regardless of weight.

ShipExtra Cost is multiplied by weight and quantity

The total is the sum of those amounts

If ShipBase cost is 0, then the base cost is SMPRICE

Calculating by Quantity

eCatalog software will calculate the shipping price automatically by reading the shipmethods table.

You need to update this table to reflect your shipping methods and costs.

For example given the following values





















ShipBaseCost is the amount that will be charged regardless of quantity.

ShipExtraCost is multiplied by items

The total is the sum of those amounts


The total cost of the order is compared against a range set in the shipmethods table.

The price is whatever is in ShipBaseCost within that price range.

















Weight Range

The total weight of the products is compared against a range set in the shipmethods table.

The price is whatever is in ShipBaseCost within that price range.

If there is an amount in ShipExtracost it is added to the base cost using the following formula

Remainingweight=Totalweight-Loweight (shipother1)

extracost = RemainingWeight*ShipExtraCost

Total Shipping Cost = ShipBaseCost + ExtraCost






















The actual shipping cost is in the product record. By default eCatalog software assumes the weight field has the shipping cost instead of a weight.


We could provide other shipping type methods. For those types specify "OTHER".

The routine names that handle these special shipping types are defined in the shipmethods table field "shiproutine". Separate instructions come with these other shipping methods.

Some of those are

UPS and FEDEX Shipping

Many customers have asked us about UPS and FEDEX shipping.

We have developed two special modules for these ocasions.

UPS Real Time

UPS real time requires a special DLL to be installed on our servers.

eCatalog software calculates the weight of the items, uses your zip code and sends a message to UPS.

UPS online returns with different costs and the customer can select the type of shipping based on the costs being displayed. The response normally only takes a few seconds. ShipRoutine=shopupsreal.asp.


UPSDB uses a separate database with UPS tables.

These tables must be supplied to us by you.

One of these tables is a zone table which represents your local zip code. You will need to obtain your specific zone table from UPS themselves. Shiproutine=shopupsdb.asp

eCatalog software calculates the weight of the items, uses the zone table and the shipping zip code and looks up the various prices. The customer can select the type of shipping based on the costs being displayed.

Other Fields in Shipmethods Tables

There are other fields in the Shipmethods table that you can use.

eCatalog software does not use these fields and they are reserved for future use..

They are read in for you automatically by eCatalog software but ignored for now.

Card Charges

eCatalog software comes with 3 credit cards types as default. If this do not suite your needs simply let us know and we will adjust these.

So if we make it so far probably now we have a working system.

It is time to test it and that is exactly what we will do in the next lesson.

Until then.



eCatalogOrder manual.-------------Lesson 4. Finishing Up.

Test and adjustments, Web site links, Admin operations and Reports.

Customer Service Center.

Test and adjustments

To test the system you could try the customer experience.

That is buy something on different ways as no charges will be made unless you actually charge yourself.

Make corrections until it works as desired.

Web site links

Interface to Existing Web

Any existing web can easily interface to eCatalog. A few examples using hyperlinks and forms are shown below. eCatalog provides facilities to:

Displaying Categories

By just including a simple link anywhere in the existing web to our routine shopdisplaycategories.asp all the shopping facilities and product displays are automatic.No further interface is required.

<a href="shopdisplaycategories.asp">Display Categories</a>


Add To Cart

The second method of interfacing to your existing web site is slightly more complex. A specific hyperlink is added anywhere in your existing web site to our routine shopaddtocart.asp.

This will allow adding one specific product to the cart from anywhere in the existing web.

Two parameters are required:

Productid and Quantity as shown below.

The catalogid comes from the products database (catalogid field).

<a href="shopaddtocart.asp?catalogid=1&quantity=1">Click to Order</a>


Displaying Products for a category

To display products for a category the following hyperlink can be used

<a href="shopdisplayproducts.asp?id=2">Display travel Products</a>

Displaying Products in a Subcategory

To display products for a subcategory the following hyperlink can be used

<a href="shopdisplayproducts.asp?id=2&subcat=3">Products in subcategory 3</a>

Displaying Products by name

To display a specific product use:

<a href="shopquery.asp?catalogid=1">Products with catalog id 1</a>

Displaying Products by any Criteria- shopquery.asp

To display products by any field in the products table, either create a form with the field names or use a hyperlink. See file shopquerytest.htm for examples of both.

Using a hyperlink

Suppose you want to display all shirts with prices less than $50. Shopquery.asp is an extremely flexible search facility.

<a href="shopquery.asp?cprice=50&cname=shirt">Display stuff</a>

Using a form

When using a form, the submit button must be called shopquery

<form method="POST" action="shopquery.asp">

Name<input type = "text" name = "cname" size="30"><br>

Manufacturer<input type = "text" name = "mfg" size="30"><br>

Price<input type = "text" name = "cprice" size="30"><br>

<input type = "submit" value = "Display" name = "Shopquery">

<input type = "reset" value = "Reset" name = "resetbutton"></p>


Search for products by Keyword

The normal routine shopsearch.asp can be used with a hyperlink using the following method

<a href = "shopsearch.asp?search = YES&keyword = abc,def,jkl">Search for keywords</a>

Creating a form on your page to do searching

Simply add the following code to your form and see it happening.

<form method = "POST" action = "shopsearch.asp?search = Yes">
<p><input type = "text" name = "keyword" size="20"><br>
<input type = "submit" value = "Search" name = "B1">

Add a product not in the database

Using the routine shopaddtocartnodb.asp, it is possible to add an item to the cart without it being in the database. The following fields can be passed as either a form field or on the URL

Two fields are



Name to appear in the shopping cart


Price without dollar signs




A number representing the product


Number of items


Category Number


Product Code


If you want to stay on the same page and add item to the cart specify the Return page



<a href = "shopaddtocartnodb.asp?Productname = Mystuff&price = 10.00">Add to cart</a>

<a href = "shopaddtocartnodb.asp?Productname = Otherstuff&price = 3.95&quantity = 2&returnurl = mypage.html">Add to cart</a>

Sample Hyperlinks

We provide a file called shopsamplelinks.htm which will teach you these sample hyperlink examples.


This routine can be used to add a product to the cart, that does not exists in the database.

The following fields can be used:


Name to appear in the cart



Optional fields





Product number in the database


Category number in the database


If specified, this routine goes to this page on your web site otherwise the cart is displayed

This is used only as a hyperlink or form interface. It is never automatically displayed

Admin operations



The administration components let you

Users can be added to the database and have different privileges.

There are two administrator users defined in the database.

USER and ADMIN. USER only has a subset of privileges and ADMIN has the full set.

We strongly recommend that you rename these userids and passwords before starting using your e-commerce site.


Shop Administration

Shop administration is for the merchant or administrator and not for the customer.

The administration facilities include:

Login onto the system

This is the login screen for shop administration.

All the administration routines require that the user log in. If not then user must login or re-login after about ten minutes to maintain security on the system. Administrators can add, delete, and alter user privileges.

Once logged in

Once a successful login has been done, a menu displays the options available for the user.

Each administrative user can be given different menus.

Adding New menu items

The menu items on this page are dynamically read from the database.

Using menu control, you can add/delete and alter what is displayed on this page.

Adding or altering products

Clicking on Display products (option 3) will allow to alter or add products and features for them as well. This is the main form for adding and altering product information. Certain required fields such as description and price are entered. It also generates a selection list for categories and category codes. Products are very important and this data entry screen forces correct information and makes feature selection easy.

There are two buttons at the bottom of the form, Add and Update. After you add a product, if you made a mistake, you can correct it immediately. This only works until you add another product or leave the session. This button allows for the entry of multiple products that change very little form one to the next.

Products In Multiple Categories and Subcategories

If you wish to assign product to multiple categories and subcategories, send an email to and request that feature stating your shop id and the nature of the change.


Adding Products

Products can have only one category and subcategory. They can have multiple features.

If SpecialOffer is specified, the product will appear at the top of its product list.

If retailprice is specified, the price appears in italics under the current price of the product.

Subcategories for a specific category

By default all subcategories are displayed. If you only want subcategories for the selected category to be displayed send an email to and request that feature stating your shop id and the nature of the change.

Supplier Drop Down List

One feature that might be of interest to you is supplier drop down list

To have the list of suppliers generated as a dropdown list send an email to and request that feature stating your shop id and the nature of the change.


Product Fields - Other

This display can also include your own fields and captions. To add your own fields send an email to and request that feature stating your shop id and the nature of the change.

There might be some extra programming setting and testing charges for this thought.

Sub Sub Categories

By default eCatalog supports unlimited categories and unlimited subcategories under each category.

It is possible to add three additional levels of sub category called sub sub categories.

If sub sub categories are used, three additional fields will appear for fields level3, level4, level5.

Both a list and a field are supplied. You can use either to enter the sub sub category values.


Using Sub Sub Categories

Three new fields are used for sub sub categories. Level3, level4 and Level5. Three new tables are used subcatelevel3, subcatlevel3, subcatelevel5.

Level3 has the actual name of the subcategory. It is not a number. The drop-down-list simply is a reminder of what subcategories are at that level in the subcatlevel3 table. The same applies to fields level4, level5.

The extra table subcatelevel3 are only used if you want eCatalog to automatically display these subcategories.

It will be very easy to confuse your customers and yourself with so many levels.

We strongly recommend you do not use this facility unless you really need sub sub categories.


If you are have suppliers and wish to select them from the suppliers table, send an email to and request that feature stating your shop id and the nature of the change.


Special Product Fields

The following fields have special meanings





This is used to create a dropdown list when features facility is too cumbersome. A feature must be created and assigned to this product. The FeatureOther fields must be filled in with the word "SelectList"

red,green,yellow [2.00]


This is a larger image for the product. It is only used if we generate the extended description page using shopexd.asp.



This is a detailed large description of the product. It is only used if we generate the extended description page using shopexd.asp.



List of keywords that can be searched by your web customers.



An html file used by shopexd.asp that is used to generate an extended description of the product page.



This generates a text box for the customer to enter free form text. Useful when details such as engraving, birthday cakes are examples. The data in this field becomes the caption of the text box



If there is any text in this field it is displayed with the product. All products with special offers are listed first on product displays



If you do not want a product to be displayed set this value to TRUE


Display orders

Display orders formats an order. It also allows orders to be marked as processed, deleted and sorted in various ways. This is the prime administrative tool for viewing orders and processing them. The order can also be edited to put in any order status.

Edit Order

Here you will have the opportunity to print and process the order as here is the only place (you computer) where the encrypted credit card is displayed in the clear. If needed the order can be edited by selecting "Edit Order".

Editing the order

You can edit the fields of the order by clicking "Edit Order". To edit the actual order items click "Edit Oitems". Please note that if you delete or change the order item prices, the total in the order is not automatically updated so it is best to simply delete the whole order and add a new one with the correct information.

Display order items.

The order items can be edited or deleted. You must have permission to edit the oitems table as an administrator to edit the order item.

Edit Display.

This is a general-purpose routine to generate a table for the rows in any table in the database.

From this menu you can:

The control Bar

The mail Setup, Export Setup, Delete Setup are used to control those facilities.

Mail Setup allows you to email a message to elements of a table.

Delete Setup allows you to delete items on a table. Be very careful with this one.

Export Setup allows you to create a exported file of pre-selected data

Select Table allows you to select a table from the database to work on it.

Deleting Records

Deleting products must be set-up by selecting Delete Setup. This brings up a set of checkboxes on the right hand side of the table. A button will then appear and allow you to delete records. Be very careful with this one.

Mail Setup.

This facility allows you to send a message to all the customers or recipients of a table that you select.

This is not the same as setting up the mail system for the eCatalog as that is done on our side.

This sets up the message and subject for your e-mail. Most of the other fields should not normally be changed. This mail facility is designed for relatively short messages. You can mail in text format or html format. You can mail a specific file or you can paste in the text of your message.

When set-up is complete, it returns to Edit display with a checkbox on the right hand side

Mail can now be sent to all customers or just selected customers or recipients of a table.

Table Select.

This routine allows selection of a table that can be viewed and edited.

Only the tables you are permitted to view will be displayed.

Export Setup.

This routine is used to control where records are exported. They can be written to a file, or written to a browser window. If a file is selected, make sure that the location is a directory on which data can be written to. If it is not the export will fail.

To write to a browser window, do not put a filename.


Edit Record.

This routine generates a form with values filled in for a specific record in any table.

The fields in the record can then be updated, the record deleted, or it can just be viewed.

When editing, existing values can be set to null by simply clearing the text field.

Menu Control.

When a merchant logs on to the administrative system, a list of scripts available to him/her are displayed. This is controlled through this menu control.

Menus consist of a description, a comment and a URL. Although the shopping system uses only simple file names, full URLs can be used to invoke any other web sites or pages.


This routine allows you to enter valid SQL. Sample SQL statements are shown. Under the textbox are the fields within the tables you are permitted to view. You need to be familiar with Structured Query Language to use this page. The tables at the bottom of the page are the tables you are allowed to view and the field names within those tables.

User Control.

This is routine is used in the administrative system to add and delete users and to provide a selection of menu items that the user can display. You can also assign tables for which the user can view and edit. This is not a fool-proof security scheme however it should suffice if the users are to follow directions.

Restricted User

A restricted user is an administrator who can only edit products that he/she has added. The user should be assigned permission to products table and display products menu. Use this facility ONLY if you wish to have different people control their own products within the same shop.


Sales Reports.

This sales report routine displays counts and or details of sales over a date range. Dates are very system specific. Your system may require dd/mm/yyyy or it may require mm/dd/yyyy.


Sample Sales Reports

The detailed report shows each order and the total sales for the date range specified. The order can be displayed by clicking on the order number.


This routine displays stock low reports. You can specify the low level to report on. It will list each product, which you can then edit to alter the current stock level.

Product Report.

This report lists all products sold by supplier. If no supplier is specified for a product, then the supplier number is set to 0.

Other Administrative Files

The files below are other administrative files.

Log history.

Each time an administrator logs into the shopping database, a record is made.

This history log can be viewed and entries deleted with this script.


Customer Service Center

The customer service center is the place for the customer to come to:

You could select more or less menu items to appear on the Customer Service Center.

Gift Certificates and Discount coupons are supported as separate modules.

Adding Menu Items

This menu is created dynamically. The menu changes depending on the configuration options selected. Additional items can be added by requesting them via email to

Review Previous Orders -Shopstatus.Asp

The customer can enter last name and password to check all orders. To check a specific order the order number can be entered. The Status field is a text field that is displayed for the customer. If the customer has already logged in, then the login screen is bypassed otherwise the customer is asked to re-login.

Status Display – Shopstatus.asp

The display shows order is in descending order by date. The customer can review the entire order by clicking on view. A display of the last 20 orders is the default. The customer can search for a specific order.

The customer can restore the contents of the order by clicking on the "Yes" under restore order. If you do not want customer to restore orders let us know via email and request that change.

Merchant Responsibilities

The merchant is responsible for setting the processed indicator. This is done when displaying orders in the administration section. The ostatus field in the order needs to be filled in by the merchant if anything is to be displayed.


Saving and Restoring Carts

The customer can save the shopping cart and restore it at a later date. Saving and Restoring carts are disabled by default. Let us know if you wish this to be changed.

Carts are saved on the customer’s computer as a set of cookies. The customer can restore the cart or delete the cart. Cart names can be anything. If any carts have been stored on the customer’s computer, they are listed.

Mail Forgotten Password – Shopmailpwd.asp

If you allow customers to use passwords to login, they can retrieve forgotten passwords by entering their e-mail address and name.




eCatalogOrder manual.-------------Lesson 5. eMarketing

Coupons, Gift certificates, Affiliates, Banners, Look and feel.

Tell a friend, Customer Reviews, Upload module, Banking gateways,



Discount coupons allow your customers to use eMarketing discounts on purchases.

The discounts can be either be:

Discounts have the following attributes:

How the customer uses a Coupon

Customer can enter the discount coupon at any time before they checkout. If the coupon is valid, the coupon discount is applied to the order and appears as a separate line item in the order confirmation form.

How the merchant defines a coupon

The merchant defines a coupon by adding a record to the Coupons table. This is done using normal eCatalog administration facility. The coupon is then immediately available or a date when the coupon starts can be specified. Multiple different coupons can be valid at any one time. There is no limit.

Coupon Expiration

Coupons can expire in two ways.

The first is an expiration date. The coupon expires immediately at the end of the day.
Days are very dependent on where you web hosting company is located and may be different from your local date.

The other method is to use a "use count". eCatalog records each time an order has been completed and a coupon has been used. The next time a shopper enters the coupon name, if the use count has exceeded the limit, the customer is notified that the coupon is no longer valid.

Since the recording and the checking are done at different times, It is possible to exceed the use count if multiple customers enter the coupon name before the use count has been exceeded.

Coupon Discounts

Discounts can either be a percentage of the total order or a fixed amount.

Coupon Limitations

Coupons can be limited to specific products or categories. In the coupon table there are two fields


This is a list of category numbers to which the discount applies. For example


This is a list of product catalogids numbers to which the discount applies. For example

Creating A Coupon

A coupon is created by adding a record to the Coupons Table using the normal administration table edits.



Can be anything. This is what the customer enters


The amount of discount, Can be a $amount of left empty


The percent discount in the form .10 or for currencies that use comma as decimal point ,10


If left empty, the coupon starts immediately


If left empty, the coupon has no expiration data


The number of times the coupon can be used. If left empty, there is no limit


A list of categories to which the discount applies. If empty and the next field is also empty, it applies to all products


A list of catalogids to which the discount applies. Can be left empty


Updated by eCatalog


Updated by eCatalog


Unused by eCatalog


Unused by eCatalog

Gift Certificates

Gift Certificates

Gift certificates could be considered as prepayments or even as your own store's credit or debit Card to be precise. They are sold on the customer service center department and they last for a year since purchase price. This could be changed of course If necessary let us know via email and we will change that option.

Customers will be able to buy and redeem gift certificates on your site. Gift certificates are purchased separately on eCatalog Customer Service Center screen; they cannot be mixed with other items. A gift certificate is paid for like any other product in your shop. The person receiving the gift certificate can then use it to pay for purchases in your shop. The certificate essentially acts as a discount up to the value remaining on the certificate or in other word as a prepayment on account.

FAQ on Gift Certificates

  • Can a customer use only a portion of the gift certificate?

Yes, the portion used is deducted from the remaining amount. A customer can then use the remaining amount for a purchase at some other time.

eCatalog will bypass the normal payment processing and mark that payment was made by a specific gift certificate.

The customer will be required to pay the difference between the amount purchased and the value of the gift certificate.

eCatalog records payment with a gift certificate in the orders table. It also puts trace information in the gifts table. You can see how many times a gift certificate was used, which orders they were used for and how much in each order.

There is no guarantee that gift certificate processing cannot be comprised by hackers.

If the database fails to get updated properly because of a web server failure, it is possible that an order may not have fully completed, yet the gift certificate usage details may have been updated. If this occurs you may need to restore the amount remaining based on the internal trace record. This is a simple edit of the gifts table.

Buying A Gift Certificate

Multiple Gift Certificates can be bought at one time. They must all be of the same value and will have the same message associated with them. Messages can be up to 255 characters.

The checkout process is similar to normal shopping.

Buy a Gift Certificate fields

A gift Certificate can be bought for more than one person but the second and other recipients only can be specified by their e-mail addresses. The e-mail addresses in the bottom box are simply in the form,

Limiting Gift Certificates

The amount of an individual gift certificate can be limited to a Maximum amount. Email to us and request the limit to be set.

Using A Gift Certificate

During the normal shopping for a product on your site, the gift certificate number is entered on the same page as other customer details. The certificate is checked at this time. It is checked for value remaining, authorization and expiration date.

How Gift Certificate Appears on Checkout

The Gift certificate amount is deducted from the purchase price.

In the example below, the gift certificate had enough value to cover the full purchase.



Affiliate Processing Module

Affiliate processing module allows you to associate individual orders with another site, person or company or even far fetched actions as tracking purchases coming from selected advertisements or internal company emarketing campaigns. The affiliates site links to your e-commerce site passing their affiliate number. eCatalog remembers that number and adds that number to any orders processed for that customer for that session.

eCatalog Affiliates Module

The affiliates module associates individual order with an affiliate

Provides detail reports which include:

How does it Works

The affiliate must link to your site with a hyperlink or form specifying

Where nnn is the assigned affiliate number. This is the affid in the affiliate table.

If the affiliate does not exist, eCatalog goes to your home page. No error occurs.

If the affiliate exists, the login count and login date is updated. Each affiliate can have a unique page on your site and eCatalog will automatically link to that page. If no page is specified in the field (DIRECTURL in the affiliates table then eCatalog goes to your home page.

Report Program

Reporting programs have been provided that allows you to:

Registering an affiliate

Affiliates can register themselves by linking to

Or you can use normal eCatalog administration facilities to add names to the affiliates table.

Configuring the Affiliate System

The affiliate system needs some information about your site before you can use it.

The configuration involves you to send to us the following information so we could set the site up.

We need your site details

We need the text that you want to display when a new affiliate registers.

If you are a non English shop, you might need to translate the words used to you language.

Optionally create a page or pages on your Web Site that describe your affiliate system.

Affiliate Options

Certain options need to be set for this module to work.

These need to be set on your site for the affiliate to use shopaffregister.asp.

You must send these information to us before you allow self-registration using


A page on your web site where you supply more information about your affiliate program.

"Your web site name"

The name of your site


Location of your eCatalog site. This will be used to generate a URL to be given to the affiliate to link to your site


Commission rate. Used to generate some sample reports.


Default page on your site that the customer will be directed to.

Information - Shopaffuserinfo.htm

On the affiliate registration page, shopaffregister.asp, you can provide information about your Affiliates program by editing file shopaffuserinfo.htm. This file is plain html but should not include any html start or ending code.

Affiliate Service – Shopaffadmin.asp

Affiliates can register themselves, login and review any orders.

Self Registration - New Affiliate

The system allows a new affiliate to self register. Let us know if is not desirable.

There are two ways to register an affiliate.

One is to allow the affiliate to register themselves using shopaffregister.asp.

The second is for the shop administrator to add the affiliate in the administration section of eCatalog Shopping Cart.

The form below is displayed by shopaffregister.asp. It allows both new registrations and for existing affiliates to update their details.

Affiliate Login – shopafflogin.asp

Affiliates can login and then alter their details or review any orders.


Affiliate Reports

Affiliates can see what orders have been made and the status of their orders.

Confirmation of Registration

Upon registration and change, a confirmation page will appear to confirm the changes.

For new registrations, an e-mail confirmation is set to both the affiliate and the merchant.

How Affiliate Links to Your Site

Where nnn is the affiliate id assigned during registration. You can set up a default page the affiliate can be directed to by setting field DirectURL in the affiliates table. This means you can set-up different pages on your site where different affiliates will be directed.

It is possible that the customer may not buy goods at this time but may come back in the future without the affiliate link. To associate this subsequent order with the affiliate, a cookie must be left on the customer’s PC. You can choose not to do this. Let us know via email and we will stop this.

E-mail Confirmation of Registration

When a new affiliate registers both the merchant and the affiliate receive an e-mail confirmation.

Templates are used to send the e-mail and they can be customized to your site.

Templates are plain text files.

Two templates are supplied and you can alter these or supply your own.

tmp_affiliate.txt for mail confirmation to the affiliate

tmp_affmerchant.txt for mail confirmation to the merchant

Affiliate Template

The sample affiliate template is shown below. More information about templates is in the next section. Templates are a combination of text and special codes in [ ]. These codes tell eCatalog to substitute fields from the database. In this case data is being taken from the affiliates table such as the affiliate id, name, country, phone and e-mail.

Sample tmp_affiliate

Thank you for becoming an affiliate.

Affiliate ID: [Affid]

Name: [FirstName] [LastName]

Country: [Country]

Phone: [Phone]

Email: [email]

Thank you again.

Administration Affiliate Reports

On the administration affiliates report screen a date range can be specified. All affiliates who had links to your site during that period are displayed. If an affiliate is registered but had no links to your site, they are omitted from the report. To override this date check, select 'List all affiliates". If this box is checked, the dates are ignored and a report for all affiliates is provided.

Each affiliate that had at least one visit to your site during the period is displayed.

Login Count represents the number of site visits.

Orders represent the number of orders.

The orders can be displayed as well as a report on your affiliate accounts

Report Output

The detailed report shows you:

From this report you can view the individual orders or create a summary report for that affiliate.


Account Report

This report summarizes the details of the orders for this affiliate for the dates selected. Commission is only calculated on orders that have been processed

The default commission settings are based on processed orders with shipping costs subtracted.



Look and feel

Tell a friend,

Tell a friend

This routine allows you to have the customer tell a friend about your site or about a specific product.

Hyperlink to Tell a friend Use to tell about your site Used to tell about a specific product

Tell A Friend Mail

Tell a friend e-mails the message an a hyperlink. The hyperlink will be different for a product than for a site.

For a product the hyperlink is

or have eCatalog do extended description dynamic catalog.generation.

Customer Reviews

Product Rating and Reviews

Customers can rate and review any product. They can also view other people’s comments.

The merchant can optionally be notified when a review has been added.

Automatic Hyperlinks for Reviews

eCatalog can automatically generate a hyperlink to "write a review" or "read reviews".


To make a review simply click on the link on the product page. Then eCatalog will automatically generate this hyperlink.

Product Review Fields

All Fields are required except the e-mail address. The information is stored in the reviews table. Optionally the merchant is e-mailed a message when are review is written.


The reviews are listed last in first out. The product name is listed along with the links to write a review and go back to the product details.


Upload module

Banking gateways,



eCatalogOrder manual.-------------Appendix.



This is a summary of the database fields and tables in shopping.mdb




Affiliate details


Holds all the categories or departments of products


Discount Coupons


Customer based pricing table


Each time a customer orders a product(s) a record is stored in the database. Even if customer cancels the order, the customer information is not deleted


Gift Certificates


Describes details about the merchant's company.

Used to print merchant details on printed orders


One row for each item ordered. If multiple products are ordered in a single transaction, there are multiple rows in the database.


The order information is stored here.


Lists all categories for a specific product. Used only if the products in multiple categories is used


Product Features such as color, size styles or any other attributes.


Lists all subcategories for a specific product.


The products in the database


Quantity discount table


Search term recording.


Different shipping methods and prices


Sub categories


Sub sub category


Sub sub sub category


Sub sub sub sub category


Supplier Details


Passwords and access rights for users


Log of user login to administer the system


Userids and passwords


Holds the products information.


unique id


Product Code


Product Name - required


Description- required


Price – required


An array of numbers such as 1,2,3 meaning features with featurenum 1,2 etc


Image for the product.

Will be displayed in shopdisplayproducts


Date available - unused


Stock level


Category Number - required.
Determines which category a product is in


Category Name – no longer used


Manufacturer – unused


URL of extended description page. We generate hyperlinks to this page automatically
Only used in shopdisplayproducts




The name of a gif or jpg file that replaces the standard order button in shopdisplayproducts.

As in images/mypic.gif


The number representing the subcategory to which this product belongs

retail price

Displays under Price in italics


A text field that is bolded under descriptions and products are sorted so special offers appear at the top of the products listing.


A caption is entered in this field. This allows the buyer to enter up to 255 characters of information when ordering the product. Obsolete. This is now controlled by ProdFeatures FeatureType












The user who entered the product


A list of keywords used in searching in the form abc, def


If we generate the extended description page, this is the html template to be used. If not specified the default template in shop$config is used.


If we generate the extended description this is a larger image of the product that is displayed instead of the thumbnail


If we generate the extended description page this is the long description of the product. It can have embedded html tag controls.


Use to generate a unique selection

dropdown list. In the form: big, small, large, x-large


Sub sub category that this product belongs

Single name or list of names.


Sub sub sub category that this product belongs


Sub sub sub sub category


Number of the supplier in the suppliers table


A list of catalogids to be displayed when this product is displayed as in " 27,55,990 " etc.


Supplier number from the suppliers table


If set to TRUE, product is not displayed




Unique Id


First Name


Last Name








Zip Code






















Updated each time the user login.


Last date user logged in to buy something




Password for the user


The discount to be applied to customer. If less than 0 it is a percent, if > 0 it is a dollar amount.

















Whether customer wants to be on mailing list




Unique Id


Index back to Customer record


Order Date


Total Price
























Credit Card type


Card Number


Name on Credit Card


Expire date in form mm/yy


Credit Card Address

oprocessed yes/no

0 = unprocessed, 1=processed


User order special instructions










Shipping cost


Shop to name






Shipping method in words


















Time of order


Authorization code from credit card gateways.


Any table add errors are placed here. New 2.40


The actual discount amount given to the customer


Status of the order.

Manually completed by the merchant.


Unique affiliate number associated with this order


Dual Price total


Dual Price taxes


Dual price shipping cost


Dual price discount


Handling Price


Dual Handling Price


Text name of coupon used for purchase


Amount of discount


Dual Discount Coupon amount


Gift Certificate used


Amount of Gift certificate


Dual currency amount used


Set to True if order was canceled


Each order consists of one or more products.


Unique id


Index representing the specific order=Orderid


Index representing the specific product=catalogid




The Product Name.

The name may include product options.


The Unit Price.


The dual price for this item


Number of supplier in suppliers table


Delivery address.

Fields are delimited by semicolons



The products database must have at least one category. These are displayed by shopdisplaycategories.


unique id.




Unused expansion field.


If not null, subcategories will be displayed.


Image to display for this category.



unique id.


Description of this subcategory.


Number representing the main category.




Image to display for subcategory.


If not null, then subcategories will be displayed.



Shipping Methods which are displayed during shopshipping form


Unique ID


Description of Method


Price. Used if next two values are not set and displayed in shopshipping.asp


Minimum cost for this shipping method


Used in weight and quantity calculations


Text field unused


Text Field unused


CurrencyField used for fixed amounts.


Currency Field used for fixed amounts.


File name to be used for special shipping routines



Products may or may not have features such as color or size. These are defined in this table.


Unique Id


Feature Group Number


Feature Group caption that is displayed above drop down list


The feature name displayed in drop down list


Feature price or null or 0


Unused expansion field


If empty default to dropdown
Values can be: dropdown radio checkbox usertext selectlist userprice


If empty only 1 feature can be selected if the word Yes or anything else, multiple features can be selected


True/False whether feature is required



The Administrative userids have access to various menus. These are described here.


Unique id


The name displayed on the menu


The actual URL an of html or asp file to execute


Displayed by shopadmin.asp on right hand side of menu.


The userids and passwords allowed to use the administrative system are here.


Has access to all functions


Has access mainly to shop setup functions

The password is the same as the userid.


Unique Id






A list of numbers 1,2,3 relating to tblAccess.




A string of table names that the user is allowed to view and edit. Customers,Orders,tblUser


Two types are supported. SUPER and Restricted







Each time an administrator does a login into the shopping administration, it is logged here.


Unique id




Time of login

flddate date

Date of Login


Values are In for Login


Coupons can be used to give a discount for all or selected products.


Unique id




The percent discount. For example .10 for 10%


Actual amount in dollars


Date of expiration


Number of times coupon can be used






Optional. List of category numbers to which coupon applies as in " 1,7,3 " etc.


Optional. List of product catalogids to which discount applies as in " 23,77,66 " etc.


Updated each time a coupon is used


Last date coupon was used



Used only if products are allowed to be in multiple categories.

It relates the products to the categories they are in.


Unique id


Category number


product catalog id


Used only if products are allowed to be in multiple categories.

It relates the products to the categories they are in.


Unique id


Category number


product catalog id



eCatalogOrder manual.-------------Appendix.