• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

nSiteful Web Builders

Building a Better Web - One Site at a Time.

  • Home
  • About
    • Testimonials
    • Resources
  • Web Sites
  • Online Marketing
  • WordPress Support
    • Customized WordPress Training
    • 60-for-60 Sessions
  • Web Applications
  • Blog
    • Archive Listing Minimalistic
    • Blog Articles Grouped by Category
    • Case Studies
    • General
    • Portfolio
    • Reviews
    • Snippets
    • Techniques
  • Contact Jeff
    • Purchase Retainer Consulting Hours
    • About Retainer Consulting Hours

By Jeff Cohan, October 9, 2015

Hayes Shutters Online Ordering System

Project Goal

Hayes Shutters, who manufactures furniture-quality plantation shutters in their facility in Ellijay, Georgia, hired nSiteful to streamline their ordering process.

The Problem

Previously, most of Hayes’ customers (wholesalers and retailers who sell to and service homeowners) submitted orders by downloading and printing out a PDF of a 130-field form, filling in dimensions and other specifications by hand, and then faxing it back.

hayes-shutters-downloadable-order-form
Image of Downloadable PDF Order Form

Upon receiving each fax, someone from Hayes — usually David Hayes, the owner — had to transfer all of the data into a master Excel spreadsheet that automatically generates cut lists and calculates costs for each order. It should be no surprise that the potential for problems — namely, data that is either invalid or illegible or both — was great.

The Solution

nSiteful’s job was to create an online form for order entry; programming scripts for validating submissions and transforming them into files to be imported into Hayes’ master Excel spreadsheet; and an administrative notification system and interface for downloading orders. As a second phase of the project, we built a customer portal through which customers can view, print, and clone saved orders. Hayes personnel use the portal to view, print, search, download, and update the status of orders.

The customer portal and form are integrated into Hayes’ existing WordPress Web site, thanks to the site’s developer, who brought nSiteful into this project. Scripting is done in PHP; customer and order data are stored in and served from MySQL tables in a database external to the WordPress database.

Screen Shots of Online Order Form

Order form, top
Order form, top
Filling in dimensions and specifications
Filling in dimensions and specifications
Preview order prior to submission
Preview order prior to submission

Validating the Online Order Form

One noteworthy — and challenging — aspect of the project was validating form submissions. Some of the factors adding to that challenge:

  • Many of the dimensions have to be entered free-form as Imperial units (inches with optional fractions).
  • Those optional fractions have to be separated from whole inches by at least one space and expressed in halves, quarters, eighths, or sixteenths of an inch, reduced to their lowest terms. (Examples: 1 1/4; 22 7/16; 30 1/2)
  • Several of the dimension fields have minimum and/or maximum constraints.
  • Some of the dimension fields accept specific sets of optional non-numeric values.
  • There is a multi-row section of the form, where the customer enters dimensions and specifications for up to 10 shutter panels.

(In another blog post I wrote about my foray into Regular Expressions to address the inches-fractions validation requirement.)

Converting Submissions from Online Order Form to Importable Files

Another aspect of the project worth noting was converting form submissions into files that can be imported into David Hayes’ master Excel spreadsheet.

(You might be wondering why the project didn’t include the creation of a new back-end system to replace that spreadsheet. If you were to inspect that extremely sophisticated spreadsheet, you’d understand why we took the “Don’t Fix It If It Ain’t Broke” approach.)

What the system does is generate a single-row Master CSV file for all of the basic order data (customer information and manufacturing specifications that apply to all shutter panels) and a Details CSV file that contains a row for each shutter panel ordered. The system then combines the two files for each order into a single downloadable zip archive. The contents of each individual file is mapped to predefined cells in the master spreadsheet so that all cut-list and cost computations are automatically performed immediately upon import.

Summary of Benefits

As of this writing, more than 30 active registered users of the online system have submitted more than 1,000 orders for more than 6,000 shutters.

