First Things First

First Things First
To get the most out of the program. please review the following topics before you begin your evaluation.

  • Using This Program
  • Item Descriptions - Just turn them back ON
  • Demonstration Sample Data
  • Standard and Inventory Type Sample Stores included with the Program

Using This Program
This XLEcom program uses your internet web browser for both previewing HTML pages and for viewing the final Published web site. For efficient visibility usage of this program, it is suggested that you do not run Microsoft Excel and your internet web browser in a maximized window mode. You should run both Microsoft Excel and your internet web browser in windows sized to provide a good view of the content.  Optimally, it would be best to have both Microsoft Excel and your internet web browser windows positioned side-by-side.

The reason for this is that this XLEcom program uses your internet web browser for both previewing HTML pages and for viewing the final Published web site. Throughout the design process of your web site, you will be previewing your designed pages within your internet web browser. It is much easier to make changes to your web site and view the changes in your internet web browser while both windows are displayed on the screen at the same time

Item Descriptions - Just turn them back ON
The XLEcom program is initially provided with a Demonstration web store called DemoStore Online. The program is set to Publish this web store using the "Two Ad Column Layout" and  small condensed Product Ads by suppressing the publishing of the long Item Descriptions. To Publish the web store to display the long Item Descriptions, you must turn them back ON.

To turn the Item Descriptions back ON, look in the "Publish" or "Site Setup" functions for the "Product Ad Display Override Options" utility as shown in the image below, and check the "Display Item Description" check box. You may also want to set up the site to use the "Single Ad Column Layout" so that Product Ads displaying the long Item Descriptions will appear visually better to the website visitor. Now you can republish the store displaying the long Item Descriptions.

Demonstration Sample Data
It is highly recommended that you first experiment with the demonstration sample data provided within the program before you begin creating your own Ecommerce web site. By experimenting with this sample data you will quickly learn the program's capabilities and how to use it efficiently. You should also review the published demonstration web site so that you will understand how it functions and how you can customize it for your needs. After you are familiar with the program you can remove the demonstration sample data using the Utilities function on the Product Design sheet.

At a first glance this program may seem a little overwhelming due the number of the features, controls, and settings offered within this program. Most of these features, controls, and settings do not have to be changed from the default state thus minimizing the time needed to develop your web site(s). A majority of them are provided so that you can customize the look and feel of the web site(s). Read the Quick and Simple Setup instructions below to easily get started today.

Standard and Inventory Type Sample Stores included with the Program
This program is initially loaded with data for a Standard demonstration ecommerce store called DemoStore Online. This demonstration store features electronic consumer products. There is also another version of this demonstration store, included as a Store Module, that supports Inventory control. This Inventory control Store Module is located in the \Modules\DemoStore directory, and the file name is "DemoStore with Inventory mm-dd-yyy.xls" where mm-dd-yyyy is the date the file was created.

The only difference between the Standard and Inventory stores is that the Inventory store utilizes formulas within the Product Database. The User fields within the Product Database contain Inventory, Cost, Markup, and formulas to calculate Profit, the sale price (Our Price), and the You Save amount. The Publish Ad field also utilizes a formula to determine if the product should or should not be publish. If the Inventory is zero (0) then a formula in the Publish Ad field returns FALSE meaning that the product will not be published. Based on the Inventory values, the Stock Note field values also change. Keep in mind that this is an example of what can be achieve by utilizing formulas within the Product Database. You can enter any type of formulas you want in order to achieve a desired result.

You have two options for importing the Inventory store. You can either import the data directly into this program via the Utilities function or via the Store Modules function. If you choose to use the Store Module option, all the file assets associated with this store such as the products images and support documents will also be imported into this program. Since both the Standard and Inventory stores utilize the same file assets, products, and categories, you can use Utilities function method of import.

Note: This particular Inventory sample store was setup to utilize Hyperlink only type Add-to-Cart Button without any Options. This is because all five (5) of the User fields within the Database are used for the Inventory values and functions. If you import this Inventory Sample store into the program, you must first do the following after you import the data prior to doing anything else. (1) Uncheck all five (5) Option check boxes above the User fields on the Database sheet. (2) Uncheck the Publish Ad, Profit, Stock Note, and Our Price (Required) check boxes within the Save Ad "Overrides" function dialog box on the Product Design sheet. (3) Make sure the "Force use of HTML Form type Add-to-Cart buttons for all Product Ads" check box is unchecked.