Sigma Faucet Portfolio

Sigma Faucet

American Faucet and Coatings Corporation

Handles and Finishes Image Rollovers

Implemented image rollovers using the jQuery plugin imgPreview to allow users to view an enlarge picture of a handle or image by hovering their mouse over a thumbnail image. This allows the user to view the details of many handles and finishes at once without any clicking, loading or page refreshes.

Content Management System

Installed CKEditor to the administrator web portal of SigmaFaucets.com to allow site owners to edit verbiage on the site. CKEditor is a text and WYSIWYG editor, which means that the text being edited on it looks as similar as possible to the results users have when publishing it. It brings to the web common editing features found on desktop editing applications like Microsoft Word and OpenOffice.

Contact Form

Created a web page with a contact form to allow users to get in touch with Sigma Faucets. The form was developed with the Form and Validate jQuery plugins to allows easy rendering of the form while applying security and validation for required text fields. The form also includes submission via AJAX so there are no page refreshes and the submit button is hidden in order to prevent multiple submissions.

Showrooms

Sigma Faucets has showrooms all over the United States so in order to allow a user to find a Sigma showroom in their state, we created an image map that allows a user to click on a state and view the showrooms in that state. The showrooms are listed in a modal window using the jQuery plugin Thickbox. All showrooms data is stored in a database and is rendered via AJAX.

Product Images

Each product image can be viewed in a thumbnail on the product detail page. In order to view a larger version of the product image, the jQuery plugin Thickbox was used to load a large view of the product. CSS was used to style the large image which includes blacking out the web page so we can draw attention to the high quality product image.

Product Data ETL

Sigma Faucets has thousands of products to order from. In order to get all the products into the database, a sophisticated ETL process was written using SQL Server Integration Services (SSIS). This initially included creating a specific category heirarchy that allows products to be classified by one or more categories, subcategories and Handle values. This process also imported the thousands of product records from a Excel spreadsheet into a series of database tables. Product data included images, PDF specifications, SKU values, short and long descriptions.