The online system eliminates virtually all of the data-entry errors that the paper-based order entry method admits. Our client reports that each order placed through the system saves so much administrative processing time that they have been able to reduce turnaround time dramatically — benefitting everyone.

More and more of Hayes’ customers are converting from the old method to the new system every week, and these online customers are thrilled with the system’s convenience and efficiency. In fact, several of Hayes’ online customers actually submit orders at the point of purchase — in the homes of their customers, accessing the system from their tablets in living rooms and at kitchen tables all over the country.

Related Posts

  1. How to use Advanced Custom Fields with Genesis
  2. How to Create Tooltips with CSS (Only)
  3. NextGen Gallery Compact Album Mods
  4. Downscaling Images On Upload in WordPress
  5. Case Study: Emergency Notice Banner for Hybrid Web site
  • Choose the best match.

Written by Jeff Cohan · Categorized: Case Studies · Tagged: Images, php, Web forms, WordPress

  • Choose the best match.

Reader Interactions

Comments

  1. Nancy Culotta says

    April 10, 2016 at 9:25 am

    HEY! I need this form too!! We have out of town customers that need to submit measurements and this would make it SO MUCH easier for them to submit measurements on-line rather than our “old way” of printing and faxing!!

    Let’s convert!! Thanks Jeff!
    Nancy

    Reply
    • Jeff Cohan says

      April 11, 2016 at 4:12 pm

      Yes, indeed, Nancy. We shall do.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

mailchimp signup

Subscribe to get notified when new articles are published. Unsubscribe any time. No spam. I promise. Check out my newsletter archives.

social

Twitter Facebook LinkedIn

Recent Articles

  • Create a Custom Shortcode to Display a MemberPress Membership Price ANYWHERE on Your Website February 5, 2023
  • Avoid Direct Styling; Use CSS Instead September 21, 2022
  • Blog Tags: What They Are (and What They’re Not) August 5, 2022
  • How to Create a Simple Custom Events Plugin May 24, 2022
  • Make your Web Site the Heart & Hub of your Online Marketing Strategy March 24, 2022

Filter By Category/Tag

Categories

  • Case Studies (7)
  • General (61)
  • Portfolio (5)
  • Reviews (12)
  • Snippets (16)
  • Techniques (37)

Popular Tags

Advanced Custom Fields Blogging Child Themes Content Marketing CSS CSS Grid Customer Service Custom Fields Custom Post Types Diagnostics Facebook FooGallery Genesis Gutenberg HTML Images iPhone Libra Live Chat Marketing Media MemberPress MemberPress Courses mu-plugins MySQL Photo Gallery php Pinterest Plugins Post Formats Pricing Project Management Security SEO Seth Godin Shortcodes Social Networking Surveys Taxonomies Trello Twitter Video Web design Web forms WordPress

siteground wp hosting

Web Hosting

wp101

EasyWordPresstutorialvideosforbeginners.
MemberPress CTA

Footer

Background

Web Sites | WordPress Support | Web Applications.

Formally trained in liberal arts and education (I have a B.A. in Government from Harvard and studied Secondary Education at Rutgers Graduate School), I have honed my skills in the communication arts and sciences as a teacher, trainer, instructional designer, writer, photographer, calligrapher, helpdesk manager, database programmer, and multimedia developer.

(I've also been a group counselor, waiter, bartender, bicycle messenger boy, computer salesman, carpenter's helper, financial analyst, and school board president.)

Tech

Systems since 1983.
Web sites since 1994.
PHP since 2001.
WordPress since 2007.

Contact

770-772-5134
Email Jeff
Send Money
All Ways

Copyright 2023, nSiteful Web Builders, Inc.

 

Subscribe

Pardon the interruption. I know popups can be annoying. But I’d love to have you as a subscriber.

Sign up to be notified when new articles are published. Unsubscribe any time.

* indicates required

Powered by MailChimp

×