Cold Fusion has not been a supported platform for quite some time now.
if you wanted to recreate the PHP eCommerce database, there is a diagram that shows how the database is put together that you can use as a referance when creating a new MS Access Database, see the following page:
ecommerce-database/
and click the diagram image to open a larger version.
at the end of the day, eCart is a tool that works with the database you provide, we have many examples of how the database _can_ be configured, but the best database design depends on what you want to accomplish.
after creating the database and populating the data, you create Recordsets in Dreamweaver to return the data that eCart will use.
how to format your database for product options depends entirely on how the product options will function in your site. there are many different ways product options can be accomplished.
the PHP eCommerce database uses three tables for product options:
optiongroups - creates a record to define each options group: i.e. Color, Size
options - creates a record to define each option and relate it to the options group using the optionGropupID column to relate to the optiongroups.GroupID column
productoptions - linking table used to create a many to many relationship between the options and products
quantity discounts also depends greatly on how you want to accomplish this, does each item have a different quantity breaks?
there are no tutorials for these things because there are simply to many different variables to cover.
