====================================================

How easy easy can be.

====================================================

Lets get started.

Company, categories, products, Sub categories.

====================================================

Easy going.

Products, Features, Images and Logo

====================================================

Over the hump.

Shipping charges, Card charges and other options.

====================================================

Finishing Up.

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

Customer Service Center

====================================================

eMarketing

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

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

And much much more!

====================================================

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

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. 

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

• Name          Part Number
• Description  What the customer sees at minimum
• Price            The price you sell the product
• And select the category (Department) that the product belongs to.

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.

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

====================================================

====================================================

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

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.

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.

• Drop Down Lists
• Check Boxes
• Radio buttons
• User Supplied Text
• User Supplied Prices

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

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

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

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.

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

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.

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.

• Dropdown

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.

FeatureType=UserText

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.

• FeatureType=Radio
• FeatureCaption should be the same for all items with same featurenum
• FeatureName should be the individual different buttons
• Featureprice optional price associated with feature

• FeatureType=Checkbox
• FeatureCaption should be the same for all items with same featurenum
• FeatureName should be the individual different buttons
• Featureprice optional price associated with feature
• FeatureMulti Optional. Use Yes to allow multiple selections

• FeatureType=DropDown or Null (nothing in the field)
• FeatureCaption should be the same for all items with same featurenum
• FeatureName should be the individual different buttons
• Featureprice optional price associated with feature
• FeatureMulti Optional. Use Yes to allow multiple selections

• Featuretype=SelectList
• FeatureCaption should be the value to be placed above the text box

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.

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.

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.

• Featuretype="selectlist"
• Featurecaption="Caption for this feature"
• Featureother="Pother1"

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.

• FeatureType=UserPrice
• FeatureCaption should be the value to be placed above the text box

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:

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 .

• Large image URL and
• More Information html code and the word
• SHOPEXD.ASP on Extended description page.

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.

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.

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:

"Your Shipping Method" "3.00" ' your price

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

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.

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.

Many customers have asked us about UPS and FEDEX shipping.

We have developed two special modules for these ocasions.

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.

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.

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.

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.

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

• Add a product to the shopping cart
• Display products based on category, subcategory, product field
• Search for products
• All the features of your existing web site are still there but eCatalog shopping component is now a part of your web site.

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

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>

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

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

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>

To display a specific product use:

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

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.

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

<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>

</form>

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

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">
</form>

<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>

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:

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

The administration components let you

• setup your company information,
• view orders,
• change any table,
• update product information,
• search for data,
• add new products,
• categories,
• add and delete users,
• and so on.

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 is for the merchant or administrator and not for the customer.

The administration facilities include:

• Add, delete and modify Company information
• Add, delete and modify categories and subcategories
• Add, delete and modify products
• Add, delete and modify any other eCatalog table
• Define administrator userids
• Define menus and tasks for each administrator
• Restrict administrators to viewing or updating specific tables
• Display sales reports
• Display stock low reports
• Perform searches of the database
• Export data from tables
• Mail to selected customers
• Upload and maintain images if this module is enabled.
• Do most merchant and administrative functions

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 a successful login has been done, a menu displays the options available for the user.

Each administrative user can be given different menus.

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.

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 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.

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

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

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.

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.

The following fields have special meanings

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".

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.

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:

• Discount to the total price
• Discount to specific products
• Discount to specific category of products

Discounts have the following attributes:

• A name that you define when you create a coupon
• A start date
• An ending date
• A use count.

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.

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.

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.

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

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

CouponCategories

This is a list of category numbers to which the discount applies. For example
1,55,3,2

CouponProducts

This is a list of product catalogids numbers to which the discount applies. For example
7,3,13,77,22,1

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

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.

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.

• What happens if the gift certificate exceeds the purchase?

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

• What happens if the gift certificate is less than the amount ordered?

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

• How do I know who used a 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.

• Are Gift Certificates Hacker Proof?

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

• What about Server Failures?

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.

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.

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

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.

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 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.

The affiliates module associates individual order with an affiliate

Provides detail reports which include:

• The number of links to your site for each affiliate
• The number of orders
• The total of all orders
• Date of last link to your site
• Commission reports

• Ability to add, alter affiliates using standard eCatalog administration
• Affiliate Administrator.
• Affiliates can review orders and change their details.

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.

Reporting programs have been provided that allows you to:

• Summarize all affiliate activity
• View orders for a specific affiliate
• View account details by date range
• Edit affiliate records

Affiliates can register themselves by linking to

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

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.

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

Affiliates can register themselves, login and review any orders.

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.

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

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

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.

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.

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

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.

Thank you for becoming an affiliate.

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

The detailed report shows you:

• Link Count - the number of times someone linked to your site
• Order Count - the number of orders received
• Amount - Total amount of all the orders
• The Distributor name
• Commission - an approximate commission based purely on multiplying the amount by the commission rate.

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

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.

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

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.

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

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.

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.

====================================================

====================================================

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

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

Shipping Methods which are displayed during shopshipping form

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

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

The password is the same as the userid.

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

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

It relates the products to the categories they are in.

It relates the products to the categories they are in.

====================================================

====================================================

====================================================