Sage 50 U.S. WooCommerce Integration by CartSpan

Higher capability, better value, better support!

WooCommerce QuickBooks IntegrationWhile 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. Support for this assertion can be found in the following paragraphs.

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.

There are no safe assumptions when evaluating integrations

Are these factors important to you?

  • 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 Sage 50 system offers.
  • 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

$
$
  • 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 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.
  • 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

$$$
$$$
  • 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 IDs...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 generally only able to offer a bulk update of inventory on a predetermined frequency.
  • 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 Sage 50; some do not.
  • 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.

CartSpan offers value vs. integrations that ‘just get you by’

Competitive integrations like the one compared above utilize a common ledger account for items, regardless of how you have them configured on the Sage 50 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 Sage 50 company file to support this detail in the import.

Also, many competitive integrations for WooCommerce do not recognize assembled product types in the Sage 50 system. If you are offering anything other than the basic ‘Inventory Item’ in Sage 50, you are going to have difficulties importing them properly into the accounting system from WooCommerce.

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 WooCommerce in a timely manner, you are losing significant income opportunities.

Hard Benefits: CartSpan provides a deep integration with Sage 50 to provide you with near real-time updates of product availability in your store. So, as soon as you receive stock into Sage 50 or accept a new order over the phone, CartSpan sees the new inventory and pushes an updated quantity-available to WooCommerce. 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 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 Sage 50 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.

To ‘piggy-back’ on a well-known phrase, “CartSpan integrates your WooCommerce with Sage 50…beautifully.”

We support for some very popular WooCommerce extensions

Stripe Payment Gateway WooCommerce Addon (FREE!) – Syed “Nazrul” Hassan, author of the ‘Stripe Payment Gateway WooCommerce Addon’ (SPGWA) has extended the functionality of his extension to support CartSpan integration with WooCommerce. The basic WooCommerce implementation allows payments to be taken via PayPal, but will not provide suitable detail regarding the payment method for merchants to reconcile payments. The basic PayPal integration will only provide back a reference of ‘Credit Card’ for the online payment transaction.  His ‘Stripe Payment Gateway’ has been extended to allow merchants using the CartSpan eCommerce integration to import a ‘real’ reference as to what type of credit card was actually used (i.e., Visa, MasterCard, Discover, etc.) as well as a reference to the last four digits of the card used.

This small, but very important feature,  supports a superior integration where the merchant may more easily reconcile payments made with bank statements from the associated card companies.

We are aware of no other extension for WooCommerce that enables this level of support for payment method detail…not even the commercial extensions offered by WooThemes. We are also not aware of any other accounting integration tool for WooCommerce capable of utilizing this additional detail even if it were provided by the gateway. CartSpan + SPGWA represents the most effective approach to accounting integration and payment reconciliation available. Though this Addon is offered for ‘free’, many developers rely on supplemental income via the donation process to sustain themselves. So, if you end up using this Addon, please consider ‘buying Nazrul a beer’ to show your appreciation!

WooCommerce Sequential Order Numbers Pro plugin – If your business has a ‘must-have’ requirement of order numbers being formatted to a legacy convention, the Sequential Order Numbers Pro plug-in by WooThemes may be able to help you. It supports initialization of the order numbers themselves to a value that you choose, as well as options for adding a customer prefix and/or suffix.

Testimonials from Customers and Developers:

September 2, 2015

When our company decided it was time for a website overhaul, we went with WooCommerce. After researching integration options, CartSpan stood out as the best option. We needed something to download our orders into QuickBooks and also be able to update inventory quantities on our WooCommerce site. CartSpan does both. Scott Wheeler is also very helpful with any issues and concerns. He actually added a function we requested that related to how item prices are updated when certain products are on sale. Talk about personalized service! I would not hesitate to recommend CartSpan to anyone needing integration between their e-commerce site and accounting software.

Brian Evers, Owner, PDR Outlet @ pdroutlet.com

August 25, 2015

I was asked to develop an e-commerce website and shopping cart to replace an existing WordPress/Yahoo Shopping Cart site. The client’s first priority was to integrate orders and stock management with their Sage 50 accounting system. The company CFO had done some research and asked me to check out CartSpan. CartSpan’s specs met the company’s accounting and stock management needs. Using WordPress, WooCommerce, and CartSpan I developed a website that meets both the e-commerce and accounting needs of the client.

Scott provided great support to get CartSpan installed, and tested, and has been available without fail through the growing pains and changes of the website. He has continued to provided effective and professional support for CartSpan, with quick turnaround. It is a great pleasure to work with Scott.

Patricia Gill, Web Developer @ saidthespider.net