How XLEcom Handles Add-to-Cart Buttons
XLEcom's Automatic Add-to-Cart Button Type Detection
This program supports both Paypal's and Mal's e-commerce Hyperlink and HTML Form type Add-to-Cart buttons. Refer to the illustration below for examples of both Hyperlink and HTML Form type Add-to-Cart buttons.
XLEcom will automatically detect the type of button to use for each individual Product Ad depending on the properties of the Ad. You can however override the Automatic detection setting and force all Ads to be published using HTML Form type buttons only.
The image below illustrates the four (4) "standard" Add-to-Cart Publishing options, excluding Multiple Price Options. Depending on your store and Product Ads, you can utilize any of the formats you wish.
Note: The Product Ads shown below do not display the longer Item Descriptions. You have the option to suppress Publishing of the Item Descriptions via the Product Ad Display Override Options utility within the program
Multiple Price Options (Included in versions 4.0 and greater)
XLEcom also supports Multiple Price Options that can include up to three (3) drop-down option scroll boxes with each scroll box supporting up to 5 selections. The first of the three scroll boxes can include up to 5 different prices.
For more information on Multiple Price Options, including an example, see the following page: Multiple Price Options
The image below illustrates a Multiple Price Option Product Ad:
Before you make any changes to the installed XLEcom.xls file such as adding your own data, first experiment with the included sample data and account settings so that you will understand how these form options function.
XLEcom's default behavior is to utilize the Hyperlink Add-to-Cart button format only if the Product Ads do not contain user selectable Options.
To utilize the HTML Form option, switch to the Database sheet and check the Option boxes located in the User Field header (see image below). When checked, these User fields will automatically transform into Option fields in which the data in these fields will become selectable options in drop down scroll boxes next to the Add to Cart buttons in your final published Product Ad pages. If you leave the Database Option check boxes unchecked, then these User fields will act as static field values just as they were in the previous releases.
You can have up to five (5) selectable options. These options do not affect the price and only present added selectable features for the product ad such as a size: Small, Medium, Large, X-Large, and XX-Large or colors option like Blue, Red, Green, Yellow, and Orange.
If you check the Option check boxes and leave all five (5) User cells empty, then the Add to Cart buttons will automatically revert back to Hyperlink buttons. If data is present in these field cells and the Option boxes are checked, then the program will automatically generate HTML Form buttons.
Force use of HTML Form type Add-to-Cart buttons for all Product Ads
By checking this box within the "Publish Web Site" utility or on the Product Design sheet, you can override the Automatic Add-to-Cart Button Type Detection setting by "Forcing" the program to publish all of your Add-to-Cart buttons as HTML Form type buttons and not publish any as Hyperlink type buttons. This is useful if you want the Item Quantity edit boxes to be appear on each of your Product Ads.
Display the Item Quantity edit box on all Product Ads
You also have the option to suppress (turn off) publishing of the Item Quantity edit boxes displayed on the Product Ads. This setting only functions on Product Ads that use HTML Form type Add-to-Cart buttons and has no affect on Ads that use Hyperlink type buttons. This setting is called "Display the Item Quantity edit box on all Product Ads".
Examples of both Hyperlink and HTML Form type Add-to-Cart buttons
Database User / Option Columns
There are a total of six (6) extra user columns in the Product Database reserved for you to use. Five of them are located just to the right of the Product Image column and are initially named User 1 thru User 5. The sixth user column is located at the right end of the database and is named Notes. If desired, you can rename the five user column field names, User 1 thru User 5, but do not rename the Notes column. Also, do not leave these user column field names blank. These users columns must contain field names.
You can use these columns for anything you want because they do not initially affect the data for the Product Ads. You can however input constants and formulas into these columns to manipulate the data within the other columns. For example, you can use these columns for adding cost, markup, or profit and calculate a List Price or Our Price. You can also use the five (5) User columns for Add-to-Cart selectable options as mentioned above.
A word of caution. If you decide to use calculation formulas within the Database, keep in mind that when you use the Product Ad Entry form on the Product Design sheet to update your product data via the "Save Ad" function, the values in the Database will be overwritten with the constant values from the Product Ad Entry form for that particular product. To prevent the overwriting and to control the behavior of the "Save Ad" function, use the Overrides options on the Product Design sheet. Make sure you check your data prior to publishing if you plan to edit the product database.