Jim:

XLEcom does not "dynamically" keep track of the Inventory you sell. If needed, you can add a sheet to the program to "manually" keep track of the Inventory you sell.

There is also an Inventory example Excel file called "DemoStore with Inventory 10-07-2005.xls" located in the Modules\DemoStore\ folder that came with the program. I suggest you look at this example for a possible way of controlling your inventory. You can either open it manually or better yet, use the Store Module "import" function on the Product Design sheet to seamlessly import it into the program. Save you work before performing the Import. Maybe this example will work for you.

As you can see in the example, some of the User / Option columns in the Database are now used for keeping track of Inventory and additional formulas were added to some of the other columns to make the sheet function as a inventory solution. This way when the inventory is zero (0) for a particular product, the Publish field is changed to false. Take a look at the formulas in the cells so that you can understand how the sheet functions. The formulas are coded with blue color fonts. For functionality with the XLEcom program, remember to uncheck the option boxes along the top of the User columns since these columns are now being used as User data instead of product options.

Keep in mind that this is an example solution for inventory control. You can use this example for controlling inventory or develop an entirely new one. The great thing about the Excel environment is that you can create a solution that meets you goals.