The CartSpan eCommerce integration for QuickBooks now pushes expected ‘back in-stock’ date for item from the accounting system to product masters in the Magento 2.x and legacy Magento 1.x platforms. This exciting functionality is presently only available between the QuickBooks and Magento platforms. Other eCommerce platforms will be considered on an as-requested basis.
Displaying when your product is expected back in stock gives your visitors a measure of certainty around availability and offers you, the merchant, an improved chance of converting the sale. In fact, this feature is so important, it is listed in the #1 recommendation by SEO Expert Trond Lyngbo in his blog post 17 SEO Best Practices That Could Double Your E-Commerce Sales.
The Magento eCommerce platform has a convenient feature called ‘attributes’ for associating additional information with items in the cart. When stock availability is zero in the accounting system, CartSpan will auto-detect an attribute of a given name and automatically push the next expected delivery date for items (based upon open Purchase Orders) to this field. You then have the flexibility as to how you want to present this information on the item page.
To our knowledge, no other commercial accounting/ecommerce integration offers this power feature. There are shopping cart platforms on the market, other than Magento, that offer free-form text entry fields on the item master to hold this information, but lack the time-saving power of a deep-dive integration with the accounting system to make it happen automatically.
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. This functionality is especially useful with QuickBooks U.S. accounting system where the built-in ‘Undeposited Funds’ feature is targeted to this business process of payment reconciliation.
The concept of the open-source software represents a double-edged sword for merchants. The ability to tailor software to meet business requirements is highly-valued, but the very changes a developer makes to support these requirements can render 3rd party integration tools useless. This even includes cases where the developer makes changes outside of what is commonly referred to as the ‘core’ product.
For instance, if a merchant needs to apply a non-standard up-charge on an order, the typical development practice is to add an additional column to the orders table (or elsewhere) to support the transaction. Everything is then coded properly and functions according to specification. The problem that ensues for 3rd party integrations is that they ‘know nothing’ of your new supporting table/columns as they are looking for information based upon the standard schema of the database. As a result, the transaction being imported into the accounting system fails because part of the money is simply missing.
QuickBooks offers users of its Enterprise Edition functionality known as Advanced Inventory. This functionality allows for the creation of multiple ‘sites’ and creation of multiple ‘locations’ within each site; which can also be thought of as ‘warehouse/bin’ designations. Inventory may then be distributed amongst the individual storage locations, thus supporting more precise availability in the order taking and fulfillment processes.
The process indicated above flow naturally when an order is originated via the QuickBooks user interface, given that the person taking the order manually selects the desired stock location. A gap, however, exists when eCommerce orders are imported into QuickBooks via 3rd party integrations. Given that the QuickBooks SDK (Software Development Kit) does not expose the default storage location for each item, the most popular integrations, at best, have been limited to importing just a default ‘site’, thereby leaving a significant amount of manual adjustment to enable an efficient pick-list. Using extensive business logic, CartSpan has overcome this limitation to reference an appropriate stock ‘location’ at the time of import. This logic also accounts for items that may have two (or more) storage locations and can be configured to ignore locations that might be designated as ‘Quarantine.’
Seemingly small features such as these can greatly improve the operational efficiency of an organization, especially when order line-item counts are high.
The following paragraphs describe a method of using Magento to offer fixed-price bundling, but with the user being able to select individual options from configured subgroups of products. Such functionality IS NOT presently available in standard Magento CE and can only be obtained via complex, expensive, and often poorly supported extensions.
The CartSpan eCommerce integration for QuickBooks and Sage 50 now supports a configurable bundle offering without any code changes to your Magento system. All work is accomplished utilizing standard fields in Magento’s existing Configurable product type and one has only to follow SKU formatting guidelines recognized by CartSpan’s import logic. This approach eliminates any opportunity for disruptions during future Magento upgrades and provides a new and powerful marketing tool for attracting customers.
Inventory management for manufacturers in the eCommerce environment is uniquely challenging due to the product-type(s) they sell; namely ‘assembled’ products. To maintain flexibility in order fulfillment, a manufacturer will often ‘assemble-to-order’ using the required child components. With demand for related products with common components constantly changing, it becomes near-impossible for the business to indicate how many of each assembled item are actually available for sale.