Contact Us

Use the form on the right to contact us.

You can edit the text in this area, and change where the contact form on the right submits to, by entering edit mode using the modes on the bottom right. 

           

123 Street Avenue, City Town, 99999

(123) 555-6789

email@address.com

 

You can set your address, phone number, email and site description in the settings tab.
Link to read me page with more information.

Pala 4


Overview

Months prior to the start of this project, Pala purchased a lifetime license for a proprietary, online system that powered thousands of art gallery ecommerce websites.  When the sale was made, the web firm and Pala must have thought that the system could be easily modified for Pala's gemstone and mineral specimen businesses.  There was, however, a misunderstanding of expectations.  Pala thought they'd bought three new websites for the price of one.  The web firm thought that they'd sold an online database engine plus a limited number of hours to modify that engine. 

Using the analogy of a buying a car, Pala had purchased a fine engine but nothing else.  Someone would need to design, build and test the chassis, the transmission, the body, the interior, the instrumentation, and so on.

After we completed the initial scope of work, it soon became clear that the web firm's database would not work without extensive modification.  Although the web firm worked closely with us at no cost to overcome these technical limitations, the additional cost and delay to complete the most essential modifications were unacceptable to both the web firm and Pala.

We explored converting to other platforms such as WordPress and Shopify.  We also explored updating the existing FileMaker database to a version that could power an ecommerce website.  Once again the cost and delay were unacceptable to the client.

The only remaining course of action was to modify the existing code base.  This required deciphering the HTML, CSS, PHP, and MySQL code powering a fifteen-year old website design.  A key challenge was making the the ecommerce side of the site look and feel like the Squarespace frontend.  This required deciphering the design principles behind Squarespace's innovative templates and untangling sophisticated CSS files with over 35,000 lines of code.


Step 1

Normalize the nomenclature used to search for gemstones<

Gemstone searches usually depend upon selecting a gem type, shape, or color.  Ideally these are based upon standards set by a leading gemological institute such as GIA.

The custom in-house FileMaker system allowed Pala's employees to add new gem types, colors, and shapes when entering new inventory.  Over time this flexibility had greatly corrupted the integrity of the database.  For example, there were over ten different spellings of the color blue-green.  Finding all blue-green gemstones required searching for each of the spellings,  Gem types and sub-types were even more confused.

 

Type Menu

Previous Type menu had over 180 different types of gemstones and mixed in special effects such as Cat's Eye and Star.

New Type menu is based upon nomenclature from the Gemological Institute of America.

 

Shape menu

Previous Shape menu had about 140 different terms with many duplications.

New Shape menu has just 29 terms.

New shape menu.jpg
 

Color menu

Previous Color menu had 180 different colors and mixed in special effects such as Cat's Eye and Star.

New Color menu has just 20 colors and 3 special effects.

New color menu.jpg
 

Step 2

Create the technical specifications for the web firm's proprietary database

The first step was to map the existing in-house FileMaker database's fields to the fields used by the web firm's proprietary on-line database. 

Over the years, the in-house database had been extended to accommodate the needs of Pala's three separate businesses plus the personal collections of the founder.  Some fields such as color were shared, while others were unique to a business.  In addition, a number of fields were no longer used, or whose contents could not be understood.  We used Microsoft Excel to manually determine the meaning of the fields, consolidate fields, and prepare a CSV-formatted output field that could be imported into the on-line database.

These attempts to map fields ultimately failed due to technical limitations.   A key issue was the limited number of indexed fields within the online database that could contain the key search variables.  For gemstones these key fields are type, color, and cut.  For mineral specimens these are type, color, and origin.

Overcoming these limitations would have required doubling the cost of the original license and waiting many months.


Step 3

Convert the in-house FileMaker database

Restructuring the in-house database system powering Pala's inventory and customer systems required refreshing my understanding of FileMaker. 

xxx


Step 4

Redesign the gemstone search interface

Search Form

Previous search dialog &nbsp;had two search forms plus lots of extra text.&nbsp; Since the site was non-responsive, these search dialogs were difficult to use on mobile devices.   Click image to magnify.

Previous search dialog had two search forms plus lots of extra text.  Since the site was non-responsive, these search dialogs were difficult to use on mobile devices.

Click image to magnify.

New search dialog  is simple, clear and inviting.&nbsp; It's clear that a registered trade member must log in to see pricing.&nbsp; The search form automatically reformats itself for smaller screens.   Click image to magnify.

New search dialog is simple, clear and inviting.  It's clear that a registered trade member must log in to see pricing.  The search form automatically reformats itself for smaller screens.

Click image to magnify.

 

Search Results

Previous search results &nbsp;were not easily visible on smaller screens. The images were not linked to the detail view.   Click image to magnify.

Previous search results were not easily visible on smaller screens. The images were not linked to the detail view.

Click image to magnify.

New search results &nbsp;automatically reformat to three, two, or one item per row.&nbsp; The images link to the detail view.   Click image to magnify.

New search results automatically reformat to three, two, or one item per row.  The images link to the detail view.

Click image to magnify.

 

Search Detail

Previous search detail &nbsp;had small text that was hard to read.&nbsp; The static top, side and bottom navigation cluttered the screen.   Click image to magnify.

Previous search detail had small text that was hard to read.  The static top, side and bottom navigation cluttered the screen.

Click image to magnify.

New search detail  calmly invites the buyer to inquire about the stone.&nbsp; The Go Back button returns to the found items.   Click image to magnify.

New search detail calmly invites the buyer to inquire about the stone.  The Go Back button returns to the found items.

Click image to magnify.


Project Phases

1) Redesign the User Experience

2) Branding & Graphic Design

3) Organize the Content

4) Update the eCommerce System

Click links to read more detail about that phase