While there are low-cost (and some free) tools that can be used to simply ‘get your orders into the accounting system’, a well-designed (and supported) commercial integration can better support how your business records General Ledger transactions and actually help you sell more product; thus paying for itself in an extremely short period of time.
If you are a developer that has been tasked with sourcing an eCommerce integration for a client, it is highly recommended that you confer with your client regarding the following criteria. Business owners tend to be more concerned with the continuity and capability of their operations than trying to save a few hundred dollars. Failing even one of the following criteria can turn the money/time your client spends on a lesser product, into a sunk-cost.
Compare Product Features Important to Your Business
Recognizes G/L accounts of individual items?Many businesses classify sales of individual items by specific G/L accounts. This helps them better perform financial analysis of their product lines.
Rule-based creation of customer names?Businesses often have a very specific naming convention that they use for their customer names. Changing this convention can be very disruptive to the user experience.
Updates using Invent. Avail. vs. Qty. on-hand?What businesses have on-hand is not necessarily what they have to sell. Open orders in the accounting system reduce this availability, potentially leaving the company exposed to over-commitments of stock.
Phone orders trigger inventory updates?New phone orders and purchasing receipts are constantly changing the inventory landscape and a good integration keeps the inventory picture up-to-date in near real-time.
Detailed feature-list to aid your decision?The old saying that, "The devil is in the details," could not be truer than in the case of eCommerce/accounting integration. Ensure that the intended solution appropriately meets well-defined business requirements.
Try before you buy! No money up-front.Companies confident in their offering should be willing to let you try their product before requiring any financial commitment on the front-end.
History of positive reviews?Do your due-diligence and research the product's reputation in the marketplace. Even if there are limited positive reviews in the market, you should avoid products with a documented presence of negative user-experiences.
Money-back Guarantee?How confident is the solution-provider in their offering that they are willing to eliminate financial-risk altogether?
Phone number indicated on website?How accessible is the company to you before and after the sale?
Support for Assembly-based products?Make sure the tool you use supports not just basic inventory items, but also the extended product types that your QuickBooks system offers.
Support for QuickBooks Group-Item products?The Group-Item is a heavily used item type in QuickBooks that allows merchants to easily offer 'kit' type offerings to customers.
Recognizes CC used in transaction?Stores processing hundreds of transactions on a daily basis need visibility of detailed payment method to efficiently support bank reconciliation.
NO Per/Order transaction fees?Your integration provider should be committed to your satisfaction before you pay for anything, AND, should stay 'out of your pocket' just for growing your business.
CartSpan recognizes the G/L Sales, Asset, and Cost-of-Goods-Sold accounts configured on the accounting side.
CartSpan offers sophisticated naming capabilities to match the convention that a business has been using successfully for years.
CartSpan factors open orders in the accounting system when updating stock availability in the shopping cart; ensuring that the company does not over-commit inventory.
CartSpan actually 'watches' for activity in the accounting system for transactions affecting specific inventory and will update it in a timely fashion.
CartSpan offers you an exhaustive list of product features with which to make a decision. If the information provided isn't enough to answer your questions...we're always available by phone.
CartSpan not only offers a free 10-day trial, but we will assist you in getting the trial started at not cost to you. You pay nothing until you are happy with the way your orders are being imported into the accounting system.
CartSpan has been in business doing eCommerce integrations since 2010 and has an A+ rating with the Better Bureau that is accompanied by many positive reviews. Most integration providers, along with other plug-in developers, are unwilling to participate in such forums that give the consumer a voice.
CartSpan not only offers a free 10-day trial with setup assistance, but will refund your money if you are not satisfied with it's performance within 30 days of purchase. To-date, CartSpan has never had to refund a customer purchase.
CartSpan posts it's phone number in large font at the top of its website and promises a call back within 3 hours for inquiries or support requests.
CartSpan will update stock in the cart for all of your product types, including assemblies. CartSpan employs advanced logic that determines the maximum number of assembled items that 'could' be sold based upon availability of first-level BoM-items.
CartSpan offers advanced support for Group Item types, recognizing them during the import and converting to the appropriate items, quantities, and prices.
CartSpan supports the FREE Payment Gateway listed lower on this page...which allows you to record the specific credit card type as the payment method. You may then direct the transaction to its own G/L account or to the QB 'Undeposited Funds' account.
We personally help you get setup on your trial at no additional cost. CartSpan has never employed a per/order model of licensing and doesn't plan to.
Competitors often require the use of a single account for all items imported.
Competitors often offer a 'one size fits all' approach to creating customer names...raising the probability of orders being assigned to incorrect accounts.
Competitors often update stock based upon quantity on-hand in the accounting system, leading potentially, to conversations with irate customers who want refunds for non-delivery of product.
Competitors are often subject to the triggering logic of the QuickBooks web connector that will not account for new phone orders.
Competitors typically offer you a paragraph and a few bullet-points to to make a decision...and there is no one to call for clarification.
Competitors most often take the 'buyer beware' approach, requires you to pay up-front, and offers little in the way of personalized assistance to get the product running efficiently.
Search the internet for a history of positive reviews. Even check the forums of other shopping carts to research user experiences with your prospective integration tool.
With competitors 'buyer beware' approach to the market, all sales are FINAL.
Competitors often don't provide any information about themselves. No phone number on the website, no contact names, and no business address; only web-based email for communication.
Manufacturers beware; ensure the prospective integrating tool supports the update of assembly-type products in QuickBooks; some do not.
Many competitors offer absolutely no support for this important QuickBooks feature.
Many competitors offers no such support and import credit card type for the transaction reference only.
Most competitive systems require some form of payment up-front before you even import your first order. This is often in the form of separately listed 'setup charges'. Ongoing per/order transaction fees can cost you hundreds (if not thousands) of dollars in lost profit over time.
Consider the CartSpan value-proposition vs. integrations that ‘just get you by’
Competitive integrations like the ones compared above tend to utilize a common ledger account for items, regardless of how you have them configured on the QuickBooks POS side. Most businesses classify their products differently for the purpose of analyzing sales. This capability is lost because there is no dynamic interaction with the QuickBooks POS company file to support this detail in the import.
Also, many competitive integrations do not recognize assembled product types in the QuickBooks POS system. If you are offering anything other than the basic ‘Inventory Item’ in QuickBooks POS, you may have difficulties importing them properly into the accounting system from MijoShop. The CartSpan integration for MijoShop closes this gap beautifully and even provides advanced support the ‘Group Item’ type in QuickBooks POS.
Relying upon your integration to help increase your sales has less to do with the order import side of the equation than with the practice of effective stock management between systems. If you have a significant number of products to manage and don’t update availability in MijoShop in a timely manner, you are losing significant income opportunities.
Hard Benefits: CartSpan provides a deep integration with QuickBooks POS to provide you with near real-time updates of product availability in your store. If you are a manufacturer, CartSpan offers a stock management feature that projects how many of an assembled item you can offer based upon supporting stock. See our blog post, Inventory Management for Assembled Product Types, for details on how this feature can increase your earnings.
Soft Benefits: Don’t discount the ‘softer’ side of how a good integration can maximize the use of your accounting system. If you are constantly changing, adjusting, or ‘tweaking’ your imports to reflect how you do business, you might ask yourself, Am I really saving that much time? CartSpan is built for QuickBooks POS and maximizes integration opportunities. These finer points of integration can be found on our Product Features page for order imports as well as for inventory updates.
MijoShop is packed with useful features that are not typically included in standard open-source offerings. These features include: Pricing/quantity discounts by customer groups, capture of item-level product options (a.k.a. ‘variants’), gift certificates, and affiliate management.
During the development of the CartSpan integration we found the configurable product options to be especially flexible in that they allow multiple selection mechanisms to be utilized; mechanisms such as radio buttons, free-form text, and drop-down lists. These user-selected options are conveniently appended to the base description of the item during the import process.
For businesses that track online sales by sales representative or affiliate, MijoShop provides a small but useful feature, differentiating itself from other carts. Rather than providing just an integer-based reference of the affiliate, MijoShop allows a meaningful ‘code’ to be associated with the affiliate. This code can then be expressed as an actual Sales Rep ID that can be perfectly mapped to the QuickBooks POS import.
From a broader development/implementation perspective, MijoShop has had the foresight to support multiple stores within the same database. So, if you are a merchant with multiple storefronts, and would like to handle them from within one administrative environment, MijoShop is a great option.
One tricky aspect of integration with MijoShop, which CartSpan handles flexibly, is the cross-reference between items in the cart and those in the accounting system. CartSpan allows you to indicate either the ‘SKU’ or the ‘Model’ field to serve this purpose. This is helpful if you have already committed one or the other fields to some other purpose in the cart.
We also offer native support for some very popular community extensions:
Purchase Order by qphoria (developer) – If you are conducting a lot of Business-to-Business eCommerce and your customer want to provided you a Purchase Order for the sale, this is an effective and very low-cost extension to get the job done. CartSpan will simply import the PO provided into the appropriate field on the order or invoice in the accounting import. See the details of this extension Here.
Auto Discount by qphoria (developer) – If you would like to reward your customers with an automatic discount based on order total-value or item total-quantity, this is a useful extension to have. See the details of this extension Here.