Let's Talk: 866–592–9235

Project Details

  • Client TRW Innovations, LLC
  • Date 2011
  • Tags CSS, Database, Design-Development, Desktop Solutions, eX-BizTracker, FileMaker Pro, Graphic Design, HTML, Integration, MySQL, Paypal, PHP, Retail-Sales, Web Applications, Web Database Integration, Websites, WordPress

Project Description

About TRW Innovations, LLC
TRW Innovations, LLC is a family-owned part-time business who sell, designed and manufacture the SnowPusherLite (https://www.snowpusherlite.com), a wide lightweight light-snow removal shovel.

Challenge:
Needed an inventory and sales management system for their part-time home-based business of manufacturing and selling the SnowPusher series of shovels. The client had limited availability to tend to their business and with the triple increase in business their current manual methods for tracking sales and inventory in Excel and Word were proving to be very inadequate and thus they were losing track of sales. They would have to refresh their customer list by manually downloading the data from PayPal once a month. Also needed a new website to showcase their product and allow online-ordering.

Solution:
eX-BizTracker 3 modification (FileMaker Pro Jump-Start solution). Direct importing of order details from PayPal through a button on the Home screen (web service integration). Created shipment and label retrieving from UPS (web service integration). Developed an inventory management system in 2 locations for both parts and assemblies. Components (parts) and assemblies are collected and shipped together in the boxes to fulfill the orders (“Complete Blade” in screenshot includes blade, metal edge, and squeegee. Blade, metal edge, and squeegee can also be purchased separately as replacement parts.) Website – Set up, configure, design and integrate a new website and web-application using a WordPress template.

Result:
99.9% accuracy on orders and order processing, better track of supplies, better ability of sending out replacement parts, true inventory control of parts, and faster sales fulfillment. Less time and effort to run their part-time business, made it truly once again a part-time business. This client also has a very special place in our hearts, she was diagnosed with cancer and passed on towards the end of development. We will miss you Deb, and we look forward to helping your family continue your efforts!

Reference:
Tom Westman, Owner
Phone: 248-701-8911
Email: twestman at comcast dot net

Back to Top

eXcelisys Customer Project Login

Log in to the eXcelisys project management system to view the details of your eXcelisys project.

Log in now