In this tutorial, the third in the eCommerce series, you will learn how to add dynamic product options to your website's online store using eCart's shopping cart functionality. This will give your customers the ability to choose options appropriate to your product line, for example, color and size.
If you want to add static product options (for example, product options that do not change often) or dynamic product options that affect more than one column (for example, a price increment), these types of product options have dedicated tutorials in this series. You'll find a linked index including an overview of each tutorial belonging to the eCommerce series at the bottom of this page.
- Dreamweaver CS3 or higher.
- eCart 5 or higher installed and activated in Dreamweaver
- Site defined in Dreamweaver. For assistance defining a site, view these tutorials: Define a dynamic site in CS4 or Define a dynamic site in CS5+.
- PHP web page and connection in Dreamweaver to your database. For assistance, view this tutorial: Create a PHP database connection.
- MySQL database. If you do not have one, you can download our free eCommerce MySQL database in this tutorial.
- Product catalog pages. For assistance creating product catalog pages, view this tutorial: Create a product catalog.
- Shopping cart. For assistance creating a shopping cart, view this tutorial: Create a shopping cart.
Before you begin to add product option functionality to a shopping cart, you need to populate your product catalog, adding into a database the various product options and option groups to display products you wish to sell on your website. You can use our free eCommerce MySQL database with the necessary tables for defining product options. However, if you already have a database and a product catalog, you can skip this step and move to the next section of this tutorial.
If you are not using the eCommerce MySQL database, you will need to review the table and column references to make sure they match up with your database structure.
In this tutorial, we will be setting up product options in a database to populate a product catalog for a fictitious online store selling t-shirts and athletic shoes. But we are going to work with only one product option group, color, that has three color options, Red, Blue, and Green.
This simplified product catalog is useful for demonstrating how to set up basic product options in a database. After completing the tutorial, you can customize a database to fully display options in your product line using the steps you have learned here. Additionally, subsequent tutorials in the eCommerce series show how to add more complex options to your product catalog, for example, price increments.
- Go to a MySQL administration tool of your choice and open the eCommerce MySQL database that you downloaded. You will be working in these five tables, OptionGroups, Options, ProductCategories, Products, and ProductOptions.
- OptionGroups table: The first table we are going to populate in the eCommerce MySQL database is OptionGroups. Fill in 1 for color and 2 for size.
- Options table: Let's limit the options in OptionName to three colors and five sizes. Give each color an individual OptionID, in this case, 1, 2, and 3. Continue numbering the sizes sequentially. Type 1 in OptionGroupID to join the individual color options to the main Option Group, color, found in the OptionGroups table. Type 2 in OptionGroupID to join the individual size options to the main Option Group, size, found in the OptionGroups table.
- ProductCategories table: There are four categories of men's athletic shoes in our fictitious store, Running, Walking, Hiking, and Track and Trail. They each are assigned an individual CategoryID, 1, 2, 3, and 4. The t-shirts come in two sleeve options which are numbered 5 and 6.
- Products table: Give each shoe and t-shirt product a ProductID and product name. Fill in price, weight, and a description of the product. In the ProductCategoryID column, place the CategoryID number from the ProductCategories table to tell your customers if this shoe belongs to the Running, Walking, Hiking, or Track and Trail category. Do this for the t-shirt sleeve options also.
- ProductOptions table: Now it is time to tie each shoe (pardon the pun) and t-shirt to a color option. First though, give each shoe and t-shirt a unique ProductOptionID. Then fill in the ProductID found in the Products table. In the OptionID column, add the corresponding OptionID for the appropriate color and size. Lastly, fill in the OptionGroupID, which joins this table to the OptionGroups table where we set up the option groups, color and size. (Incremental pricing is covered in a subsequent eCommerce tutorial.)
In the Add a shopping cart tutorial, you already created the eCart Object. Now you are going to update the eCart Object by adding necessary columns to accommodate your online store's product options.
- Back in Dreamweaver, go to Webassist > eCart > eCart Object.
- From the eCart Object panel, select your cart and click the Edit icon.
- Choose the Columns tab of your eCart object. This is where you will define specific columns for use within your shopping cart.
- Click the Add icon to add a new column. Name it Colors.
- From the menu list, choose Text as the Output Type for the Colors column so your shopping cart can display the various colors contained in your database. The six available Output Types are number, Text, Currency, Date, Integer, and Weight. For example, the price column's Output Type is Currency.
- Select the unique checkbox so that the shopping cart recognizes that some customers may want to purchase more than one pair of red shoes, for example.
- Just as you used the Add icon to insert a new column into the list, you can also use the Delete icon to remove an existing column.
Adding cart columns requires that you manually add that column in the Add to Cart button interface and shopping cart display.
In the Add a shopping cart tutorial, you created the shopping cart. You also created a page named cart.php. Now that you have made changes to your eCart Object by adding columns, you need to update the shopping cart page. This requires that you remove the Shopping Cart instance from your cart page, and insert a new one using the eCart Display Manager.
- Open your shopping cart page and remove your shopping cart. Place your cursor where you wish your new shopping cart display to be inserted.
- Go to Insert > WebAssist > eCart > Display Manager. Review the settings, make any updates to the design of your cart, and click Next.
- Click the Add icon to add the Colors column you added to the eCart Object.The label can be changed to Color.
To display additional columns that you created in the eCart object, click the Add icon. However, if you decide that you want additional columns, they need to be created first in the eCart object before being added on this page.
- Use the up and down arrows to adjust the order of the columns. Check the Group with previous column box to group items together. You can also delete columns. Click Next.
- Next you can determine how charges, discounts, shipping, and tax will be displayed. Choose between Summary which includes the section header and a corresponding total, Individually for each rule triggered in the shopping cart as well as the sum, or Do not show to disable the selected option on the cart display. Summary is a common choice. After you have have made your selection, click Finish.
- Review your shopping cart columns.
- Save the page (Ctrl or Cmd + S).
Now that you have updated your eCart Object and recreated your Shopping Cart Display, the server behaviors need updating in order to populate the select list with the dynamic product options.
- Open your product detail page.
The product detail page is typically created by DataAssist to display the details for a specific item and a related Add to Cart button.
- Go to Window > Server Behaviors.
- From the Server Behaviors panel, click the + icon and then Recordset to open the Recordset dialog box.
When the Recordset dialog box displays, it may open in Simple mode. For these instructions, you will need to change this to Advanced. Choose Advanced from the buttons on the right. If you see Simple, you are already in Advanced mode.
- In the Name field enter rsColor.
- Select and copy (Ctrl or Cmd + C) the following code:
SELECT productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName='color' AND productoptions.ProductID = ParamItem
- Place your cursor in the SQL box of the Recordset dialog and press (Ctrl or Cmd + V) to paste this content.
- In the Variables section, click the + icon.
- Enter ParamItem into the Name field of the Variables dialog.
- From the menu list choose Integer.
- In the Default value field, enter -1.
- Copy (Ctrl or Cmd + C) and paste (Ctrl or Cmd + V) the following parameter into the Runtime value field:
- Click OK.
WADAproducts is the name of the products recordset created by the DataAssist: Create Pages wizard. If you are using your own details page, you will need to substitute WADAproducts with the name of your own products recordset
The next step is to update your Add to Cart buttons that you added during the Add a shopping cart tutorial.
- To begin updating, launch the Add to Cart button interface by double-clicking the eCart Add from Recordset option in the Server Behaviors panel.
- From the General tab, choose Look up item ID from recordset.
- Choose the DataAssist recordset, WADAProducts. This recordset was created by DataAssist and displays all the products in the products database table.
If you are not using a DataAssist created page, you will want to create this recordset, and then re-enter the Add to Cart interface.
- To specify the page you wish the customer to be taken to after adding this product to their cart, click the folder icon and browse to the page. In this tutorial, the page is named cart2.php.
- Choose the Bindings tab.
- Select the Colors column but instead of binding it to the recordset, check the Updatable checkbox and from the menu list, choose the select list. Set Action to Sum so that the quantity of the item in the cart can be increased, for example, two pairs of blue running shoes.
You may bind other items such as Name, Description and Price to the proper columns in your Products table (WADAProducts) at this time if they are not already bound. By default, the Quantity of the item added to the cart is automatically configured to be set using a text field placed on the page with the Add to Cart button.
- Now select the Button tab. In the Style menu, browse through the 11 different color schemes. Then select the button that fits best with your website's design. You can also choose a form button or specify a custom image location. You can also add an image description in the Alt text field.
- Click OK to update the Add to Cart button.
The Color select list was automatically created for you when you updated your eCart Add to Cart button.
- Click inside the select list and from the Properties Inspector, choose the Dynamic button.
- Click in the Value/Label box and delete any blank entry that could be hiding using the minus icon next to Static options. (This corrects a Dreamweaver error.)
- Choose the rsColor recordset.
- For Values, choose OptionName.
- For Labels, choose OptionName.
- Click OK.
- View the product page in your browser (File > Preview in Browser) where you can make a color choice and specify quantity.
- By clicking the Add to Cart button, you can review your order on the shopping cart page (assuming the product page was re-directed to the shopping cart page in the General tab). Use the Continue Shopping button to make another selection. You can also increase quantity, remove items, clear the cart, update the cart, and proceed to checkout from the shopping cart.
With eCart technology as the cornerstone of the WebAssist eCommerce series, these in-depth tutorials will walk you through the steps of building an eCommerce site, including product catalogs, shopping carts, product options, and checkout. You will also learn about online payment solutions as well as hosting and shipping options. Completing the eCommerce series is help for setting up a back-end administration to manage your eCommerce business.
- Introduction to the eCommerce series: An overview of the WebAssist eCommerce series including a detailed description of each tutorial.
- Create a product catalog: Learn to create a dynamic product catalog for an online store.
- Add a shopping cart: Learn about using eCart to create a shopping cart for selling your products online.
- Add dynamic product options I: Learn how to add dynamic product options to your website's online store using eCart's shopping cart functionality.
- Add dynamic product options II: Learn how to add dynamic product options, which include options within themselves (for example, incremental pricing), to your website's online store using eCart's shopping cart functionality.
- Add static product options: Learn how to add static product options to your online catalog store.
- Add check-out and payments: (Coming soon)
- Online payment solutions: Learn about online payment solutions including seamless checkout, remote checkout, and various PayPal checkout options.
- Hosting provider solutions: Learn about and choose between five hosting providers, 1&1, GoDaddy, HostGator, Network Solutions, and DreamHost.
- Online shipping solutions: Learn where and how to set up free shipping accounts with FedEx, UPS, USPS, and Australia Post.
- Add product administration and managing orders: (Coming soon)