Archive

Archive for October, 2017

PCI Performs BigCommerce Integration

October 24th, 2017

BigCommerce-logo-dark

We recently assisted a customer integrate BigCommerce with their Core4 CRM FileMaker solution.
BigCommerce is an online platform that helps businesses build an e-commerce presence. The platform allows customers to build and customize their site, take orders, and manage shipping.

Our client sells restoration parts for the MOPAR auto industry and they recently upgraded to FileMaker 16. We were asked to write a routine to help them better integrate BigCommerce with their elaborate FileMaker solution.

Our client had two problems with their daily workflow.

Problem – Duplicate Data Entry
The first issue they were dealing with was redundant data entry. The same product information needed to be entered into FileMaker, BigCommerce, and QuickBooks Online. The client wanted FileMaker to be the main point of entry for data and from there the data could be pushed to QuickBooks Online and BigCommerce.

Problem – Data Accuracy
It is important that all data is consistent across all three programs (QuickBooks Online, FileMaker, and BigCommerce). When an order is created in BigCommerce it is imperative that the data exactly matches what is in FileMaker, because when the order is placed with BigCommerce, it is then imported into QuickBooks Online and subsequently pulled to FileMaker via the FM Books Connector Online Edition plug-in. This cyclical process is easily broken if any of the data does not match across the three programs.

To solve these issues there were two main objectives.

Objective – Pull BigCommerce Categories
The first task was to “pull categories” directly from BigCommerce so that these categories could be used in dropdown lists in FileMaker.

We used FileMaker 16 and cURL to pull the categories directly from BigCommerce using the BigCommerce API. Once these “official categories” were in FileMaker, users could easily and more accurately pick items for use on their sales orders and invoices directly in FileMaker.

In order to add a new category to their FileMaker dropdown list, the user first adds the category in BigCommerce and then clicks a button in FileMaker to pull the new category into their solution.

We also scripted the customer’s solution with the ability to “push categories” from FileMaker to BigCommerce. This gave the customer the option to either pull or push new categories, but we cautioned them against using both options interchangeably. We recommended selecting a consistent direction (for example, always pulling categories) to ensure better workflow and to make internal training easier. To be consistent with their current workflow, we suggested setting up rules that all categories must be first entered into BigCommerce, then pulled into FileMaker.

Objective – Push Products to BigCommerce

The customer keeps all their product items in FileMaker and is accustomed to entering all data there. The customer asked for the ability to “push these product items” to BigCommerce. Product items consist of a product description, pricing, and additional details.

Now, these items are entered and managed in FileMaker and pushed to BigCommerce. Pictures for the product items are stored on an FTP server (to ensure BigCommerce would have public access to them) and each photo is linked to FileMaker.

As part of their updated process to add a new product to BigCommerce, the user enters the necessary information in FileMaker, then clicks a button and, using the cURL technology in FileMaker 16, the data is automatically entered into BigCommerce.

Due to their workflow, the customer only wanted the ability to push one product at a time. However, as with most data transfers, it would have been easy to create a batch push script and loop through a found set of products in FileMaker and push them all to BigCommerce at once. Likewise, a server-side script could be instituted to run every hour to automatically push products from FileMaker, creating a sense of true synchronization between FileMaker and BigCommerce.

Result – Client Impact
Predictably, as a result of this integration the client has seen several hours of time savings per week. This is due to the fact they are no longer entering the same data into multiple systems and they do not have to spend time fixing data errors associated with manual entry or order errors that occurred because of data errors.

Result – Capabilities of FileMaker Data API
As developers, we strive to learn something from every integration. One of our most prominent revelations from working with this client was the increased integration capabilities available with FileMaker 16. We discovered that these kinds of projects (REST API integrations) can be completed in less time and with less overhead (no plug-in to install) than traditional integrations. REST APIs, in general, can be a little tricky to learn, but once the process is understood it opens up a lot of possibilities to interact with data across other platforms.

Musicians Make the Best Developers?

October 20th, 2017

Nord

Our CEO, Marc, recently wrote a blog for Elusive Moose asking the question “Do musicians make the best developers?” and exploring the correlation between developers and musical talent/ inclination. Is there a link there? If so, why?

If you are looking for a fun and quick read, check it out at: https://elusivemoose.com/2017/10/musicians-make-best-developers/

Author: Categories: Chief Executive Officer Tags:

macOS High Sierra Compatibility

October 17th, 2017

macoshighsierra-800x464

macOS High Sierra was released on September 25 and we worked diligently to test and update each of our plug-ins to confirm compatibility with the new OS. If you have updated to High Sierra make sure you download an updated plug-in.

Each plug-in comes with an updated demo file and many plug-ins feature new functionality, updated documentation, and bug fixes.

Plug-ins:
FM Books Connector Online v2.0.3.1: Available for client or server-side deployment and compatible with FileMaker Cloud, the FM Books Connector Online Edition connects FileMaker with QuickBooks Online. Users can save time and money by eliminating double entry of contacts, invoices or sales transactions. This release also includes additional plug-in enhancements and functionality.

Address Book Manipulator v4.0.2.1: The Address Book Manipulator allows users to update all contacts in FileMaker or Apple Contacts and then easily push the information from one application to the other, ensuring contact information is always up-to-date.

iCal Manipulator v2.0.2.1: The iCal Manipulator plug-in directly connects FileMaker with Apple Calendar. The plug-in supports multiple calendars, recurring events, and tasks. This release also includes additional plug-in enhancements and functionality.

FM Credit Card v2.0.0.0: Available for client and server-side deployments, FM Credit Card connects a user’s FileMaker solution to their preferred merchant services provider. Productive Computing also offers low-priced, basic integration packages for this plug-in.

PDF Manipulator DC v1.0.2.1: The PDF Manipulator DC Edition enables users to create a searchable document management system and process forms faster by extracting and inserting data between PDF form fields and FileMaker.

File Manipulator v4.0.2.1: File Manipulator can copy, move, rename, or delete files and folders directly from a FileMaker solution. In addition, it can compress and encrypt file data with password protection, as well as decompress and decrypt file data.

Change Printer v4.0.8.1: The Change Printer plug-in automatically changes printers, sets optional printing attributes, facilitates the coordination of large and complex print procedures, and easily switches between various types of printers/drivers.

Solutions:
Core5 Starter Edition v1.0.2.1: The Core5 Starter Edition is an intuitive and easy-to-use CRM solution. Pre-configured to connect with QuickBooks Desktop or Online, the Core5 is designed to be easy to customize and immediately deployable.

Core4 CRM v3.0.0.5: Core4 is a robust and expandable CRM solution. This business tool allows users to track everything from contacts to sales transactions and calendar appointments to notes and documents. The Core4 can connect with QuickBooks and Outlook for Windows, Apple Contacts, and Apple Calendar.

For additional information on product functionality, updates, and integration details, please contact sales@productivecomputing.com or call 760-510-1200.