Login Count: This is a count of how many times this affiliate has logged into the system.
Login Date/Time: This is the date/time this affiliate last logged in.
Commission Rate: This is the rate at which the affiliate's commission is calculated. Should be entered as a full number - eg. 5 = 5% or 40 = 40%
Orders: This is the number of orders that have been completed through this affiliate.
Total Commission: This is the total commission the affiliate has generated.
Type of Payment: This is the method that the affiliate has requested that they are paid by (eg. PayPal).
Bank/Bank Account/Etc: This is the affiliate's banking details, if they have requested payment by this method.
Password: This is the affiliate's password so they can login to the system.
Direct URL: When a customer arrives at the site via an affiliate link, they will be redirected to the page specified in here (eg. shopdisplaycategories.asp).
Referral ID: If this is a sub-affiliate of another affiliate, you need to enter the ID of the master affiliate here.
Master Commission Rate:If this is a sub-affiliate of another affiliate, and you want the master affiliate to have a different rate of commission from this sub-affiliate, enter the value here.
Template: If you want this affiliate to have a custom template for mailing their customers, enter the template name here.
<% case "affiliatelog" %>This table stores a record of everyone who has visited your site via an affiliate, so you shouldn't need to add records to this manually.
affid: This is the ID of the affiliate who the customer has arrived through.
affdate/afftime: This is the date/time of the customer's visit.
affdirecturl: This is URL of the affiliate that the customer arrived through.
affreferrer: This is the page the customer hit before arriving at your site.
affcookie: This is whether the affiliate information was stored as a cookie on the customer's computer.
<% case "customers" %>contacttypeid: This field is used to group customers in Customer Pricing.
contactreason: When a customer signs up just for the mailing list on your site, this field will have the value "registration" in it, so you can distinguish them as mailing list customers.
logincount: This is how many times the customer has logged into your store.
lastlogindate/lastlogintime: This is the last date/time that the customer logged into your store.
discount: If the customer should receive a discount specific to them, you can enter it here.
cardno: If you are accepting credit cards on your site, the customer's credit card number will be stored here.
cardexpires: If you are accepting credit cards on your site, the customer's credit card expiry date will be stored here.
cardname: If you are accepting credit cards on your site, the name on the customer's credit card will be stored here.
cardaddress: If you are accepting credit cards on your site, the address associated with the customer's credit card will be stored here.
cardcvn: If you are accepting credit cards on your site, the customer's credit card CVN will be stored here.
maillist: This is a flag describing whether the customer wants to be on your mailing list or not.
productgroup: If you have xproductmatchcustomer set to Yes in your configuration and you enter a value in this field, this customer will only see products and categories with the same value in their customermatch field.
cookiequestion: This is a flag describing whether the customer opted to have their details stored in a cookie on their computer for quick access next time.
pointstotal: If you have Points/Rewards installed and turned on, this field tells you how many points the customer has accumulated in total.
pointsremaining: if you have Points/Rewards installed and turned on, this field tells you how many points the customer has left on their account.
taxexempt: If this customer is not to be charged tax, enter Yes or True into this field.
<% case "reviews" %>catalogid: This is the catalogid of the product this review is for.
authorized: This is a flag to determine whether the review has been authorized for display on your site.
reviewdate/reviewtime: This is the date/time that the review was submitted.
rating: This is the rating that the customer has given the product.
title: This is the title that the customer has given their review.
comment: This is the customer's comments about the product.
location: This is the location that the customer has entered.
<% case "suppliers" %>supplieruserid: This is the userid from the tbluser table for this supplier, so that they can log into the <%=getlang("langcommonsoftwarename")%> administration.
logincount: This is how many times the supplier has logged in.
lastlogindate: This is the date that the supplier last logged in.
supplierpassword: This is the supplier's password so that they can log into the system.
template: This is the template for the email that is sent to the supplier when one of their products is ordered from your site.
commissionrate: This is the rate at which the supplier's commission is calculated.
<% case "billing" %>billamount: This is how much each bill is for the customer (eg. 29.95).
billnextbilldate: This is the date that the customer's next bill is due.
billinstallments: This is how many bills the customer should receive.
billinstallmenttype: This is the period between each bill. Valid entries for this field are: DAY, WEEK, MONTH, YEAR
billinterval: This is the interval between each billing period.
billlastbilldate: This is the date the last bill was due.
billorderid: This is the ID of the order associated with this recurring billing record.
billlastmaildate: This is the date the last bill was sent to the customer.
billsentcount: This is how many bills have been sent to the customer.
billcanceled: If this is set to True, no further bills will be sent to the customer.
billcompleted: If this is set to True, it means that this billing record is no longer used since all installment e-mails have been sent. It is normally set by <%=getlang("langcommonsoftwarename")%> automatically after the last installment is sent.
billcreationdate: This is the date this billing record was initially created.
billenddate: Used to stop billing at a certain date regardless of whether the number of installments has been reached.
billtemplate: If you want to use a specific template for the emails sent for this billing record, enter the template name here.
<% case "coupons" %>couponname: This can be anything - it is what the customer enters when they checkout to receive the coupon discount.
couponamount: The amount of discount. It can be a dollar amount, or left empty if you want to use a percentage.
couponpercent: The percentage discount in the form ".10" or, for currencies that use comma as decimal point ",10" (without quotes).
couponstartdate: This is required, it is the date from which the coupon is able to be used.
couponenddate: This is optional - it is the last date that the coupon is valid.
couponlimit: If you want to limit the coupons use to, for example, the first hundred customers, you can enter the limit here.
couponcategories: If you want to limit the use of the coupon to certain categories, enter their IDs here, separated by commas.
couponproducts: If you want to limit the use of the coupon to certain products, enter their IDs here, separated by commas.
couponusedcount: This is automatically updated by <%=getlang("langcommonsoftwarename")%> - it is how many times this coupon has been used.
couponlastuseddate: This is automatically updated by <%=getlang("langcommonsoftwarename")%> - it is the last time that the coupon was used.
couponcustomers: If you want to limit the use of the coupon to certain customers, enter their IDs here, separated by commas.
couponminimum: If you want to limit the coupon to orders over a certain amount, enter the minimum order cost here.
couponaffid: If you want this coupon to be linked to an affiliate ID, then enter the ID here. This means that when a customer enters this coupon, the purchase will also be linked to the affiliate and they will get a commission.
<% case "gifts" %>giftissuedate: This is the date the gift certificate was originally purchased.
giftauthorized: This is a flag to determine whether the gift certificate has been authorized for use on your site.
giftamount: This is the amount of credit purchased for the gift certificate.
giftamountremaining: This is how much credit is remaining on the gift certificate.
giftorderid: This is the order ID the gift certificated was purchased with.
giftcustomerid: This is the customer ID of the gift certificate's purchaser.
giftuseddate: This the last date that the gift certificate was used.
giftusedcustomerid: This is the customer ID of the customer who last used the gift certificate.
giftusedlastamount: This is how much of the credit was used in the last purchase using this gift certificate.
giftusedorderid: This is the order ID from the last order made using this gift certificate.
giftexpirydate: If you want to have this certificate expire after a certain amount of time, enter the expiry date here.
giftusedcount: This is how many times this gift certificate has beeen used.
<% case "registrant" %>logincount: This is how many times the customer has logged into your store.
lastlogindate/lastlogintime: This is the last date/time that the customer logged into your store.
regpassword: This is the registrant's password for logging in and editing the gift registry.
publicpassword: This is the public password for logging in and browsing/purchasing items from the registry.
shippingtype: This is the shipping type chosen for shipment of the registry items to the registrant.
regorderid: This is the order ID of the registry.
publicallowed: This determines whether the general public can access this registry without a password from the registrant.
processed: This is whether the registry has been completed and shipped to the registrant.
<% case "pinnumbers" %>catalogid: The associated product catalogid for this record.
pinnumber: The pin number to be used.
ordered: This is automatically filled in when the pin number is used.
pinproductmatch: If the catalogid field is not used to match the product record, this is the field name to be used in the match. It is assumed to be a text field (eg. ccode).
<% case "projects" %>pdate: Today's date or the date of the project.
description: Description of up to 255 characters.
customer: Name or organization who is going to pay for this project.
price: The amount being paid for this project.
dualprice: If you are using dual pricing, this is the cost of this project in the alternate currency.
paid: Whether or not the customer has paid for the project.
datepaid: The date that the customer paid for the project.
orderid: The order ID associated with this project.
canceled: A flag to specify that this project has been canceled.
billid: If this project is to be a recurring billing item, this is the ID of the bill record.
billdescription: If this project is to be a recurring billing item, this is a description of the bill.
<% case "categories" %>Description: A name for your category.
Image: You can either enter in the path for your image, or you can use the image upload feature by clicking the Upload button. If you have already uploaded an image, you can view it by clicking the View link.
Higher Category: If this category is a sub-category, select the category that should be its parent.
Sub-Categories: Select Yes if this category is going to have sub-categories below it.
Hide: Set to Yes if you don't want this category to be displayed in your store.
Match Product: If you are using product matching, enter the matching keyword here.
Match Customer: If you are using customer matching, enter the matching keyword here.
catmemo: You can enter a detailed description of your category here using HTML or plain text.
catextra: Enter the name of a HTML or text file here that includes a detailed category description that is to be included at the top of certain product pages.
Language: This field is included for compatibility but is not used by any specific <%=getlang("langcommonsoftwarename")%> functions any longer. You can add translations of the category after you have added the initial record by clicking the "Add Translation" button.
Template: If you want this category to display using a specific template, you can do this by adding the name of the template file here.
Impressions: This is how many people have viewed this category.
<% case "content" %>Type: A name for your content.
Content Header: You can enter a header for your content here using HTML or plain text.
Content Body: You can enter your content here using HTML or plain text.
Image: You can either enter in the path for your image, or you can use the image upload feature by clicking the Upload button.
Hide: Set to Yes if you don't want this content to be displayed in your store.
Template: If you want this content to display using a specific template, you can do this by adding the name of the template file here.
Language: This field is included for compatibility but is not used by any specific <%=getlang("langcommonsoftwarename")%> functions any longer. You can add translations of the content after you have added the initial record by clicking the "Add Translation" button.
Only available to registered users: Set this to Yes if you want this content hidden from people who aren't logged into your store.
Impressions: This is how many people have viewed this content.
Date Added/Updated: This is the date the content was first added and then the last time it was updated.
<% case "templates" %>Template File: A name to reference your template by. It should generally be the same as a filename (eg. tmp_product.htm).
Template: Enter the HTML or text of the template here.
<% case "languages" %>lang: Enter the name of the language that this variable is for (eg. English or German).
keyword: Enter the keyword that will be used to refer to this language variable (eg. langcommonselect).
caption: Enter the value for this language variable (eg. Select or Click to Continue).
<% case "tblaccess" %>Menu Name: This is the display name for the menu item.
Filename: This is the file the menu item will link to.
Comment: This is not currently used by <%=getlang("langcommonsoftwarename")%>.
Section: This is the top level section this menu item will appear in (eg. everyday, occasional or setup).
Menu: This is the sub section this menu item will appear in (eg. navigation or langauges).
Order: This is the order this menu item will appear in the sub section.
<% case "prodfeatures" %>Feature Number: Every feature needs to have a feature number. If you have three colors, they will all have the same feature number.
Feature Caption: The caption to appear with the feature.
Feature Name: The unique name of this feature. In this case the color. Two other records will have different colors.
Feature Price: A feature can be free or have a price, which is added to the price of the product.
Feature Type: This defines how the features appear in the product listing in your store.
Feature Percent: A percentage of the cost of the main product that should be used as the price for the feature. eg. If featurepercent is set to 10, then the cost of the feature when added to a $10 product will be $1.
Multiple: If this is set to Yes, the customer can choose multiple features for each product.
Required: If this is set to Yes, the customer must choose a feature.
Image: An image to be displayed when the feature is displayed.
Weight: Weight added to the overall product weight, for use in shipping calculations.
<% case "quantitydiscounts" %>categoryid: Discount should apply to products in this category - leave blank to apply to all categories
catalogid: Discount should apply to this specific product - leave blank to apply to all products.
minquantity: The minimum quantity before the discount should apply
quantity1: The upper level of the quantity. For example if a discount is to be applied for purchases over 5 to 10 items set minquantity 5 and 10 in this field
discount1: The amount of discount. If it is less than 1 such as .10 it is treated as a percent and if greater than 1 it is treated as an actual discount amount
quantity2 and discount2, etc: These are the next ranges. The quantity must be higher that the previous quantity. You must set the last quantity to a high number such as 99999
groupfordiscount: Will group products before calculating the discount. This allows you to apply a discount across a range of products. This field must match the same field in the products table. If using this facility, make sure catalogid and categoryid are set to null.
<% case "configuration", "configuration1" %>PLEASE DO NOT EDIT THIS TABLE UNLESS YOU ARE 100% SURE WHAT YOU ARE DOING. ANY MISTAKES COULD CAUSE YOUR ENTIRE STORE TO STOP FUNCTIONING!
Fieldname: The name of this config option (eg. xincludestates).
Fieldvalue: The value of this config option.
Fieldgroup: OLD CONFIG MODE: the section this config option appears in from the config menu.
FieldYesNo: True/False whether this config option should be a Yes/No option.
Message: The help message associated with this config option.
Show: Whether or not this config option should appear when browsing or searching the config.
FieldGroup2: NEW CONFIG MODE: the section this config option appears in from the config menu.
<% case "currencyvalues" %>You can update these values using information from online currency conversion sites, such as http://www.x-rates.com/
CID: The short name for this currency (eg. USD or AUD).
FullUnitName: The long name for this currency (eg. US Dollars or Australian Dollars).
ConversionValue: The conversion rate to calculate this currency.
CurrencySymbol: The symbol for this currency (eg. AU$ or £).
TheImage: The patch to the image of the flag for this currency.
Hide: True/False whether this currency should be displayed on your site.
<% case "customerprices" %>customerid: This is the customer ID for the customer who will receive the discount.
categoryid: The category ID for the category that this discount will apply to.
catalogId: The catalog ID for the product that this discount will apply to.
discountpercent: If you want the discount to apply as a percentage of the price, enter the percentage here.
discountamount: If you want the discount to be a fixed amount, enter the value here.
<% case "downloads" %>orderid: This is the order ID that the download originated from.
catalogid: This is the catalog ID of the product that the download is associated with.
customerid: This is the customer ID of the customer who downloaded the file.
filename: This is the name of the file that was downloaded.
downloadcount: This is how many times this file has been downloaded from this order.
downloaddatelimit: This is the expiry date of the download.
downloadmaxcount: This is the maximum number of times this file can be downloaded.
downloadcreatedate: This is the date the order was completed.
authorized: This is whether or not the ability to download has been authorized or not.
lastdownloaddate: This is the last date the file was downloaded.
<% case "hackers" %>ipaddress: This is the IP address of the hacker.
email: This is the email address used by the hacker.
comment: You can enter any comments you like here, they are not used by <%=getlang("langcommonsoftwarename")%>.
<% case "menuitem" %>PLEASE NOTE: We do not recommend you update your menu here. Please go to the Site Navigation page to update your menu.
name: This is the display name for your menu item.
seq: This is the order that the item will appear in the menu.
pmenuitemid: If this menu item is a sub-menu item, this is the ID of the parent menu item.
url: This is the URL that the menu item will link to.
contentid: If you want your menu item to link to an entry in your content table, enter the "type" of the content here.
openin: You can have the link open in either the same browser window (_self) or a new browser window (_blank).
<% case "oitems" %>orderid: This is the order ID that these items belong to.
catalogid: This is the catalog ID of the product that has been ordered.
numitems: This is the number of this item that have been ordered.
itemname: This is the name of the item that has been ordered.
unitprice: This is the price of the item that has been ordered.
dualprice: This is the dual currency converted price of the item that has been ordered.
supplierid: If you have suppliers, this is the ID of the supplier from the suppliers table that this product comes from.
features: If the customer has selected features for this product, this is a listing of the options they have chosen.
pinnumber: If you are using pin numbers, this is the pin number that has been sent for this product.
<% case "orders" %>ocustomerid: This is the ID of the customer that placed this order.
odate: This is the date the order was placed.
orderamount: This is the total cost of the order.
oprocessed: Whether or not the order has been marked processed.
otax: How much tax was applied to this order.
oshipmethod: The method of shipping requested by the customer.
oshipcost: YThe amount the customer was charged for shipping.
opaymethod: The method of payment chosen by the customer.
oauthorization: If you have requested the CVN, it will be stored here.
odiscount: If the customer received a discount, this is how much it was.
oaffid: If the order was made through an affiliate, this is their affiliate ID.
odualtotal/odualtaxes/odualshipping/etc: If you have dual currency turned on, this is converted value.
ohandling: This is any handling fees the customer was charged.
coupon: If you have coupons turned on, this is the coupon that the customer used.
coupondiscount: This is how much discount the customer received from the coupon.
giftcertificate: If you have gift certificates turned on, this is the gift certificate the customer used.
giftamountused: This is the amount of the order that was covered by the gift certificate.
canceled: A true/false flag to say if the order has been cancelled.
ipaddress: This is the IP address of the customer.
hackeryesno: If you have hacker checking turned on, this is a flag to say if the order was created by a hacker.
opending: A flag to say whether this order is pending or not.
producttotal: A total of the products ordered, minus shipping, tax, etc.
upstrackno: If using UPS, enter the tracking number you received when shipping this item so the customer can use the tracking function.
<% case "ordertracking" %>orderid: This is the order ID that these tracking items belong to.
trackcomment: This is the message for this tracking item.
trackdate/tracktime: This is the date/time this message was entered.
trackname: This is the name of the person who entered the tracking message.
trackview: This is whether or not the customer should be allowed to see this message.
trackemail: This is the email address of the person who entered the message.
<% case "prodcategories" %>intcategoryid: This is the category ID that you are entering the product into.
intcatalogid: This is catalog ID for the product that you want to assign to the category above.
<% case "registryitems" %>registrantid: This is the ID of the registry this item belongs to.
orderid: This is the order ID this registry is associated with.
regcatalogid: This is the catalog ID of this product.
numitems: This is the number of this product added to the registry.
itemname: This is the name of the item.
unitprice: This is how much this product costs.
dualprice: If you are using dual currency, this is the alternate cost of this product in the secondary currency.
supplierid: If you are using suppliers, this is the ID of the supplier that this product is sourced from.
numpurchased: This is the number of this item that have been purchased from the registry.
purchaseorderid: This is the order IDs of the orders that have purchased this item for this registry.
<% case "savedcarts" %>cartname: This is the name the customer has saved this cart under.
customerid: This is the customer ID of the customer who has saved this cart.
cartcookies: This is the cart data as it would be stored in the cookie.
savedate/savetime: This is the date/time the cart was saved.
<% case "searchresults" %>rdate/rtime: This is the date/time the search was completed.
categories: These are the categories that the customer chose to search.
subcategories: This is the number of this product added to the registry.
words: These are the words the customer entered to search on.
lastname: This is the customer's last name (if they were logged in).
customerid: This is the customer's customer ID last name (if they were logged in).
ipaddress: This is the customer's IP address.
<% case "tbllog" %>fldusername: This is the username of the person trying to log in.
flddate/fldtime: This is the date/time the login/logout attempt was made.
fldinout: This is whether the person was trying to login or logout.
fldipaddress: This is the IP address of the person logging in/out.
<% case "tbluser" %>PLEASE NOTE: We don't recommend you use this page to update your users. Please go to the Admin Users page to complete this process.
fldusername: This is the username of the admin user.
fldpassword: This is the password of the admin user.
fldaccess: This is a comma delimited list of the menu items this user has access to.
tablesallowed: These are the database tables that the admin user is allowed to access.
admintype: The admin user can either be SUPER or RESTRICTED. If restricted, they can only edit content they have created themselves.
<% case "translatecategories" %>Language: This is the language that this translation belongs to.
categoryid: This is the category ID for the category that this translation should be linked to.
description: This is the translated name for this category.
<% case "translatecontent" %>lang: This is the language that this translation belongs to.
contentid: This is the content ID for the content that this translation should be linked to.
message: This is the translated text for the message field of the content.
message2: This is the translated text for the message2 field of the content.
<% case "translateproducts" %>Language: This is the language that this translation belongs to.
catalogid: This is the catalogid ID for the product that this translation should be linked to.
Name: This is the translated text for the name field of the product.
Description: This is the translated text for the description field of the product.
More: This is the translated text for the more field of the product.
<% case "translateprodfeatures" %>Language: This is the language that this translation belongs to.
Feature ID: This is the feature ID for the feature that this translation should be linked to.
Feature Caption: This is the translated text for the caption field of the feature.
Feature Name: This is the translated text for the name field of the feature.
<% case else %> No help available <% end select %> <% GenerateDisplayBodyFooter End Sub %>