XLEcom Version 3.0 Released

XLEcom Version 3.0 Released

Version 3.0 (3.0.408) released on August 15, 2005

New Features:

Now Includes Product Options - Added HTML Form Type Add-to-Cart Button Support
This new version now supports both Paypal's and Mal's e-commerce HTML Form type Add-to-Cart buttons in addition to the standard Hyperlink type buttons. The store owner is now able to present selectable options via drop-down scroll boxes within each of their Product Ads. See below for more information.

Import / Export Feature Upgrade
More options are offered to the XLEcom user for both data Import and Exporting.

Sam Raheb
XLEcom Program Developer


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 table 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) possible Add-to-Cart Publishing options. Depending on your store and Product Ads, you can utilize any of the formats you wish.

Usage
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 four (4) 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, and X-Large or colors option like Blue, Red, Yellow, and Orange.

If you check the Option check boxes and leave all four (4) 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

PayPal Add-to-Cart Hyperlink

<a href="https://www.paypal.com/cart/add=1&amp;business=demo_only%40xlecom.com&amp;item_number=ABCO-15TTFB&amp;item_name=ABCO+15TTFB+Black+Flat+Panel+15+inch+LCD+Display&amp;quantity=1&amp;amount=29 5.95&amp;shipping=5.00&amp;shipping2=3.00&&amp;handling=10.00&amp;tax=8.25&amp;return=http%3A//www.yourdomain.com/html/successful.html&amp;cancel_return=http%3A//www.yourdomain.com/html/canceled.html"><img src="add-to-cart-01.gif" border="0" alt="Add to Cart"></a>

Mal's e-commerce Add-to-Cart Hyperlink

<a href="http://ww7.aitsafe.com/cf/add.cfm?userid=98103224&scode=ABCO-15TTFB&product=ABCO%2015TTFB%20Black%20Flat%20Panel%2015%20inch%20LCD%20Display&qty=1&noqty=0&price=295.95&units=25&tax=8.25&return=www.yourdomain.com"><img src="add-to-cart-01.gif" border="0" alt="Add to Cart"></a>

PayPal's Add-to-Cart HTML Form

Form Tag Start:

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">

Cart:

<input type="hidden" name="cmd" value="_cart">

Paypal Email Address:

<input type="hidden" name="business" value="demo_only@xlecom.com">

Add:

<input type="hidden" name="add" value="1">

Undefined Quantity [optional]:

<input type="hidden" name="undefined_quantity" value="1">

Item Name [optional]:

<input type="hidden" name="item_name" value="ABCO 15TTFB Black Flat Panel 15 inch LCD Display">

Item Number [optional]:

<input type="hidden" name="item_number" value="ABCO-15TTFB">

Item Amount (Our Price) [optional]:

<input type="hidden" name="amount" value="295.95">

Shipping [optional]:

<input type="hidden" name="shipping" value="5.00">

Add. Shipping [optional]:

<input type="hidden" name="shipping2" value="3.00">

Handling [global - optional]:

<input type="hidden" name="handling" value="10.00">

Tax [global - optional]:

<input type="hidden" name="tax" value="8.25">

Currency Code [global - optional]:

<input type="hidden" name="currency_code" value="USD">

Company logo [global - optional]:

<input type="hidden" name="image_url" value="http:/www.yourdomain.com/images/companylogo.gif">

Successful Return Page [global - optional]:

<input type="hidden" name="return" value="http://www.yourdomain.com/html/successful.html">

Cancel Return Page [global - optional]:

<input type="hidden" name="cancel_return" value="http://www.yourdomain.com/html/canceled.html">

Quantity [optional]:

<input type="text" name="quantity" size="3" value="1">

Option Descriptor [optional]:

<input type="hidden" name="on0" value="Selected">

Select Tag Start:

<select name="os0">

option1:

<option value="Desktop Stand">Desktop Stand

option2:

<option value="Wall mount">Wall mount

Option Tag End:

</option>

Select Tag End:

</select>

Submit:

<input type="image" name="submit" src="add-to-cart-01.gif" border="0" alt="Add to Cart">

Form Tag End:

</form>

Mal's e-commerce Add-to-Cart HTML Form

Form Tag Start:

<form action="http://ww7.aitsafe.com/cf/add.cfm" method="post">

userid:

<input type="hidden" name="userid" value="98103224">

price:

<input type="hidden" name="price" value="295.95">

scode [optional]:

<input type="hidden" name="scode" value="ABCO-15TTFB">

noqty [optional]:

<input type="hidden" name="noqty" value="0">

units [optional]:

<input type="hidden" name="units" value="25">

tax [global - optional]:

<input type="hidden" name="tax" value="8.25">

currency [global - optional]:

<input type="hidden" name="currency" value="3">

lg [global - optional]:

<input type="hidden" name="lg" value="0">

return [global - optional]:

<input type="hidden" name="return" value="http://www.yourdomain.com">

qty [optional]:

<input type="text" name="qty" size="3" value="1">

product:

<input type="hidden" name="product[]" value="ABCO 15TTFB Black Flat Panel 15 inch LCD Display">

Select Tag Start:

<select name="product[]">

option1:

<option value="Desktop Stand">Desktop Stand

option2:

<option value="Wall mount">Wall mount

Option Tag End:

</option>

Select Tag End:

</select>

Submit:

<input type="image" name="submit" src="add-to-cart-01.gif" border="0" alt="Add to Cart">

Form Tag End:

</form>

Database User / Option Columns
There are a total of five (5) extra user columns in the Product Database reserved for you to use. Four of them are located just to the right of the Product Image column and are initially named User 1 thru User 4. The fifth user column is located at the right end of the database and is named Notes. If desired, you can rename the four user column field names, User 1 thru User 4, 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 four (4) 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.